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); // } }