sb_accommodationmanagerbean.java~40~

用j2ee开发的一个旅店管理系统

package com.xc.hotelmanager.hotel.control.session;

import javax.ejb.*;
import javax.naming.*;
import javax.rmi.*;
import java.util.*;
import java.util.Date;
import java.text.SimpleDateFormat;
import com.xc.hotelmanager.hotel.control.EjbGetter;
import com.xc.hotelmanager.hotel.control.entity.*;
import com.xc.hotelmanager.hotel.exception.*;
import com.xc.hotelmanager.hotel.model.*;
import com.xc.hotelmanager.hotel.control.entity.TbAccommodationBean;
import java.sql.*;


public class SB_AccommodationManagerBean implements SessionBean {
  SessionContext sessionContext;
  public void ejbCreate() throws CreateException {
    /**@todo Complete this method*/
  }
  public void ejbRemove() {
    /**@todo Complete this method*/
  }
  public void ejbActivate() {
    /**@todo Complete this method*/
  }
  public void ejbPassivate() {
    /**@todo Complete this method*/
  }
  public void setSessionContext(SessionContext sessionContext) {
    this.sessionContext = sessionContext;
  }
  public Collection getAccInfo(String cname, String roomid) throws HotelManagerException {
     try{
           String sql="select * from Accommodation where name='"+cname+"'"+" and roomid='"+roomid+"' and charge=0.0";
           System.out.println(sql);
           return this.loadBySql(sql);
         }
     catch(Exception ex){
       throw new HotelManagerException(ex.getMessage());
     }
  }

  public String getleavedate() throws HotelManagerException {

      try{
       java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat("yyyy-MM-dd");
       java.util.Date date = new java.util.Date();
       String str_date = formatter.format(date);
       return  str_date;
      }
      catch(Exception ex){
      throw  new  HotelManagerException(ex.getMessage());
      }

  }
  public int getlivedays(String id) throws HotelManagerException {
    try{
       TbAccommodation ejbAcc=EjbGetter.getTbAccommodationHome().findByPrimaryKey(id);
       String str_date2=ejbAcc.getIntime();
       java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat("yyyyMMdd");
        java.util.Date TimeNow = new java.util.Date();
       String str_date1 = formatter.format(TimeNow);
       int x=(Integer.parseInt(str_date1)-Integer.parseInt(str_date2));
       int days=(x/10000)*365+((((x%10000)/1000)*10)+((x%1000)/100))*30+(x%100);
       if(days<100){days=days-70;}
       return days;
     }
     catch(Exception ex){
       throw new HotelManagerException(ex.getMessage());
     }


  }
  public float getTotelCost(String id) throws HotelManagerException {
    float cost;
    try{
       TbAccommodation ejbAcc=EjbGetter.getTbAccommodationHome().findByPrimaryKey(id);
       int price=ejbAcc.getPrice();
       int precharge=ejbAcc.getPrecharge();
       String str_date2=ejbAcc.getIntime();
       java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat("yyyyMMdd");
       java.util.Date TimeNow = new java.util.Date();
       String str_date1 = formatter.format(TimeNow);
       int days = (Integer.parseInt(str_date1) - Integer.parseInt(str_date2));
       cost=price*days-precharge;
       }
       catch(Exception ex){
            throw new HotelManagerException(ex.getMessage());
          }

      return  cost;

  }
  public String saveToAcc(String id, String leavetime, float charge) throws HotelManagerException {
    String r1="保存成功，已存入数据库！";
    String r2="出错啦！";
    try{
           TbAccommodation ejbAcc=EjbGetter.getTbAccommodationHome().findByPrimaryKey(id);
            ejbAcc.setLeavetime(leavetime);
            ejbAcc.setCharge(charge);
            return  r1;
        }
        catch(Exception ex){
            //throw new HotelManagerException(ex.getMessage());
            return r2;
          }


  }

  private Collection loadBySql(String sql) throws Exception {
            Connection conn=EjbGetter.getDataSource().getConnection();
            Statement st=conn.createStatement();
            ResultSet rs=st.executeQuery(sql);
            Collection result=new Vector();
            while(rs.next()){
                Accommodation acc=new Accommodation();
                acc.setId(rs.getString("id"));
                acc.setCid(rs.getString("cid"));
                acc.setName(rs.getString("name"));
                acc.setIntime(rs.getString("intime"));
                acc.setLeavetime(rs.getString("leavetime"));
                acc.setRoomid(rs.getString("roomid"));
                acc.setPrice(rs.getInt("price"));
                acc.setPrecharge(rs.getInt("precharge"));
                acc.setCharge(rs.getFloat("charge"));
                System.out.println("this is load method");
                System.out.println(acc.getId());
                System.out.println(acc.getName());
                result.add(acc);
            }
            rs.close();
            conn.close();
            return result;

  }
  public Accommodation loadAccommodation(String id)  throws HotelManagerException {
      try{
          TbAccommodation ejbAccommodation=EjbGetter.getTbAccommodationHome().findByPrimaryKey(id);
          return ejbAccommodation.getAccommodation();
      }
      catch(Exception ex){
          throw new HotelManagerException("SB_AccommoManagerBean.load Eorr:"+ex.getMessage());
      }

  }
  public void removeAccommodation(String id)  throws HotelManagerException {
      try{
          TbAccommodation ejbAccommodation=EjbGetter.getTbAccommodationHome().findByPrimaryKey(id);
         ejbAccommodation.setLeavetime(String.valueOf(new Timestamp(System.currentTimeMillis())));

      }
      catch(Exception ex){
          throw new HotelManagerException(ex.getMessage());
      }

  }
  public Accommodation saveAccommodation(Accommodation arecord)  throws HotelManagerException {
      try{
          TbAccommodation ejbAccommodation=EjbGetter.getTbAccommodationHome().findByPrimaryKey(arecord.getId());
          ejbAccommodation.setAccommodation(arecord);
          return arecord;
      }
      catch(Exception ex){
          throw new HotelManagerException("SB_AccommoManagerBean.save Eorr:"+ex.getMessage());
      }

  }
  public Accommodation addAccommodation(Accommodation arecord) throws HotelManagerException {
    try{
        System.out.print("后台测试传入的老顾客的身份证号为："+arecord.getCid());
    Date date=new Date();
    SimpleDateFormat df=new SimpleDateFormat("yyMMddhh");
    SimpleDateFormat ds=new SimpleDateFormat("yyyyMMdd");
    String str=df.format(date);
    str=str+arecord.getCid();
    System.out.println(str);
          TbAccommodation ejbAccommodation=EjbGetter.getTbAccommodationHome().create(str,arecord.getCid(),arecord.getRoomid());
         System.out.println("ejbcreate ok");
          ejbAccommodation.setAccommodation(arecord);
           System.out.print("后台测试老顾客的身份证号是否正确："+arecord.getCid());
          //ejbAccommodation.setInDate(new Timestamp(System.currentTimeMillis()));
          ejbAccommodation.setIntime(ds.format(date));

          return arecord;
      }
      catch(Exception ex){
          throw new HotelManagerException("SB_AccommoManagerBean.add Eorr:"+ex.getMessage());
      }

  }
  public Collection getAllAccommodation() throws HotelManagerException{
      try{
          String sql="select * from Accommodation";
           System.out.print("SB_AccommodationMangerBEAN.getAllAccommodation OK!");
          return this.loadBySql(sql);
      }
      catch(Exception ex){
        ex.printStackTrace();
        System.out.print("SB_AccommodationMangerBEAN.getAllAccommodation Error!");
          throw new HotelManagerException(ex.getMessage());
      }

  }
  public Collection getSearchAccommodation(String sql)throws HotelManagerException{
      try{
          System.out.print("SB_AccommodationMangerBEAN.getAllAccommodation OK!");
          return this.loadBySql(sql);
      }
      catch(Exception ex){
        ex.printStackTrace();
        System.out.print("SB_AccommodationMangerBEAN.getSearchAccommodation Error!");
          throw new HotelManagerException(ex.getMessage());
      }

  }

  public Collection getAllAccommodation(String id) throws HotelManagerException{

       try{
         String sql="select * from Accommodation where id='"+id+"'";
         return this.loadBySql(sql);
       }
       catch(Exception ex){
         throw new HotelManagerException(ex.getMessage());
       }
     }

     public float getCost(String id)  throws HotelManagerException{
        float cost;
        try{
           TbAccommodation ejbAcc=EjbGetter.getTbAccommodationHome().findByPrimaryKey(id);
           int price=ejbAcc.getPrice();
           String str_date2=ejbAcc.getIntime();
           java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat("yyyyMMdd");
           java.util.Date TimeNow = new java.util.Date();
           String str_date1 = formatter.format(TimeNow);
           int x = (Integer.parseInt(str_date1) - Integer.parseInt(str_date2));
           int days=(x/10000)*365+((((x%10000)/1000)*10)+((x%1000)/100))*30+(x%100);
           cost=price*days;
           }
           catch(Exception ex){
                throw new HotelManagerException(ex.getMessage());
              }

          return  cost;

       }


}