Spring+Struts2+ExtJs權(quán)限管理的設(shè)計（一）數(shù)據(jù)庫的設(shè)計

1、本系統(tǒng)的后臺使用MySQL數(shù)據(jù)庫，SSH 框架，前端使用ExtJs實現(xiàn)。因為系統(tǒng)需要用到權(quán)限管理，所以作此記錄，權(quán)限管理精確到前端的每一個按鈕，甚至每一個action請求。

成都創(chuàng)新互聯(lián)，為您提供成都網(wǎng)站建設(shè)、網(wǎng)站制作、網(wǎng)站營銷推廣、網(wǎng)站開發(fā)設(shè)計，對服務(wù)成都樓梯護欄等多個行業(yè)擁有豐富的網(wǎng)站建設(shè)及推廣經(jīng)驗。成都創(chuàng)新互聯(lián)網(wǎng)站建設(shè)公司成立于2013年,提供專業(yè)網(wǎng)站制作報價服務(wù),我們深知市場的競爭激烈，認(rèn)真對待每位客戶，為客戶提供賞心悅目的作品。與客戶共同發(fā)展進步，是我們永遠(yuǎn)的責(zé)任！

廢話不多說，直接進入主題

（一）、數(shù)據(jù)庫的設(shè)計

權(quán)限管理部分總共包括4個數(shù)據(jù)表：

Power（記錄權(quán)限）、 Role（記錄角色）、 PowerRole（中間表）、 PowerUrl（記錄每一個action請求或者前端按鈕）

（Role表）

package com.txb.model;

import java.util.Set;

import javax.persistence.CascadeType;

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.FetchType;

import javax.persistence.GeneratedValue;

import javax.persistence.GenerationType;

import javax.persistence.Id;

import javax.persistence.OneToMany;

import javax.persistence.Table;

@Entity

@Table(name="TB_ROLE")

public class Role {

private int roleId;

private String roleName;

private Set<RolePower> rolePowers;

private Set<AdminRole> adminRoles;

@Id

@Column(name = "ROLE_ID", insertable = false, updatable = false, nullable = false, unique = true)

@GeneratedValue(strategy=GenerationType.AUTO)

public int getroleId() {

return roleId;

}

public void setroleId(int roleId) {

this.roleId = roleId;

}

@Column(name = "role_NAME", nullable = false, length = 50)

public String getroleName() {

return roleName;

}

public void setroleName(String roleName) {

this.roleName = roleName;

}

@OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY, mappedBy = "role")

public Set<RolePower> getrolePowers() {

return rolePowers;

}

public void setrolePowers(Set<RolePower> rolePowers) {

this.rolePowers = rolePowers;

}

@OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY, mappedBy = "role")

public Set<AdminRole> getAdminroles() {

return adminRoles;

}

public void setAdminroles(Set<AdminRole> adminRoles) {

this.adminRoles = adminRoles;

}

（Power表）

package com.txb.model;

import java.util.Set;

import javax.persistence.CascadeType;

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.FetchType;

import javax.persistence.GeneratedValue;

import javax.persistence.GenerationType;

import javax.persistence.Id;

import javax.persistence.OneToMany;

import javax.persistence.Table;

@Entity

@Table(name="TB_POWER")

public class Power {

private int powerId;

private String powerName;

private String powerType;

private String menu; //菜單

private Set<RolePower> rolePowers;

private Set<ActionUrl> actionUrls; //用戶角色

@Id

@Column(name = "POWER_ID", insertable = false, updatable = false, nullable = false, unique = true)

@GeneratedValue(strategy=GenerationType.AUTO)

public int getPowerId() {

return powerId;

}

public void setPowerId(int powerId) {

this.powerId = powerId;

}

@Column(name="POWER_NAME", nullable = false, length = 50)

public String getPowerName() {

return powerName;

}

public void setPowerName(String powerName) {

this.powerName = powerName;

}

@OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY, mappedBy = "power")

public Set<RolePower> getRolePowers() {

return rolePowers;

}

public void setRolePowers(Set<RolePower> rolePowers) {

this.rolePowers = rolePowers;

}

@OneToMany(cascade = CascadeType.ALL, fetch = FetchType.EAGER, mappedBy = "power")

public Set<ActionUrl> getActionUrls() {

return actionUrls;

}

public void setActionUrls(Set<ActionUrl> actionUrls) {

this.actionUrls = actionUrls;

}

@Column(name="POWER_TYPE", nullable = false, length = 10)

public String getPowerType() {

return powerType;

}

public void setPowerType(String powerType) {

this.powerType = powerType;

}

@Column(name="POWER_MENU", nullable = true, length = 10)

public String getMenu() {

return menu;

}

public void setMenu(String menu) {

this.menu = menu;

}

（Role - Power 中間表，因為他們是多對多的關(guān)系）

package com.txb.model;

import java.io.Serializable;

import javax.persistence.*;

/**

* The persistent class for the rose_power database table.

@Entity

@Table(name="TB_ROLE_POWER")

public class RolePower implements Serializable {

private int rpid;

private Power power;

private Role role;

public RolePower() {

}

@Id

@Column(name = "RP_ID", insertable = false, updatable = false, nullable = false, unique = true)

@GeneratedValue(strategy=GenerationType.AUTO)

public int getRpid() {

return this.rpid;

}

public void setRpid(int rpid) {

this.rpid = rpid;

}

@ManyToOne

@JoinColumn(name="POWER_ID")

public Power getPower() {

return this.power;

}

public void setPower(Power power) {

this.power = power;

}

@ManyToOne

@JoinColumn(name="ROLE_ID")

public Role getRole() {

return role;

}

public void setRole(Role role) {

this.role = role;

}

（PowerUrl 表，這個表是用來記錄每一個action請求，判斷該用戶所擁有的權(quán)限是否能執(zhí)行對應(yīng)的action請求）

package com.txb.model;

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.GeneratedValue;

import javax.persistence.GenerationType;

import javax.persistence.Id;

import javax.persistence.JoinColumn;

import javax.persistence.ManyToOne;

import javax.persistence.Table;

@Entity

@Table(name="TB_ACTION_URL")

public class ActionUrl {

private Power power;

private String url;

private String actionName;

private int aId;

@ManyToOne

@JoinColumn(name="POWER_ID")

public Power getPower() {

return power;

}

public void setPower(Power power) {

this.power = power;

}

@Column(name="URL", nullable = false, length = 50)

public String getUrl() {

return url;

}

public void setUrl(String url) {

this.url = url;

}

@Column(name="ACTION_NAME", nullable = false, length = 50)

public String getActionName() {

return actionName;

}

public void setActionName(String actionName) {

this.actionName = actionName;

}

@Id

@Column(name = "A_ID", insertable = false, updatable = false, nullable = false, unique = true)

@GeneratedValue(strategy=GenerationType.AUTO)

public int getaId() {

return aId;

}

public void setaId(int aId) {

this.aId = aId;

}

到此權(quán)限數(shù)據(jù)庫就已經(jīng)設(shè)計完畢，下一篇給大家介紹后臺邏輯部分

當(dāng)前標(biāo)題：Spring+Struts2+ExtJs權(quán)限管理的設(shè)計（一）數(shù)據(jù)庫的設(shè)計
網(wǎng)站網(wǎng)址：http://bm7419.com/article38/psdppp.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供、網(wǎng)站策劃、網(wǎng)頁設(shè)計公司、做網(wǎng)站、ChatGPT、靜態(tài)網(wǎng)站

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源：創(chuàng)新互聯(lián)

猜你還喜歡下面的內(nèi)容