userdao.java

jsp/servlet/javaBean:通讯录

package common;

import java.sql.*;
import entity.UserBean;

public class UserDao {
	
	BaseDao base=new BaseDao();
	
	//验证登录
	public int getUserId(UserBean user){		
		Connection conn=null;
		String sql=null;
		PreparedStatement psmt=null;
		ResultSet rest=null;
		int userId=-1;
		try{
			conn=base.getConn();
			sql="select userId from USERS where userName=? and passWord=?";
			psmt=conn.prepareStatement(sql);
			psmt.setString(1, user.getUserName());
			psmt.setString(2, user.getPassWord());
			rest=psmt.executeQuery();
			if(rest.next()){
				userId=rest.getInt("userId");
			}
		}catch(SQLException se){
			se.printStackTrace();
			System.out.println(se.getMessage());
		}finally{
			base.closeConn(conn, psmt, rest);
		}
		return userId;
	}
}