loginjdbcdao.java

本套系统采用了业界当前最为流行的beanAction组件

/**
 * 
 */
package teleReport.persistence.jdbcdao;

import com.ibatis.dao.client.DaoManager;
import commons.persistence.BaseJdbcDAO;
import teleReport.persistence.iface.LoginDAO;
import teleReport.domain.User;
import java.sql.*;
/**
 * @author new
 *
 */
public class LoginJdbcDAO  extends BaseJdbcDAO implements LoginDAO{

	public LoginJdbcDAO(DaoManager daoManager){
		super(daoManager);
	}
	
	public int login(User user){
		int result = 0;
		String sql = "select passwd,personname,personclass from personinfo where personid = ?";
		PreparedStatement pstm = null;
		ResultSet rs = null;
		
		try{
			pstm = getConnection().prepareStatement(sql);
			pstm.setString(1, user.getUserId());
			rs = pstm.executeQuery();
			if (rs == null){
				result = 0;	//输入的ID不存在
			}else{
				while(rs.next()){
					user.setUserClass(rs.getString("personclass"));					
					user.setUserName(rs.getString("personname"));
					String password = rs.getString("passwd");
					if (!user.getPassword().equals(password)){
						result = -1;	//输入的密码错误
					}else{
						result = Integer.parseInt(rs.getString("personclass"));	//返回用户的类别
					}
				}				
			}			
		}catch(SQLException e){
			dealException(e);
		}finally{
			close(rs,pstm);
		}		
		return result;
	}
}