• mybatis中的一对多和多对一


    因为一对多和多对一是相互使用的,只是站的角度不同,因此只看类的属性

    public class User {
        private int user_id;
        private String user_name;
        private String user_gender;
        private String user_email;
        private String user_phone;
        private String user_address;
        private Date user_birthday;
        private int department_id;
    
        //一对多,1个用户可能有多个角色。
        private List<Role> roles;
    
        //多对一,1个部门多个员工
        private Department department;
    
        public User() {
            super();
        }
    
        public User(String user_name, String user_gender,
                String user_email, String user_phone, String user_address,
                Date user_birthday, int department_id) {
            super();
            this.user_name = user_name;
            this.user_gender = user_gender;
            this.user_email = user_email;
            this.user_phone = user_phone;
            this.user_address = user_address;
            this.user_birthday = user_birthday;
            this.department_id = department_id;
        }
    
        public int getUser_id() {
            return user_id;
        }
    
        public void setUser_id(int user_id) {
            this.user_id = user_id;
        }
    
        public String getUser_name() {
            return user_name;
        }
    
        public void setUser_name(String user_name) {
            this.user_name = user_name;
        }
    
        public String getUser_gender() {
            return user_gender;
        }
    
        public void setUser_gender(String user_gender) {
            this.user_gender = user_gender;
        }
    
        public String getUser_email() {
            return user_email;
        }
    
        public void setUser_email(String user_email) {
            this.user_email = user_email;
        }
    
        public String getUser_phone() {
            return user_phone;
        }
    
        public void setUser_phone(String user_phone) {
            this.user_phone = user_phone;
        }
    
        public String getUser_address() {
            return user_address;
        }
    
        public void setUser_address(String user_address) {
            this.user_address = user_address;
        }
    
        public Date getUser_birthday() {
            return user_birthday;
        }
    
        public void setUser_birthday(Date user_birthday) {
            this.user_birthday = user_birthday;
        }
    
        public int getDepartment_id() {
            return department_id;
        }
    
        public void setDepartment_id(int department_id) {
            this.department_id = department_id;
        }
    
        public Department getDepartment() {
            return department;
        }
    
        public void setDepartment(Department department) {
            this.department = department;
        }
    
        public List<Role> getRoles() {
            return roles;
        }
    
        public void setRoles(List<Role> roles) {
            this.roles = roles;
        }
    
        @Override
        public String toString() {
            return "User [user_id=" + user_id + ", user_name=" + user_name
                    + ", user_gender=" + user_gender + ", user_email=" + user_email
                    + ", user_phone=" + user_phone + ", user_address="
                    + user_address + ", user_birthday=" + user_birthday
                    + ", department_id=" + department_id + ", roles=" + roles
                    + ", department=" + department + "]
    ";
        }
    }

    集合的使用

     <collection property="roles" ofType="employee_management.entity.Role">
         <id property="role_id" column="role_id" javaType="java.lang.Integer" />
         <result property="role_name" column="role_name" javaType="java.lang.String" />
     </collection>
    

    对象的使用

     <!-- property是user实体类中department类属性的名字
                多个user对应1个department-->
     <association property="department" javaType="employee_management.entity.Department">
       <id property="department_id" column="department_id" javaType="java.lang.Integer" />
       <result property="department_name" column="department_nam javaType="java.lang.String" />
     </association>
     
    小蘑菇
  • 相关阅读:
    python --函数
    Python基本数据类型
    初识python
    【 D3.js 高级系列 — 8.0 】 标线
    【 D3.js 高级系列 — 7.0 】 标注地点
    Azure SQL 数据库最新版本现已提供预览版
    Azure SQL 数据库新服务级别现已正式发布
    聚焦 SQL 数据库活动异地复制
    Azure SQL 数据库:服务级别与性能问答
    Azure SQL 数据库:新服务级别问答
  • 原文地址:https://www.cnblogs.com/wang66a/p/12069297.html
Copyright © 2020-2023  润新知