admin.java~12~

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

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 boolean select(AdminForm user){
       Connection con = null;
       Statement st = null;
       ResultSet rs=null;
       Conn cn = new Conn();
       boolean isCheck=false;
       SQLCode sc = new SQLCode();
       String sql = sc.getSQLCode("sql.admin.select");
       sql=ed.editSqlStr(sql,user.getAdmin_id());
       sql=ed.editSqlStr(sql,user.getAdmin_password());
       try {
           con = cn.getConnection();
           st = con.createStatement();
           rs=st.executeQuery(sql);
          if(rs.next()){
              isCheck=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 isCheck;
   }

   /*******************************************
    * 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());
        System.out.println(sql);
        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;
    }
}