enterprise.java~129~

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

package dao;

import java.util.*;

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

public class Enterprise implements EnterpriseDao {
    EidetSql eidetSql = null;
    public Enterprise() {
        eidetSql = new EidetSql();
    }

    /*******************************************
     * method name:nameSelecte
     * method function :根据企业名称查询eid
     * return type:String
     * datetime : 2007-09-26
     *******************************************/

    public Integer nameSelect(EnterpriseForm et) {
        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.nameselect");
        sql = eidetSql.editSqlStr(sql, et.getName());
        System.out.println("0"+sql);
        Integer eid = -1;
        try {
            con = cn.getConnection();
            st = con.createStatement();
            rs = st.executeQuery(sql);
            if (rs.next()) {
                eid = rs.getInt(1);
            }
            if (rs != null) {
                rs.close();
            }
            if (st != null) {
                st.close();
            }
            if (con != null) {
                con.close();
            }
        } catch (SQLException ex) {
            System.out.println("eidsql:" + ex.getMessage());
        } catch (ClassNotFoundException ex) {
            System.out.println("eid类加载:" + ex.getMessage());
        }
        return eid;
    }

    /*******************************************
     * method name:crdupdate
     * method function :更新企业信誉度
     * return type:int
     * datetime : 2007-09-17
     *******************************************/

    public int crdupdate(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.crdupdate");
        sql = eidetSql.editSqlInt(sql, et.getId());
        try {
            con = cn.getConnection();
            st = con.createStatement();
            row = st.executeUpdate(sql);
            st.close();
            con.close();
        } catch (SQLException ex) {
            System.out.println("企业表crdupdateSql:" + ex.getMessage());
        } catch (ClassNotFoundException ex) {
            System.out.println("企业表crdupdate类加载:" + ex.getMessage());
        }
        return row;
    }

    /*******************************************
     * method name:creditSelect
     * method function :根据信誉度查询酒店
     * return type:Collection
     * datetime : 2007-09-17
     *******************************************/
    public Collection idSelect(EnterpriseForm en) {
        Connection con = null;
        Statement st = null;
        ResultSet rs = null;
        Conn cn = new Conn();
        Collection list = new ArrayList();
        SQLCode sqlCode = new SQLCode();
        String sql = sqlCode.getSQLCode("sql.enterprise.idSelect");
        if (en.getName() != "") {
            sql = sql + " where enterprise_name='" + en.getName() + "'";
        }
        if (en.getId() != 0) {
            sql = sql + " where enterprise_id=" + en.getId();
        }
        try {
            con = cn.getConnection();
            st = con.createStatement();
            rs = st.executeQuery(sql);
            while (rs.next()) {
                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);
            }
            rs.close();
            st.close();
            con.close();
        } catch (SQLException ex) {
            System.out.println("企业表idSelectSql:" + ex.getMessage());
        } catch (ClassNotFoundException ex) {
            System.out.println("企业表idSelect加载:" + ex.getMessage());
        }
        return list;
    }

    /*******************************************
     * method name:delete
     * method function :删除酒店
     * return type:int
     * datetime : 2007-09-17
     *******************************************/
    public int delete(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.delete");
        sql = eidetSql.editSqlInt(sql, et.getId());
        try {
            con = cn.getConnection();
            st = con.createStatement();
            row = st.executeUpdate(sql);
            st.close();
            con.close();
        } catch (SQLException ex) {
            System.out.println("企业表deleteSql:" + ex.getMessage());
        } catch (ClassNotFoundException ex) {
            System.out.println("企业表delete类加载:" + ex.getMessage());
        }
        return row;
    }

    /*******************************************
     * method name:insert
     * method function :注册企业
     * return type:int
     * datetime : 2007-09-17
     *******************************************/
    public int insert(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.insert");
        sql = eidetSql.editSqlStr(sql, et.getName());
        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("企业表insertSql:" + ex.getMessage());
        } catch (ClassNotFoundException ex) {
            System.out.println("企业表insert类加载:" + ex.getMessage());
        }
        return row;
    }