权限管理——by SmallQian（不得用于商业用途）
(二)权限管理
1）需求分析确定数据库实体类
2）在bean中建立数据库实体类
User（用户类）、RoleAndMenu（角色菜单类）、UserRole（角色类）、WebMenu（菜单功能类）
1、User（用户类）
package cn.qiwei.bean;
import javax.persistence.Column; import javax.persistence.Entity;
import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.Table;
import javax.persistence.UniqueConstraint;
@Entity
@Table(name = \ , catalog = \ , uniqueConstraints = @UniqueConstraint(columnNames = \)) publicclass User {
private Integer userId;
版权所属——QQW.NULL
权限管理——by SmallQian（不得用于商业用途）
}
private String userName; private String password; private String roleName; @Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
@Column(name = \,unique=true,nullable = false ) public Integer getUserId() { returnuserId; }
publicvoid setUserId(Integer userId) { this.userId = userId; }
@Column(name = \) public String getUserName() { returnuserName; }
publicvoid setUserName(String userName) { this.userName = userName; }
@Column(name = \) public String getPassword() { returnpassword; }
publicvoid setPassword(String password) { this.password = password; }
@Column(name = \) public String getRoleName() { returnroleName; }
publicvoid setRoleName(String roleName) { this.roleName = roleName; }
版权所属——QQW.NULL
权限管理——by SmallQian（不得用于商业用途）
2、RoleAndMenu（角色菜单类）
package cn.qiwei.bean;
import javax.persistence.Column; import javax.persistence.Entity;
import javax.persistence.GeneratedValue; importjavax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.Table;
import javax.persistence.UniqueConstraint;
@Entity
@Table(name = \ , catalog = \ ,
uniqueConstraints = @UniqueConstraint(columnNames = \)) publicclass RoleAndMenu {
private Integer roleAndMenuId; private String roleName; //角色名 private String webMenuName;//菜单名
private String menuItemArray;//子菜单数组 private Integer menuLevel;//菜单级数 @Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
@Column(name = \,unique=true,nullable = false ) public Integer getRoleAndMenuId() { returnroleAndMenuId; }
publicvoid setRoleAndMenuId(Integer roleAndMenuId) { this.roleAndMenuId = roleAndMenuId; }
@Column(name = \) public String getRoleName() { returnroleName; }
publicvoid setRoleName(String roleName) { this.roleName = roleName; }
@Column(name = \) public String getWebMenuName() { returnwebMenuName;
版权所属——QQW.NULL
权限管理——by SmallQian（不得用于商业用途）
}
}
publicvoid setWebMenuName(String webMenuName) { this.webMenuName = webMenuName; }
@Column(name = \) public String getMenuItemArray() { returnmenuItemArray; }
publicvoid setMenuItemArray(String menuItemArray) { this.menuItemArray = menuItemArray; }
@Column(name = \)
public Integer getMenuLevel() { returnmenuLevel; }
publicvoid setMenuLevel(Integer menuLevel) { this.menuLevel = menuLevel; }
3、UserRole（角色类）
package cn.qiwei.bean;
import javax.persistence.Column; import javax.persistence.Entity;
import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.Table;
import javax.persistence.UniqueConstraint;
@Entity
@Table(name = \ , catalog = \ , uniqueConstraints = @UniqueConstraint(columnNames = \)) publicclass UserRole {
private Integer roleId; private String roleName; private String roleInfo;
版权所属——QQW.NULL
权限管理——by SmallQian（不得用于商业用途）
}
@Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
@Column(name = \,unique=true,nullable = false ) public Integer getRoleId() { returnroleId; }
publicvoid setRoleId(Integer roleId) { this.roleId = roleId; }
@Column(name = \) public String getRoleName() { returnroleName; }
publicvoid setRoleName(String roleName) { this.roleName = roleName; }
@Column(name = \) public String getRoleInfo() { returnroleInfo; }
publicvoid setRoleInfo(String roleInfo) { this.roleInfo = roleInfo; }
4、WebMenu（菜单功能类）
package cn.qiwei.bean;
import javax.persistence.Column; import javax.persistence.Entity;
import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.Table;
import javax.persistence.UniqueConstraint;
@Entity
@Table(name = \ , catalog = \ , uniqueConstraints
版权所属——QQW.NULL