managerdate.java

java 网吧项目 源码

package netbar;

import java.sql.*;
import java.awt.*;

public class ManagerDate {
    public ManagerDate() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    //设置位置
    public static void setLocationAndView(Component frame) {

      // Center the window
      Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
      Dimension frameSize = frame.getSize();
      if (frameSize.height > screenSize.height) {
          frameSize.height = screenSize.height;
      }
      if (frameSize.width > screenSize.width) {
          frameSize.width = screenSize.width;
      }
      frame.setLocation((screenSize.width - frameSize.width) / 2,
                        (screenSize.height - frameSize.height) / 2);
      frame.setVisible(true);
  }

    //获取上机管理的时间
    public String getBeginTime(String cardId){
        String begintime="";
        SQLDate.sqldate();
        try {
            Connection con = DriverManager.getConnection("jdbc:odbc:netbar");
            Statement st = con.createStatement();
            ResultSet rs = st.executeQuery("select BeginTime from WorkOfManager where ManagerId='"+cardId+"' and EndTime='1900-01-01 00:00:00'");
            rs.next();
            begintime=rs.getString(1);
            st.close();
            con.close();
        } catch (SQLException ee) {
            System.out.println(ee);
        }
        return begintime;
    }


    //获得下机时管理员的管理时间
    public int getManagerTime(String begintime,String endtime){
      //获取上机各个时间段
      int byear=Integer.parseInt(begintime.substring(0,4).trim());
      int bmonth=Integer.parseInt(begintime.substring(5,7).trim());
      int bday=Integer.parseInt(begintime.substring(8,10).trim());
      int bhour=Integer.parseInt(begintime.substring(11,13).trim());
      int bminute=Integer.parseInt(begintime.substring(14,16).trim());

      //System.out.println(byear+"\n"+bmonth+"\n"+bday+"\n"+bhour+"\n"+bminute);
      //获取下机各个时间段
      int eyear=Integer.parseInt(endtime.substring(0,4).trim());
      //System.out.println(eyear);
      int emonth=Integer.parseInt(endtime.substring(5,7).trim());
      //System.out.println(emonth);
      int eday=Integer.parseInt(endtime.substring(8,10).trim());
      //System.out.println(eday);
       //System.out.println(endtime);
      int ehour=Integer.parseInt(endtime.substring(11,14).trim());
      //System.out.println(ehour);
      int eminute=Integer.parseInt(endtime.substring(15,17).trim());
      //System.out.println(eminute);

      //System.out.println(eyear+"\n"+emonth+"\n"+eday+"\n"+ehour+"\n"+eminute);

      int donettime=0;
      //计算当前总共上机时间
      donettime=Math.abs((eyear-byear)*365*24*60+
                (emonth-bmonth)*30*24*60+
                (eday-bday)*24*60+
                (ehour-bhour)*60+
                (eminute-bminute));
      return donettime;
  }

  //记录数据
  public void notedate(String cardId,String endtime,int managertime){
      SQLDate.sqldate();
       try{
       Connection con=DriverManager.getConnection("jdbc:odbc:netbar");
       Statement st=con.createStatement();
       st.executeUpdate("update Manager set Onuse=0 where Id='"+cardId+"'");
       st.executeUpdate("update WorkOfManager set EndTime='"+endtime+"',ManagerTime='"+managertime+"' where ManagerId='"+cardId+"' and EndTime='1900-01-01 00:00:00'");
       st.close();
       con.close();
       }catch(SQLException ee){
       System.out.println(ee);
       }
  }

  //获得当前用费
  public int getfee(int  time){
      int fee=2;
       if(time>=65&&(time%60)<5&&(time%60)>0){
        fee=(time/60)*2;
        }
        if(time>65&&(time%60)<60&&(time%60)>=5){
        fee=(time/60+1)*2;
        }
        return fee;
  }

    private void jbInit() throws Exception {
    }
}