package com.javaforever.jeedemo.daoimpl;
import com.javaforever.jeedemo.dao.UserDao;
import com.javaforever.jeedemo.domain.User;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
public class UserDaoImpl implements UserDao{
public List<User> listAllUsers(Connection connection) throws Exception{
try {
String query = "select empid,firstname,lastname,password,gender,isadmin,salt,loginfailure,namec,address,address1,phone,mobile,confirmpassword,username,active,id from demo_users;";
PreparedStatement ps = connection.prepareStatement(query);
ResultSet result = ps.executeQuery();
ArrayList<User> list = new ArrayList<User>();
while(result.next()) {
//Build the list object.
User user = new User();
user.setEmpid(result.getLong("empid"));
user.setFirstname(result.getString("firstname"));
user.setLastname(result.getString("lastname"));
user.setPassword(result.getString("password"));
user.setGender(result.getString("gender"));
user.setIsadmin(result.getBoolean("isadmin"));
user.setSalt(result.getString("salt"));
user.setLoginfailure(result.getInt("loginfailure"));
user.setNamec(result.getString("namec"));
user.setAddress(result.getString("address"));
user.setAddress1(result.getString("address1"));
user.setPhone(result.getString("phone"));
user.setMobile(result.getString("mobile"));
user.setConfirmpassword(result.getString("confirmpassword"));
user.setUsername(result.getString("username"));
user.setActive(result.getBoolean("active"));
user.setId(result.getLong("id"));
//Build the object list.
list.add(user);
}
return list;
} catch (Exception e){
e.printStackTrace();
return new ArrayList<User>();
}
}
public boolean updateUser(Connection connection,User user) throws Exception{
String query = "update demo_users set empid = ? ,firstname = ? ,lastname = ? ,password = ? ,gender = ? ,isadmin = ? ,salt = ? ,loginfailure = ? ,namec = ? ,address = ? ,address1 = ? ,phone = ? ,mobile = ? ,confirmpassword = ? ,username = ? ,active = ? where id = ?;";
PreparedStatement ps = connection.prepareStatement(query);
ps.setLong(1,user.getEmpid());
ps.setString(2,user.getFirstname());
ps.setString(3,user.getLastname());
ps.setString(4,user.getPassword());
ps.setString(5,user.getGender());
ps.setBoolean(6,user.getIsadmin());
ps.setString(7,user.getSalt());
ps.setInt(8,user.getLoginfailure());
ps.setString(9,user.getNamec());
ps.setString(10,user.getAddress());
ps.setString(11,user.getAddress1());
ps.setString(12,user.getPhone());
ps.setString(13,user.getMobile());
ps.setString(14,user.getConfirmpassword());
ps.setString(15,user.getUsername());
ps.setBoolean(16,user.getActive());
ps.setLong(17,user.getId());
int result = ps.executeUpdate();
if (result > 0) {
return true;
}
return false;
}
public boolean deleteUserById(Connection connection,long id) throws Exception{
String query = "delete from demo_users where id = ?;";
PreparedStatement ps = connection.prepareStatement(query);
ps.setLong(1,id);
int result = ps.executeUpdate();
if (result > 0) {
return true;
}
return false;
}
public boolean addUser(Connection connection,User user) throws Exception{
String query = "insert into demo_users ( empid,firstname,lastname,password,gender,isadmin,salt,loginfailure,namec,address,address1,phone,mobile,confirmpassword,username,active) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);";
PreparedStatement ps = connection.prepareStatement(query);
ps.setLong(1,user.getEmpid());
ps.setString(2,user.getFirstname());
ps.setString(3,user.getLastname());
ps.setString(4,user.getPassword());
ps.setString(5,user.getGender());
ps.setBoolean(6,user.getIsadmin());
ps.setString(7,user.getSalt());
ps.setInt(8,user.getLoginfailure());
ps.setString(9,user.getNamec());
ps.setString(10,user.getAddress());
ps.setString(11,user.getAddress1());
ps.setString(12,user.getPhone());
ps.setString(13,user.getMobile());
ps.setString(14,user.getConfirmpassword());
ps.setString(15,user.getUsername());
ps.setBoolean(16,user.getActive());
int result = ps.executeUpdate();
if (result > 0) {
return true;
}
return false;
}
public boolean softDeleteUserById(Connection connection,long id) throws Exception{
String query = "update demo_users set active = false where id = ? ;";
PreparedStatement ps = connection.prepareStatement(query);
ps.setLong(1,id);
int result = ps.executeUpdate();
if (result > 0) {
return true;
}
return false;
}
public User findUserByUserId(Connection connection,long id) throws Exception{
try {
String query = "select empid,firstname,lastname,password,gender,isadmin,salt,loginfailure,namec,address,address1,phone,mobile,confirmpassword,username,active,id from demo_users where id = ?;";
PreparedStatement ps = connection.prepareStatement(query);
ps.setLong(1,id);
ResultSet result = ps.executeQuery();
User user = new User();
result.last();
//Build the object.
user.setEmpid(result.getLong("empid"));
user.setFirstname(result.getString("firstname"));
user.setLastname(result.getString("lastname"));
user.setPassword(result.getString("password"));
user.setGender(result.getString("gender"));
user.setIsadmin(result.getBoolean("isadmin"));
user.setSalt(result.getString("salt"));
user.setLoginfailure(result.getInt("loginfailure"));
user.setNamec(result.getString("namec"));
user.setAddress(result.getString("address"));
user.setAddress1(result.getString("address1"));
user.setPhone(result.getString("phone"));
user.setMobile(result.getString("mobile"));
user.setConfirmpassword(result.getString("confirmpassword"));
user.setUsername(result.getString("username"));
user.setActive(result.getBoolean("active"));
user.setId(result.getLong("id"));
return user;
} catch (Exception e){
e.printStackTrace();
return null;
}
}
public User findUserByUsername(Connection connection,String username) throws Exception{
try {
String query = "select empid,firstname,lastname,password,gender,isadmin,salt,loginfailure,namec,address,address1,phone,mobile,confirmpassword,username,active,id from demo_users where username = ?;";
PreparedStatement ps = connection.prepareStatement(query);
ps.setString(1,username);
ResultSet result = ps.executeQuery();
User user = new User();
result.last();
//Build the object.
user.setEmpid(result.getLong("empid"));
user.setFirstname(result.getString("firstname"));
user.setLastname(result.getString("lastname"));
user.setPassword(result.getString("password"));
user.setGender(result.getString("gender"));
user.setIsadmin(result.getBoolean("isadmin"));
user.setSalt(result.getString("salt"));
user.setLoginfailure(result.getInt("loginfailure"));
user.setNamec(result.getString("namec"));
user.setAddress(result.getString("address"));
user.setAddress1(result.getString("address1"));
user.setPhone(result.getString("phone"));
user.setMobile(result.getString("mobile"));
user.setConfirmpassword(result.getString("confirmpassword"));
user.setUsername(result.getString("username"));
user.setActive(result.getBoolean("active"));
user.setId(result.getLong("id"));
return user;
} catch (Exception e){
e.printStackTrace();
return null;
}
}
public List<User> searchUsersByUsername(Connection connection,String username) throws Exception{
try {
String query = "select empid,firstname,lastname,password,gender,isadmin,salt,loginfailure,namec,address,address1,phone,mobile,confirmpassword,username,active,id from demo_users where username like ?";
PreparedStatement ps = connection.prepareStatement(query);
ps.setString(1,"%"+username+"%");
ResultSet result = ps.executeQuery();
ArrayList<User> list = new ArrayList<User>();
while(result.next()) {
//Build the list object.
User user = new User();
user.setEmpid(result.getLong("empid"));
user.setFirst
Sun标准的JEE示例JEEDemo
需积分: 9 83 浏览量
2015-04-11
13:28:26
上传
评论
收藏 4.97MB ZIP 举报
Sun标准的JEE示例JEEDemo （381个子文件） 
UserDaoImpl.class 11KB LeaveLeftDaoImpl.class 10KB LeaveLimitDaoImpl.class 10KB ClockRecordDaoImpl.class 8KB BonusDaoImpl.class 8KB LeaveDaoImpl.class 8KB FineDaoImpl.class 8KB PrivilegeDaoImpl.class 8KB LeaveTypeDaoImpl.class 8KB EmployeeTypeDaoImpl.class 8KB EmployeeTypeServiceImpl.class 5KB ClockRecordServiceImpl.class 5KB LeaveLimitServiceImpl.class 5KB LeaveLeftServiceImpl.class 5KB PrivilegeServiceImpl.class 5KB LeaveTypeServiceImpl.class 5KB BonusServiceImpl.class 5KB LeaveServiceImpl.class 5KB FineServiceImpl.class 5KB UserServiceImpl.class 5KB DBConf.class 4KB User.class 4KB UpdateUserController.class 3KB AddUserController.class 3KB UpdateLeaveLeftController.class 3KB AddLeaveLeftController.class 3KB UpdateLeaveLimitController.class 3KB AddLeaveLimitController.class 3KB UpdateClockRecordController.class 3KB ListAllEmployeeTypesByPageController.class 3KB ListAllClockRecordsByPageController.class 3KB UpdateBonusController.class 3KB UpdateLeaveController.class 3KB ListAllLeaveLimitsByPageController.class 3KB UpdateFineController.class 3KB ListAllLeaveLeftsByPageController.class 3KB ListAllLeaveTypesByPageController.class 3KB ListAllPrivilegesByPageController.class 3KB AddClockRecordController.class 3KB AddBonusController.class 3KB ListAllBonusesByPageController.class 3KB AddLeaveController.class 3KB ListAllLeavesByPageController.class 3KB UpdatePrivilegeController.class 3KB ListAllFinesByPageController.class 3KB ListAllUsersByPageController.class 3KB AddFineController.class 3KB ReadConfigXml.class 3KB UpdateLeaveTypeController.class 3KB LeaveLeft.class 3KB UpdateEmployeeTypeController.class 3KB AddPrivilegeController.class 2KB AddLeaveTypeController.class 2KB AddEmployeeTypeController.class 2KB SearchEmployeeTypesByEmployeeTypeNameController.class 2KB SearchClockRecordsByClockRecordNameController.class 2KB SearchLeaveLimitsByLeaveLimitNameController.class 2KB SearchPrivilegesByPrivilegeNameController.class 2KB SearchLeaveLeftsByLeaveLeftNameController.class 2KB SearchLeaveTypesByLeaveTypeNameController.class 2KB SearchBonusesByBonusNameController.class 2KB SearchLeavesByLeaveNameController.class 2KB SearchUsersByUsernameController.class 2KB SearchFinesByFineNameController.class 2KB DeleteEmployeeTypeController.class 2KB DeleteClockRecordController.class 2KB DeleteLeaveLimitController.class 2KB SoftDeleteEmployeeTypeController.class 2KB DeletePrivilegeController.class 2KB DeleteLeaveTypeController.class 2KB DeleteLeaveLeftController.class 2KB LeaveLimit.class 2KB SoftDeleteClockRecordController.class 2KB SoftDeleteLeaveLimitController.class 2KB SoftDeleteLeaveTypeController.class 2KB SoftDeletePrivilegeController.class 2KB SoftDeleteLeaveLeftController.class 2KB DeleteBonusController.class 2KB DeleteLeaveController.class 2KB ListActiveEmployeeTypesController.class 2KB DeleteFineController.class 2KB DeleteUserController.class 2KB ListActiveClockRecordsController.class 2KB ListAllEmployeeTypesController.class 2KB ListActiveLeaveLimitsController.class 2KB SoftDeleteBonusController.class 2KB ListAllClockRecordsController.class 2KB SoftDeleteLeaveController.class 2KB FindEmployeeTypeByEmployeeTypeIdController.class 2KB ListActiveLeaveTypesController.class 2KB ListActivePrivilegesController.class 2KB ListActiveLeaveLeftsController.class 2KB ListAllLeaveLimitsController.class 2KB SoftDeleteFineController.class 2KB SoftDeleteUserController.class 2KB FindEmployeeTypeByEmployeeTypeNameController.class 2KB ListAllPrivilegesController.class 2KB FindClockRecordByClockRecordIdController.class 2KB ListAllLeaveLeftsController.class 2KB ListAllLeaveTypesController.class 2KB共 381 条
- 1
- 2
- 3
- 4
资源评论
