src/org/bs/dao/impl/UserDaoImpl.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package org.bs.dao.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import org.bs.dao.RoleDao;
import org.bs.dao.UserDao;
import org.bs.model.User;
import org.bs.utils.ConnContext;
import org.bs.utils.DB;
import org.bs.utils.PageContext;

public class UserDaoImpl extends BaseDao implements UserDao {
	private RoleDao roleDao = new RoleDaoImpl();

	public User login(String username, String password) {
		User user = getUserByUsername(username);
		if (user == null) {
			throw new RuntimeException("用户名不存在");
		} else {
			if (!password.equals(user.getPassword())) {
				throw new RuntimeException("密码错误");
			}
		}
		return user;
	}

	public User getById(int id) {
		Connection conn = DB.getConn();
		String sql = "select * from t_user where id = ?";
		User user = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		try {
			pstmt = conn.prepareStatement(sql);
			pstmt.setInt(1, id);
			rs = pstmt.executeQuery();
			while (rs.next()) {
				user = new User();
				user.setId(rs.getInt("id"));
				user.setUsername(rs.getString("username"));
				user.setPassword(rs.getString("password"));
				user.setRole(roleDao.getById(rs.getInt("role")));
			}
		} catch (SQLException e) {
		} finally {
			DB.close(conn);
			DB.close(pstmt);
			DB.close(rs);
		}
		return user;
	}

	public User getUserByUsername(String username) {
		Connection conn = DB.getConn();