waiterbo.java~16~

宽带网收费系统的前台

package netservice.waiter.BO;

import java.util.GregorianCalendar;
import java.util.Calendar;
import java.util.Date;
import netservice.vo.UserInfo;
import java.sql.*;
import netservice.DBconnect.DBConnectManage;
public class WaiterBO {
    public WaiterBO() {
    }
    public String getUserid(){
        GregorianCalendar calendar=(GregorianCalendar) Calendar.getInstance();
       calendar.setTime(new Date());
       String year=String.valueOf(calendar.get(GregorianCalendar.YEAR));
       String month=String.valueOf(calendar.get(GregorianCalendar.MONTH)+1);
       int m=Integer.parseInt(month);
       if(m<10){
           month="0"+month;
       }
       String day=String.valueOf(calendar.get(GregorianCalendar.DAY_OF_MONTH));
       int d=Integer.parseInt(day);
       if(d<10){
           day="0"+day;
       }
       String minute=String.valueOf(calendar.get(GregorianCalendar.MINUTE));
       if(Integer.parseInt(minute)<10){
           minute="0"+minute;
       }
       String second=String.valueOf(calendar.get(GregorianCalendar.SECOND));
       if(Integer.parseInt(second)<10){
           second="0"+second;
       }
       return year+month+day+minute+second;
    }
    public String getRegisterTime(){
       //产生注册日期
       GregorianCalendar calendar=(GregorianCalendar) Calendar.getInstance();
       calendar.setTime(new Date());
       String year=String.valueOf(calendar.get(GregorianCalendar.YEAR));
       String month=String.valueOf(calendar.get(GregorianCalendar.MONTH)+1);
       int m=Integer.parseInt(month);
       if(m<10){
           month="0"+month;
       }
       String day=String.valueOf(calendar.get(GregorianCalendar.DAY_OF_MONTH));
       int d=Integer.parseInt(day);
       if(d<10){
           day="0"+day;
       }
       return year+month+day;
   }
   public String getEndtime(String userBegintime,String userAccounttype){
       String userEndtime=new String();
       int n=0;
       if(userAccounttype.equals("0")){
           n=0;
       }
       if(userAccounttype.equals("1")){
           n=1;
       }
       if(userAccounttype.equals("2")){
           n=2;
       }
       if(userAccounttype.equals("3")){
           n=3;
       }
       char[] c=userBegintime.toCharArray();
       if(n==0){
           c[3]='7';
           c[5]='3';
       }
       if(n==1){
           c[3]='7';
       }
       if(n==2){
           c[4]='1';
           c[5]='2';
       }
       if(n==3){
           c[5]='0';
           c[4]='1';
       }
       userEndtime=String.valueOf(c);
       return userEndtime;
   }
   public boolean saveNewuser(UserInfo user){
       Connection conn=null;
       PreparedStatement ps=null;
       PreparedStatement ps1=null;
       ResultSet rs=null;
       try{
           conn=DBConnectManage.getInstance().getConnection("SQLServer");
           ps=conn.prepareStatement("insert into userinfo(userId,userType,userName,userAddress,userTel,userMobile,userBegintime,userMemo,userAccounttype,waiterId,userStatus) values(?,?,?,?,?,?,?,?,?,?,?)");
           ps.setString(1,user.getUserId());
           ps.setString(2,user.getUserType());
           ps.setString(3,user.getUserName());
           ps.setString(4,user.getUserAddress());
           ps.setString(5,user.getUserTel());
           ps.setString(6,user.getUserMobile());
           ps.setString(7,user.getUserBegintime());
           ps.setString(8,user.getUserMemo());
           ps.setString(9,user.getUserAccounttype());
           ps.setString(10,user.getWaiterId());
           ps.setString(11,user.getUserStatus());
           ps.executeUpdate();
           ps1=conn.prepareStatement("insert into Bus(busType,waiterId,userId,verifyStatus) values(?,?,?,?)");
           ps1.setString(1,"0");
           ps1.setString(2,user.getWaiterId());
           ps1.setString(3,user.getUserId());
           ps1.setString(4,"0");
           ps1.executeUpdate();
       }catch(SQLException e){
           e.printStackTrace();
       }
       DBConnectManage.getInstance().freeConnection("SQLServer",conn);
       return true;
   }
   public UserInfo getOlduser(String userId){
       Connection conn=null;
       PreparedStatement ps=null;
       ResultSet rs=null;
       UserInfo user=new UserInfo();
       try{
           conn=DBConnectManage.getInstance().getConnection("SQLServer");
           System.out.print("Connection ....");
           System.out.println(userId);
           ps=conn.prepareStatement("select * from UserInfo where userId=?");
           ps.setString(1,userId);
           rs=ps.executeQuery();
           while(rs.next()){
                user.setUserId(rs.getString(1));
                user.setUserType(rs.getString(2));
                user.setUserName(rs.getString(3));
                user.setUserAddress(rs.getString(4));
                user.setUserTel(rs.getString(5));
                user.setUserMobile(rs.getString(6));
                user.setUserBegintime(rs.getString(7));
                user.setUserMemo(rs.getString(8));
                user.setUserAccounttype(rs.getString(9));
                user.setWaiterId(rs.getString(10));
                user.setUserStatus(rs.getString(11));
                user.setUserEndtime(rs.getString(12));
           }

       }catch(SQLException e){
           e.printStackTrace();
       }
       DBConnectManage.getInstance().freeConnection("SQLServer",conn);
       if(user.getUserId()==null){
           return null;
       }else{
           return user;
       }
   }
   public boolean  continueAcc(UserInfo user,String type){
       String begintime=new WaiterBO().getRegisterTime();
       Connection conn=null;
       PreparedStatement ps1=null;
       PreparedStatement ps=null;
       PreparedStatement ps2=null;
       ResultSet rs=null;
       try{
           conn=DBConnectManage.getInstance().getConnection("SQLServer");
           ps1=conn.prepareStatement("delete from UserInfo where userId=?");
           ps1.setString(1,user.getUserId());
           ps1.executeUpdate();
           ps=conn.prepareStatement("insert into userinfo(userId,userType,userName,userAddress,userTel,userMobile,userBegintime,userMemo,userAccounttype,waiterId,userStatus) values(?,?,?,?,?,?,?,?,?,?,?)");
           ps.setString(1,user.getUserId());
           ps.setString(2,user.getUserType());
           ps.setString(3,user.getUserName());
           ps.setString(4,user.getUserAddress());
           ps.setString(5,user.getUserTel());
           ps.setString(6,user.getUserMobile());
           ps.setString(7,user.getUserBegintime());
           ps.setString(8,user.getUserMemo());
           ps.setString(9,type);
           ps.setString(10,user.getWaiterId());
           ps.setString(11,user.getUserStatus());
           ps.executeUpdate();
           ps2=conn.prepareStatement("insert into Bus(busType,waiterId,userId,verifyStatus) values(?,?,?,?)");
           ps2.setString(1,"0");
           ps2.setString(2,user.getWaiterId());
           ps2.setString(3,user.getUserId());
           ps2.setString(4,"1");
           ps2.executeUpdate();


       }catch(SQLException e){
           e.printStackTrace();
           return false;
       }
       DBConnectManage.getInstance().freeConnection("SQLServer",conn);
       return true;
   }
  /* public UserInfo Problem(String userId){
       Connection conn=null;
       PreparedStatement ps=null;
       ResultSet rs=null;
       UserInfo user=new UserInfo();
       try{
           conn=DBConnectManage.getInstance().getConnection("SQLServer");
           System.out.print("Connection ....");
           System.out.println(userId);
           ps=conn.prepareStatement("select * from UserInfo where userId=?");
           ps.setString(1,userId);
           rs=ps.executeQuery();
           while(rs.next()){
               user.setUserId(rs.getString(1));
               user.setUserType(rs.getString(2));
               user.setUserName(rs.getString(3));
               user.setUserAddress(rs.getString(4));
               user.setUserTel(rs.getString(5));
               user.setUserMobile(rs.getString(6));
               user.setUserBegintime(rs.getString(7));
               user.setUserMemo(rs.getString(8));
               user.setUserAccounttype(rs.getString(9));
               user.setWaiterId(rs.getString(10));
               user.setUserStatus(rs.getString(11));
               user.setUserEndtime(rs.getString(12));
           }

       }catch(SQLException e){
           e.printStackTrace();
       }
       if(user.getUserId()==null){
           return null;
       }else{
           return user;
       }

   }*/
}