javaweb(servlet)+jsp+Mysql实现的酒店客房管理系统（功能包含登录、用户管理、住客信息管理、房型管理、房间管理、会员星级管理、订单管理等）

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);
   }
}

完整源码

觉得有用，记得一键三连哦！