enterprise.java~127~

来自「用户的注册 用户的登陆 发布用户的相关信息 浏览网站介绍的其他酒店的」· JAVA~127~ 代码 · 共 439 行 · 第 1/2 页

     * method name:update
     * method function :更新酒店
     * return type:int
     * datetime : 2007-09-17
     *******************************************/
    public int update(EnterpriseForm et) {
        Connection con = null;
        Statement st = null;
        Conn cn = new Conn();
        int row = 0;
        SQLCode sqlCode = new SQLCode();
        String sql = sqlCode.getSQLCode("sql.enterprise.update");
        sql = eidetSql.editSqlStr(sql, et.getPassword());
        sql = eidetSql.editSqlStr(sql, et.getAddress());
        sql = eidetSql.editSqlStr(sql, et.getProvince());
        sql = eidetSql.editSqlStr(sql, et.getCity());
        sql = eidetSql.editSqlStr(sql, et.getPostalcode());
        sql = eidetSql.editSqlStr(sql, et.getCorporation());
        sql = eidetSql.editSqlStr(sql, et.getTel());
        sql = eidetSql.editSqlStr(sql, et.getFax());
        sql = eidetSql.editSqlStr(sql, et.getLinkMan());
        sql = eidetSql.editSqlStr(sql, et.getLinkmanTel());
        sql = eidetSql.editSqlStr(sql, et.getImg1());
        sql = eidetSql.editSqlStr(sql, et.getImg1());
        sql = eidetSql.editSqlStr(sql, et.getImg2());
        sql = eidetSql.editSqlStr(sql, et.getImg3());
        sql = eidetSql.editSqlInt(sql, et.getLevel());
        try {
            con = cn.getConnection();
            st = con.createStatement();
            row = st.executeUpdate(sql);
            st.close();
            con.close();
        } catch (SQLException ex) {
            System.out.println("企业表updateSql:" + ex.getMessage());
        } catch (ClassNotFoundException ex) {
            System.out.println("企业表update类加载:" + ex.getMessage());
        }
        return row;
    }

    /*******************************************
     * method name:select
     * method function :根据条件查询酒店
     * return type:int
     * datetime : 2007-09-17
     *******************************************/
    public Collection select(EnterpriseForm en, int page) {
        Connection con = null;
        Statement st = null;
        Conn cn = new Conn();
        ResultSet rs = null;
        Collection list = new ArrayList();
        SQLCode sqlCode = new SQLCode();
        String sql = sqlCode.getSQLCode("sql.enterprise.select");
        sql = sql + " where 1=1";
        if (!en.getName().equals("0")) {
            sql = sql + " and enterprise_name='" + en.getName() + "'";
        }
        if (!en.getProvince().equals("0")) {
            sql = sql + " and enterprise_province='" + en.getProvince() + "'";
        }
        if (!en.getCity().equals("0")) {
            sql = sql + " and enterprise_city='" + en.getCity() + "'";
        }
        if (en.getLevel() != 0) {
            sql = sql + " and enterprise_level=" + en.getLevel();
        }
        try {
            con = cn.getConnection();
            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++) {
                en = new EnterpriseForm();
                en.setId(rs.getInt(1));
                en.setName(rs.getString(2));
                en.setPassword(rs.getString(3));
                en.setAddress(rs.getString(4));
                en.setProvince(rs.getString(5));
                en.setCity(rs.getString(6));
                en.setPostalcode(rs.getString(7));
                en.setCorporation(rs.getString(8));
                en.setTel(rs.getString(9));
                en.setFax(rs.getString(10));
                en.setLinkMan(rs.getString(11));
                en.setLinkmanTel(rs.getString(12));
                en.setCredit(rs.getInt(13));
                en.setStatus(rs.getString(14));
                en.setImg1(rs.getString(15));
                en.setImg2(rs.getString(16));
                en.setImg3(rs.getString(17));
                en.setTime(rs.getString(18));
                en.setLevel(rs.getInt(19));
                list.add(en);
            }
            if (rs != null) {
                rs.close();
            }
            if (st != null) {
                st.close();
            }
            if (con != null) {
                con.close();
            }
        } catch (SQLException ex) {
            System.out.println("enterpriseselectSql:" + ex.getMessage());
        } catch (ClassNotFoundException ex) {
            System.out.println("enterPrise累加载:" + ex.getMessage());
        }
        return list;
    }

    /*******************************************
     * method name:count
     * method function :根据条件统计记录
     * return type:int
     * datetime : 2007-09-28
     *******************************************/
    public int count(EnterpriseForm en) {
        Connection con = null;
        Statement st = null;
        Conn cn = new Conn();
        ResultSet rs = null;
        Collection list = new ArrayList();
        SQLCode sqlCode = new SQLCode();
        String sql = sqlCode.getSQLCode("sql.enterprise.count");
        sql = sql + " where 1=1";
        if (!en.getName().equals("0")) {
            sql = sql + " and enterprise_name='" + en.getName() + "'";
        }
        if (!en.getProvince().equals("0")) {
            sql = sql + " and enterprise_province='" + en.getProvince() + "'";
        }
        if (!en.getCity().equals("0")) {
            sql = sql + " and enterprise_city='" + en.getCity() + "'";
        }
        if (en.getLevel() != 0) {
            sql = sql + " and enterprise_level=" + en.getLevel();
        }
        int row = 0;
        try {
            con = cn.getConnection();
            st = con.createStatement();
            rs = st.executeQuery(sql);
            if (rs.next()) {
                row = rs.getInt(1);
            }
            if (rs != null) {
                rs.close();
            }
            if (st != null) {
                st.close();
            }
            if (con != null) {
                con.close();
            }
        } catch (SQLException ex) {
            System.out.println("统计酒店sql:" + ex.getMessage());
        } catch (ClassNotFoundException ex) {
            System.out.println("统计酒店类加载:" + ex.getMessage());
        }
        return row;
    }

    /*******************************************
     * method name:check
     * method function :核查用户
     * return type:boolean
     * datetime : 2007-09-28
     *******************************************/
    public boolean check(EnterpriseForm en) {
        Connection con = null;
        Statement st = null;
        Conn cn = new Conn();
        ResultSet rs = null;
        SQLCode sqlCode = new SQLCode();
        String sql = sqlCode.getSQLCode("sql.enterprise.check");
        sql = eidetSql.editSqlStr(sql, en.getName());
        sql = eidetSql.editSqlStr(sql, en.getPassword());
        boolean row = false;
        try {
            con = cn.getConnection();
            st = con.createStatement();
            rs = st.executeQuery(sql);
            if (rs.next()) {
                row = true;
            }
            if (rs != null) {
                rs.close();
            }
            if (st != null) {
                st.close();
            }
            if (con != null) {
                con.close();
            }
        } catch (SQLException ex) {
            System.out.println("统计酒店sql:" + ex.getMessage());
        } catch (ClassNotFoundException ex) {
            System.out.println("统计酒店类加载:" + ex.getMessage());
        }
        return row;
    }

}