javaweb(servlet)+jsp+Mysql实现的酒店客房管理系统
本系统是一个简单的酒店客房管理系统,通过在线的方式,可以比较高效的实现酒店和客户的对接,并且可以对VIP可以有一个很好的使用体验,也可以极大的方便了酒店的宣传和信息展示。
(文末查看完整源码)
实现功能截图
登录
用户 管理
房型管理
房间列表
订单列表
会员星级查询
住宿信息
系统功能
本系统实现了以下功能:
1、登录
2、用户管理
3、住客管理
4、房型管理
5、房间管理
6、会员星级管理
7、订单管理
8、退出登录
等
使用技术
数据库:mysql
开发工具:Idea(Myeclispe、Eclipse也可以)
知识点:javaweb(servlet+jsp)
项目结构
代码
java端
实体类
addadmin.java
package wzt.com.bean;
public class addadmin{
String aname="",apwd="",atype="";
int la;
public int getLa() {
return la;
}
public void setLa(int la) {
this.la = la;
}
String backNews;
public String getAname() {
return aname;
}
public void setAname(String aname) {
this.aname = aname;
}
public String getApwd() {
return apwd;
}
public void setApwd(String apwd) {
this.apwd = apwd;
}
public String getAtype() {
return atype;
}
public void setAtype(String atype) {
this.atype = atype;
}
public String getBackNews(){
return backNews;
}
public void setBackNews(String s){
backNews=s;
}
}
addroom.java
package wzt.com.bean;
public class addroom {
String rid="",rdescribe="",rstate="",rtname="";
int la;String backNews;
public int getLa() {
return la;
}
public void setLa(int la) {
this.la = la;
}
public String getBackNews(){
return backNews;
}
public void setBackNews(String s){
backNews=s;
}
public String getRid() {
return rid;
}
public void setRid(String rid) {
this.rid = rid;
}
public String getRdescribe() {
return rdescribe;
}
public void setRdescribe(String rdescribe) {
this.rdescribe = rdescribe;
}
public String getRstate() {
return rstate;
}
public void setRstate(String rstate) {
this.rstate = rstate;
}
public String getRtname() {
return rtname;
}
public void setRtname(String rtname) {
this.rtname = rtname;
}
}
servlet层
Handleaddroom.java
package wzt.com.servlet;
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import wzt.com.bean.addroom;
import wzt.com.link.DBUtil;
public class Handleaddroom extends HttpServlet{
public int t=0;
public void init(ServletConfig config) throws ServletException{
super.init(config);
try {
Class.forName("com.mysql.jdbc.Driver");
}
catch(Exception e){}
}
public String handleString(String s){
try{
byte bb[]=s.getBytes("iso-8859-1");
s=new String(bb);
}
catch(Exception ee){}
return s;
}
public void doPost(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException{
Connection con;
Statement sql;
addroom reg=new addroom();
request.setAttribute("register",reg);
String rid=request.getParameter("rid").trim(),
rdescribe=request.getParameter("rdescribe").trim(),
rtname=request.getParameter("rtname").trim()
,rstate=request.getParameter("rstate").trim();
System.out.print(rid);
System.out.print(rdescribe);
System.out.print(rtname);
System.out.print(rstate);
int la=0;
String uri="jdbc:mysql://localhost/hotelmanage";
if(rid==null)
rid="";
if(rstate==null)
rdescribe="";
boolean isLD=true;
for(int i=0;i<rid.length();i++){
char c=rdescribe.charAt(i);
if(!((c<='z'&&c>='a')||(c<='Z'&&c>='A')||(c<='9'&&c>='0')))
isLD=false;
}
boolean boo=rid.length()>0&&rdescribe.length()>0;
String backNews="";
try{
rid=handleString(rid);
rdescribe=handleString(rdescribe);
rstate=handleString(rstate);
rtname=handleString(rtname);
// con=DriverManager.getConnection(uri,"root","123456");
con= DBUtil.getConnection();
String insertCondition="INSERT INTO room (rid, rdescribe,rstate,rtname) VALUES ('"+rid+"','"+rdescribe+"','"+rstate+"','"+rtname+"')";
System.out.println(insertCondition);
sql=con.createStatement();
if(boo){
int m=sql.executeUpdate(insertCondition);
if(m!=0){
backNews="��ӳɹ�";
reg.setBackNews(backNews);
reg.setRid(rid);
reg.setRdescribe(rdescribe);
reg.setRtname(rtname);
reg.setRstate(rstate);
reg.setLa(la);
}
}
else{
backNews="�û���Ϣ�����������ԣ�";
reg.setBackNews(backNews);
}
con.close();
}
catch(SQLException exp){
backNews="���û�����ʹ�ã�";
reg.setBackNews(backNews);
}
RequestDispatcher dispatcher=
request.getRequestDispatcher("showaddroom.jsp");//ת��
dispatcher.forward(request,response);
}
public void doGet(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException{
doPost(request,response);
}
}
Handleadduser.java
package wzt.com.servlet;
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import wzt.com.bean.adduser;
import wzt.com.link.DBUtil;
public class Handleadduser extends HttpServlet{
public int t=0;
public void init(ServletConfig config) throws ServletException{
super.init(config);
try {
Class.forName("com.mysql.jdbc.Driver");
}
catch(Exception e){}
}
public String handleString(String s){
try{
byte bb[]=s.getBytes("iso-8859-1");
// byte bb[]=s.getBytes("gbk");
s=new String(bb);
}
catch(Exception ee){}
return s;
}
public void doPost(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException{
Connection con;
Statement sql;
adduser reg=new adduser();
request.setAttribute("register",reg);
String name=request.getParameter("name").trim(),
phone=request.getParameter("phone").trim(),
idcard=request.getParameter("idcard").trim()
,vip=request.getParameter("vip").trim();
System.out.print(name);
System.out.print(phone);
System.out.print(idcard);
System.out.print(vip);
int la=0;
String uri="jdbc:mysql://localhost/hotelmanage?useUnicode=true&characterEncoding=utf8";
if(name==null)
name="";
if(phone==null)
phone="";
boolean isLD=true;
for(int i=0;i<name.length();i++){
char c=phone.charAt(i);
if(!((c<='z'&&c>='a')||(c<='Z'&&c>='A')||(c<='9'&&c>='0')))
isLD=false;
}
boolean boo=name.length()>0&&phone.length()>0&&isLD;
String backNews="";
try{
name=handleString(name);
phone=handleString(phone);
idcard=handleString(idcard);
vip=handleString(vip);
// con=DriverManager.getConnection(uri,"root","root");
con= DBUtil.getConnection();
String insertCondition="INSERT INTO user (name, phone,idcard,vip) VALUES ('"+name+"','"+phone+"','"+idcard+"','"+vip+"')";
System.out.println(insertCondition);
sql=con.createStatement();
if(boo){
int m=sql.executeUpdate(insertCondition);
if(m!=0){
backNews="ע��ɹ�";
reg.setBackNews(backNews);
reg.setName(name);
reg.setPhone(phone);
reg.setIdcard(idcard);
reg.setVip(vip);
reg.setLa(la);
}
}
else{
backNews="�û���Ϣ�����������ԣ�";
reg.setBackNews(backNews);
}
con.close();
}
catch(SQLException exp){
backNews="���û�����ʹ�ã�";
reg.setBackNews(backNews);
}
RequestDispatcher dispatcher=
request.getRequestDispatcher("showadduser.jsp");//ת��
dispatcher.forward(request,response);
}
public void doGet(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException{
doPost(request,response);
}
}
完整源码
觉得有用,记得一键三连哦!