网上书城（权限管理）

分析

就是传入id in (…);
1、通过当前用户的账号获取角色类别
String sql2 = “select * from t_easyui_role_permission where rid = ?”;
上面就获取到了pid的集合
2、给sql1做拼接id in (pids);//pids是通过pid的集合拼成的“，”分割的字符串

实现代码

权限实体类

package com.luojun.entity;


public class Permission {
   
    private long id;
    private String name;
    private String description;
    private String url;
    private long pid;
    private int ismenu;
    private long displayno;
	public long getId() {
   
		return id;
	}
	public void setId(long id) {
   
		this.id = id;
	}
	public String getName() {
   
		return name;
	}
	public void setName(String name) {
   
		this.name = name;
	}
	public String getDescription() {
   
		return description;
	}
	public void setDescription(String description) {
   
		this.description = description;
	}
	public String getUrl() {
   
		return url;
	}
	public void setUrl(String url) {
   
		this.url = url;
	}
	public long getPid() {
   
		return pid;
	}
	public void setPid(long pid) {
   
		this.pid = pid;
	}
	public int getIsmenu() {
   
		return ismenu;
	}
	public void setIsmenu(int ismenu) {
   
		this.ismenu = ismenu;
	}
	public long getDisplayno() {
   
		return displayno;
	}
	public void setDisplayno(long displayno) {
   
		this.displayno = displayno;
	}
	@Override
	public String toString() {
   
		return "Permission [id=" + id + ", name=" + name + ", description=" + description + ", url=" + url + ", pid="
				+ pid +