userdao.java

图书馆管理的源代码文件

package com.nitpro.webmvc.dao;

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

import com.nitpro.webmvc.bean.User;

public class UserDao {
	private Connection conn;

	public void setConn(Connection conn) {
		this.conn = conn;
	}

	public User selectUserByUserNameAndPwd(String userName, String pwd)
			throws Exception {
		User u = null;
		String sql = "SELECT user_id, user_name, pwd FROM users WHERE user_name = ? AND pwd = ?";
		PreparedStatement stat = conn.prepareStatement(sql);
		stat.setString(1, userName);
		stat.setString(2, pwd);
		ResultSet rs = stat.executeQuery();
		if (rs.next()) {
			u = new User();
			u.setUser_id(rs.getInt("user_id"));
			u.setUser_name(rs.getString("user_name"));
			u.setPwd(rs.getString("pwd"));
		}
		rs.close();
		stat.close();
		return u;
	}
}