userdao.java

jsp/servlet/javaBean应用：网上购书系统

package dao;

import java.sql.*;
import java.util.*;
import bean.UserBean;

/**
 * 用户数据层
 * @author dell
 *
 */
public class UserDao {
	
	BaseDao dao=new BaseDao();
	List titles=new ArrayList();
	Connection conn=null;
	PreparedStatement psmt=null;
	ResultSet rest=null;
	String sql=null;
	int i;
	
	//添加用户
	public int addUser(UserBean user){
		sql="insert userInfo values(?,?)";
		String[] param={user.getUserName(),user.getUserPass()};
		try{
			i=dao.executeDB(sql, param);
		}catch(Exception ex){
			ex.printStackTrace();
			System.out.println(ex.getMessage());
		}
		return i;
	}
	
	//用户登录
	public boolean checkLogin(UserBean user){
		boolean flage=false;
		try{
			conn=dao.getConn();
			sql="select * from userInfo where userName=? and userPass=?";
			psmt=conn.prepareStatement(sql);
			psmt.setString(1, user.getUserName());
			psmt.setString(2, user.getUserPass());
			rest=psmt.executeQuery();
			while(rest.next()){
				flage=true;
			}
		}catch(SQLException sex){
			sex.printStackTrace();
			System.out.println(sex.getMessage());
		}
		return flage;
	}
}