package com.fgkj.dao.impl;
|
|
import java.sql.Connection;
|
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.dao.LimitNumberFactory;
|
import com.fgkj.dao.UinfDaoFactory;
|
import com.fgkj.db.DBUtil;
|
import com.fgkj.db.IDatabaseName;
|
import com.fgkj.dto.Page;
|
import com.fgkj.dto.User_inf;
|
|
public class User_infImpl implements BaseDAO, CallBack {
|
|
public List getResults(ResultSet rs) {
|
List list = new ArrayList();
|
try {
|
while (rs.next()) {
|
User_inf userinf = new User_inf();
|
|
userinf.setUId(rs.getInt("uId"));
|
|
userinf.setUSnId(rs.getString("uSnId"));
|
|
userinf.setUName(rs.getString("uName"));
|
|
userinf.setUShenFenId(rs.getString("uShenFenId"));
|
|
userinf.setUEmployeeId(rs.getString("uEmployeeId"));
|
|
userinf.setUTelephone(rs.getString("uTelephone"));
|
|
userinf.setUMobilephone(rs.getString("uMobilephone"));
|
|
userinf.setUEmail(rs.getString("uEmail"));
|
|
userinf.setUAddr(rs.getString("uAddr"));
|
|
userinf.setUBirthDay((Date) rs.getObject("uBirthDay"));
|
|
userinf.setUAccessionDay((Date) rs.getObject("uAccessionDay"));
|
|
userinf.setUSex(rs.getString("uSex"));
|
|
userinf.setUDepartment(rs.getString("uDepartment"));
|
|
userinf.setUProTitle(rs.getString("uProTitle"));
|
|
userinf.setUAuthority(rs.getString("uAuthority"));
|
|
userinf.setUJobGroup(rs.getString("uJobGroup"));
|
|
userinf.setUDuties(rs.getString("uDuties"));
|
|
userinf.setUTasks(rs.getString("uTasks"));
|
|
userinf.setUBaojiusr(Integer.parseInt(rs.getString("uBaojiUsr")));
|
|
userinf.setUNote(rs.getString("uNote"));
|
|
//userinf.setUpassword(rs.getString("upassword"));
|
|
list.add(userinf);
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
return list;
|
}
|
|
//5.1用户管理(添加)
|
public boolean add(Object obj) {
|
User_inf uinf=(User_inf) obj;
|
String sql="insert into db_user.tb_user_inf(uSnId,uPassword,uName,uShenFenId,uEmployeeId,uTelephone,uMobilephone,uEmail,uAddr,uBirthday,uAccessionDay," +
|
"uSex,uDepartment,uProTitle,uAuthority,uJobGroup,uDuties,uTasks,uBaojiusr,uNote) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
|
Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{uinf.getUSnId(),uinf.getUpassword(),uinf.getUName(),uinf.getUShenFenId(),
|
uinf.getUEmployeeId(),uinf.getUTelephone(),uinf.getUMobilephone(),uinf.getUEmail(),uinf.getUAddr(),uinf.getUBirthDay(),uinf.getUAccessionDay(),
|
uinf.getUSex(),uinf.getUDepartment(),uinf.getUProTitle(),uinf.getUAuthority(),uinf.getUJobGroup(),uinf.getUDuties(),uinf.getUTasks(),uinf.getUBaojiusr(),
|
uinf.getUNote()});
|
return bl;
|
}
|
//5.1用户管理(添加时判断用户名是否重复)
|
public int addJudge(Object obj){
|
User_inf uinf=(User_inf) obj;
|
String sql=" select count(uid) as nums from db_user.tb_user_inf where uname=? limit 1";
|
List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{uinf.getUName()}, new CallBack() {
|
|
public List getResults(ResultSet rs) {
|
List list=new ArrayList();
|
try {
|
while(rs.next()){
|
int nums=rs.getInt("nums");
|
list.add(nums);
|
}
|
} catch (SQLException e) {
|
// TODO Auto-generated catch block
|
e.printStackTrace();
|
}
|
return list;
|
}
|
});
|
int flag=1;
|
if(list!=null&&list.size()>0){
|
int nums=(Integer) list.get(list.size()-1);
|
//System.out.println(nums);
|
if(nums>0){
|
flag=0;
|
}else{
|
flag=1;
|
}
|
}
|
return flag;
|
}
|
|
//5.1用户管理(编辑)
|
public boolean update(Object obj) {
|
User_inf uinf=(User_inf) obj;
|
String sql="update db_user.tb_user_inf set uName=?,uShenFenId=?,uEmployeeId=?,uTelephone=?,uMobilephone=?,uEmail=?,uAddr=?,uBirthday=?,uAccessionDay=?," +
|
"uSex=?,uDepartment=?,uProTitle=?,uAuthority=?,uJobGroup=?,uDuties=?,uTasks=?,uBaojiusr=?,uNote=? where uId=?";
|
Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{uinf.getUName(),uinf.getUShenFenId(),
|
uinf.getUEmployeeId(),uinf.getUTelephone(),uinf.getUMobilephone(),uinf.getUEmail(),uinf.getUAddr(),uinf.getUBirthDay(),uinf.getUAccessionDay(),
|
uinf.getUSex(),uinf.getUDepartment(),uinf.getUProTitle(),uinf.getUAuthority(),uinf.getUJobGroup(),uinf.getUDuties(),uinf.getUTasks(),uinf.getUBaojiusr(),
|
uinf.getUNote(),uinf.getUId()});
|
return bl;
|
}
|
|
//5.1用户管理(删除)
|
public boolean del(Object obj) {
|
User_inf uinf=(User_inf) obj;
|
boolean bl = false;
|
String sql="delete from db_user.tb_user_inf where uId=? ";
|
bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{uinf.getUId()});
|
return bl;
|
}
|
|
//首页会根据uname查询用户信息
|
public List serchByCondition(Object obj) {
|
User_inf uinf=(User_inf) obj;
|
String sql = "select uid,uname,uSnId,upassword,unote from db_user.tb_user_inf where uname=?";
|
List list = DAOHelper
|
.executeQuery(sql, DBUtil.getConn(), new Object[]{uinf.getUName()},
|
new CallBack() {
|
|
public List getResults(ResultSet rs) {
|
List list=new ArrayList();
|
try {
|
while(rs.next()){
|
User_inf uinf=new User_inf();
|
uinf.setUId(rs.getInt("uId"));
|
uinf.setUName(rs.getString("uName"));
|
uinf.setUSnId(rs.getString("uSnId"));
|
uinf.setUNote(rs.getString("uNote"));
|
uinf.setUpassword(rs.getString("upassword"));
|
list.add(uinf);
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
return list;
|
}
|
});
|
return list;
|
}
|
//查询当前库中存在的name名字的排序(模糊)
|
public List serchinfoUname() {
|
String sql = "select uid,uname from db_user.tb_user_inf where uname like '%name%' order by uname";
|
List list = DAOHelper
|
.executeQuery(sql, DBUtil.getConn(),null,
|
new CallBack() {
|
|
public List getResults(ResultSet rs) {
|
List list=new ArrayList();
|
try {
|
while(rs.next()){
|
User_inf uinf=new User_inf();
|
uinf.setUId(rs.getInt("uId"));
|
uinf.setUName(rs.getString("uName"));
|
list.add(uinf);
|
}
|
} catch (SQLException e) {
|
// TODO Auto-generated catch block
|
e.printStackTrace();
|
}
|
return list;
|
}
|
});
|
return list;
|
}
|
/*//5.3根据uid查包机组
|
public List serchByInfo(Object obj) {
|
User_inf uinf=(User_inf) obj;
|
String sql = "select distinct(baoji_group_name) " +
|
"from db_user.tb_user_battgroup_baojigroup,db_user.tb_user_battgroup_baojigroup_usr " +
|
"where tb_user_battgroup_baojigroup_usr.baoji_group_id=tb_user_battgroup_baojigroup.baoji_group_id " +
|
"and tb_user_battgroup_baojigroup_usr.uId=?";
|
List list = DAOHelper
|
.executeQuery(sql, DBUtil.getConn(), new Object[]{uinf.getUId()},
|
new CallBack() {
|
|
public List getResults(ResultSet rs) {
|
List list=new ArrayList();
|
try {
|
while(rs.next()){
|
User_battgroup_baojigroup u=new User_battgroup_baojigroup();
|
u.setBaoji_group_name(rs.getString("baoji_group_name"));
|
list.add(u);
|
}
|
} catch (SQLException e) {
|
// TODO Auto-generated catch block
|
e.printStackTrace();
|
}
|
return list;
|
}
|
|
});
|
return list;
|
}*/
|
/*//根据battgroupid查对应的包机人
|
public List searchByBattGroupId(Object obj){
|
User_battgroup_baojigroup_battgroup ugroup=(User_battgroup_baojigroup_battgroup) obj;
|
String sql="select distinct(db_user.tb_user_inf.uid),db_user.tb_user_inf.uName,db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId " +
|
"from db_user.tb_user_inf ,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr " +
|
"where db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id=db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id " +
|
"and db_user.tb_user_battgroup_baojigroup_usr.uId=db_user.tb_user_inf.uid " +
|
"and db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=? and db_user.tb_user_inf.uBaojiUsr=1 ";
|
|
|
//System.out.println(sql);
|
List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{ugroup.getBattGroupId()}, new CallBack() {
|
|
public List getResults(ResultSet rs) {
|
List list=new ArrayList();
|
try {
|
while(rs.next()){
|
User_inf uinf=new User_inf();
|
uinf.setUSnId(Integer.toString((rs.getInt("battgroupid"))));
|
uinf.setUId(rs.getInt("uId"));
|
uinf.setUName(rs.getString("uName"));
|
list.add(uinf);
|
|
}
|
} catch (SQLException e) {
|
// TODO Auto-generated catch block
|
e.printStackTrace();
|
}
|
return list;
|
}
|
});
|
return list;
|
}
|
*/
|
//根据uId查用户姓名
|
public List serchUname(Object obj) {
|
User_inf uinf=(User_inf) obj;
|
String sql = "select uName from db_user.tb_user_inf where uId=?";
|
List list = DAOHelper
|
.executeQuery(sql, DBUtil.getConn(), new Object[]{uinf.getUId()},
|
new CallBack() {
|
|
public List getResults(ResultSet rs) {
|
List list=new ArrayList();
|
try {
|
while(rs.next()){
|
User_inf uinf=new User_inf();
|
uinf.setUName(rs.getString("uName"));
|
list.add(uinf);
|
}
|
} catch (SQLException e) {
|
// TODO Auto-generated catch block
|
e.printStackTrace();
|
}
|
return list;
|
}
|
|
});
|
return list;
|
}
|
|
//根据uId查用户姓名
|
public String changeUidToUname(Object obj) {
|
int uid=(Integer) obj;
|
String sql = "select distinct uName from db_user.tb_user_inf where uId=? limit 1";
|
List list = DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{uid},new CallBack() {
|
public List getResults(ResultSet rs) {
|
List list=new ArrayList();
|
try {
|
while(rs.next()){
|
String uname="";
|
if(rs.getString("uname")!=null){
|
uname=rs.getString("uname");
|
list.add(uname);
|
}
|
}
|
} catch (SQLException e) {
|
// TODO Auto-generated catch block
|
e.printStackTrace();
|
}
|
return list;
|
}
|
|
});
|
String uname="";
|
if(list!=null&&list.size()>0){
|
uname=(String) list.get(list.size()-1);
|
}
|
return uname;
|
}
|
//查询所有uid在字符串objs中的所有用户名,并且用，连接多个用户名
|
public List searchUnams(Object objs){
|
String sql = "SELECT GROUP_CONCAT(DISTINCT(uname))as unames from db_user.tb_user_inf where locate(uid,?);";
|
return DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{objs.toString()}, new CallBack() {
|
public List getResults(ResultSet rs) {
|
List list = new ArrayList();
|
try {
|
while(rs.next()){
|
String uname = rs.getString("unames");
|
if(uname != null && uname.length() >0){
|
list.add(rs.getString("unames"));
|
}
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
return list;
|
}
|
});
|
}
|
|
/*//5.1查询所有员工信息
|
public List searchAll(Object obj) {
|
Batt_User_Permit bup=(Batt_User_Permit) obj;
|
//System.out.println(bup);
|
String sql = "select distinct(tb_user_inf.uid),uSnId,uName,uShenFenId,uEmployeeId,uTelephone,uMobilephone,uEmail,uAddr,uBirthday,uAccessionDay,uSex,uDepartment,uProTitle,uAuthority,uJobGroup,uDuties,uTasks,uBaojiusr,uNote" +
|
",permit_group_name " +
|
"from db_user.tb_user_inf " +
|
"left outer join db_user.tb_user_permitgroup_data on db_user.tb_user_inf.uid=db_user.tb_user_permitgroup_data.uid " +
|
"left outer join db_user.tb_user_permitgroup on db_user.tb_user_permitgroup.permit_group_id=db_user.tb_user_permitgroup_data.permit_group_id " +
|
"where tb_user_inf.uid!=1002 " +
|
"order by uid";
|
List list = DAOHelper
|
.executeQuery(sql, DBUtil.getConn(), null,
|
new CallBack() {
|
public List getResults(ResultSet rs) {
|
List list = new ArrayList();
|
int id=0;
|
String permit="";
|
try {
|
while (rs.next()) {
|
|
Batt_User_Permit bup=new Batt_User_Permit();
|
|
User_inf userinf = new User_inf();
|
userinf.setUId(rs.getInt("uId"));
|
if(id==rs.getInt("uId")){
|
continue;
|
}else{
|
id=rs.getInt("uId");
|
}
|
userinf.setUSnId(rs.getString("uSnId"));
|
userinf.setUName(rs.getString("uName"));
|
userinf.setUShenFenId(rs.getString("uShenFenId"));
|
userinf.setUEmployeeId(rs.getString("uEmployeeId"));
|
userinf.setUTelephone(rs.getString("uTelephone"));
|
userinf.setUMobilephone(rs.getString("uMobilephone"));
|
userinf.setUEmail(rs.getString("uEmail"));
|
userinf.setUAddr(rs.getString("uAddr"));
|
userinf.setUBirthDay((Date) rs.getObject("uBirthDay"));
|
userinf.setUAccessionDay((Date) rs.getObject("uAccessionDay"));
|
userinf.setUSex(rs.getString("uSex"));
|
userinf.setUDepartment(rs.getString("uDepartment"));
|
userinf.setUProTitle(rs.getString("uProTitle"));
|
userinf.setUAuthority(rs.getString("uAuthority"));
|
userinf.setUJobGroup(rs.getString("uJobGroup"));
|
userinf.setUDuties(rs.getString("uDuties"));
|
userinf.setUTasks(rs.getString("uTasks"));
|
userinf.setUBaojiusr(Integer.parseInt(rs.getString("uBaojiUsr")));
|
userinf.setUNote(rs.getString("uNote"));
|
|
Page page=new Page();
|
bup.setUinf(userinf);
|
bup.setPage(page);
|
|
list.add(bup);
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
return list;
|
}
|
});
|
List<Batt_User_Permit> listd=new ArrayList();
|
for(int i=0;i<list.size();i++){
|
System.out.println(((Batt_Maint_Dealarm)list.get(i)).getBinf().getBattGroupId());
|
}
|
int index=0;
|
|
//System.out.println(list);
|
for(int i=(bup.getPage().getPageCurr()-1)*bup.getPage().getPageSize();i<bup.getPage().getPageSize()*bup.getPage().getPageCurr()&&i<list.size();i++){
|
|
listd.add((Batt_User_Permit) list.get(i));
|
//System.out.println(list.get(i));
|
((Batt_User_Permit)listd.get(index++)).getPage().setPageAll(list.size());
|
}
|
return listd;
|
}*/
|
|
//5.1查询所有员工信息
|
public List searchAll() {
|
String sql = "select distinct(tb_user_inf.uid),uSnId,uName,uShenFenId,uEmployeeId,uTelephone,uMobilephone,uEmail,uAddr,uBirthday,uAccessionDay,uSex,uDepartment,uProTitle,uAuthority,uJobGroup,uDuties,uTasks,uBaojiusr,uNote" +
|
",permit_group_name " +
|
"from db_user.tb_user_inf " +
|
"left outer join db_user.tb_user_permitgroup_data on db_user.tb_user_inf.uid=tb_user_permitgroup_data.uid " +
|
"left outer join db_user.tb_user_permitgroup on db_user.tb_user_permitgroup.permit_group_id=tb_user_permitgroup_data.permit_group_id " +
|
"where tb_user_inf.uid!=1002 " +
|
"order by uid";
|
List list = DAOHelper
|
.executeQuery(sql, DBUtil.getConn(), null,
|
new CallBack() {
|
public List getResults(ResultSet rs) {
|
List list = new ArrayList();
|
int id=0;
|
String permit="";
|
try {
|
while (rs.next()) {
|
|
|
|
User_inf userinf = new User_inf();
|
userinf.setUId(rs.getInt("uId"));
|
if(id==rs.getInt("uId")){
|
continue;
|
}else{
|
id=rs.getInt("uId");
|
}
|
userinf.setUSnId(rs.getString("uSnId"));
|
userinf.setUName(rs.getString("uName"));
|
userinf.setUShenFenId(rs.getString("uShenFenId"));
|
userinf.setUEmployeeId(rs.getString("uEmployeeId"));
|
userinf.setUTelephone(rs.getString("uTelephone"));
|
userinf.setUMobilephone(rs.getString("uMobilephone"));
|
userinf.setUEmail(rs.getString("uEmail"));
|
userinf.setUAddr(rs.getString("uAddr"));
|
userinf.setUBirthDay(rs.getTimestamp("uBirthDay"));
|
userinf.setUAccessionDay(rs.getTimestamp("uAccessionDay"));
|
userinf.setUSex(rs.getString("uSex"));
|
userinf.setUDepartment(rs.getString("uDepartment"));
|
userinf.setUProTitle(rs.getString("uProTitle"));
|
userinf.setUAuthority(rs.getString("uAuthority"));
|
userinf.setUJobGroup(rs.getString("uJobGroup"));
|
userinf.setUDuties(rs.getString("uDuties"));
|
userinf.setUTasks(rs.getString("uTasks"));
|
userinf.setUBaojiusr(Integer.parseInt(rs.getString("uBaojiUsr")));
|
userinf.setUNote(rs.getString("uNote"));
|
|
list.add(userinf);
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
return list;
|
}
|
});
|
return list;
|
}
|
/* //4.1查询维护区对应的维护人员个数(由模板创建作业时)
|
public List serchDepNum(Object obj){
|
User_task_batt_template utem=(User_task_batt_template) obj;
|
String sql="select distinct(uid) from db_user.tb_user_inf where db_user.tb_user_inf.ubaojiusr=1 and db_user.tb_user_inf.udepartment=? ";
|
List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{utem.getQuyu_name()}, new CallBack() {
|
|
public List getResults(ResultSet rs) {
|
List list=new ArrayList();
|
try {
|
while(rs.next()){
|
User_inf uinf=new User_inf();
|
uinf.setUId(rs.getInt("uId"));
|
list.add(uinf);
|
}
|
} catch (SQLException e) {
|
// TODO Auto-generated catch block
|
e.printStackTrace();
|
}
|
return list;
|
}
|
});
|
return list;
|
}*/
|
|
//修改用户密码
|
public boolean updatePassword(Object obj){
|
User_inf uinf=(User_inf) obj;
|
String sql="update db_user.tb_user_inf set usnid=? , upassword=? where uid=?";
|
Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{uinf.getUSnId(),uinf.getUpassword(),uinf.getUId()});
|
return bl;
|
}
|
//重置用户密码
|
public boolean resetPassword(Object obj){
|
User_inf uinf=(User_inf) obj;
|
String sql="update db_user.tb_user_inf set usnid=?,upassword=? where uid=?";
|
Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{UinfDaoFactory.MR_PWD,(String)ActionUtil.EncryptionMD5(UinfDaoFactory.MR_PWD),uinf.getUId()});
|
return bl;
|
}
|
|
/*//根据员工信息和员工编号去匹配合适的员工
|
public List searchByNameOrId(Object obj){
|
Batt_User_Permit bup=(Batt_User_Permit) obj;
|
User_inf uinf=bup.getUinf();
|
Page p=bup.getPage();
|
Connection conn=DBUtil.getConn();
|
String numberSql=" SELECT FOUND_ROWS() number";
|
String sql="select SQL_CALC_FOUND_ROWS distinct(uid),uSnId,uName,uShenFenId,uEmployeeId,uTelephone,uMobilephone,uEmail,uAddr,uBirthday,uAccessionDay,uSex,uDepartment,uProTitle,uAuthority,uJobGroup,uDuties,uTasks,uBaojiusr,uNote" +
|
" from db_user.tb_user_inf " +
|
" where uName like ? or uEmployeeId like ? " +
|
" order by uid " +
|
" limit ?,?";
|
//System.out.println(sql);
|
List<User_inf> list=DAOHelper.executeQueryLimit(sql, conn, new Object[]{"%"+uinf.getUName()+"%","%"+uinf.getUEmployeeId()+"%",(p.getPageCurr()-1)*p.getPageSize(),p.getPageSize()}, new CallBack() {
|
public List getResults(ResultSet rs) {
|
List list=new ArrayList();
|
try {
|
while(rs.next()){
|
User_inf userinf = new User_inf();
|
userinf.setUId(rs.getInt("uId"));
|
userinf.setUSnId(rs.getString("uSnId"));
|
userinf.setUName(rs.getString("uName"));
|
userinf.setUShenFenId(rs.getString("uShenFenId"));
|
userinf.setUEmployeeId(rs.getString("uEmployeeId"));
|
userinf.setUTelephone(rs.getString("uTelephone"));
|
userinf.setUMobilephone(rs.getString("uMobilephone"));
|
userinf.setUEmail(rs.getString("uEmail"));
|
userinf.setUAddr(rs.getString("uAddr"));
|
userinf.setUBirthDay(rs.getTimestamp("uBirthDay"));
|
userinf.setUAccessionDay(rs.getTimestamp("uAccessionDay"));
|
userinf.setUSex(rs.getString("uSex"));
|
userinf.setUDepartment(rs.getString("uDepartment"));
|
userinf.setUProTitle(rs.getString("uProTitle"));
|
userinf.setUAuthority(rs.getString("uAuthority"));
|
userinf.setUJobGroup(rs.getString("uJobGroup"));
|
userinf.setUDuties(rs.getString("uDuties"));
|
userinf.setUTasks(rs.getString("uTasks"));
|
userinf.setUBaojiusr(Integer.parseInt(rs.getString("uBaojiUsr")));
|
userinf.setUNote(rs.getString("uNote"));
|
list.add(userinf);
|
}
|
} catch (SQLException e) {
|
// TODO Auto-generated catch block
|
e.printStackTrace();
|
}
|
return list;
|
}
|
});
|
//去掉limit条件后的总数
|
int number=LimitNumberFactory.GetLimtitNumber(conn, numberSql);
|
if(list!=null&&list.size()>0){
|
list.get(list.size()-1).setUNote(String.valueOf(number));
|
}
|
return list;
|
}*/
|
|
public static void main(String[] args) {
|
User_infImpl ui= new User_infImpl();
|
List<User_inf> list=ui.searchAll();
|
for (User_inf u : list) {
|
System.out.println(u);
|
}
|
User_inf u=new User_inf();
|
|
u.setUId(1003);
|
// List<User_inf> list=ui.serchByCondition(u);
|
// for (User_inf uu : list) {
|
// System.out.println(uu);
|
// }
|
|
/*Batt_User_Permit bup=new Batt_User_Permit();
|
Page page=new Page();
|
page.setPageSize(2);
|
page.setPageCurr(1);
|
bup.setPage(page);*/
|
// List<Batt_User_Permit> list=ui.searchAll(bup);
|
// for (Batt_User_Permit object : list) {
|
// System.out.println(object);
|
// }
|
|
ui.searchUnams("01001,01002,01003");
|
}
|
|
@Override
|
public List serchByInfo(Object obj) {
|
// TODO Auto-generated method stub
|
return null;
|
}
|
|
|
}
|
