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