kaoqinbean.java

oa源码哈

package edu.scfc;

import java.sql.*;
import java.util.*;

public class KaoqinBean {

    private String dateTime;
    private String week;
    private String timeAm;
    private String timePm;
    private String uName;
    private String uIP1;
    private String uIP2;
    private String dept;
    ConnDB objConnDB = new ConnDB();
    Connection con = null;
    PreparedStatement pstmt = null;
    Statement stmt=null;
    ResultSet rs = null;
    private int curPage=1;
    private int maxPage;
    private int maxRowCount;
    public int rowsPerPage = 10;
    public java.util.Vector data;


    public KaoqinBean() {
        try {
            this.setKaoqinBean();
        } catch (Exception ex) {
        }
    }

    public void setDateTime(String datetime){
        this.dateTime=datetime;
    }
    public String getDateTime(){
        return this.dateTime;
    }
    public void setWeek(String week){
        this.week=week;
    }
    public String getWeek(){
        return this.week;
    }
    public void setTimeAm(String timeam){
        this.timeAm=timeam;
    }
    public String getTimeAm(){
        return this.timeAm;
    }
    public void setTimePm(String timepm){
        this.timePm=timepm;
    }
    public String getTimePm(){
        return this.timePm;
    }
    public void setUName(String uname){
        this.uName=uname;
    }
    public String getUName(){
        return this.uName;
    }
    public void setUIP1(String uip1){
        this.uIP1=uip1;
    }
    public String getUIP1(){
        return this.uIP1;
    }
    public void setUIP2(String uip2){
        this.uIP2=uip2;
    }
    public String getUIP2(){
        return this.uIP2;
    }
    public void setDept(String dept){
        this.dept=dept;
    }
    public String getDept(){
        return this.dept;
    }
    public void setMaxPage(int maxpage){
        this.maxPage=maxpage;
    }
    public int getMaxPage(){
        return this.maxPage;
    }
    public void setCurPage(int curpage){
        this.curPage=curpage;
    }
    public int getCurPage(){
        return this.curPage;
    }
    public void setMaxRowCount(int maxrowcount){
        this.maxRowCount=maxrowcount;
    }
    public int getMaxRowCount(){
        return this.maxRowCount;
    }
    public Vector selectKaoqinDept(String dept){
        try{
            Vector vc = new Vector();
            con = objConnDB.getConnection();
            pstmt = con.prepareStatement("select * from TB_Kaoqin where Dept=?");
            pstmt.setString(1,dept);
            rs = pstmt.executeQuery();
            while(rs.next()){
                KaoqinBean objKaoqinBean = new KaoqinBean();
                objKaoqinBean.setDateTime(rs.getString("DateTime").substring(0,11));
                objKaoqinBean.setWeek(rs.getString("Week"));
                objKaoqinBean.setTimeAm(rs.getString("TimeAm"));
                objKaoqinBean.setTimePm(rs.getString("TimePm"));
                objKaoqinBean.setUName(rs.getString("UName"));
                objKaoqinBean.setUIP1(rs.getString("UIP1"));
                objKaoqinBean.setUIP2(rs.getString("UIP2"));
                objKaoqinBean.setDept(rs.getString("Dept"));
                vc.addElement(objKaoqinBean);
            }
            return vc;
        }catch(SQLException ex){
        }
        return null;
    }

    public Vector selectKaoqinName(String realName){
        try{
            Vector vc = new Vector();
            con = objConnDB.getConnection();
            pstmt = con.prepareStatement("select * from TB_Kaoqin where UName=?");
            pstmt.setString(1,realName);
            rs = pstmt.executeQuery();
            while(rs.next()){
                KaoqinBean objKaoqinBean = new KaoqinBean();
                objKaoqinBean.setDateTime(rs.getString("DateTime").substring(0,11));
                objKaoqinBean.setWeek(rs.getString("Week"));
                objKaoqinBean.setTimeAm(rs.getString("TimeAm"));
                objKaoqinBean.setTimePm(rs.getString("TimePm"));
                objKaoqinBean.setUName(rs.getString("UName"));
                objKaoqinBean.setUIP1(rs.getString("UIP1"));
                objKaoqinBean.setUIP2(rs.getString("UIP2"));
                objKaoqinBean.setDept(rs.getString("Dept"));
                vc.addElement(objKaoqinBean);
            }
            return vc;
        }catch(SQLException ex){}
        return null;
    }
    public int InsertKaoqinAM(String datetime,String week,String timeam,String uname,String ip1,String dept){
        try{
            con = objConnDB.getConnection();
            pstmt = con.prepareStatement("select * from TB_Kaoqin where DateTime=? and UName=? and Dept=?");
            pstmt.setString(1,datetime);
            pstmt.setString(2,uname);
            pstmt.setString(3,dept);
            rs = pstmt.executeQuery();
            if(rs.next()){
            }else{
                con = objConnDB.getConnection();
                pstmt = con.prepareStatement(
                        "insert into TB_Kaoqin(DateTime,Week,TimeAm,UName,UIP1,Dept)values(?,?,?,?,?,?)");
                pstmt.setString(1, datetime);
                pstmt.setString(2, week);
                pstmt.setString(3, timeam);
                pstmt.setString(4, uname);
                pstmt.setString(5, ip1);
                pstmt.setString(6, dept);
                int i = pstmt.executeUpdate();
                return i;
            }
        }catch(Exception ex){}
        return 0;
    }
    public int InsertKaoqinPM(String datetime,String week,String timepm,String uname,String ip2,String dept){
        try{
            int i = 0;
            con = objConnDB.getConnection();
            pstmt = con.prepareStatement("select * from TB_Kaoqin where DateTime=? and UName=? and Dept=?");
            pstmt.setString(1,datetime);
            pstmt.setString(2,uname);
            pstmt.setString(3,dept);
            rs = pstmt.executeQuery();
            if(rs.next()){
                con = objConnDB.getConnection();
                pstmt = con.prepareStatement("update TB_Kaoqin set TimePm=?,UIP2=? where DateTime=? and UName=? and Dept=?");
                pstmt.setString(1,timepm);
                pstmt.setString(2,ip2);
                pstmt.setString(3,datetime);
                pstmt.setString(4,uname);
                pstmt.setString(5,dept);
                i = pstmt.executeUpdate();
            }else{
                con = objConnDB.getConnection();
                pstmt = con.prepareStatement("insert into TB_Kaoqin(DateTime,Week,TimePm,UName,UIP2,Dept)values(?,?,?,?,?,?)");
                pstmt.setString(1,datetime);
                pstmt.setString(2,week);
                pstmt.setString(3,timepm);
                pstmt.setString(4,uname);
                pstmt.setString(5,ip2);
                pstmt.setString(6,dept);
                i = pstmt.executeUpdate();
            }
            return i;
        }catch(Exception ex){
            ex.printStackTrace();
        }
        return 0;
    }
    public KaoqinBean getResult(String page) {
        try{
            KaoqinBean objKaoqinBean = new KaoqinBean();
            Vector vc = new Vector();
            int pageNum = Integer.parseInt(page);
            con = objConnDB.getConnection();
            stmt = con.createStatement();
            ResultSet rs = stmt.executeQuery("select top " + pageNum * objKaoqinBean.rowsPerPage +" * from TB_Kaoqin");
            int i = 0;
            while(rs.next()){
                if(i>(pageNum-1)*objKaoqinBean.rowsPerPage-1){
                    Object[] obj = new Object[8];
                    obj[0] = rs.getString("DateTime").substring(0,11).trim();
                    obj[1] = rs.getString("Week").trim();
                    obj[2] = rs.getString("TimeAm").trim();
                    obj[3] = rs.getString("TimePm").trim();
                    obj[4] = rs.getString("UName").trim();
                    obj[5] = rs.getString("UIP1").trim();
                    obj[6] = rs.getString("UIP2").trim();
                    obj[7] = rs.getString("Dept").trim();
                    vc.addElement(obj);
                }
                i++;
            }
            rs.close();
            stmt.close();
            objKaoqinBean.setCurPage(pageNum);
            objKaoqinBean.data = vc;
            return objKaoqinBean;
        }catch(Exception ex){ex.printStackTrace();}
        return null;
    }
    public int getAvailableCount()throws Exception{
        int ret = 0;
        con = objConnDB.getConnection();
        stmt = con.createStatement();
        rs = stmt.executeQuery("select * from TB_Kaoqin");
        while(rs.next()){
            ret++;
        }
        return ret;
    }
    public void setKaoqinBean() throws Exception {
        this.setMaxRowCount(this.getAvailableCount());
        if(this.maxRowCount%this.rowsPerPage==0){
            this.maxPage = this.maxRowCount / this.rowsPerPage;
        }else{
            this.maxPage = this.maxRowCount / this.rowsPerPage+1;
        }
    }
}