update

whycrzg

2021-02-02 9be8bbb37df5acb845838acf5d7bf2d4469946c0

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
package com.fgkj.mapper.impl;
 
import com.fgkj.dto.User_inf;
import com.fgkj.dto.User_permitgroup;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
 
import java.util.List;
 
public interface User_permitgroupMapper{
 
    //5.2添加(新增权限组并将所有权限都添加)
    public boolean add(Object obj);
 
    //5.2添加(新增权限组并将所有权限都添加)
    @Insert("insert into db_user.tb_user_permitgroup(permit_group_id,permit_group_name,permit_item_name,permit_item_value) " +
            "values(#{permit_group_id},#{permit_group_name},#{permit_item_name},#{permit_item_value})")
    public int addPro(User_permitgroup obj);
    
    //5.2编辑(修改权限值)
    @Update("update db_user.tb_user_permitgroup set permit_item_value=#{permit_item_value} where num=#{num}")
    public boolean update(User_permitgroup obj);
 
    //5.2编辑(修改权限值)
    public boolean updatePro(Object obj);
 
    //5.2重命名(修改权限名)
    @Update("update db_user.tb_user_permitgroup set permit_group_name=#{permit_group_name} where permit_group_id=#{permit_group_id}")
    public int updateName(Object obj);
 
    //5.2删除(删除所有该权限组)
    @Delete("delete from db_user.tb_user_permitgroup where tb_user_permitgroup.permit_group_id=#{permit_group_id}")
    public int del(User_permitgroup obj) ;
 
    //5.1根据uid查权限
    @Select("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=#{uId}")
    public List<User_permitgroup> serchByCondition(User_inf obj);
 
    //5.2查所有的权限id和权限名称
    @Select("select distinct(permit_group_id),permit_group_name from db_user.tb_user_permitgroup")
    public List<User_permitgroup> searchAll() ;
    
    
    //5.2根据权限id查用户
    @Select("select distinct(uname),tb_user_inf.uid,tb_user_permitgroup_data.num as uBaojiusr 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=#{permit_group_id}")
    public List<User_inf> serchByPermit(User_permitgroup obj);
    
    //5.2根据权限组id查对应的所有权限
    @Select("select num,permit_group_id,permit_group_name,permit_item_name,permit_item_value from db_user.tb_user_permitgroup " +
            "where permit_group_id=#{permit_group_id} order by permit_group_id")
    public List<User_permitgroup> serchByInfo(User_permitgroup obj) ;
    
    //5.2查所有具体的权限
    @Select("select distinct(permit_item_name) from db_user.tb_user_permitgroup ")
    public List<String> serchRole();
 
    //5.2查最大的权限Id
    public List serchMaxRoleId();
    
    //5.2根据用户id查对应的权限值为1的所有权限
    public List serchItem(Object obj);
 
    /*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);
    }*/
}