/**
* 修改用户
*
* @param user
*/
public void updateUser(User user) {
Connection conn = DbUtil.getConnection();
PreparedStatement ps = null;
try {
if (StringUtils.isNotBlank(user.getUserPassword())) {
ps =
conn.prepareStatement(
"update auth_user au SET au.department_id = ? ,au.user_name = ? ,au.user_password = ? ,au.user_real_name = ?,au.use_status = ?,au.create_time = ? WHERE au.id = ?");
ps.setInt(1, user.getDepartmentId());
ps.setString(2, user.getUserName());
ps.setString(3, Secure.encryptPwd(user.getUserPassword()));
ps.setString(4, user.getUserRealName());
ps.setInt(5, user.getUseStatus());
ps.setTimestamp(6, user.getCreateTime());
ps.setInt(7, user.getId());
ps.executeUpdate();
} else {
ps =
conn.prepareStatement(
"update auth_user au SET au.department_id = ? ,au.user_name = ? ,au.user_real_name = ?,au.use_status = ?,au.create_time = ? WHERE au.id = ?");
ps.setInt(1, user.getDepartmentId());
ps.setString(2, user.getUserName());
ps.setString(3, user.getUserRealName());
ps.setInt(4, user.getUseStatus());
ps.setTimestamp(5, user.getCreateTime());
ps.setInt(6, user.getId());
ps.executeUpdate();
}
} catch (Exception e) {
log.error("修改用户信息出错", e);
} finally {
DbUtil.closeConnection(null, ps, conn);
}
}
/**
* 修改用户密码
*
* @param user 用户对象
* @throws Exception
*/
public void updatePassword(User user) throws Exception {
Connection conn = DbUtil.getConnection();
PreparedStatement ps = null;
try {
ps = conn.prepareStatement("update auth_user set user_password=? where id=?");
ps.setString(1, Secure.encryptPwd(user.getUserPassword()));
ps.setInt(2, user.getId());
ps.executeUpdate();
} catch (Exception e) {
log.error("修改用户密码时出现异常：", e);
throw e;
} finally {
DbUtil.closeConnection(null, ps, conn);
}
}
/**
* 添加新用户
*
* @param user
*/
public void addUser(User user) {
Connection conn = DbUtil.getConnection();
PreparedStatement ps = null;
try {
ps =
conn.prepareStatement(
"insert into auth_user(department_id,user_name,user_password,user_real_name,use_status,create_time) values(?,?,?,?,?,?)");
ps.setInt(1, user.getDepartmentId());
ps.setString(2, user.getUserName());
ps.setString(3, Secure.encryptPwd(user.getUserPassword()));
ps.setString(4, user.getUserRealName());
ps.setInt(5, 1);
ps.setTimestamp(6, user.getCreateTime());
ps.execute();
} catch (Exception e) {
log.error("增加用户信息出错", e);
} finally {
DbUtil.closeConnection(null, ps, conn);
}
}