~whyclxw/sensor.git

package com.fgkj.dao.impl; 
 
import java.sql.ResultSet; 
import java.sql.SQLException; 
import java.util.ArrayList; 
import java.util.List; 
 
import com.fgkj.dao.BaseDAO; 
import com.fgkj.dao.CallBack; 
import com.fgkj.dao.DAOHelper; 
import com.fgkj.dao.UinfDaoFactory; 
import com.fgkj.db.DBUtil; 
import com.fgkj.db.IDatabaseName; 
import com.fgkj.dto.User_inf; 
import com.fgkj.dto.User_log; 
import com.fgkj.dto.User_permitgroup; 
import com.fgkj.services.User_logService; 
 
public class User_permitgroupImpl implements BaseDAO,CallBack{ 
 
    public List getResults(ResultSet rs) { 
        List list=new ArrayList(); 
        try { 
            while(rs.next()){ 
                User_permitgroup ugroup=new User_permitgroup(); 
                ugroup.setNum(rs.getInt("num")); 
                ugroup.setPermit_group_id(rs.getInt("permit_group_id")); 
                ugroup.setPermit_group_name(rs.getString("permit_group_name")); 
                ugroup.setPermit_item_name(rs.getString("permit_item_name")); 
                ugroup.setPermit_item_value(rs.getInt("permit_item_value")); 
                 
                list.add(ugroup); 
            } 
        } catch (SQLException e) { 
            e.printStackTrace(); 
        } 
        return list; 
    } 
     
    //5.2添加(新增权限组并将所有权限都添加) 
    public boolean add(Object obj) { 
        User_permitgroup ugroup=(User_permitgroup) obj; 
        String sql="insert into db_user.tb_user_permitgroup(permit_group_id,permit_group_name,permit_item_name,permit_item_value) values(?,?,?,?)"; 
        Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{ugroup.getPermit_group_id(),ugroup.getPermit_group_name(), 
            ugroup.getPermit_item_name(),ugroup.getPermit_item_value()}); 
        return bl; 
    } 
    //5.2添加(新增权限组并将所有权限都添加) 
    public boolean addPro(Object obj) { 
        List<User_permitgroup> list=(List) obj; 
        ArrayList sql_strs=new ArrayList(); 
        if(list!=null&&list.size()>0){ 
            for (User_permitgroup ugroup : list) { 
                String sql="insert into db_user.tb_user_permitgroup(permit_group_id,permit_group_name,permit_item_name,permit_item_value) values("+ugroup.getPermit_group_id()+",'"+ugroup.getPermit_group_name()+"','"+ugroup.getPermit_item_name()+"',"+ugroup.getPermit_item_value()+")"; 
                sql_strs.add(sql); 
            } 
        } 
        boolean bl=DAOHelper.makeManualCommit(DBUtil.getConn(), sql_strs); 
        return bl; 
    } 
     
    //5.2编辑(修改权限值) 
    public boolean update(Object obj) { 
        List<User_permitgroup> list=(List) obj; 
        ArrayList sql_strs=new ArrayList(); 
        if(list!=null&&list.size()>0){ 
            for (User_permitgroup ugroup : list) { 
                String sql="update db_user.tb_user_permitgroup set permit_item_value='"+ugroup.getPermit_item_value()+"' where num="+ugroup.getNum(); 
                sql_strs.add(sql); 
            } 
        } 
        boolean bl=DAOHelper.makeManualCommit(DBUtil.getConn(), sql_strs); 
        return bl; 
    } 
    //5.2编辑(修改权限值) 
    public boolean updatePro(Object obj) { 
        User_permitgroup ugroup=(User_permitgroup) obj; 
        String sql="update db_user.tb_user_permitgroup set permit_item_value=? where num=? "; 
        Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{ 
            ugroup.getPermit_item_value(),ugroup.getNum()}); 
        return bl; 
    } 
    //5.2重命名(修改权限名) 
    public boolean updateName(Object obj) { 
        User_permitgroup ugroup=(User_permitgroup) obj; 
        String sql="update db_user.tb_user_permitgroup set permit_group_name=? where permit_group_id=?"; 
        Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{ 
            ugroup.getPermit_group_name(),ugroup.getPermit_group_id()}); 
        return bl; 
    } 
    //5.2删除(删除所有该权限组) 
    public boolean del(Object obj) { 
        User_permitgroup ugroup=(User_permitgroup) obj; 
        String sql="delete from db_user.tb_user_permitgroup where tb_user_permitgroup.permit_group_id=?  "; 
        Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{ugroup.getPermit_group_id()}); 
        return bl; 
    } 
 
    //5.1根据uid查权限 
    public List serchByCondition(Object obj) { 
        User_inf uinf=(User_inf) obj; 
        String sql="select distinct(permit_group_name),tb_user_permitgroup.permit_group_id from db_user.tb_user_permitgroup,db_user.tb_user_permitgroup_data where tb_user_permitgroup.permit_group_id=tb_user_permitgroup_data.permit_group_id" + 
                " and tb_user_permitgroup_data.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_permitgroup upgroup=new User_permitgroup(); 
                        upgroup.setPermit_group_name(rs.getString("permit_group_name")); 
                        upgroup.setPermit_group_id(rs.getInt("permit_group_id"));                         
                        list.add(upgroup); 
                    } 
                } catch (SQLException e) { 
                    e.printStackTrace(); 
                } 
                return list; 
            } 
        }); 
        return list; 
    } 
 
    //5.2查所有的权限id和权限名称 
    public List searchAll() { 
        String sql="select distinct(permit_group_id),permit_group_name from db_user.tb_user_permitgroup"; 
        List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), null, new CallBack() { 
             
            public List getResults(ResultSet rs) { 
                List list=new ArrayList(); 
                try { 
                    while(rs.next()){ 
                        User_permitgroup ugroup=new User_permitgroup(); 
                        ugroup.setPermit_group_id(rs.getInt("permit_group_id")); 
                        ugroup.setPermit_group_name(rs.getString("permit_group_name")); 
                        list.add(ugroup); 
                    } 
                } catch (SQLException e) { 
                    // TODO Auto-generated catch block 
                    e.printStackTrace(); 
                } 
                return list; 
            } 
        }); 
        return list; 
    } 
     
     
    //5.2根据权限id查用户 
    public List serchByPermit(Object obj){ 
        User_permitgroup ugroup=(User_permitgroup) obj; 
        String sql="select distinct(uname),tb_user_inf.uid,tb_user_permitgroup_data.num from db_user.tb_user_inf,db_user.tb_user_permitgroup,db_user.tb_user_permitgroup_data " + 
                "where tb_user_permitgroup.permit_group_id=tb_user_permitgroup_data.permit_group_id " + 
                "and tb_user_inf.uid=tb_user_permitgroup_data.uid " + 
                "and tb_user_permitgroup.permit_group_id=?"; 
        List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{ugroup.getPermit_group_id()}, 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.setUBaojiusr(rs.getInt("num")); 
                        list.add(uinf); 
                    } 
                } catch (SQLException e) { 
                    e.printStackTrace(); 
                } 
                return list; 
            } 
        }); 
        return list; 
    } 
     
    //5.2根据权限组id查对应的所有权限 
    public List serchByInfo(Object obj) { 
        User_permitgroup ugroup=(User_permitgroup) obj; 
        String sql="select num,permit_group_id,permit_group_name,permit_item_name,permit_item_value from db_user.tb_user_permitgroup " + 
                "where permit_group_id=? order by permit_group_id"; 
        List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{ugroup.getPermit_group_id()}, new User_permitgroupImpl()); 
        return list; 
    } 
     
    //5.2查所有具体的权限 
    public List serchRole() { 
        String sql="select distinct(permit_item_name) from db_user.tb_user_permitgroup  "; 
        List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), null, new CallBack() { 
             
            public List getResults(ResultSet rs) { 
                List list=new ArrayList(); 
                try { 
                    while(rs.next()){ 
                        User_permitgroup ugroup=new User_permitgroup(); 
                         
                        ugroup.setPermit_item_name(rs.getString("permit_item_name")); 
                         
                        list.add(ugroup); 
                    } 
                } catch (SQLException e) { 
                    // TODO Auto-generated catch block 
                    e.printStackTrace(); 
                } 
                return list; 
            } 
        }); 
        return list; 
    } 
    //5.2查最大的权限Id 
    public List serchMaxRoleId() { 
        String sql="select max(permit_group_id)as permit_group_id from db_user.tb_user_permitgroup  "; 
        List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), null, new CallBack() { 
             
            public List getResults(ResultSet rs) { 
                List list=new ArrayList(); 
                try { 
                    while(rs.next()){ 
                        User_permitgroup ugroup=new User_permitgroup(); 
                         
                        ugroup.setPermit_group_id(rs.getInt("permit_group_id")); 
                         
                        list.add(ugroup); 
                    } 
                } catch (SQLException e) { 
                    // TODO Auto-generated catch block 
                    e.printStackTrace(); 
                } 
                return list; 
            } 
        }); 
        return list; 
    } 
     
    //5.2根据用户id查对应的权限值为1的所有权限 
    public List serchItem(Object obj){ 
            User_inf uinf=(User_inf) obj; 
            String sql="select  tb_user_permitgroup.num,permit_group_name,permit_item_name,permit_item_value " + 
                    "from db_user.tb_user_permitgroup,db_user.tb_user_permitgroup_data  " + 
                    "where tb_user_permitgroup.permit_group_id=tb_user_permitgroup_data.permit_group_id " + 
                    "and tb_user_permitgroup_data.uId=? " + 
                    "and tb_user_permitgroup.permit_item_value=1 "; 
            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_permitgroup ugroup=new User_permitgroup(); 
                            ugroup.setNum(rs.getInt("num")); 
                            ugroup.setPermit_group_name(rs.getString("permit_group_name")); 
                            ugroup.setPermit_item_name(rs.getString("permit_item_name")); 
                            ugroup.setPermit_item_value(rs.getInt("permit_item_value")); 
                            list.add(ugroup); 
                        } 
                    } catch (SQLException e) { 
                        // TODO Auto-generated catch block 
                        e.printStackTrace(); 
                    } 
                    return list; 
                } 
            }); 
            return list; 
        } 
 
 
    public static void main(String[] args) { 
    User_permitgroupImpl uimpl=new User_permitgroupImpl(); 
    /*List<User_permitgroup> list=up.searchAll(); 
    for(User_permitgroup u:list){ 
        System.out.println(u); 
    }*/ 
    /*User_permitgroup u=new User_permitgroup(); 
    u.setNum(144); 
    List<User_permitgroup> list=up.serchByCondition(u); 
    for(User_permitgroup uu:list){ 
        System.out.println(uu); 
    }*/ 
    /*User_inf uinf=new User_inf(); 
    uinf.setUId(1002); 
    List<User_permitgroup> list=uimpl.serchByCondition(uinf); 
    System.out.println(list.size());*/ 
    User_permitgroup ugroup=new User_permitgroup(); 
    ugroup.setPermit_group_id(100002); 
    //List<User_permitgroup> list=uimpl.serchByInfo(ugroup); 
    List<User_inf> list=uimpl.serchByPermit(ugroup); 
    for(User_inf uu:list){ 
        System.out.println(uu); 
    } 
} 
}