权限查询

whyclxw

2021-03-24 c183231059a980d6581968361b44b0d74439c773

权限查询

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

@@ -39,7 +39,12 @@
        result=tojson(model);
        return SUCCESS;
    }
	
    //权限管理——————查出所有的用户标识是否有权限
    public String serchUserByGroup() {
        ServiceModel model=service.serchUserByGroup();
        result=tojson(model);
        return SUCCESS;
    }
    
    
    

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

@@ -95,12 +95,37 @@
                        });
        return list;
    }

    @Override
    public List serchByInfo(Object obj) {
        // TODO Auto-generated method stub
        return null;
    }
    //权限管理——————查出所有的用户标识是否有权限
    public List serchUserByGroup() {
        String sql=" select distinct tb_user_inf.uid,uname,IFNULL(tb_user_battgroup_baojigroup_usr.baoji_group_id,0) as permit_id from tb_user_inf "
                + " LEFT JOIN  tb_user_battgroup_baojigroup_usr on tb_user_inf.uid=tb_user_battgroup_baojigroup_usr.uId "
                + " order by tb_user_inf.uid asc ";
        List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[] {}, new CallBack() {
			
            @Override
            public List getResults(ResultSet rs) {
                List list=new ArrayList();
                try {
                    while(rs.next()) {
                        User_inf u=new User_inf();
                        u.setUId(rs.getInt("uid"));
                        u.setUName(rs.getString("uname"));
                        u.setUNote(rs.getString("permit_id"));
                        list.add(u);
                    }
                } catch (SQLException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }
                return list;
            }
        });
        return list;
    }

    
    

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

@@ -11,6 +11,7 @@
import com.fgkj.actions.ActionUtil;
import com.fgkj.dao.BaseDAO;
import com.fgkj.dao.BaseDAOFactory;
import com.fgkj.dao.impl.User_infImpl;
import com.fgkj.dto.UserClient;
import com.fgkj.dto.User_inf;

@@ -190,4 +191,18 @@
        application.setAttribute("users", map);
    }
    
    //权限管理——————查出所有的用户标识是否有权限
    public ServiceModel serchUserByGroup() {
        List list=((User_infImpl)dao).serchUserByGroup();
        if(list!=null&&list.size()>0){
            model.setCode(1);
            model.setData(list);
            model.setMsg("查询成功!");
        }
        else{
            model.setCode(0);
            model.setMsg("查询失败!");
        }
        return model;
    }
}