userbo.java

在线通信录(struts+hibernate+spring+ajax)

package y2javaee.xmal1.operation;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import y2javaee.xmal1.common.DBConnection;
import y2javaee.xmal1.entity.Users;

public class UserBo {

	private Connection conn;// 用于保存数据库连接对象

	private PreparedStatement ps;// 用于执行SQL语句（预处理）

	private ResultSet rs;// 用于保存查询的结果集
	/**
	 * 根据用户名和密码，判断该用户是否存在
	 * @param userName
	 * @param password
	 * @return  用户对象
	 */
	public Users validUser(String userName, String password) {
		Users user = null;
		String sql = "select * from users where userName=? and password=? ";
		try {
			conn = DBConnection.getConnection();
			ps = conn.prepareStatement(sql);
			ps.setString(1, userName);
			ps.setString(2, password);

			rs = ps.executeQuery();
			if (rs.next()) {
				user = new Users();
				user.setUserId(rs.getInt("userId"));
				user.setUserName(rs.getString("userName"));
				user.setRealName(rs.getString("realName"));
				user.setSex(rs.getString("sex"));
			}

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			DBConnection.closeResultSet(rs);
			DBConnection.closeStatement(ps);
			DBConnection.closeConnection();
		}
		return user;
	}

}