@Override
public boolean add(User user) throws AppException {
boolean flag = false; // 声明操作标识
Connection conn = null;
PreparedStatement psmt = null;
try {
conn = DBUtil.getConnection(); // 创建数据库连接
// 声明操作语句，将用户信息保存在数据库中，“？”为占位符
String sql =
"insert into t_user(IDnum,type,createTime,del,password,username) values(?,?,?,?,?,?)";
psmt = conn.prepareStatement(sql);
// 为占位符设置值
psmt.setString(1, user.getIDnum());
psmt.setInt(2, (Integer.parseInt(user.getType())));
psmt.setDate(3, new java.sql.Date(new java.util.Date().getTime()));
psmt.setInt(4, user.getDel());
psmt.setString(5, user.getPassword());
psmt.setString(6, user.getUsername());
// 执行更新操作，返回受影响的行数
psmt.executeUpdate();
flag = true;
} catch (SQLException e) {
flag = false;
} finally {
// 关闭数据库操作对象，释放资源
DBUtil.closePreparedStatement(psmt);
DBUtil.closeConnection(conn);
}
// ...返回操作标识flag
return flag;
}
@Override
public int login(String username, String password) throws AppException {
// 声明数据库连接对象，预编译对象和结果集对象
Connection conn = null;
PreparedStatement psmt = null;
ResultSet rs = null;
try {
// 创建数据库连接
conn = DBUtil.getConnection();
// 声明操作语句：根据用户名和密码查询用户编号，“？”为占位符
String sql = "select id from t_user where username=? and password =?";
// 预编译sql
psmt = conn.prepareStatement(sql);
// 填充占位符
psmt.setString(1, username);
psmt.setString(2, password);
rs = psmt.executeQuery();
// 查询到记录，提取用户编号
if (rs.next()) {
return rs.getInt("id");
} else {
return -1;
}
} catch (Exception e) {
e.printStackTrace();
throw new AppException("com.wh.dao.impl.UserDaoImpl.login");
} finally {
// 关闭数据库操作对象，释放资源
DBUtil.closeResultSet(rs);
DBUtil.closePreparedStatement(psmt);
DBUtil.closeConnection(conn);
}
}
@Override
public int getRoleById(int userId) throws AppException {
int role = -1;
// 声明数据库连接对象，预编译对象和结果集对象
Connection conn = null;
PreparedStatement psmt = null;
ResultSet rs = null;
try {
// 创建数据库连接
conn = DBUtil.getConnection();
// 声明操作语句：根据用户名和密码查询用户编号，“？”为占位符
String sql = "select role from t_user where id=?";
// 预编译sql
psmt = conn.prepareStatement(sql);
// 填充占位符
psmt.setInt(1, userId);
rs = psmt.executeQuery();
// 查询到记录，提取用户编号
if (rs.next()) {
role = rs.getInt("role");
} else {
role = -1;
}
} catch (Exception e) {
e.printStackTrace();
throw new AppException("com.wh.dao.impl.UserDaoImpl.getRoleById");
} finally {
// 关闭数据库操作对象，释放资源
DBUtil.closeResultSet(rs);
DBUtil.closePreparedStatement(psmt);
DBUtil.closeConnection(conn);
}
return role;
}
