package com.fgkj.dao.impl;
|
|
import java.sql.ResultSet;
|
import java.sql.SQLException;
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
|
import com.fgkj.actions.ActionUtil;
|
import com.fgkj.dao.BaseDAO;
|
import com.fgkj.dao.CallBack;
|
import com.fgkj.dao.DAOHelper;
|
import com.fgkj.db.DBUtil;
|
import com.fgkj.db.IDatabaseName;
|
import com.fgkj.dto.User;
|
import com.fgkj.dto.UserRole;
|
|
public class UserDAOImpl implements BaseDAO {
|
|
/**
|
* Ìí¼ÓÔ±¹¤
|
*/
|
public boolean add(Object obj) {
|
String sql = "insert into web_site.tb_user(maintain,uname,upass,idnumber,employeeid,phone,mobile,email,address,birthday,entryday,"
|
+ "sex,job,jurisdiction,jobgroup,duties,tasks,isairplane,remarks,pid,flag) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
|
User user = (User) obj;
|
Boolean bl = DAOHelper.executeUpdate(
|
DBUtil.getConn(),
|
sql,
|
new Object[] {user.getMaintain(), user.getUname(),
|
user.getUpass(), user.getIdnumber(),
|
user.getEmployeeid(), user.getPhone(),
|
user.getMobile(), user.getEmail(), user.getAddress(),
|
ActionUtil.getSimpDate(user.getBirthday()),
|
ActionUtil.getSimpDate(user.getEntryday()),
|
user.getSex(), user.getJob(), user.getJurisdiction(),
|
user.getJobgroup(), user.getDuties(), user.getTasks(),
|
user.getIsairplane(), user.getRemarks(), user.getPid(),
|
user.getFlag() });
|
return bl;
|
}
|
|
/**
|
* ÐÞ¸ÄÔ±¹¤
|
*/
|
public boolean update(Object obj) {
|
String sql = "update web_site.tb_user set maintain=?,idnumber=?"
|
+ ",employeeid=?,phone=?,mobile=?,email=?,address=?,birthday=?"
|
+ ",entryday=?,sex=?,"
|
+ "job=?,jurisdiction=?,jobgroup=?,duties=?"
|
+ ",tasks=?,isairplane=?,remarks=?,pid=? where uname=?";
|
User user = (User) obj;
|
Boolean bl = DAOHelper.executeUpdate(
|
DBUtil.getConn(),
|
sql,
|
new Object[] { user.getMaintain(), user.getIdnumber(),
|
user.getEmployeeid(), user.getPhone(),
|
user.getMobile(), user.getEmail(), user.getAddress(),
|
ActionUtil.getSimpDate(user.getBirthday()),
|
ActionUtil.getSimpDate(user.getEntryday()),
|
user.getSex(), user.getJob(), user.getJurisdiction(),
|
user.getJobgroup(), user.getDuties(), user.getTasks(),
|
user.getIsairplane(), user.getRemarks(), user.getPid(),
|
user.getUname()});
|
return bl;
|
}
|
|
/**
|
* ÐÞ¸ÄÃÜÂë
|
* @param obj
|
* @return
|
*/
|
public boolean updatePass(Object obj){
|
User u=(User)obj;
|
String sql="update web_site.tb_user set upass=? where uname=?";
|
return DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{u.getUpass(),u.getUname()});
|
}
|
|
/**
|
* ɾ³ýÔ±¹¤
|
*/
|
public boolean del(Object obj) {
|
String sql = "update web_site.tb_user set flag=? where uid=?";
|
User user = (User) obj;
|
user.setFlag(1);
|
Boolean bl = DAOHelper.executeUpdate(DBUtil.getConn(), sql,
|
new Object[] { 1, user.getUid() });
|
return bl;
|
}
|
|
/**
|
* ²éѯָ¶¨Óû§ÃûµÄÔ±¹¤
|
*/
|
public List serchByCondition(Object obj) {
|
String sql = "select uid,maintain,uname,upass,idnumber"
|
+ ",employeeid,phone,mobile,email,address,birthday"
|
+ ",entryday,sex,job,jurisdiction,jobgroup,duties"
|
+ ",tasks,isairplane,remarks,pid,flag from web_site.tb_user where uname=? and flag=0";
|
User user = (User) obj;
|
// System.out.println(user+"&&&");
|
List list = DAOHelper.executeQuery(sql,DBUtil.getConn(),
|
new Object[] { user.getUname() }, new CallBack() {
|
|
public List getResults(ResultSet rs) {
|
List list = new ArrayList();
|
try {
|
while (rs.next()) {
|
User u = new User();
|
|
u.setUid(rs.getInt("uid"));
|
u.setMaintain(rs.getString("maintain"));
|
u.setUname(rs.getString("uname"));
|
u.setUpass(rs.getString("upass"));
|
u.setIdnumber(rs.getString("idnumber"));
|
u.setEmployeeid(rs.getString("employeeid"));
|
u.setPhone(rs.getString("phone"));
|
u.setMobile(rs.getString("mobile"));
|
u.setEmail(rs.getString("email"));
|
u.setAddress(rs.getString("address"));
|
u.setBirthday((Date) rs.getObject("birthday"));
|
u.setEntryday((Date) rs.getObject("entryday"));
|
u.setSex(rs.getString("sex"));
|
u.setJob(rs.getString("job"));
|
u.setJurisdiction(rs.getString("jurisdiction"));
|
u.setJobgroup(rs.getInt("jobgroup"));
|
u.setDuties(rs.getString("duties"));
|
u.setTasks(rs.getString("tasks"));
|
u.setIsairplane(rs.getBoolean("isairplane"));
|
u.setRemarks(rs.getString("remarks"));
|
u.setPid(rs.getInt("pid"));
|
u.setFlag(rs.getInt("flag"));
|
list.add(u);
|
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
return list;
|
}
|
});
|
return list;
|
}
|
|
public List serchByPage(int currentPage,int PageSize) {
|
String sql = "select uid,maintain,uname,upass,idnumber"
|
+ ",employeeid,phone,mobile,email,address,birthday"
|
+ ",entryday,sex,job,jurisdiction,jobgroup,duties"
|
+ ",tasks,isairplane,remarks,pid,flag from (select * from web_site.tb_user where flag=0)t where t.uid limit ?,?";
|
|
// System.out.println(user+"&&&");
|
List list = DAOHelper.executeQuery(sql,DBUtil.getConn(),
|
new Object[] {(currentPage-1)*PageSize,PageSize }, new CallBack() {
|
|
public List getResults(ResultSet rs) {
|
List list = new ArrayList();
|
try {
|
while (rs.next()) {
|
User u = new User();
|
|
u.setUid(rs.getInt("uid"));
|
u.setMaintain(rs.getString("maintain"));
|
u.setUname(rs.getString("uname"));
|
u.setUpass(rs.getString("upass"));
|
u.setIdnumber(rs.getString("idnumber"));
|
u.setEmployeeid(rs.getString("employeeid"));
|
u.setPhone(rs.getString("phone"));
|
u.setMobile(rs.getString("mobile"));
|
u.setEmail(rs.getString("email"));
|
u.setAddress(rs.getString("address"));
|
u.setBirthday((Date) rs.getObject("birthday"));
|
u.setEntryday((Date) rs.getObject("entryday"));
|
u.setSex(rs.getString("sex"));
|
u.setJob(rs.getString("job"));
|
u.setJurisdiction(rs.getString("jurisdiction"));
|
u.setJobgroup(rs.getInt("jobgroup"));
|
u.setDuties(rs.getString("duties"));
|
u.setTasks(rs.getString("tasks"));
|
u.setIsairplane(rs.getBoolean("isairplane"));
|
u.setRemarks(rs.getString("remarks"));
|
u.setPid(rs.getInt("pid"));
|
u.setFlag(rs.getInt("flag"));
|
list.add(u);
|
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
return list;
|
}
|
});
|
return list;
|
}
|
|
/**
|
* ²éѯËùÓÐÔ±¹¤
|
*/
|
public List searchAll() {
|
String sql = "select * from web_site.tb_user where flag=0";
|
// System.out.println(user.getUname()+"&&&");
|
List list = DAOHelper.executeQuery(sql,DBUtil.getConn(), null, new CallBack() {
|
|
public List getResults(ResultSet rs) {
|
List list = new ArrayList();
|
try {
|
while (rs.next()) {
|
User u = new User();
|
UserRole ur=new UserRole();
|
u.setUid(rs.getInt("uid"));
|
u.setMaintain(rs.getString("maintain"));
|
u.setUname(rs.getString("uname"));
|
u.setUpass(rs.getString("upass"));
|
u.setIdnumber(rs.getString("idnumber"));
|
u.setEmployeeid(rs.getString("employeeid"));
|
u.setPhone(rs.getString("phone"));
|
u.setMobile(rs.getString("mobile"));
|
u.setEmail(rs.getString("email"));
|
u.setAddress(rs.getString("address"));
|
u.setBirthday((Date) rs.getObject("birthday"));
|
u.setEntryday((Date) rs.getObject("entryday"));
|
u.setSex(rs.getString("sex"));
|
u.setJob(rs.getString("job"));
|
u.setJurisdiction(rs.getString("jurisdiction"));
|
u.setJobgroup(rs.getInt("jobgroup"));
|
u.setDuties(rs.getString("duties"));
|
u.setTasks(rs.getString("tasks"));
|
u.setIsairplane(rs.getBoolean("isairplane"));
|
u.setRemarks(rs.getString("remarks"));
|
u.setPid(rs.getInt("pid"));
|
u.setFlag(rs.getInt("flag"));
|
|
|
list.add(u);
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
return list;
|
}
|
});
|
return list;
|
}
|
|
/**
|
* Ä£ºý²éѯ
|
*/
|
public List serchByInfo(Object obj) {
|
String sql = "select uid,maintain,uname,upass,idnumber"
|
+ ",employeeid,phone,mobile,email,address,birthday"
|
+ ",entryday,sex,job,jurisdiction,jobgroup,duties"
|
+ ",tasks,isairplane,remarks,pid,flag from web_site.tb_user where (uname like BINARY ? or uid like ? or employeeid like ?) and flag = 0";
|
User user = (User) obj;
|
// System.out.println(user+"&&&");
|
List list = DAOHelper.executeQuery(
|
sql,DBUtil.getConn(),
|
new Object[] { "%" + user.getUname() + "%",
|
"%" + user.getUname() + "%",
|
"%" + user.getUname() + "%" }, new CallBack() {
|
|
public List getResults(ResultSet rs) {
|
List list = new ArrayList();
|
try {
|
while (rs.next()) {
|
User u = new User();
|
|
u.setUid(rs.getInt("uid"));
|
u.setMaintain(rs.getString("maintain"));
|
u.setUname(rs.getString("uname"));
|
u.setUpass(rs.getString("upass"));
|
u.setIdnumber(rs.getString("idnumber"));
|
u.setEmployeeid(rs.getString("employeeid"));
|
u.setPhone(rs.getString("phone"));
|
u.setMobile(rs.getString("mobile"));
|
u.setEmail(rs.getString("email"));
|
u.setAddress(rs.getString("address"));
|
u.setBirthday((Date) rs.getObject("birthday"));
|
u.setEntryday((Date) rs.getObject("entryday"));
|
u.setSex(rs.getString("sex"));
|
u.setJob(rs.getString("job"));
|
u.setJurisdiction(rs.getString("jurisdiction"));
|
u.setJobgroup(rs.getInt("jobgroup"));
|
u.setDuties(rs.getString("duties"));
|
u.setTasks(rs.getString("tasks"));
|
u.setIsairplane(rs.getBoolean("isairplane"));
|
u.setRemarks(rs.getString("remarks"));
|
u.setPid(rs.getInt("pid"));
|
u.setFlag(rs.getInt("flag"));
|
list.add(u);
|
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
return list;
|
}
|
});
|
return list;
|
}
|
// public static void main(String[] args) {
|
// List list= new UserDAOImpl().serchByPage(1, 6);
|
// System.out.println(list);
|
// }
|
}
|
