修改用户管理穿梭框

lxw

2020-06-16 12901f1550d9dc592aef1e2251fda632a913662c

修改用户管理穿梭框

 zijing/src/com/fgkj/actions/User_infAction.java

@@ -212,6 +212,14 @@
    public String checkService(){

        return SUCCESS;

    }

	
    //包机组重做（穿梭框）查询所有的用户
    public String searchCS_All() {
        ServiceModel model=service.searchCS_All();
        result = ActionUtil.tojson(model);
        return SUCCESS;
    }

    public String test(){

        System.out.println(upjson);

        System.out.println(uif);


 zijing/src/com/fgkj/dao/impl/User_infImpl.java

@@ -541,6 +541,48 @@
        return list;

    }

    

    //包机组重做（穿梭框）查询所有的用户
    public List searchCS_All() {
        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 "+ 
                " from db_user.tb_user_inf " +
                " order by uid ";
        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 userinf = new User_inf();
                                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;
    }
    public static void main(String[] args) {

        User_infImpl ui= new User_infImpl();

        List<User_inf> list=ui.searchAll(); 


 zijing/src/com/fgkj/services/User_infService.java

@@ -333,6 +333,22 @@
        }

        return model;

    }

	
    //包机组重做（穿梭框）查询所有的用户
    public ServiceModel searchCS_All() {
        List list=((User_infImpl)dao).searchCS_All();
        if(list!=null&&list.size()>0){
            model.setCode(1);
            model.setData(list);
            model.setMsg("查询成功!");
        }
        else{
            model.setCode(0);
            model.setMsg("查询失败!");
        }
        return model;
    }

    public static void main(String[] args) {

        User_infService us = new User_infService();

        User_inf u = new User_inf();