adminutil.java

来自「spring+struts+hibernate做的银行系统」· Java 代码 · 共 97 行

/*
 * Created on 2006-3-12
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package cn.com.tym.admin;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import javax.servlet.http.HttpSession;
import cn.com.tym.util.text.*;
import cn.com.tym.pub.DB;

 

/**
 * @author jack_booth
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class AdminUtil {
	
 
	public boolean login(String user,String pwd, HttpSession session,DB db)throws SQLException{
		boolean bool=false;
		
	 
	 String strSql= " select card_id from mdh_admin  " +
	                "where admin_name='"+DealText.dealToSql(user)+"' and admin_pwd='"+DealText.dealToSql(pwd)+"'"; 
	 
	        ResultSet rs = db.OpenSql(strSql);  
			if ( rs.next())	{
			    session.setAttribute("adminId",rs.getString("card_id"));
			    session.setAttribute("admin",user);	 
				bool=true;
			}
		return bool;
	}
	
	
 
	public boolean check(String id,String pwd,DB db)throws SQLException{
		boolean bool=false;
		String bid=DealText.dealToSql(id);
		String pwds=DealText.dealToSql(pwd);
	    String strSql="update  mdh_admin set admin_pwd='"+pwds+"' where card_id='"+bid+"'";
		 	
	    if(db.ExecSql(strSql)!=0)	{ 
			    bool=true; 
			}
		return bool;
	}
	
	
 
    public ArrayList listAllPage(String adminId,DB db)throws SQLException{
        ArrayList list = new ArrayList();
   	 	String strSql= "select admin_name,admin_pwd from mdh_admin where  card_id='"+adminId+"'"; 

   	 	ResultSet rs = db.OpenSql(strSql);
 
        while(rs.next())
        {
            AdminBean  bean=new AdminBean();
            bean.setAdminName(rs.getString("admin_name"));
            bean.setAdminPwd(rs.getString("admin_pwd"));
            list.add(bean);
            bean = null;
        }
    return list;
}
    
   
    public ArrayList coteList(DB db)throws SQLException{
       
 
        ArrayList list = new ArrayList();
   	 	String strSql= "select  card_id,card_name from mdh_cote "; 
   	 	ResultSet rs = db.OpenSql(strSql);
   	 	
        while(rs.next())
        {
            CoteBean bean=new CoteBean();
            bean.setCoteId(rs.getString("card_id"));
            bean.setCoteName(rs.getString("card_name"));
 
            list.add(bean);
            bean = null;
        }
    return list;
}
}