admin.java~3~

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

package dao;

import tool.EidetSql;
import tool.Conn;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.Connection;
import domain.AdminForm;
import tool.SQLCode;
import java.util.Collection;
import java.util.ArrayList;
import java.sql.SQLException;

public class Admin implements AdminDao{
     EidetSql ed = new EidetSql();
     public Admin(){
     }

     /*******************************************
      * method name:select
      * method function :核查管理员帐户和密码
      * return type:int
      * datetime : 2007-09-15
      *******************************************/

   public Collection select(AdminForm user){
       Connection con = null;
       Statement st = null;
       ResultSet rs = null;
       Conn cn = new Conn();
       SQLCode sc = new SQLCode();
       String sql = sc.getSQLCode("sql.admin.select");
       Collection list = new ArrayList();

       try {
           con = cn.getConnection();
           st = con.createStatement();
           rs = st.executeQuery(sql);
           while(rs.next()){
               user=new AdminForm();
               user.setAdmin_id(rs.getString(1));
               user.setAdmin_password(rs.getString(2));
               list.add(user);
           }
       } catch (SQLException ex) {
           System.out.println("查询管理员sql:" + ex.getMessage());
       } catch (ClassNotFoundException ex) {
           System.out.println("类加载：" + ex.getMessage());
       }
       return list;
   }

   /*******************************************
    * method name:update
    * method function :更新管理员密码
    * return type:int
    * datetime : 2007-09-15
    *******************************************/

   public int update(AdminForm user) {
        Connection con = null;
        Statement st = null;
        ResultSet rs = null;
        Conn cn = new Conn();
        SQLCode sc = new SQLCode();
        String sql = sc.getSQLCode("sql.admin.update");
        sql = ed.editSqlStr(sql, user.getAdmin_password());
        sql = ed.editSqlStr(sql, user.getAdmin_id());
        int row = 0;
            try {
                con = cn.getConnection();
                st = con.createStatement();
                row = st.executeUpdate(sql);
            } catch (SQLException ex) {
                System.out.println("更新管理员密码sql:" + ex.getMessage());
            } catch (ClassNotFoundException ex) {
                System.out.println("类加载：" + ex.getMessage());
            }
        return row;
    }
}