EJB——无状态会话Bean的Enterprise JavaBean类_hotelBean.java

最新推荐文章于 2021-02-25 07:09:50 发布
最新推荐文章于 2021-02-25 07:09:50 发布
阅读量722 收藏
点赞数
文章标签： bean ejb exception string null service
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/wanggsx918/article/details/4475285
版权

 package wanggsx.ejb;
import wanggsx.ejb.*;
import java.util.*;
import java.sql.* ;
import javax.sql.*;
import javax.naming.*;
import java.lang.*;
/**
* Bean implementation class for Enterprise Bean: Hotel
*/
public class hotelBean implements javax.ejb.SessionBean
  {
    private javax.ejb.SessionContext mySessionCtx;
/**
* getSessionContext
*/
    public javax.ejb.SessionContext getSessionContext()
      {
        return mySessionCtx;
      }
/**
* setSessionContext
*/
    public void setSessionContext(javax.ejb.SessionContext ctx)
      {
        mySessionCtx = ctx;
      }
/**
* ejbActivate
*/
    public void ejbActivate()
      {}
/**
* ejbCreate
*/
    public void ejbCreate() throws javax.ejb.CreateException
      {}
  


/**
* ejbPassivate
*/
    public void ejbPassivate()
      {}
/**
* ejbRemove
*/
    public void ejbRemove()
      {}
 
/**
* 商务方法
*/
   
     
     Context ctx;
        /**
        * 属性,表示数据源
        */
    DataSource ds;
        /**
        * 属性,statement
        */
    Statement stmt;
        /**
        * 属性,PreparedStatement
        */
    PreparedStatement pstmt;
        /**
        * 属性,查询结果
        */
    ResultSet rs;
       /**
       *初始化数据源
       */

    public void init(){
      try{
                 /*Context initCtx = new InitialContext();
                  Context envCtx = (Context) initCtx.lookup("java:comp/env");
                  ds = (DataSource)envCtx.lookup("jdbc/mydatabase");*/
                  Context initCtx = new InitialContext();
                  Context envCtx = (Context) initCtx.lookup("java:comp/env");

              //    ds = (DataSource)initCtx.lookup("java:/MSSQLDSLabour").
                  ds = (DataSource)initCtx.lookup("java:/database");
                  System.out.println("connect the database");
                }
   catch(Exception E){
    System.out.println("Init DataSource Error: "+E);
   }
 }
 
 
        public int UpdateBookUser()
                         {
                                Connection con = null;
                                String a="RemainToday";
                                String b="RemainTomorrow";
                                String c="RemainAfterTomorrow";
                                String d="RemainInThird";
  int flag=0;
  int flag1=0;
  int flag2=0;
  int flag3=0;
  int flag4=0;
            
  init();

 try{
                                     con = ds.getConnection();
                                     pstmt = con.prepareStatement("delete from Hotel_Book_User where 预订日期=?");
                                     pstmt.setString(1,a);                           
                                     flag1 = pstmt.executeUpdate();
                       }//end try
                        catch (SQLException ex){
                                System.out.println("sql error: "+ex);
                        }
                        catch (Exception E){
                                System.out.println("Service Error: "+E);
                        }
                        finally{
                                if (rs!=null){
                                       try { rs.close();} catch (Exception ignore){ };
                                }
                                if (pstmt!=null){
                                       try { pstmt.close();} catch (Exception ignore){ };
                                }
                                if (con!=null){
                                         try { con.close();} catch (Exception ignore){ };
                                }
                         }//finally

  try{
                                     con = ds.getConnection();
                                      pstmt=con.prepareStatement("update Hotel_Book_User set 预订日期=? where 预订日期=?");
                                      pstmt.setString(1,a);
                                      pstmt.setString(2,b);
                                      flag2 = pstmt.executeUpdate();
                       }//end try
                        catch (SQLException ex){
                                System.out.println("sql error: "+ex);
                        }
                        catch (Exception E){
                                System.out.println("Service Error: "+E);
                        }
                        finally{
                                if (rs!=null){
                                       try { rs.close();} catch (Exception ignore){ };
                                }
                                if (pstmt!=null){
                                       try { pstmt.close();} catch (Exception ignore){ };
                                }
                                if (con!=null){
                                         try { con.close();} catch (Exception ignore){ };
                                }
                         }//finally

 try{
                                     con = ds.getConnection();
                                      pstmt=con.prepareStatement("update Hotel_Book_User set 预订日期=? where 预订日期=?");
                                      pstmt.setString(1,b);
                                      pstmt.setString(2,c);
                                      flag3 = pstmt.executeUpdate();
                       }//end try
                        catch (SQLException ex){
                                System.out.println("sql error: "+ex);
                        }
                        catch (Exception E){
                                System.out.println("Service Error: "+E);
                        }
                        finally{
                                if (rs!=null){
                                       try { rs.close();} catch (Exception ignore){ };
                                }
                                if (pstmt!=null){
                                       try { pstmt.close();} catch (Exception ignore){ };
                                }
                                if (con!=null){
                                         try { con.close();} catch (Exception ignore){ };
                                }
                         }//finally
 
 try{
                                     con = ds.getConnection();
                                      pstmt=con.prepareStatement("update Hotel_Book_User set 预订日期=? where 预订日期=?");
                                      pstmt.setString(1,c);
                                      pstmt.setString(2,d);
                                      flag4 = pstmt.executeUpdate();
                       }//end try
                        catch (SQLException ex){
                                System.out.println("sql error: "+ex);
                        }
                        catch (Exception E){
                                System.out.println("Service Error: "+E);
                        }
                        finally{
                                if (rs!=null){
                                       try { rs.close();} catch (Exception ignore){ };
                                }
                                if (pstmt!=null){
                                       try { pstmt.close();} catch (Exception ignore){ };
                                }
                                if (con!=null){
                                         try { con.close();} catch (Exception ignore){ };
                                }
                         }//finally
                flag=flag1 + flag2 + flag3 + flag4;
                 return flag;
            }
 
    public Vector FHotelAdministor(){
  Connection con = null;
  Vector data = new Vector();            
  init();
  try{
   con = ds.getConnection();
                        //必须这样设置以对结果集进行指针操作
                        stmt = con.createStatement();
                        rs=stmt.executeQuery("select user_name,user_password,super_password,user_sex from Hotel_Administor");
                        System.out.println("enter the hotel_administor");
                        while (rs.next())
                          {
                             Hashtable ht = new Hashtable();
                             ht.put("a",rs.getString("user_name"));
                             ht.put("b",rs.getString("user_password"));
                             ht.put("c",rs.getString("super_password"));
                             ht.put("d",rs.getString("user_sex"));
                             data.addElement(ht);
                          }
                
  }
                catch(SQLException ex){
                  System.out.println("ex is  "+ex);
                }
  catch (Exception E){
       System.out.println("Service Error: "+E);
  }
  finally{
         if (rs!=null){
      try { rs.close();} catch (Exception ignore){ };
         }
         if (stmt!=null){
        try { stmt.close();} catch (Exception ignore){ };
         }
         if (con!=null){
        try { con.close();} catch (Exception ignore){ };
         }
    }//finally
    return data;
 }
 
         public Vector FHotelRoom(){
  Connection con = null;
  Vector data = new Vector();            
  init();
  try{
   con = ds.getConnection();
                        //必须这样设置以对结果集进行指针操作
                                                stmt = con.createStatement();
                                                rs=stmt.executeQuery("select RoomID,RoomType,RoomPrice,IsEmpty,User_IdCard  from Hotel_Room");
                        System.out.println("enter the hotel_room");
                        while (rs.next())
                          {
                             Hashtable ht = new Hashtable();
                             ht.put("a",rs.getString("RoomID"));
                             ht.put("b",rs.getString("RoomType"));
                             ht.put("c",rs.getString("RoomPrice"));
                             ht.put("d",rs.getString("IsEmpty"));
                             ht.put("e",rs.getString("User_IdCard"));
                             data.addElement(ht);
                          }
                
  }
                catch(SQLException ex){
                  System.out.println("ex is  "+ex);
                }
  catch (Exception E){
       System.out.println("Service Error: "+E);
  }
  finally{
         if (rs!=null){
      try { rs.close();} catch (Exception ignore){ };
         }
         if (stmt!=null){
        try { stmt.close();} catch (Exception ignore){ };
         }
         if (con!=null){
        try { con.close();} catch (Exception ignore){ };
         }
    }//finally
    return data;
 }
 
         public Vector FHotelRoomEmpty(){
  Connection con = null;
  Vector data = new Vector();            
  init();
  try{
   con = ds.getConnection();
                        //必须这样设置以对结果集进行指针操作
                                                stmt = con.createStatement();
                                                rs=stmt.executeQuery("select RoomID,RoomType from Hotel_Room where IsEmpty='0'");
                        System.out.println("enter the hotel_room");
                        while (rs.next())
                          {
                             Hashtable ht = new Hashtable();
                             ht.put("a",rs.getString("RoomID"));
                             ht.put("b",rs.getString("RoomType"));
                             data.addElement(ht);
                          }
                
  }
                catch(SQLException ex){
                  System.out.println("ex is  "+ex);
                }
  catch (Exception E){
       System.out.println("Service Error: "+E);
  }
  finally{
         if (rs!=null){
      try { rs.close();} catch (Exception ignore){ };
         }
         if (stmt!=null){
        try { stmt.close();} catch (Exception ignore){ };
         }
         if (con!=null){
        try { con.close();} catch (Exception ignore){ };
         }
    }//finally
    return data;
 }
 
        public Vector FHotelBookUser(){
  Connection con = null;
  Vector data = new Vector();            
  init();
  try{
   con = ds.getConnection();
                        //必须这样设置以对结果集进行指针操作
                        stmt = con.createStatement();
                        rs=stmt.executeQuery("select id,电子邮箱,手机号,预订房间数,预订房间类型,预订日期  from Hotel_Book_User");
                        System.out.println("enter the Hotel_Book_User");
                        while (rs.next())
                          {
                             Hashtable ht = new Hashtable();
                             ht.put("a",rs.getString("id"));
                             ht.put("b",rs.getString("电子邮箱"));
                             ht.put("c",rs.getString("手机号"));
                             ht.put("d",rs.getString("预订房间数"));
                             ht.put("e",rs.getString("预订房间类型"));
                             ht.put("f",rs.getString("预订日期"));
                                   data.addElement(ht);
                          }
                
  }
                catch(SQLException ex){
                  System.out.println("ex is  "+ex);
                }
  catch (Exception E){
       System.out.println("Service Error: "+E);
  }
  finally{
         if (rs!=null){
      try { rs.close();} catch (Exception ignore){ };
         }
         if (stmt!=null){
        try { stmt.close();} catch (Exception ignore){ };
         }
         if (con!=null){
        try { con.close();} catch (Exception ignore){ };
         }
    }//finally
    return data;
 }


       public Vector FHotelRoomInfo(){
  Connection con = null;
  Vector data = new Vector();            
  init();
  try{
   con = ds.getConnection();
                        //必须这样设置以对结果集进行指针操作
                                                stmt = con.createStatement();
                                                rs=stmt.executeQuery("select RoomType,RoomPrice,RemainToday,RemainTomorrow,RemainAfterTomorrow,RemainInThird,Announcement from Hotel_Room_Info");
                        System.out.println("enter the hotel_room_info");
                        while (rs.next())
                          {
                             Hashtable ht = new Hashtable();
                             ht.put("a",rs.getString("RoomType"));
                             ht.put("b",rs.getString("RoomPrice"));
                             ht.put("c",rs.getString("RemainToday"));
                             ht.put("d",rs.getString("RemainTomorrow"));
                             ht.put("e",rs.getString("RemainAfterTomorrow"));
                             ht.put("f",rs.getString("RemainInThird"));
                             ht.put("g",rs.getString("Announcement"));
                             data.addElement(ht);
                          }
                
  }
                catch(SQLException ex){
                  System.out.println("ex is  "+ex);
                }
  catch (Exception E){
       System.out.println("Service Error: "+E);
  }
  finally{
         if (rs!=null){
      try { rs.close();} catch (Exception ignore){ };
         }
         if (stmt!=null){
        try { stmt.close();} catch (Exception ignore){ };
         }
         if (con!=null){
        try { con.close();} catch (Exception ignore){ };
         }
    }//finally
    return data;
 }
 
 
 
       public int ResetRoomRemain(){
  Connection con = null;
  Vector data= new Vector();
  Hashtable ht1=null;
                                int i;
                                String t="";
  int flag=0;            
  init();
  try{
   con = ds.getConnection();
                        //必须这样设置以对结果集进行指针操作
                                                stmt = con.createStatement();
                                                rs=stmt.executeQuery("select RoomTotal from Hotel_Room_Info");
                        while (rs.next())
                        {
                                                pstmt = con.prepareStatement("update Hotel_Room_Info set RemainToday=?,RemainTomorrow=?,RemainAfterTomorrow=?,RemainInThird=? where RoomTotal=?");
                                                pstmt.setString(1,rs.getString("RoomTotal"));
                                                pstmt.setString(2,rs.getString("RoomTotal"));
                                                pstmt.setString(3,rs.getString("RoomTotal"));
                                                pstmt.setString(4,rs.getString("RoomTotal"));
                                                pstmt.setString(5,rs.getString("RoomTotal"));
                                                flag = pstmt.executeUpdate();
                          }
  }
                catch(SQLException ex){
                  System.out.println("ex is  "+ex);
                }
  catch (Exception E){
       System.out.println("Service Error: "+E);
  }
  finally{
         if (rs!=null){
      try { rs.close();} catch (Exception ignore){ };
         }
         if (stmt!=null){
        try { stmt.close();} catch (Exception ignore){ };
         }
         if (con!=null){
        try { con.close();} catch (Exception ignore){ };
         }
    }//finally
                                  return flag;
 }
 

       public Vector FHotelRoomInfo2(){
  Connection con = null;
  Vector data = new Vector();            
  init();
  try{
   con = ds.getConnection();
                        //必须这样设置以对结果集进行指针操作
                                                stmt = con.createStatement();
                                                rs=stmt.executeQuery("select RoomType,RoomPrice,RoomTotal,RemainToday,RemainTomorrow,RemainAfterTomorrow,RemainInThird,Announcement from Hotel_Room_Info");
                        System.out.println("enter the hotel_room_info");
                        while (rs.next())
                          {
                             Hashtable ht = new Hashtable();
                             ht.put("a",rs.getString("RoomType"));
                             ht.put("b",rs.getString("RoomPrice"));
                             ht.put("c",rs.getString("RoomTotal"));
                             ht.put("d",rs.getString("RemainToday"));
                             ht.put("e",rs.getString("RemainTomorrow"));
                             ht.put("f",rs.getString("RemainAfterTomorrow"));
                             ht.put("g",rs.getString("RemainInThird"));
                             ht.put("h",rs.getString("Announcement"));
                             data.addElement(ht);
                          }
                
  }
                catch(SQLException ex){
                  System.out.println("ex is  "+ex);
                }
  catch (Exception E){
       System.out.println("Service Error: "+E);
  }
  finally{
         if (rs!=null){
      try { rs.close();} catch (Exception ignore){ };
         }
         if (stmt!=null){
        try { stmt.close();} catch (Exception ignore){ };
         }
         if (con!=null){
        try { con.close();} catch (Exception ignore){ };
         }
    }//finally
    return data;
 }
 
 
   public Vector LHotelRoomNO(String bookdate,String roomtype){
     Connection con = null;
  Vector data = new Vector();            
  init();
  try{
   con = ds.getConnection();
                        //必须这样设置以对结果集进行指针操作
                                                stmt = con.createStatement();
                                                rs=stmt.executeQuery("select "+bookdate+" from Hotel_Room_Info where RoomType='"+roomtype+"'");
                        System.out.println("enter the hotel_room_info");
                        while (rs.next())
                          {
                             Hashtable ht = new Hashtable();
                             ht.put("a",rs.getString(""+bookdate+""));
                             data.addElement(ht);
                          }
                
  }
                catch(SQLException ex){
                  System.out.println("ex is  "+ex);
                }
  catch (Exception E){
       System.out.println("Service Error: "+E);
  }
  finally{
         if (rs!=null){
      try { rs.close();} catch (Exception ignore){ };
         }
         if (stmt!=null){
        try { stmt.close();} catch (Exception ignore){ };
         }
         if (con!=null){
        try { con.close();} catch (Exception ignore){ };
         }
    }//finally
    return data;
 }


       public Vector LHotelRoomInfo(String roomtype){
  Connection con = null;
  Vector data = new Vector();            
  init();
  try{
   con = ds.getConnection();
                        //必须这样设置以对结果集进行指针操作
                                                stmt = con.createStatement();
                                                rs=stmt.executeQuery("select RoomType,RoomPrice,RoomTotal,RemainToday,RemainTomorrow,RemainAfterTomorrow,RemainInThird,Announcement from Hotel_Room_Info where RoomType='"+roomtype+"'");
                        System.out.println("enter the hotel_room_info");
                        while (rs.next())
                          {
                             Hashtable ht = new Hashtable();
                             ht.put("a",rs.getString("RoomType"));
                             ht.put("b",rs.getString("RoomPrice"));
                             ht.put("c",rs.getString("RoomTotal"));
                             ht.put("d",rs.getString("RemainToday"));
                             ht.put("e",rs.getString("RemainTomorrow"));
                             ht.put("f",rs.getString("RemainAfterTomorrow"));
                             ht.put("g",rs.getString("RemainInThird"));
                             ht.put("h",rs.getString("Announcement"));
                             data.addElement(ht);
                          }
                
  }
                catch(SQLException ex){
                  System.out.println("ex is  "+ex);
                }
  catch (Exception E){
       System.out.println("Service Error: "+E);
  }
  finally{
         if (rs!=null){
      try { rs.close();} catch (Exception ignore){ };
         }
         if (stmt!=null){
        try { stmt.close();} catch (Exception ignore){ };
         }
         if (con!=null){
        try { con.close();} catch (Exception ignore){ };
         }
    }//finally
    return data;
 }
 
                public Vector LHotelRoom(String roomid){
  Connection con = null;
  Vector data = new Vector();            
  init();
  try{
   con = ds.getConnection();
                        //必须这样设置以对结果集进行指针操作
                                                stmt = con.createStatement();
                                                rs=stmt.executeQuery("select RoomID,RoomType,RoomPrice,IsEmpty,User_IdCard  from Hotel_Room where RoomID='"+roomid+"'");
                        System.out.println("enter the hotel_room");
                        while (rs.next())
                          {
                             Hashtable ht = new Hashtable();
                             ht.put("a",rs.getString("RoomID"));
                             ht.put("b",rs.getString("RoomType"));
                             ht.put("c",rs.getString("RoomPrice"));
                             ht.put("d",rs.getString("IsEmpty"));
                             ht.put("e",rs.getString("User_IdCard"));
                             data.addElement(ht);
                          }
                
  }
                catch(SQLException ex){
                  System.out.println("ex is  "+ex);
                }
  catch (Exception E){
       System.out.println("Service Error: "+E);
  }
  finally{
         if (rs!=null){
      try { rs.close();} catch (Exception ignore){ };
         }
         if (stmt!=null){
        try { stmt.close();} catch (Exception ignore){ };
         }
         if (con!=null){
        try { con.close();} catch (Exception ignore){ };
         }
    }//finally
    return data;
 }
  
        public Vector LHotelBookUser(String id){
  Connection con = null;
  Vector data = new Vector();            
  init();
  try{
   con = ds.getConnection();
                        //必须这样设置以对结果集进行指针操作
                        stmt = con.createStatement();
                        rs=stmt.executeQuery("select id,电子邮箱,手机号,预订房间数,预订房间类型,预订日期  from Hotel_Book_User where id='"+id+"'");
                        System.out.println("enter the Hotel_Book_User");
                        while (rs.next())
                          {
                             Hashtable ht = new Hashtable();
                             ht.put("a",rs.getString("id"));
                             ht.put("b",rs.getString("电子邮箱"));
                             ht.put("c",rs.getString("手机号"));
                             ht.put("d",rs.getString("预订房间数"));
                             ht.put("e",rs.getString("预订房间类型"));
                             ht.put("f",rs.getString("预订日期"));
                                   data.addElement(ht);
                          }
                
  }
                catch(SQLException ex){
                  System.out.println("ex is  "+ex);
                }
  catch (Exception E){
       System.out.println("Service Error: "+E);
  }
  finally{
         if (rs!=null){
      try { rs.close();} catch (Exception ignore){ };
         }
         if (stmt!=null){
        try { stmt.close();} catch (Exception ignore){ };
         }
         if (con!=null){
        try { con.close();} catch (Exception ignore){ };
         }
    }//finally
    return data;
 }
 
        public Vector LBookUserbytype(String roomtype){
  Connection con = null;
  Vector data = new Vector();            
  init();
  try{
   con = ds.getConnection();
                        //必须这样设置以对结果集进行指针操作
                        stmt = con.createStatement();
                        rs=stmt.executeQuery("select id,电子邮箱,手机号,预订房间数,预订房间类型,预订日期  from Hotel_Book_User where 预订房间类型='"+roomtype+"'");
                        System.out.println("enter the Hotel_Book_User");
                        while (rs.next())
                          {
                             Hashtable ht = new Hashtable();
                             ht.put("a",rs.getString("id"));
                             ht.put("b",rs.getString("电子邮箱"));
                             ht.put("c",rs.getString("手机号"));
                             ht.put("d",rs.getString("预订房间数"));
                             ht.put("e",rs.getString("预订房间类型"));
                             ht.put("f",rs.getString("预订日期"));
                                   data.addElement(ht);
                          }
                
  }
                catch(SQLException ex){
                  System.out.println("ex is  "+ex);
                }
  catch (Exception E){
       System.out.println("Service Error: "+E);
  }
  finally{
         if (rs!=null){
      try { rs.close();} catch (Exception ignore){ };
         }
         if (stmt!=null){
        try { stmt.close();} catch (Exception ignore){ };
         }
         if (con!=null){
        try { con.close();} catch (Exception ignore){ };
         }
    }//finally
    return data;
 }
 
 

        public Vector LBookUserbydate(String bookdate){
  Connection con = null;
  Vector data = new Vector();            
  init();
  try{
   con = ds.getConnection();
                        //必须这样设置以对结果集进行指针操作
                        stmt = con.createStatement();
                        rs=stmt.executeQuery("select id,电子邮箱,手机号,预订房间数,预订房间类型,预订日期  from Hotel_Book_User where 预订日期='"+bookdate+"'");
                        System.out.println("enter the Hotel_Book_User");
                        while (rs.next())
                          {
                             Hashtable ht = new Hashtable();
                             ht.put("a",rs.getString("id"));
                             ht.put("b",rs.getString("电子邮箱"));
                             ht.put("c",rs.getString("手机号"));
                             ht.put("d",rs.getString("预订房间数"));
                             ht.put("e",rs.getString("预订房间类型"));
                             ht.put("f",rs.getString("预订日期"));
                                   data.addElement(ht);
                          }
                
  }
                catch(SQLException ex){
                  System.out.println("ex is  "+ex);
                }
  catch (Exception E){
       System.out.println("Service Error: "+E);
  }
  finally{
         if (rs!=null){
      try { rs.close();} catch (Exception ignore){ };
         }
         if (stmt!=null){
        try { stmt.close();} catch (Exception ignore){ };
         }
         if (con!=null){
        try { con.close();} catch (Exception ignore){ };
         }
    }//finally
    return data;
 } 
 
    public Vector LHotelUserInfo(String idcard){
  Connection con = null;
  Vector data = new Vector();            
  init();
  try{
   con = ds.getConnection();
                        //必须这样设置以对结果集进行指针操作
                        stmt = con.createStatement();
                        rs=stmt.executeQuery("select 用户名,性别,身份证,是否预订,入住日期,入住房间类型,入住房间号,入住房间数量,入住天数,是否结账,结账日期,是否打印发票,预交费,消费额,是否欠费,欠费额度 from Hotel_User_Info where 身份证='"+idcard+"'");
                        System.out.println("enter the hotel_user_info");
                        while (rs.next())
                          {
                             Hashtable ht = new Hashtable();
                             ht.put("a",rs.getString("用户名"));
                             ht.put("b",rs.getString("性别"));
                             ht.put("c",rs.getString("身份证"));
                             ht.put("d",rs.getString("是否预订"));
                             ht.put("e",rs.getString("入住日期"));
                             ht.put("f",rs.getString("入住房间类型"));
                             ht.put("g",rs.getString("入住房间号"));
                             ht.put("h",rs.getString("入住房间数量"));
                             ht.put("i",rs.getString("入住天数"));
                             ht.put("j",rs.getString("是否结账"));
                             ht.put("k",rs.getString("结账日期"));
                             ht.put("l",rs.getString("是否打印发票"));
                             ht.put("m",rs.getString("预交费"));
                             ht.put("n",rs.getString("消费额"));
                             ht.put("o",rs.getString("是否欠费"));
                             ht.put("p",rs.getString("欠费额度"));
                             data.addElement(ht);
                          }
                
  }
                catch(SQLException ex){
                  System.out.println("ex is  "+ex);
                }
  catch (Exception E){
       System.out.println("Service Error: "+E);
  }
  finally{
         if (rs!=null){
      try { rs.close();} catch (Exception ignore){ };
         }
         if (stmt!=null){
        try { stmt.close();} catch (Exception ignore){ };
         }
         if (con!=null){
        try { con.close();} catch (Exception ignore){ };
         }
    }//finally
    return data;
 }
 

 

    public Vector LHotelAdministor(String name,String password){
  Connection con = null;
  Vector data = new Vector();            
  init();
  try{
   con = ds.getConnection();
                        //必须这样设置以对结果集进行指针操作
                        stmt = con.createStatement();
                        rs=stmt.executeQuery("select user_name,user_password,super_password,user_sex from Hotel_Administor where user_name='"+name+"' and user_password='"+password+"'");
                        System.out.println("enter the hotel_administor");
                        while (rs.next())
                          {
                             Hashtable ht = new Hashtable();
                             ht.put("a",rs.getString("user_name"));
                             ht.put("b",rs.getString("user_password"));
                             ht.put("c",rs.getString("super_password"));
                             ht.put("d",rs.getString("user_sex"));
                             data.addElement(ht);
                          }
                
  }
                catch(SQLException ex){
                  System.out.println("ex is  "+ex);
                }
  catch (Exception E){
       System.out.println("Service Error: "+E);
  }
  finally{
         if (rs!=null){
      try { rs.close();} catch (Exception ignore){ };
         }
         if (stmt!=null){
        try { stmt.close();} catch (Exception ignore){ };
         }
         if (con!=null){
        try { con.close();} catch (Exception ignore){ };
         }
    }//finally
    return data;
 }
 
 
     public String login(String name,String password,String spassword){
  Connection con = null;
  Vector data = new Vector(); 
  String token="no";          
  init();
  try{
         con = ds.getConnection();
                        stmt = con.createStatement();
                        rs=stmt.executeQuery("select * from Hotel_Administor where user_name='"+name+"' and user_password='"+password+"' and super_password='"+spassword+"'");
                        System.out.println("enter the login");
                        while (rs.next())
                          {
                            
                             token="yes";
                          }
                
  }
                catch(SQLException ex){
                  System.out.println("ex is  "+ex);
                }
  catch (Exception E){
       System.out.println("Service Error: "+E);
  }
  finally{
         if (rs!=null){
      try { rs.close();} catch (Exception ignore){ };
         }
         if (stmt!=null){
        try { stmt.close();} catch (Exception ignore){ };
         }
         if (con!=null){
        try { con.close();} catch (Exception ignore){ };
         }
    }
    return token;
 }
 
     public String checkid(String id){
  Connection con = null;
  Vector data = new Vector(); 
  String token="no";          
  init();
  try{
         con = ds.getConnection();
                        stmt = con.createStatement();
                        rs=stmt.executeQuery("select * from Hotel_Book_User where id='"+id+"'");
                        System.out.println("check the id");
                        while (rs.next())
                          {
                            
                             token="yes";
                          }
                
  }
                catch(SQLException ex){
                  System.out.println("ex is  "+ex);
                }
  catch (Exception E){
       System.out.println("Service Error: "+E);
  }
  finally{
         if (rs!=null){
      try { rs.close();} catch (Exception ignore){ };
         }
         if (stmt!=null){
        try { stmt.close();} catch (Exception ignore){ };
         }
         if (con!=null){
        try { con.close();} catch (Exception ignore){ };
         }
    }
    return token;
 }
 
 
 /**
 *用户信息的创建
 */
   public int CHotelBookUser(String id,String email,String tel,String booksum,String bookroomtype,String bookdate)
                         {
                                Connection con = null;
  int flag=0;          
  init();
  try{
                                     con = ds.getConnection();
                                      pstmt=con.prepareStatement("insert into Hotel_Book_User (id,电子邮箱,手机号,预订房间数,预订房间类型,预订日期) values (?,?,?,?,?,?)");
                                      pstmt.setString(1,id);
                                      pstmt.setString(2,email);
                                      pstmt.setString(3,tel);
                                      pstmt.setString(4,booksum);
                                      pstmt.setString(5,bookroomtype);
                                      pstmt.setString(6,bookdate);
                                      flag = pstmt.executeUpdate();
                       }//end try
                        catch (SQLException ex){
                                System.out.println("sql error: "+ex);
                        }
                        catch (Exception E){
                                System.out.println("Service Error: "+E);
                        }
                        finally{
                                if (rs!=null){
                                       try { rs.close();} catch (Exception ignore){ };
                                }
                                if (pstmt!=null){
                                       try { pstmt.close();} catch (Exception ignore){ };
                                }
                                if (con!=null){
                                         try { con.close();} catch (Exception ignore){ };
                                }
                         }//finally
                         return flag;
            }
           
           
           
                public int CHotelUserInfo(String name,String sex,String idcard,String isbooked,String indate,String inroomtype,String inroomno,String inroomsum,String inday,String isbalancecount,String countdate,String isprinted,String prepay,String moneytotal,String isdebt,String debtsum){
  Connection con = null;
  int flag=0;            
  init();
  try{
   con = ds.getConnection();
                                               pstmt = con.prepareStatement("insert into Hotel_User_Info (用户名,性别,身份证,是否预订,入住日期,入住房间类型,入住房间号,入住房间数量,入住天数,是否结账,结账日期,是否打印发票,预交费,消费额,是否欠费,欠费额度) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
                                               pstmt.setString(1,name);
                                               pstmt.setString(2,sex);
                                               pstmt.setString(3,idcard);
                                               pstmt.setString(4,isbooked);
                                               pstmt.setString(5,indate);
                                               pstmt.setString(6,inroomtype);
                                               pstmt.setString(7,inroomno);
                                               pstmt.setString(8,inroomsum);
                                               pstmt.setString(9,inday);
                                               pstmt.setString(10,isbalancecount);
                                               pstmt.setString(11,countdate);
                                               pstmt.setString(12,isprinted);
                                               pstmt.setString(13,prepay);
                                               pstmt.setString(14,moneytotal);
                                               pstmt.setString(15,isdebt);
                                               pstmt.setString(16,debtsum);
                                               flag = pstmt.executeUpdate();
                                       }//end try
                        catch (SQLException ex){
                                System.out.println("sql error: "+ex);
                        }
                        catch (Exception E){
                                System.out.println("Service Error: "+E);
                        }
                        finally{
                                if (rs!=null){
                                       try { rs.close();} catch (Exception ignore){ };
                                }
                                if (pstmt!=null){
                                       try { pstmt.close();} catch (Exception ignore){ };
                                }
                                if (con!=null){
                                         try { con.close();} catch (Exception ignore){ };
                                }
                         }//finally
                         return flag;
            }


          public int CHotelAdministor(String name,String password,String spassword,String sex){
  Connection con = null;
  int flag=0;            
  init();
  try{
   con = ds.getConnection();
                                                pstmt=con.prepareStatement("insert into Hotel_Administor (user_name,user_password,super_password,user_sex) values (?,?,?,?)");
                                                pstmt.setString(1,name);
                                                pstmt.setString(2,password);
                                                pstmt.setString(3,spassword);
                                                pstmt.setString(4,sex);
                                                flag=pstmt.executeUpdate();
                                     }//end try
                        catch (SQLException ex){
                                System.out.println("sql error: "+ex);
                        }
                        catch (Exception E){
                                System.out.println("Service Error: "+E);
                        }
                        finally{
                                if (rs!=null){
                                       try { rs.close();} catch (Exception ignore){ };
                                }
                                if (pstmt!=null){
                                       try { pstmt.close();} catch (Exception ignore){ };
                                }
                                if (con!=null){
                                         try { con.close();} catch (Exception ignore){ };
                                }
                         }//finally
                         return flag;
            }


          public int CHotelRoomInfo(String roomtype,String roomprice,String roomtotal,String remaintoday,String remaintomorrow,String remainaftertomorrow,String remaininthird,String announcement){
  Connection con = null;
  int flag=0;            
  init();
  try{
   con = ds.getConnection();
                                                pstmt=con.prepareStatement("insert into Hotel_Room_Info (RoomType,RoomPrice,RoomTotal,RemainToday,RemainTomorrow,RemainAfterTomorrow,RemainInThird,Announcement) values (?,?,?,?,?,?,?,?)");
                                                pstmt.setString(1,roomtype);
                                                pstmt.setString(2,roomprice);
                                                pstmt.setString(3,roomtotal);
                                                pstmt.setString(4,remaintoday);
                                                pstmt.setString(5,remaintomorrow);
                                                pstmt.setString(6,remainaftertomorrow);
                                                pstmt.setString(7,remaininthird);
                                                pstmt.setString(8,announcement);
                                                flag=pstmt.executeUpdate();
                                     }//end try
                        catch (SQLException ex){
                                System.out.println("sql error: "+ex);
                        }
                        catch (Exception E){
                                System.out.println("Service Error: "+E);
                        }
                        finally{
                                if (rs!=null){
                                       try { rs.close();} catch (Exception ignore){ };
                                }
                                if (pstmt!=null){
                                       try { pstmt.close();} catch (Exception ignore){ };
                                }
                                if (con!=null){
                                         try { con.close();} catch (Exception ignore){ };
                                }
                         }//finally
                         return flag;
            }

 

   public int CHotelRoom(String roomid,String thisroomtype,String roomprice,String isempty,String useridcard){
  Connection con = null;
  int flag=0;            
  init();
  try{
   con = ds.getConnection();
                                                pstmt = con.prepareStatement("insert into Hotel_Room (RoomID,RoomType,RoomPrice,IsEmpty,User_IdCard) values (?,?,?,?,?)");
                                                pstmt.setString(1,roomid);
                                                pstmt.setString(2,thisroomtype);
                                                pstmt.setString(3,roomprice);
                                                pstmt.setString(4,isempty);
                                                pstmt.setString(5,useridcard);
                                                flag=pstmt.executeUpdate();
                                     }//end try
                        catch (SQLException ex){
                                System.out.println("sql error: "+ex);
                        }
                        catch (Exception E){
                                System.out.println("Service Error: "+E);
                        }
                        finally{
                                if (rs!=null){
                                       try { rs.close();} catch (Exception ignore){ };
                                }
                                if (pstmt!=null){
                                       try { pstmt.close();} catch (Exception ignore){ };
                                }
                                if (con!=null){
                                         try { con.close();} catch (Exception ignore){ };
                                }
                         }//finally
                         return flag;
            }


    public int DBookUserBydate(String bookdate){
            Connection con = null;
            init();
            int flag = 0;
            try{
                 con = ds.getConnection();
                 pstmt = con.prepareStatement("delete from Hotel_Book_User where 预订日期=?");
                 pstmt.setString(1,bookdate);        
                 flag = pstmt.executeUpdate();
                 System.out.println("delete bookuser by bookdate successfully!");

            }//end try
            catch (SQLException ex){
                   System.out.println("sql error: "+ex);
            }
            catch (Exception E){
                   System.out.println("Service Error: "+E);
            }
            finally{
                 if (rs!=null){
                        try { rs.close();} catch (Exception ignore){ };
                 }
                 if (pstmt!=null){
                        try { pstmt.close();} catch (Exception ignore){ };
                 }
                 if (con!=null){
                        try { con.close();} catch (Exception ignore){ };
                 }
            }//finally
            return flag;
      }

          
          
    public int DHotelBookUser(String id){
            Connection con = null;
            init();
            int flag = 0;
            try{
                 con = ds.getConnection();
                 pstmt = con.prepareStatement("delete from Hotel_Book_User where id=?");
                 pstmt.setString(1,id);        
                 flag = pstmt.executeUpdate();
            }//end try
            catch (SQLException ex){
                   System.out.println("sql error: "+ex);
            }
            catch (Exception E){
                   System.out.println("Service Error: "+E);
            }
            finally{
                 if (rs!=null){
                        try { rs.close();} catch (Exception ignore){ };
                 }
                 if (pstmt!=null){
                        try { pstmt.close();} catch (Exception ignore){ };
                 }
                 if (con!=null){
                        try { con.close();} catch (Exception ignore){ };
                 }
            }//finally
            return flag;
      }

   public int DBookByRoomType(String inroomtype){
            Connection con = null;
            init();
            int flag = 0;
            try{
                 con = ds.getConnection();
                 pstmt = con.prepareStatement("delete from Hotel_Book_User where 预订房间类型=?");
                 pstmt.setString(1,inroomtype);        
                 flag = pstmt.executeUpdate();
            }//end try
            catch (SQLException ex){
                   System.out.println("sql error: "+ex);
            }
            catch (Exception E){
                   System.out.println("Service Error: "+E);
            }
            finally{
                 if (rs!=null){
                        try { rs.close();} catch (Exception ignore){ };
                 }
                 if (pstmt!=null){
                        try { pstmt.close();} catch (Exception ignore){ };
                 }
                 if (con!=null){
                        try { con.close();} catch (Exception ignore){ };
                 }
            }//finally
            return flag;
      }

 

    public int DHotelRoomInfo(String roomtype){
            Connection con = null;
            init();
            int flag = 0;
            try{
                 con = ds.getConnection();
                 pstmt = con.prepareStatement("delete from Hotel_Room_Info where RoomType=?");
                 pstmt.setString(1,roomtype);        
                 flag = pstmt.executeUpdate();
            }//end try
            catch (SQLException ex){
                   System.out.println("sql error: "+ex);
            }
            catch (Exception E){
                   System.out.println("Service Error: "+E);
            }
            finally{
                 if (rs!=null){
                        try { rs.close();} catch (Exception ignore){ };
                 }
                 if (pstmt!=null){
                        try { pstmt.close();} catch (Exception ignore){ };
                 }
                 if (con!=null){
                        try { con.close();} catch (Exception ignore){ };
                 }
            }//finally
            return flag;
      }
     
     
    public int DHotelUserInfo(String idcard){
            Connection con = null;
            init();
            int flag = 0;
            try{
                 con = ds.getConnection();
                 pstmt = con.prepareStatement("delete from Hotel_User_Info where 身份证=?");
                 pstmt.setString(1,idcard);        
                 flag = pstmt.executeUpdate();
            }//end try
            catch (SQLException ex){
                   System.out.println("sql error: "+ex);
            }
            catch (Exception E){
                   System.out.println("Service Error: "+E);
            }
            finally{
                 if (rs!=null){
                        try { rs.close();} catch (Exception ignore){ };
                 }
                 if (pstmt!=null){
                        try { pstmt.close();} catch (Exception ignore){ };
                 }
                 if (con!=null){
                        try { con.close();} catch (Exception ignore){ };
                 }
            }//finally
            return flag;
      }


    public int DHotelRoom(String roomid){
            Connection con = null;
            init();
            int flag = 0;
            try{
                 con = ds.getConnection();
                 pstmt = con.prepareStatement("delete from Hotel_Room where RoomID=?");
                 pstmt.setString(1,roomid);        
                 flag = pstmt.executeUpdate();
            }//end try
            catch (SQLException ex){
                   System.out.println("sql error: "+ex);
            }
            catch (Exception E){
                   System.out.println("Service Error: "+E);
            }
            finally{
                 if (rs!=null){
                        try { rs.close();} catch (Exception ignore){ };
                 }
                 if (pstmt!=null){
                        try { pstmt.close();} catch (Exception ignore){ };
                 }
                 if (con!=null){
                        try { con.close();} catch (Exception ignore){ };
                 }
            }//finally
            return flag;
      }


    public int DHotelAdministor(String name){
            Connection con = null;
            init();
            int flag = 0;
            try{
                 con = ds.getConnection();
                 pstmt = con.prepareStatement("delete from Hotel_Administor where user_name=?");
                 pstmt.setString(1,name);
                 flag = pstmt.executeUpdate();
            }//end try
            catch (SQLException ex){
                   System.out.println("sql error: "+ex);
            }
            catch (Exception E){
                   System.out.println("Service Error: "+E);
            }
            finally{
                 if (rs!=null){
                        try { rs.close();} catch (Exception ignore){ };
                 }
                 if (pstmt!=null){
                        try { pstmt.close();} catch (Exception ignore){ };
                 }
                 if (con!=null){
                        try { con.close();} catch (Exception ignore){ };
                 }
            }//finally
            return flag;
      }
     

    public int MHotelRoomInfo(String roomprice,String roomtotal,String remaintoday,String remaintomorrow,String remainaftertomorrow,String remaininthird,String announcement,String roomtype){
            Connection con = null;
            init();
            int flag = 0;
            try{
                 con = ds.getConnection();
                 pstmt = con.prepareStatement("update Hotel_Room_Info set RoomPrice=?,RoomTotal=?,RemainToday=?,RemainTomorrow=?,RemainAfterTomorrow=?,RemainInThird=?,Announcement=? where RoomType=?");
                 pstmt.setString(1,roomprice);
                 pstmt.setString(2,roomtotal);
                 pstmt.setString(3,remaintoday);
                 pstmt.setString(4,remaintomorrow);
                 pstmt.setString(5,remainaftertomorrow);
                 pstmt.setString(6,remaininthird);
                 pstmt.setString(7,announcement);
                 pstmt.setString(8,roomtype);        
                 flag = pstmt.executeUpdate();
            }//end try
            catch (SQLException ex){
                   System.out.println("sql error: "+ex);
            }
            catch (Exception E){
                   System.out.println("Service Error: "+E);
            }
            finally{
                 if (rs!=null){
                        try { rs.close();} catch (Exception ignore){ };
                 }
                 if (pstmt!=null){
                        try { pstmt.close();} catch (Exception ignore){ };
                 }
                 if (con!=null){
                        try { con.close();} catch (Exception ignore){ };
                 }
            }//finally
            return flag;
      }
     
    public int MHotelRoomInfoA(String announcement,String roomtype){
            Connection con = null;
            init();
            int flag = 0;
            try{
                 con = ds.getConnection();
                 pstmt = con.prepareStatement("update Hotel_Room_Info set Announcement=? where RoomType=?");
                 pstmt.setString(1,announcement);
                 pstmt.setString(2,roomtype);        
                 flag = pstmt.executeUpdate();
            }//end try
            catch (SQLException ex){
                   System.out.println("sql error: "+ex);
            }
            catch (Exception E){
                   System.out.println("Service Error: "+E);
            }
            finally{
                 if (rs!=null){
                        try { rs.close();} catch (Exception ignore){ };
                 }
                 if (pstmt!=null){
                        try { pstmt.close();} catch (Exception ignore){ };
                 }
                 if (con!=null){
                        try { con.close();} catch (Exception ignore){ };
                 }
            }//finally
            return flag;
      }

    public int MHotelRoomInfoT(String roomtotal,String roomtype){
            Connection con = null;
            init();
            int flag = 0;
            try{
                 con = ds.getConnection();
                 pstmt = con.prepareStatement("update Hotel_Room_Info set RoomTotal=? where RoomType=?");
                 pstmt.setString(1,roomtotal);
                 pstmt.setString(2,roomtype);        
                 flag = pstmt.executeUpdate();
            }//end try
            catch (SQLException ex){
                   System.out.println("sql error: "+ex);
            }
            catch (Exception E){
                   System.out.println("Service Error: "+E);
            }
            finally{
                 if (rs!=null){
                        try { rs.close();} catch (Exception ignore){ };
                 }
                 if (pstmt!=null){
                        try { pstmt.close();} catch (Exception ignore){ };
                 }
                 if (con!=null){
                        try { con.close();} catch (Exception ignore){ };
                 }
            }//finally
            return flag;
      }


    public int MHotelRoomInfoP(String roomprice,String roomtype){
            Connection con = null;
            init();
            int flag = 0;
            try{
                 con = ds.getConnection();
                 pstmt = con.prepareStatement("update Hotel_Room_Info set RoomPrice=? where RoomType=?");
                 pstmt.setString(1,roomprice);
                 pstmt.setString(2,roomtype);        
                 flag = pstmt.executeUpdate();
            }//end try
            catch (SQLException ex){
                   System.out.println("sql error: "+ex);
            }
            catch (Exception E){
                   System.out.println("Service Error: "+E);
            }
            finally{
                 if (rs!=null){
                        try { rs.close();} catch (Exception ignore){ };
                 }
                 if (pstmt!=null){
                        try { pstmt.close();} catch (Exception ignore){ };
                 }
                 if (con!=null){
                        try { con.close();} catch (Exception ignore){ };
                 }
            }//finally
            return flag;
      }

    public int MRoomInfoNO(String bookdate1,String oldsum1,String booksum1,String roomtype1){
            Connection con = null;
            init();
            int flag = 0;
            String newsum="";
            int a=0;
            int b=0;
            int c=0;
            a=java.lang.Integer.parseInt(oldsum1);
            b=java.lang.Integer.parseInt(booksum1);
            c=a-b;
      if(c>=0){
            newsum=java.lang.Integer.toString(c);
          try{
                 con = ds.getConnection();
                 pstmt = con.prepareStatement("update Hotel_Room_Info set "+bookdate1+"=? where RoomType=?");
                 pstmt.setString(1,newsum);
                 pstmt.setString(2,roomtype1);
                 flag = pstmt.executeUpdate();
                 System.out.println("update roomremain successfully!");
            }//end try
            catch (SQLException ex){
                   System.out.println("sql error: "+ex);
            }
            catch (Exception E){
                   System.out.println("Service Error: "+E);
            }
            finally{
                 if (rs!=null){
                        try { rs.close();} catch (Exception ignore){ };
                 }
                 if (pstmt!=null){
                        try { pstmt.close();} catch (Exception ignore){ };
                 }
                 if (con!=null){
                        try { con.close();} catch (Exception ignore){ };
                 }
            }//finally
        }else{
                      flag=0;
           }
          return flag;
      }
     
     
    public int MDRoomInfoNO(String bookdate2,String oldsum2,String booksum2,String roomtype2){
            Connection con = null;
            init();
            int flag = 0;
            String newsum="";
            int a=0;
            int b=0;
            int c=0;
            a=java.lang.Integer.parseInt(oldsum2);
            b=java.lang.Integer.parseInt(booksum2);
            c=a+b;
            newsum=java.lang.Integer.toString(c);

            try{
                 con = ds.getConnection();
                 pstmt = con.prepareStatement("update Hotel_Room_Info set "+bookdate2+"=? where RoomType=?");
                 pstmt.setString(1,newsum);
                 pstmt.setString(2,roomtype2);
                 flag = pstmt.executeUpdate();
                 System.out.println("update roomremain successfully!");
            }//end try
            catch (SQLException ex){
                   System.out.println("sql error: "+ex);
            }
            catch (Exception E){
                   System.out.println("Service Error: "+E);
            }
            finally{
                 if (rs!=null){
                        try { rs.close();} catch (Exception ignore){ };
                 }
                 if (pstmt!=null){
                        try { pstmt.close();} catch (Exception ignore){ };
                 }
                 if (con!=null){
                        try { con.close();} catch (Exception ignore){ };
                 }
            }//finally
            return flag;
      }

 

    public int MHotelRoomInfoR(String remaintoday,String remaintomorrow,String remainaftertomorrow,String remaininthird,String roomtype){
            Connection con = null;
            init();
            int flag = 0;
            try{
                 con = ds.getConnection();
                 pstmt = con.prepareStatement("update Hotel_Room_Info set RemainToday=?,RemainTomorrow=?,RemainAfterTomorrow=?,RemainInThird=? where RoomType=?");
                 pstmt.setString(1,remaintoday);
                 pstmt.setString(2,remaintomorrow);
                 pstmt.setString(3,remainaftertomorrow);
                 pstmt.setString(4,remaininthird);
                 pstmt.setString(5,roomtype);        
                 flag = pstmt.executeUpdate();
            }//end try
            catch (SQLException ex){
                   System.out.println("sql error: "+ex);
            }
            catch (Exception E){
                   System.out.println("Service Error: "+E);
            }
            finally{
                 if (rs!=null){
                        try { rs.close();} catch (Exception ignore){ };
                 }
                 if (pstmt!=null){
                        try { pstmt.close();} catch (Exception ignore){ };
                 }
                 if (con!=null){
                        try { con.close();} catch (Exception ignore){ };
                 }
            }//finally
            return flag;
      }


          public int MHotelAdministor(String password,String spassword,String name){
  Connection con = null;
  int flag=0;            
  init();
  try{
   con = ds.getConnection();
                                                pstmt=con.prepareStatement("update Hotel_Administor set user_password=?,super_password=? where user_name=?");
                                                pstmt.setString(1,password);
                                                pstmt.setString(2,spassword);
                                                pstmt.setString(3,name);
                                                flag=pstmt.executeUpdate();
                                     }//end try
                        catch (SQLException ex){
                                System.out.println("sql error: "+ex);
                        }
                        catch (Exception E){
                                System.out.println("Service Error: "+E);
                        }
                        finally{
                                if (rs!=null){
                                       try { rs.close();} catch (Exception ignore){ };
                                }
                                if (pstmt!=null){
                                       try { pstmt.close();} catch (Exception ignore){ };
                                }
                                if (con!=null){
                                         try { con.close();} catch (Exception ignore){ };
                                }
                         }//finally
                         return flag;
            }

        public int MHotelBookUser(String booksum,String bookroomtype,String bookdate,String id)
                         {
                                Connection con = null;
  int flag=0;          
  init();
  try{
                                     con = ds.getConnection();
                                      pstmt=con.prepareStatement("update Hotel_Book_User set 预订房间数=?,预订房间类型=?,预订日期=? where id=?");
                                      pstmt.setString(1,booksum);
                                      pstmt.setString(2,bookroomtype);
                                      pstmt.setString(3,bookdate);
                                      pstmt.setString(4,id);
                                      flag = pstmt.executeUpdate();
                       }//end try
                        catch (SQLException ex){
                                System.out.println("sql error: "+ex);
                        }
                        catch (Exception E){
                                System.out.println("Service Error: "+E);
                        }
                        finally{
                                if (rs!=null){
                                       try { rs.close();} catch (Exception ignore){ };
                                }
                                if (pstmt!=null){
                                       try { pstmt.close();} catch (Exception ignore){ };
                                }
                                if (con!=null){
                                         try { con.close();} catch (Exception ignore){ };
                                }
                         }//finally
                         return flag;
            }
           
     public int MchangeRoom(String inroomtype,String inroomno,String inroomsum,String idcard){
  Connection con = null;
  int flag=0;            
  init();
  try{
   con = ds.getConnection();
                                               pstmt = con.prepareStatement("update Hotel_User_Info set 入住房间类型=?,入住房间号=?,入住房间数量=? where 身份证=?");
                                               pstmt.setString(1,inroomtype);
                                               pstmt.setString(2,inroomno);
                                               pstmt.setString(3,inroomsum);
                                               pstmt.setString(4,idcard);
                                               flag = pstmt.executeUpdate();
                                       }//end try
                        catch (SQLException ex){
                                System.out.println("sql error: "+ex);
                        }
                        catch (Exception E){
                                System.out.println("Service Error: "+E);
                        }
                        finally{
                                if (rs!=null){
                                       try { rs.close();} catch (Exception ignore){ };
                                }
                                if (pstmt!=null){
                                       try { pstmt.close();} catch (Exception ignore){ };
                                }
                                if (con!=null){
                                         try { con.close();} catch (Exception ignore){ };
                                }
                         }//finally
                         return flag;
            }
           

       public int MHotelUserInfo_3(String inday,String isbalancecount,String countdate,String isprinted,String money,String isdebt,String debtsum,String idcard){
  Connection con = null;
  int flag=0;            
  init();
  try{
   con = ds.getConnection();
                                               pstmt = con.prepareStatement("update Hotel_User_Info set 入住天数=?,是否结账=?,结账日期=?,是否打印发票=?,消费额=?,是否欠费=?,欠费额度=? where 身份证=?");
                                               pstmt.setString(1,inday);
                                               pstmt.setString(2,isbalancecount);
                                               pstmt.setString(3,countdate);
                                               pstmt.setString(4,isprinted);
                                               pstmt.setString(5,money);
                                               pstmt.setString(6,isdebt);
                                               pstmt.setString(7,debtsum);
                                               pstmt.setString(8,idcard);
                                               flag = pstmt.executeUpdate();
                                       }//end try
                        catch (SQLException ex){
                                System.out.println("sql error: "+ex);
                        }
                        catch (Exception E){
                                System.out.println("Service Error: "+E);
                        }
                        finally{
                                if (rs!=null){
                                       try { rs.close();} catch (Exception ignore){ };
                                }
                                if (pstmt!=null){
                                       try { pstmt.close();} catch (Exception ignore){ };
                                }
                                if (con!=null){
                                         try { con.close();} catch (Exception ignore){ };
                                }
                         }//finally
                         return flag;
            }
           
    public int MHotelUserInfo_2(String prepay,String money,String idcard){
  Connection con = null;
  String newmoney="";
  int a=0;
  int b=0;
  int c=0;
  a=java.lang.Integer.parseInt(prepay);
  b=java.lang.Integer.parseInt(money);
  c=a+b;
  newmoney=java.lang.Integer.toString(c);
  int flag=0;            
  init();
  try{
   con = ds.getConnection();
                                               pstmt = con.prepareStatement("update Hotel_User_Info set 预交费=?,消费额=? where 身份证=?");
                                               pstmt.setString(1,prepay);
                                               pstmt.setString(2,newmoney);
                                               pstmt.setString(3,idcard);
                                               flag = pstmt.executeUpdate();
                                       }//end try
                        catch (SQLException ex){
                                System.out.println("sql error: "+ex);
                        }
                        catch (Exception E){
                                System.out.println("Service Error: "+E);
                        }
                        finally{
                                if (rs!=null){
                                       try { rs.close();} catch (Exception ignore){ };
                                }
                                if (pstmt!=null){
                                       try { pstmt.close();} catch (Exception ignore){ };
                                }
                                if (con!=null){
                                         try { con.close();} catch (Exception ignore){ };
                                }
                         }//finally
                         return flag;
            }           
           
         public int MHotelUserInfo_1(String inroomtype,String inroomno,String inroomsum,String money,String idcard){
  Connection con = null;
  int flag=0;            
  init();
  try{
   con = ds.getConnection();
                                               pstmt = con.prepareStatement("update Hotel_User_Info set 入住房间类型=?,入住房间号=?,入住房间数量=?,消费额=? where and 身份证=?");
                                               pstmt.setString(1,inroomtype);
                                               pstmt.setString(2,inroomno);
                                               pstmt.setString(3,inroomsum);
                                               pstmt.setString(4,money);
                                               pstmt.setString(5,idcard);
                                               flag = pstmt.executeUpdate();
                                       }//end try
                        catch (SQLException ex){
                                System.out.println("sql error: "+ex);
                        }
                        catch (Exception E){
                                System.out.println("Service Error: "+E);
                        }
                        finally{
                                if (rs!=null){
                                       try { rs.close();} catch (Exception ignore){ };
                                }
                                if (pstmt!=null){
                                       try { pstmt.close();} catch (Exception ignore){ };
                                }
                                if (con!=null){
                                         try { con.close();} catch (Exception ignore){ };
                                }
                         }//finally
                         return flag;
            }

   public int MHotelRoom(String thisroomtype,String roomprice,String isempty,String useridcard,String roomid){
  Connection con = null;
  int flag=0;            
  init();
  try{
   con = ds.getConnection();
                                                pstmt = con.prepareStatement("update Hotel_Room set RoomType=?,RoomPrice=?,IsEmpty=?,User_IdCard=? where RoomID=?");
                                                pstmt.setString(1,thisroomtype);
                                                pstmt.setString(2,roomprice);
                                                pstmt.setString(3,isempty);
                                                pstmt.setString(4,useridcard);
                                                pstmt.setString(5,roomid);
                                                flag=pstmt.executeUpdate();
                                     }//end try
                        catch (SQLException ex){
                                System.out.println("sql error: "+ex);
                        }
                        catch (Exception E){
                                System.out.println("Service Error: "+E);
                        }
                        finally{
                                if (rs!=null){
                                       try { rs.close();} catch (Exception ignore){ };
                                }
                                if (pstmt!=null){
                                       try { pstmt.close();} catch (Exception ignore){ };
                                }
                                if (con!=null){
                                         try { con.close();} catch (Exception ignore){ };
                                }
                         }//finally
                         return flag;
            } 
           
   public int MHotelRoomU(String isempty,String roomid){
  Connection con = null;
  int flag=0;            
  init();
  try{
   con = ds.getConnection();
                                                pstmt = con.prepareStatement("update Hotel_Room set IsEmpty=? where RoomID=?");
                                                pstmt.setString(1,isempty);
                                                pstmt.setString(2,roomid);
                                                flag=pstmt.executeUpdate();
                                     }//end try
                        catch (SQLException ex){
                                System.out.println("sql error: "+ex);
                        }
                        catch (Exception E){
                                System.out.println("Service Error: "+E);
                        }
                        finally{
                                if (rs!=null){
                                       try { rs.close();} catch (Exception ignore){ };
                                }
                                if (pstmt!=null){
                                       try { pstmt.close();} catch (Exception ignore){ };
                                }
                                if (con!=null){
                                         try { con.close();} catch (Exception ignore){ };
                                }
                         }//finally
                         return flag;
            }
  
 }
             
  

W了个G
关注
shiro将session认证改成token认证_Shiro框架：认证和授权原理
weixin_39866867的博客
01-18 882
点击上方Java后端，选择设为星标优质文章，及时送达前言Shiro作为解决权限问题的常用框架，常用于解决认证、授权、加密、会话管理等场景。本文将对Shiro的认证和授权原理进行介绍：Shiro可以做什么？、Shiro是由什么组成的？举个Shiro的例子呗？Shiro认证的原理是咋样的？Shiro授权的原理是咋样的？1. Shiro可以做什么？在构建一个网络应用的时候，权限检验管理作为...
java ejb开发_Java实践之路——EJB（一）
weixin_35682224的博客
02-16 1015
下面开始我的EJB之旅学习任何一门技巧之前，都定然容易的打听一下该技巧的用处的优缺点。因而率先我们来看一下摘自百度百科上面对EJB的定义和解释==========================================================================EJB是sun的服务器端组件模型，最大的用处是安排散布式利用过程当然,还有众多措施能够告终散布式利用，相仿微软...
EJB——无状态会话Bean的Remote远程接口_hotel.java
程序员的良师益友
08-23 704
package wanggsx.ejb; /** * Remote interface for Enterprise Bean: Hello * Remote 接口 */ import wanggsx.ejb.*;import java.util.*;import javax.ejb.*;public interface hotel extends javax.ejb.EJBObject   {
session和token实现用户认证的异同
christwei的博客
04-20 3882
现在貌似大多数网站用户认证都是基于 session 的，即在服务端生成用户相关的 session 数据，而发给客户端 sesssion_id 存放到 cookie 中，这样用客户端请求时带上 session_id 就可以验证服务器端是否存在 session 数据，以此完成用户认证。这种认证方式，可以更好的在服务端对会话进行控制，安全性比较高(session_id 随机），但是服务端需要存储 ses...
java中的ejb_在Java EE中与EJB交互的最佳方式
weixin_29150247的博客
02-25 263
我有一个中等规模的Java EE 6项目,它使用多个EJB,其中一个目的是通过JPA管理数据库调用.我的问题是添加一个新类的最佳方法是什么,该类执行一些随机功能,然后调用数据库访问EJB来保存此类中的数据.如果需要访问注释和注入,这个新类必须是EJB吗？如果必须与项目的其余部分一起部署,它是否必须是EJB？有人告诉我,如果你想为项目添加一个新的逻辑类,它必须是一个EJB,或者你可以使用JNDI远程...
Android app开放接口API安全性之Token签名Sign的设计与实现
Heqianqian的博客
11-03 2222
前言在app开放接口api的设计中，避免不了的就是安全性问题，因为大多数接口涉及到用户的个人信息以及一些敏感的数据，所以对这些接口需要进行身份的认证，那么这就需要用户提供一些信息，比如用户名密码等，但是为了安全起见让用户暴露的明文密码次数越少越好，我们一般在web项目中，大多数采用保存的session中，然后在存一份到cookie中，来保持用户的回话有效性。但是在app提供的开放接口中，后端服务器在
EJB基础.rar_ejb_enterprise java bean_分布式计算
09-22
Enterprise JavaBean（EJB）是Java平台上用于构建可部署到企业级服务器的组件模型。它是一种规范，由Java Community Process（JCP）定义，旨在简化企业级应用开发，特别是分布式计算环境中的应用。EJB技术提供了面向...
网络花店远程销售平台.rar_ejb_javabean SQL _jsp 销售_jsp+servlet销售_通用 java
09-23
EJB组件可以被设计为会话bean（Session Beans），用于管理客户端的交互，或者实体bean（Entity Beans），来持久化数据到数据库中。 JavaBean是一种符合特定规范的Java类，它封装了数据和业务逻辑，便于在JSP页面中...
Weblogic10+EJB3入门：编写无状态会话Bean教程
“Weblogic_ejb”是一个关于使用WebLogic服务器部署和管理EJB3（Enterprise JavaBeans 3.0）的教程，特别关注无状态会话Bean的创建和访问。 在Java企业级应用开发中，EJB是用于构建可扩展、分布式的后端服务的核心...
开放API接口签名验证，让你的接口从此不再裸奔
Java笔记虾
09-03 1361
作者：Joker_Codingblog.csdn.net/qq_18495465/article/details/79248608接口安全问题请求身份是否合法？请求参数是否被篡改？请求是...
移动端与PHP服务端接口通信流程设计(基础版)
weixin_33912638的博客
08-17 235
2019独角兽企业重金招聘Python工程师标准>>> ...
在EJB3中编写拦截器以及如何配置默认拦截器
syouketu的专栏
07-23 969
1.编写拦截器,主要是把进入的类和方法写入日志中 import javax.interceptor.AroundInvoke; import javax.interceptor.InvocationContext; import org.slf4j.Logger; import org.slf4j.LoggerFactory; public class HpTracingIntercept
RSA 实现数据加密解密以及Token管理
热门推荐
纸上得来终觉浅，绝知此事要躬行
08-02 1万+
1.RSA加密工具 package com.wlyd.fmcgwms.util.api; import java.io.ByteArrayOutputStream; import java.security.Key; import java.security.KeyFactory; import java.security.KeyPair; import java.security.KeyPa
【java毕业设计】应急救援物资管理系统源码（springboot+vue+mysql+说明文档）.zip
11-06
项目经过测试均可完美运行！ 环境说明： 开发语言：java jdk：jdk1.8 数据库：mysql 5.7+ 数据库工具：Navicat11+ 管理工具：maven 开发工具：idea/eclipse
基于java的音乐网站答辩PPT.pptx
11-06
基于java的音乐网站答辩PPT.pptx
基于Flexsim的公路交通仿真系统.zip
最新发布
11-06
基于Flexsim软件开发的仿真系统，可供参考学习使用
weixin073智慧旅游平台开发微信小程序+ssm后端毕业源码案例设计.zip
11-06
weixin073智慧旅游平台开发微信小程序+ssm后端毕业源码案例设计 1、资源项目源码均已通过严格测试验证，保证能够正常运行； 2、项目问题、技术讨论，可以给博主私信或留言，博主看到后会第一时间与您进行沟通； 3、本项目比较适合计算机领域相关的毕业设计课题、课程作业等使用，尤其对于人工智能、计算机科学与技术等相关专业，更为适合； 4、下载使用后，可先查看README.md或论文文件（如有），本项目仅用作交流学习参考，请切勿用于商业用途。 5、资源来自互联网采集，如有侵权，私聊博主删除。 6、可私信博主看论文后选择购买源代码。 1、资源项目源码均已通过严格测试验证，保证能够正常运行； 2、项目问题、技术讨论，可以给博主私信或留言，博主看到后会第一时间与您进行沟通； 3、本项目比较适合计算机领域相关的毕业设计课题、课程作业等使用，尤其对于人工智能、计算机科学与技术等相关专业，更为适合； 4、下载使用后，可先查看README.md或论文文件（如有），本项目仅用作交流学习参考，请切勿用于商业用途。 5、资源来自互联网采集，如有侵权，私聊博主删除。 6、可私信博主看论文后选择购买源代码。 1、资源项目源码均已通过严格测试验证，保证能够正常运行； 2、项目问题、技术讨论，可以给博主私信或留言，博主看到后会第一时间与您进行沟通； 3、本项目比较适合计算机领域相关的毕业设计课题、课程作业等使用，尤其对于人工智能、计算机科学与技术等相关专业，更为适合； 4、下载使用后，可先查看README.md或论文文件（如有），本项目仅用作交流学习参考，请切勿用于商业用途。 5、资源来自互联网采集，如有侵权，私聊博主删除。 6、可私信博主看论文后选择购买源代码。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值