hr.java~76~

来自「用户的注册 用户的登陆 发布用户的相关信息 浏览网站介绍的其他酒店的」· JAVA~76~ 代码 · 共 339 行

package dao;

import java.util.*;

import domain.*;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.Connection;
import tool.Conn;
import tool.SQLCode;
import tool.EidetSql;
import java.sql.*;
import tool.DateTime;

public class Hr implements HrDao {
    EidetSql eidetSql = null;
    public Hr() {
        eidetSql = new EidetSql();
    }


    /*******************************************
     * method name:count
     * method function :统计招聘记录
     * return type:int
     * datetime : 2007-09-15
     *******************************************/

    public int count(HrForm hr) {
        Connection con = null;
        Statement st = null;
        ResultSet rs = null;
        Conn cn = new Conn();
        SQLCode sqlCode = new SQLCode();
        String sql = sqlCode.getSQLCode("sql.hr.count");
        if (hr.getBeginTime() != "") {
            sql = sql + " and hr_beginTime='" + hr.getBeginTime() + "'";
        }
        if (hr.getEid() != 0) {
            sql = sql + " and hr_eid=" + hr.getEid();
        }
        int row = 0;
        try {
            con = cn.getConnection();
            st = con.createStatement();
            rs = st.executeQuery(sql);
            if (rs.next()) {
                row = rs.getInt(1);
            }
            rs.close();
            st.close();
            con.close();
        } catch (SQLException ex) {
            System.out.println("订单表countSql:" + ex.getMessage());
        } catch (ClassNotFoundException ex) {
            System.out.println("订单表count类加载:" + ex.getMessage());
        }
        return row;
    }

    public int idCount(HrForm hr) {
        Connection con = null;
        Statement st = null;
        ResultSet rs = null;
        Conn cn = new Conn();
        SQLCode sqlCode = new SQLCode();
        String sql = sqlCode.getSQLCode("sql.hr.idcount");
        sql = eidetSql.editSqlInt(sql, hr.getEid());
        int row = 0;
        try {
            con = cn.getConnection();
            st = con.createStatement();
            rs = st.executeQuery(sql);
            if (rs.next()) {
                row = rs.getInt(1);
            }
            rs.close();
            st.close();
            con.close();
        } catch (SQLException ex) {
            System.out.println("订单表countSql:" + ex.getMessage());
        } catch (ClassNotFoundException ex) {
            System.out.println("订单表count类加载:" + ex.getMessage());
        }
        return row;
    }


    /*******************************************
     * method name:delete
     * method function :删除数据
     * return type:int
     * datetime : 2007-09-17
     *******************************************/
    public int delete(HrForm hr) {
        Connection con = null;
        Statement st = null;
        Conn cn = new Conn();
        SQLCode sqlCode = new SQLCode();
        String sql = sqlCode.getSQLCode("sql.hr.delete");
        sql = eidetSql.editSqlInt(sql, hr.getId());
        int row = 0;
        try {
            con = cn.getConnection();
            st = con.createStatement();
            row = st.executeUpdate(sql);
            st.close();
            con.close();
        } catch (SQLException ex) {
            System.out.println("订单表countSql:" + ex.getMessage());
        } catch (ClassNotFoundException ex) {
            System.out.println("订单表count类加载:" + ex.getMessage());
        }
        return row;
    }

    /*******************************************
     * method name:hotelSelect
     * method function :根据eid 查询数据
     * return type:Collection
     * datetime : 2007-09-17
     *******************************************/

    public Collection hotelselect(HrForm hr) {
        Connection con = null;
        Statement st = null;
        ResultSet rs = null;
        Conn cn = new Conn();
        SQLCode sqlCode = new SQLCode();
        Collection list = new ArrayList();
        String sql = sqlCode.getSQLCode("sql.hr.hotelselect");
        sql = eidetSql.editSqlInt(sql, hr.getId());
        try {
            con = cn.getConnection();
            st = con.createStatement();
            st = con.createStatement();
            rs = st.executeQuery(sql);
            while (rs.next()) {
                hr = new HrForm();
                hr.setId(rs.getInt(1));
                hr.setEid(rs.getInt(2));
                hr.setContent(rs.getString(3));
                hr.setHowMany(rs.getInt(4));
                hr.setSchoolAge(rs.getString(5));
                hr.setLinkMan(rs.getString(6));
                hr.setTel(rs.getString(7));
                hr.setAddress(rs.getString(8));
                hr.setWorkPlace(rs.getString(9));
                hr.setDemand(rs.getString(10));
                hr.setLinkManEmail(rs.getString(11));
                hr.setBeginTime(rs.getString(12));
                hr.setEndTime(rs.getString(13));
                list.add(hr);
            }
            rs.close();
            st.close();
            con.close();
        } catch (SQLException ex) {
            System.out.println("订单表hotelSelectSql:" + ex.getMessage());
        } catch (ClassNotFoundException ex) {
            System.out.println("订单表hotelSelect类加载:" + ex.getMessage());
        }
        return list;
    }

    /*******************************************
     * method name:hotelSelect
     * method function :根据eid 查询数据
     * datatype : HrForm hr, int page
     * return type:Collection
     * datetime : 2007-09-17
     *******************************************/

    public Collection eidHotelselect(HrForm hr, int page) {
        Connection con = null;
        Statement st = null;
        ResultSet rs = null;
        Conn cn = new Conn();
        SQLCode sqlCode = new SQLCode();
        Collection list = new ArrayList();
        String sql = sqlCode.getSQLCode("sql.hr.hotelselect");
        sql = eidetSql.editSqlInt(sql, hr.getEid());
        System.out.println(sql);
        try {
            con = cn.getConnection();
            st = con.createStatement();
            st = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                                     ResultSet.CONCUR_READ_ONLY);
            rs = st.executeQuery(sql);
            int tip = 7 * (page - 1);
            try {
                if (tip <= 0) {
                    rs.beforeFirst();
                } else {
                    if (!rs.absolute(tip)) {
                        rs.beforeFirst();
                    }
                }
            } catch (SQLException ex1) {
                System.out.println("tip" + ex1.getMessage());
            }
            for (int i = 1; rs.next() && i <= 7; i++) {
                hr = new HrForm();
                hr.setId(rs.getInt(1));
                hr.setEid(rs.getInt(2));
                hr.setContent(rs.getString(3));
                hr.setHowMany(rs.getInt(4));
                hr.setSchoolAge(rs.getString(5));
                hr.setLinkMan(rs.getString(6));
                hr.setTel(rs.getString(7));
                hr.setAddress(rs.getString(8));
                hr.setWorkPlace(rs.getString(9));
                hr.setDemand(rs.getString(10));
                hr.setLinkManEmail(rs.getString(11));
                hr.setBeginTime(rs.getString(12));
                hr.setEndTime(rs.getString(13));
                list.add(hr);
            }
            rs.close();
            st.close();
            con.close();
        } catch (SQLException ex) {
            System.out.println("订单表hotelSelectSql:" + ex.getMessage());
        } catch (ClassNotFoundException ex) {
            System.out.println("订单表hotelSelect类加载:" + ex.getMessage());
        }
        return list;
    }


    /*******************************************
     * method name:insert
     * method function :插入数据
     * return type:int
     * datetime : 2007-09-17
     *******************************************/

    public int insert(HrForm hr) {
        Connection con = null;
        Statement st = null;
        Conn cn = new Conn();
        SQLCode sqlCode = new SQLCode();
        DateTime time = new DateTime();
        String sql = sqlCode.getSQLCode("sql.hr.insert");
        sql = eidetSql.editSqlInt(sql, hr.getEid());
        sql = eidetSql.editSqlStr(sql, hr.getContent());
        sql = eidetSql.editSqlInt(sql, hr.getHowMany());
        sql = eidetSql.editSqlStr(sql, hr.getSchoolAge());
        sql = eidetSql.editSqlStr(sql, hr.getLinkMan());
        sql = eidetSql.editSqlStr(sql, hr.getTel());
        sql = eidetSql.editSqlStr(sql, hr.getAddress());
        sql = eidetSql.editSqlStr(sql, hr.getWorkPlace());
        sql = eidetSql.editSqlStr(sql, hr.getDemand());
        sql = eidetSql.editSqlStr(sql, hr.getLinkManEmail());
        sql = eidetSql.editSqlStr(sql, time.getYMD());
        sql = eidetSql.editSqlStr(sql, hr.getEndTime());
        int row = 0;
        try {
            con = cn.getConnection();
            st = con.createStatement();
            row = st.executeUpdate(sql);
            st.close();
            con.close();
        } catch (SQLException ex) {
            System.out.println("订单表insertSql:" + ex.getMessage());
        } catch (ClassNotFoundException ex) {
            System.out.println("订单表insert类加载:" + ex.getMessage());
        }
        return row;
    }

    /*******************************************
     * method name:select
     * method function :查询数据
     * return type:Collection
     * datetime : 2007-09-17
     *******************************************/

    public Collection select(HrForm hr, int page) {
        Connection con = null;
        Statement st = null;
        ResultSet rs = null;
        Conn cn = new Conn();
        SQLCode sqlCode = new SQLCode();
        Collection list = new ArrayList();
        String sql = sqlCode.getSQLCode("sql.hr.select");
        if (hr.getBeginTime() != "") {
            sql = sql + " and hr_beginTime='" + hr.getBeginTime() + "'";
        }
        if (hr.getEid() != 0) {
            sql = sql + " and hr_eid=" + hr.getEid();
        }
        try {
            con = cn.getConnection();
            st = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                                     ResultSet.CONCUR_READ_ONLY);
            rs = st.executeQuery(sql);
            int tip = 5 * (page - 1);
            try {
                if (tip <= 0) {
                    rs.beforeFirst();
                } else {
                    if (!rs.absolute(tip)) {
                        rs.beforeFirst();
                    }
                }
            } catch (SQLException ex1) {
                System.out.println("tip" + ex1.getMessage());
            }
            for (int i = 1; rs.next() && i <= 5; i++) {
                hr = new HrForm();
                hr.setId(rs.getInt(1));
                hr.setEid(rs.getInt(2));
                hr.setEnterprise(rs.getString(3));
                hr.setContent(rs.getString(4));
                hr.setHowMany(rs.getInt(5));
                hr.setSchoolAge(rs.getString(6));
                hr.setLinkMan(rs.getString(7));
                hr.setTel(rs.getString(8));
                hr.setAddress(rs.getString(9));
                hr.setWorkPlace(rs.getString(10));
                hr.setDemand(rs.getString(11));
                hr.setLinkManEmail(rs.getString(12));
                hr.setBeginTime(rs.getString(13));
                hr.setEndTime(rs.getString(14));
                list.add(hr);
            }
            rs.close();
            st.close();
            con.close();
        } catch (SQLException ex) {
            System.out.println("订单表selectSql:" + ex.getMessage());
        } catch (ClassNotFoundException ex) {
            System.out.println("订单表select类加载:" + ex.getMessage());
        }
        return list;
    }
}