logindao.java

来自「人力资源信息管理系统！包含登录 员工管理 培训经历 用户管理 出勤管理等一系列人」· Java 代码 · 共 51 行

package com.buat.login;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.buat.connect.Connect;
import com.buat.user.User;

public class LoginDAO implements IUserDAO {
	public User isSelect(User user) {
		PreparedStatement pst = null;
		ResultSet rs = null;
		user.setId(-1);

		Connect.getConnect();

		StringBuffer sbf = new StringBuffer();
		sbf.append("select * from user where username=?");

		try {
			pst = Connect.con.prepareStatement(new String(sbf));
			pst.setString(1, user.getUsername());
			rs = pst.executeQuery();

			while (rs.next()) {
				if (rs.getString(3).trim().equals(user.getPassword().trim())) {
					user.setId(rs.getInt(1));
					user.setUserlevel(rs.getInt(8));
				} else {
					user.setId(0);
				}
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			try {
				if (rs != null)
					rs.close();
				if (pst != null)
					pst.close();
				if (Connect.con != null)
					Connect.con.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return user;
	}
}