问题:
四表连查 user role menu funs role_menu
1. 类与类之间的关系。
2.表与表之间的关系。
3.要求使用maven构建项目,使用mybatis通过username来进行查询,上传运行结果。
一:表字段与数据。
user表
role表
menu表
funs表
role_menu表
二:问题解答。
表与表之间的关系:
1.user表和role表中。
user对role是多对一的关系
role对user是一对多的关系
2.menu表和funs表中。
funs对menu是多对一的关系。
menu对funs是一对多的关系。
3.role_menu表中。
role与menu是多对多的关系。
类与类之间的关系:
1.user表和role表中。
user类:因为user对role是多对一的关系,user中存有role的属性,也就是user类中包含了role类的对象的引用。
role类:因为role对user是一对多的关系,也就是role类中存在着user类的集合。
2.menu表和funs表中。
funs类:因为funs对menu是多对一的关系,funs中存有menu的属性,也就是funs类中包含了menu类的对象的引用。
menu类:因为menu对funs是一对多的关系,也就是menu类中存在着funs类的集合。
3.role_menu表中。
因为role和menu是多对多的关系,也就是它两相互包含各自的属性,role类和menu类中相互存在对方的集合。
三:代码呈现。
funs类
package com.openlab.pojo;
public class Funs {
/**
* This field was generated by MyBatis Generator.
* This field corresponds to the database column funs.funId
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
private Integer funid;
private Menu menu;
public Menu getMenu() {
return menu;
}
public void setMenu(Menu menu) {
this.menu = menu;
}
@Override
public String toString() {
return "Funs [funid=" + funid + ", menu=" + menu + ", funname=" + funname + ", funurl=" + funurl + ", menuid="
+ menuid + "]";
}
/**
* This field was generated by MyBatis Generator.
* This field corresponds to the database column funs.funName
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
private String funname;
/**
* This field was generated by MyBatis Generator.
* This field corresponds to the database column funs.funURL
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
private String funurl;
/**
* This field was generated by MyBatis Generator.
* This field corresponds to the database column funs.menuId
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
private Integer menuid;
/**
* This method was generated by MyBatis Generator.
* This method returns the value of the database column funs.funId
*
* @return the value of funs.funId
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
public Integer getFunid() {
return funid;
}
/**
* This method was generated by MyBatis Generator.
* This method sets the value of the database column funs.funId
*
* @param funid the value for funs.funId
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
public void setFunid(Integer funid) {
this.funid = funid;
}
/**
* This method was generated by MyBatis Generator.
* This method returns the value of the database column funs.funName
*
* @return the value of funs.funName
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
public String getFunname() {
return funname;
}
/**
* This method was generated by MyBatis Generator.
* This method sets the value of the database column funs.funName
*
* @param funname the value for funs.funName
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
public void setFunname(String funname) {
this.funname = funname;
}
/**
* This method was generated by MyBatis Generator.
* This method returns the value of the database column funs.funURL
*
* @return the value of funs.funURL
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
public String getFunurl() {
return funurl;
}
/**
* This method was generated by MyBatis Generator.
* This method sets the value of the database column funs.funURL
*
* @param funurl the value for funs.funURL
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
public void setFunurl(String funurl) {
this.funurl = funurl;
}
/**
* This method was generated by MyBatis Generator.
* This method returns the value of the database column funs.menuId
*
* @return the value of funs.menuId
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
public Integer getMenuid() {
return menuid;
}
/**
* This method was generated by MyBatis Generator.
* This method sets the value of the database column funs.menuId
*
* @param menuid the value for funs.menuId
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
public void setMenuid(Integer menuid) {
this.menuid = menuid;
}
}
menu类
package com.openlab.pojo;
import java.util.List;
public class Menu {
/**
* This field was generated by MyBatis Generator.
* This field corresponds to the database column menu.menuId
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
private Integer menuid;
/**
* This field was generated by MyBatis Generator.
* This field corresponds to the database column menu.menuName
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
private String menuname;
/**
* This field was generated by MyBatis Generator.
* This field corresponds to the database column menu.menuURL
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
private String menuurl;
private List<Role> roles;
private List<Funs> funss;
public List<Funs> getFunss() {
return funss;
}
public void setFunss(List<Funs> funss) {
this.funss = funss;
}
public List<Role> getRoles() {
return roles;
}
public void setRoles(List<Role> roles) {
this.roles = roles;
}
@Override
public String toString() {
return "Menu [menuid=" + menuid + ", menuname=" + menuname + ", menuurl=" + menuurl + ", roles=" + roles
+ ", funss=" + funss + ", fatherid=" + fatherid + "]";
}
/**
* This field was generated by MyBatis Generator.
* This field corresponds to the database column menu.fatherId
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
private Integer fatherid;
/**
* This method was generated by MyBatis Generator.
* This method returns the value of the database column menu.menuId
*
* @return the value of menu.menuId
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
public Integer getMenuid() {
return menuid;
}
/**
* This method was generated by MyBatis Generator.
* This method sets the value of the database column menu.menuId
*
* @param menuid the value for menu.menuId
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
public void setMenuid(Integer menuid) {
this.menuid = menuid;
}
/**
* This method was generated by MyBatis Generator.
* This method returns the value of the database column menu.menuName
*
* @return the value of menu.menuName
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
public String getMenuname() {
return menuname;
}
/**
* This method was generated by MyBatis Generator.
* This method sets the value of the database column menu.menuName
*
* @param menuname the value for menu.menuName
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
public void setMenuname(String menuname) {
this.menuname = menuname;
}
/**
* This method was generated by MyBatis Generator.
* This method returns the value of the database column menu.menuURL
*
* @return the value of menu.menuURL
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
public String getMenuurl() {
return menuurl;
}
/**
* This method was generated by MyBatis Generator.
* This method sets the value of the database column menu.menuURL
*
* @param menuurl the value for menu.menuURL
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
public void setMenuurl(String menuurl) {
this.menuurl = menuurl;
}
/**
* This method was generated by MyBatis Generator.
* This method returns the value of the database column menu.fatherId
*
* @return the value of menu.fatherId
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
public Integer getFatherid() {
return fatherid;
}
/**
* This method was generated by MyBatis Generator.
* This method sets the value of the database column menu.fatherId
*
* @param fatherid the value for menu.fatherId
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
public void setFatherid(Integer fatherid) {
this.fatherid = fatherid;
}
}
user类
package com.openlab.pojo;
public class User {
/**
* This field was generated by MyBatis Generator.
* This field corresponds to the database column user.id
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
private String id;
private Role role;
public Role getRole() {
return role;
}
public void setRole(Role role) {
this.role = role;
}
@Override
public String toString() {
return "User [id=" + id + ", role=" + role + ", username=" + username + ", password=" + password + ", roleid="
+ roleid + ", iconurl=" + iconurl + "]";
}
/**
* This field was generated by MyBatis Generator.
* This field corresponds to the database column user.username
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
private String username;
/**
* This field was generated by MyBatis Generator.
* This field corresponds to the database column user.password
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
private String password;
/**
* This field was generated by MyBatis Generator.
* This field corresponds to the database column user.roleId
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
private Integer roleid;
/**
* This field was generated by MyBatis Generator.
* This field corresponds to the database column user.iconURL
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
private String iconurl;
/**
* This method was generated by MyBatis Generator.
* This method returns the value of the database column user.id
*
* @return the value of user.id
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
public String getId() {
return id;
}
/**
* This method was generated by MyBatis Generator.
* This method sets the value of the database column user.id
*
* @param id the value for user.id
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
public void setId(String id) {
this.id = id;
}
/**
* This method was generated by MyBatis Generator.
* This method returns the value of the database column user.username
*
* @return the value of user.username
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
public String getUsername() {
return username;
}
/**
* This method was generated by MyBatis Generator.
* This method sets the value of the database column user.username
*
* @param username the value for user.username
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
public void setUsername(String username) {
this.username = username;
}
/**
* This method was generated by MyBatis Generator.
* This method returns the value of the database column user.password
*
* @return the value of user.password
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
public String getPassword() {
return password;
}
/**
* This method was generated by MyBatis Generator.
* This method sets the value of the database column user.password
*
* @param password the value for user.password
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
public void setPassword(String password) {
this.password = password;
}
/**
* This method was generated by MyBatis Generator.
* This method returns the value of the database column user.roleId
*
* @return the value of user.roleId
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
public Integer getRoleid() {
return roleid;
}
/**
* This method was generated by MyBatis Generator.
* This method sets the value of the database column user.roleId
*
* @param roleid the value for user.roleId
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
public void setRoleid(Integer roleid) {
this.roleid = roleid;
}
/**
* This method was generated by MyBatis Generator.
* This method returns the value of the database column user.iconURL
*
* @return the value of user.iconURL
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
public String getIconurl() {
return iconurl;
}
/**
* This method was generated by MyBatis Generator.
* This method sets the value of the database column user.iconURL
*
* @param iconurl the value for user.iconURL
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
public void setIconurl(String iconurl) {
this.iconurl = iconurl;
}
}
role类
package com.openlab.pojo;
import java.util.List;
public class Role {
/**
* This field was generated by MyBatis Generator.
* This field corresponds to the database column role.roleId
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
private Integer roleid;
private List<Menu> menus ;
private List<User> users;
public List<User> getUsers() {
return users;
}
public void setUsers(List<User> users) {
this.users = users;
}
public List<Menu> getMenus() {
return menus;
}
public void setMenus(List<Menu> menus) {
this.menus = menus;
}
@Override
public String toString() {
return "Role [roleid=" + roleid + ", menus=" + menus + ", users=" + users + ", rolename=" + rolename + "]";
}
/**
* This field was generated by MyBatis Generator.
* This field corresponds to the database column role.roleName
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
private String rolename;
/**
* This method was generated by MyBatis Generator.
* This method returns the value of the database column role.roleId
*
* @return the value of role.roleId
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
public Integer getRoleid() {
return roleid;
}
/**
* This method was generated by MyBatis Generator.
* This method sets the value of the database column role.roleId
*
* @param roleid the value for role.roleId
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
public void setRoleid(Integer roleid) {
this.roleid = roleid;
}
/**
* This method was generated by MyBatis Generator.
* This method returns the value of the database column role.roleName
*
* @return the value of role.roleName
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
public String getRolename() {
return rolename;
}
/**
* This method was generated by MyBatis Generator.
* This method sets the value of the database column role.roleName
*
* @param rolename the value for role.roleName
*
* @mbggenerated Wed Jul 29 23:23:52 CST 2020
*/
public void setRolename(String rolename) {
this.rolename = rolename;
}
}
test类