JavaWeb7.23(六)

问题：

四表连查 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类