一对多和多对多

最新推荐文章于 2023-11-17 15:26:00 发布
最新推荐文章于 2023-11-17 15:26:00 发布
阅读量146 收藏
点赞数
文章标签： 人工智能
原文链接：http://www.cnblogs.com/JAYIT/p/6198183.html
版权

一个组织拥有多个用户，一个组织有多个角色，一个角色有多个组织

package com.eshore.ismp.permission.model;

import java.io.Serializable;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashSet;
import java.util.List;
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.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.ManyToMany;
import javax.persistence.OneToMany;
import javax.persistence.Table;
import javax.persistence.Transient;

@Entity
@SuppressWarnings("serial")
@Table(name="SYS_ORGANIZATION")
public class SysOrganization implements Serializable{
	private Long id;
	private String nodeId;
	private int state;
	private String name;
	private String description;
	private String phone;
	private String email;
	private Date createTime;
	private Date updateTime;
	
	private List<Long> roleIds = new ArrayList<Long>();
	
	private Set<SysRole> roles = new HashSet<SysRole>(0);
	private Set<SysUserB> users = new HashSet<SysUserB>(0);
	
	@Id
	@GeneratedValue(strategy = GenerationType.AUTO)
	@Column(name = "id", unique = true, nullable = false, length = 32)
	public Long getId() {
		return id;
	}
	public void setId(Long id) {
		this.id = id;
	}
	
	@Column(name="node_id")
	public String getNodeId() {
		return nodeId;
	}
	public void setNodeId(String nodeId) {
		this.nodeId = nodeId;
	}
	
	@Column(name="state")
	public int getState() {
		return state;
	}
	public void setState(int state) {
		this.state = state;
	}
	@Column(name="name")
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	
	@Column(name="description")
	public String getDescription() {
		return description;
	}
	public void setDescription(String description) {
		this.description = description;
	}
	
	@Column(name="phone")
	public String getPhone() {
		return phone;
	}
	public void setPhone(String phone) {
		this.phone = phone;
	}
	@Column(name="email")
	public String getEmail() {
		return email;
	}
	public void setEmail(String email) {
		this.email = email;
	}
	@Column(name="create_time")
	public Date getCreateTime() {
		return createTime;
	}
	public void setCreateTime(Date createTime) {
		this.createTime = createTime;
	}
	@Column(name="update_time")
	public Date getUpdateTime() {
		return updateTime;
	}
	public void setUpdateTime(Date updateTime) {
		this.updateTime = updateTime;
	}
	@ManyToMany(fetch = FetchType.LAZY)
	@JoinTable(name = "SYS_ORGANIZATION_ROLE", schema = "", joinColumns = { @JoinColumn(name = "organization_id", nullable = false, updatable = false) }, 
　　　　　　　　　　　inverseJoinColumns = { @JoinColumn(name = "role_id", nullable = false, updatable = false) })
	public Set<SysRole> getRoles() {
		return roles;
	}
	public void setRoles(Set<SysRole> roles) {
		this.roles = roles;
	}
	
	@OneToMany(fetch = FetchType.LAZY, mappedBy = "organization", cascade = CascadeType.ALL)
	public Set<SysUserB> getUsers() {
		return users;
	}
	public void setUsers(Set<SysUserB> users) {
		this.users = users;
	}
	
	@Transient
	public List<Long> getRoleIds() {
		return roleIds;
	}
	public void setRoleIds(List<Long> roleIds) {
		this.roleIds = roleIds;
	}
	
	
	
}

USER

package com.model;

import java.io.Serializable;
import java.util.Date;
import java.util.HashSet;
import java.util.Set;

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.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.ManyToMany;
import javax.persistence.ManyToOne;
import javax.persistence.Table;
import javax.persistence.Transient;

@Entity
@SuppressWarnings("serial")
@Table(name="SYS_USER")
public class SysUser implements Serializable{
	private Long id; //ID
	private String loginName; //登录名
	private String name; //名称
	private String password; //密码
	private Long nodeId;//节点
	private SysOrganization organization; // 所属组织
	private String phone; //电话
	private String mobilePhone; //手机
	private String email; //邮箱
	private String description; //描述
	private String creatorId; //创建人
	private Date createTime; // 创建时间
	private Date updateTime; //更新时间
	private Set<String> roleIds; // 角色ID
	
	private int type; // 类型  0 ismp-b ,1 ismp-hb,2 ismp-yh
	private String roleIdS; //角色ID
	private String orgName; //组织名
	private String nodeName; //节点名
	private Set<SysRole> roles = new HashSet<SysRole>(0); // 角色ID
	
	private Long orgId;//组织ID
	
	
	@Id
	@GeneratedValue(strategy = GenerationType.AUTO)
	@Column(name = "id", unique = true, nullable = false, length = 32)
	public Long getId() {
		return id;
	}
	
	public void setId(Long id) {
		this.id = id;
	}
	
	@Column(name="name")
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	
	@Column(name="type")
	public int getType() {
		return type;
	}
	public void setType(int type) {
		this.type = type;
	}
	
	@Column(name = "description", unique = false, nullable = true, insertable = true, updatable = true, length = 255)
	public String getDescription() {
		return description;
	}
	public void setDescription(String description) {
		this.description = description;
	}
	@Column(name = "node_id", unique = false, nullable = true, insertable = true, updatable = true)
	public Long getNodeId() {
		return nodeId;
	}
	public void setNodeId(Long nodeId) {
		this.nodeId = nodeId;
	}
	@Column(name = "create_id", unique = false, nullable = true, insertable = true, updatable = true, length = 20)
	public String getCreatorId() {
		return creatorId;
	}
	public void setCreatorId(String creatorId) {
		this.creatorId = creatorId;
	}
	@Column(name = "password", unique = false, nullable = true, insertable = true, updatable = true, length = 255)
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	
	@ManyToOne(fetch = FetchType.LAZY)
	@JoinColumn(name = "organization_id")
	public SysOrganization getOrganization() {
		return organization;
	}
	public void setOrganization(SysOrganization organization) {
		this.organization = organization;
	}
	@Column(name = "phone", unique = false, nullable = true, insertable = true, updatable = true, length = 20)
	public String getPhone() {
		return phone;
	}
	public void setPhone(String phone) {
		this.phone = phone;
	}
	@Column(name = "mobile_phone", unique = false, nullable = true, insertable = true, updatable = true, length = 20)
	public String getMobilePhone() {
		return mobilePhone;
	}
	public void setMobilePhone(String mobilePhone) {
		this.mobilePhone = mobilePhone;
	}
	@Column(name = "email", unique = false, nullable = true, insertable = true, updatable = true, length = 60)
	public String getEmail() {
		return email;
	}
	public void setEmail(String email) {
		this.email = email;
	}
	
	@Column(name = "login_name", unique = false, nullable = true, insertable = true, updatable = true)
	public String getLoginName() {
		return loginName;
	}
	public void setLoginName(String loginName) {
		this.loginName = loginName;
	}
	
	@Column(name = "create_time", unique = false, nullable = true, insertable = true, updatable = true)
	public Date getCreateTime() {
		return createTime;
	}
	public void setCreateTime(Date createTime) {
		this.createTime = createTime;
	}
	
	@Column(name = "update_time", unique = false, nullable = true, insertable = true, updatable = true)
	public Date getUpdateTime() {
		return updateTime;
	}
	
	public void setUpdateTime(Date updateTime) {
		this.updateTime = updateTime;
	}
	
	
	@Transient
	public Set<String> getRoleIds() {
		return roleIds;
	}
	public void setRoleIds(Set<String> roleIds) {
		this.roleIds = roleIds;
	}
	@Transient
	public String getRoleIdS() {
		return roleIdS;
	}
	public void setRoleIdS(String roleIdS) {
		this.roleIdS = roleIdS;
	}
	@Transient
	public String getOrgName() {
		
		if(organization!=null){
			return organization.getName();
		}
		return orgName;
	}
	public void setOrgName(String orgName) {
		this.orgName = orgName;
	}
	@Transient
	public String getNodeName() {
		return nodeName;
	}
	public void setNodeName(String nodeName) {
		this.nodeName = nodeName;
	}
	@ManyToMany(fetch = FetchType.LAZY)
	@JoinTable(name = "SYS_USER_ROLE", schema = "", joinColumns = { @JoinColumn(name = "user_id", nullable = false, updatable = false) }, inverseJoinColumns = { @JoinColumn(name = "role_id", nullable = false, updatable = false) })
	public Set<SysRole> getRoles() {
		return roles;
	}
	public void setRoles(Set<SysRole> roles) {
		this.roles = roles;
	}
	
	
	@Transient
	public Long getOrgId() {
		return orgId;
	}
	public void setOrgId(Long orgId) {
		this.orgId = orgId;
	}
	@Override
	public String toString() {
		return "SysUser [loginName=" + loginName + ", createTime=" + createTime
				+ "]";
	}
	
}

 

SYSROLE

package com.model;

import java.io.Serializable;
import java.util.Date;
import java.util.HashSet;
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.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.ManyToMany;
import javax.persistence.OneToMany;
import javax.persistence.Table;
import javax.persistence.Transient;


@Entity
@SuppressWarnings("serial")
@Table(name="SYS_ROLE")
public class SysRole implements Serializable{
	private Long id; //ID
	private String name; //名称
	private int type;//类型 0 -B, 1-HB,2-YH
	
	private String createrName;//创建人
	
	private String description; //描述
	private Date createTime; //创建时间
	private Date updateTime; //更新时间
	
	private Long[] resourceIds;
	private Set<SysUserRole> userRoles = new HashSet<SysUserRole>(0);
//	private Set<SysUser> users = new HashSet<SysUser>(0); //关联用户
//	private Set<SysOrganization> organizations = new HashSet<SysOrganization>(0); //管理组织
	private Set<SysResource> resources = new HashSet<SysResource>(0); //管理权限
	
	@Id
	@GeneratedValue(strategy = GenerationType.AUTO)
	@Column(name = "id", unique = true, nullable = false, length = 32)
	public Long getId() {
		return id;
	}
	public void setId(Long id) {
		this.id = id;
	}
	
	@Column(name="name")
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	
	
	@Column(name="type")
	public int getType() {
		return type;
	}
	public void setType(int type) {
		this.type = type;
	}
	
	@Column(name="creater_name")
	public String getCreaterName() {
		return createrName;
	}
	public void setCreaterName(String createrName) {
		this.createrName = createrName;
	}
	@Column(name="description")
	public String getDescription() {
		return description;
	}
	public void setDescription(String description) {
		this.description = description;
	}
	
	
	@Column(name="create_time")
	public Date getCreateTime() {
		return createTime;
	}
	public void setCreateTime(Date createTime) {
		this.createTime = createTime;
	}
	@Column(name="update_time")
	public Date getUpdateTime() {
		return updateTime;
	}
	public void setUpdateTime(Date updateTime) {
		this.updateTime = updateTime;
	}
	
	
	
	/*
	@ManyToMany(fetch = FetchType.LAZY)
	@JoinTable(name = "SYS_USER_ROLE", schema = "", joinColumns = { @JoinColumn(name = "role_id", nullable = false, updatable = false) }, inverseJoinColumns = { @JoinColumn(name = "user_id", nullable = false, updatable = false) })
	public Set<SysUser> getUsers() {
		return users;
	}
	public void setUsers(Set<SysUser> users) {
		this.users = users;
	}
	*/
	
	@OneToMany(fetch = FetchType.LAZY)
	@JoinColumn(name="role_id",updatable = false)
    public Set<SysUserRole> getUserRoles() {
        return userRoles;
    }
	
    public void setUserRoles(Set<SysUserRole> userRoles) {
        this.userRoles = userRoles;
    }
    //	
//	@ManyToMany(mappedBy="roles",cascade = CascadeType.MERGE,fetch = FetchType.LAZY)
//	public Set<SysOrganization> getOrganizations() {
//		return organizations;
//	}
//	public void setOrganizations(Set<SysOrganization> organizations) {
//		this.organizations = organizations;
//	}
//	
	@ManyToMany(fetch = FetchType.LAZY)
	@JoinTable(name = "SYS_ROLE_RESOURCE", schema = "", joinColumns = { @JoinColumn(name = "role_id", nullable = false, updatable = false) }, inverseJoinColumns = { @JoinColumn(name = "resource_id", nullable = false, updatable = false) })
	public Set<SysResource> getResources() {
		return resources;
	}
	public void setResources(Set<SysResource> resources) {
		this.resources = resources;
	}
	
	@Transient
	public Long[] getResourceIds() {
		return resourceIds;
	}
	public void setResourceIds(Long[] resourceIds) {
		this.resourceIds = resourceIds;
	}
	
	
}

　　

SYSUSERB

package com.eshore.ismp.permission.model;

import java.util.Date;
import java.util.HashSet;
import java.util.Set;

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.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.ManyToMany;
import javax.persistence.ManyToOne;
import javax.persistence.Table;
import javax.persistence.Transient;


@Entity
@SuppressWarnings("serial")
@Table(name="SYS_USER_B")
public class SysUserB {
    private Long id; //ID
    private String loginName; //登录名
    private String password; //密码
    private String name; //姓名
    private String nodeId;//节点
    private SysOrganization organization; // 所属组织
    private String phone; //电话
    private String mobilePhone; //手机
    private String email; //邮箱
    private String description; //描述
    private int type; // 类型  0 ismp-b ,1 ismp-hb,2 ismp-yh
    private String creatorId; //创建人
    private Date createTime; // 创建时间
    private Date updateTime; //更新时间
    private Set<String> roleIds; // 角色ID
    private String roleIdS; //角色ID
    private String orgName; //组织名
    private String nodeName; //节点名


    private Set<SysRole> roles = new HashSet<SysRole>(0); // 角色ID

    private Integer adminType; //0-非管理员，1-管理员
    private Long orgId;//组织ID
    
    
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    @Column(name = "id", unique = true, nullable = false, length = 32)
    public Long getId() {
        return id;
    }
    
    public void setId(Long id) {
        this.id = id;
    }
    
    
    
    @Column(name = "description", unique = false, nullable = true, insertable = true, updatable = true, length = 255)
    public String getDescription() {
        return description;
    }
    public void setDescription(String description) {
        this.description = description;
    }
    
    
    @Column(name="type")
    public int getType() {
        return type;
    }

    public void setType(int type) {
        this.type = type;
    }
    
    @Column(name="name")
    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    @Column(name = "node_id", unique = false, nullable = true, insertable = true, updatable = true)
    public String getNodeId() {
        return nodeId;
    }
    public void setNodeId(String nodeId) {
        this.nodeId = nodeId;
    }
    @Column(name = "create_id", unique = false, nullable = true, insertable = true, updatable = true, length = 20)
    public String getCreatorId() {
        return creatorId;
    }
    public void setCreatorId(String creatorId) {
        this.creatorId = creatorId;
    }
    @Column(name = "password", unique = false, nullable = true, insertable = true, updatable = true, length = 255)
    public String getPassword() {
        return password;
    }
    public void setPassword(String password) {
        this.password = password;
    }
    
    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "organization_id")
    public SysOrganization getOrganization() {
        return organization;
    }
    public void setOrganization(SysOrganization organization) {
        this.organization = organization;
    }
    @Column(name = "phone", unique = false, nullable = true, insertable = true, updatable = true, length = 20)
    public String getPhone() {
        return phone;
    }
    public void setPhone(String phone) {
        this.phone = phone;
    }
    @Column(name = "mobile_phone", unique = false, nullable = true, insertable = true, updatable = true, length = 20)
    public String getMobilePhone() {
        return mobilePhone;
    }
    public void setMobilePhone(String mobilePhone) {
        this.mobilePhone = mobilePhone;
    }
    @Column(name = "email", unique = false, nullable = true, insertable = true, updatable = true, length = 60)
    public String getEmail() {
        return email;
    }
    public void setEmail(String email) {
        this.email = email;
    }
    
    @Column(name = "login_name", unique = false, nullable = true, insertable = true, updatable = true)
    public String getLoginName() {
        return loginName;
    }
    public void setLoginName(String loginName) {
        this.loginName = loginName;
    }
    
    @Column(name = "create_time", unique = false, nullable = true, insertable = true, updatable = true)
    public Date getCreateTime() {
        return createTime;
    }
    public void setCreateTime(Date createTime) {
        this.createTime = createTime;
    }
    
    @Column(name = "update_time", unique = false, nullable = true, insertable = true, updatable = true)
    public Date getUpdateTime() {
        return updateTime;
    }
    
    public void setUpdateTime(Date updateTime) {
        this.updateTime = updateTime;
    }
    
    @Column(name = "admin_type")
    public Integer getAdminType() {
        return adminType;
    }

    public void setAdminType(Integer adminType) {
        this.adminType = adminType;
    }

    @Transient
    public Set<String> getRoleIds() {
        return roleIds;
    }
    public void setRoleIds(Set<String> roleIds) {
        this.roleIds = roleIds;
    }
    @Transient
    public String getRoleIdS() {
        return roleIdS;
    }
    public void setRoleIdS(String roleIdS) {
        this.roleIdS = roleIdS;
    }
    @Transient
    public String getOrgName() {
        
        if(organization!=null){
            return organization.getName();
        }
        return orgName;
    }
    public void setOrgName(String orgName) {
        this.orgName = orgName;
    }
    @Transient
    public String getNodeName() {
        return nodeName;
    }
    public void setNodeName(String nodeName) {
        this.nodeName = nodeName;
    }
    
    /*
    @ManyToMany(fetch = FetchType.LAZY)
    @JoinTable(name = "SYS_USER_ROLE", schema = "", joinColumns = { @JoinColumn(name = "user_id", nullable = false, updatable = false) }, inverseJoinColumns = { @JoinColumn(name = "role_id", nullable = false, updatable = false) })
    */
    @Transient
    public Set<SysRole> getRoles() {
        return roles;
    }
    public void setRoles(Set<SysRole> roles) {
        this.roles = roles;
    }
    
    
    
    @Transient
    public Long getOrgId() {
        return orgId;
    }
    public void setOrgId(Long orgId) {
        this.orgId = orgId;
    }
    
    @Override
    public String toString() {
        return "SysUser [loginName=" + loginName + ", createTime=" + createTime
                + "]";
    }
}

　　

转载于:https://www.cnblogs.com/JAYIT/p/6198183.html

weixin_30768661
关注
关联关系映射
hou_yi_tao的博客
10-23 341
1.将数据表导入数据库中 2.通过mybatis-generator插件生成dao、mapper、model 1）配置mybatis-generator插件生成文件位置 2）修改generatorConfig.xml配置文件的生成目录(mapper和model)及对应生成关系 generatorConfig.xml <?xml version="1.0" encoding="UTF-8" ?...
MySQL----表的一对多关系和多对多关系
weixin_47906895的博客
09-10 3059
MySQL----表的一对多关系和多对多关系 1.一对多关系 1.1名词解释： 一对多关系：通过主键外关系，形成一对多关系。 一表：又称之为主表，主表需要提供主键。 多表：又称之为从表，从表需提供外键。 1.2实例演示 一个分类拥有多个商品，这就是一对多关系。 1.3连接语法 alter table 从表 add constraint foreign key (外键) references 主表 (主键); 1.4一对多实践案例 在这里插入代码片 ...
多对一，一对多，多对多
Carl_Zhang
09-06 339
One-to-many 班级对于学生，如一个班可以有多名学生。 Many-to-one 学生对于班级，如一个学生只能属于一个班级。 Many-to-many 课程和学生的关系，就是多对多的关系。一名学生可以选择多门课程，一门课程也可以对应多名学生。 ...
一对多与多对多
weixin_45180770的博客
10-23 766
Mybatis关系映射之一对多 一对多 （订单对应多个订单项） 多对一 （订单项对应一个订单） 其是映射关系的基层思维是一样的，只是用法不一样，今天所记录的mybatis关系映射比Hibernate要简单 之前我记录一篇hibernate映射关系，可以移步（https://www.cnblogs.com/huangting/p/11203498.html） 今天就用订单表和订单项表来演示myba...
详解Mybatis一对多、多对一、多对多
热门推荐
菜鸟逆袭之路
05-07 2万+
Mybatis一对一、一对多、多对多
一对一，一对多，多对多三种关系简单理解
最新发布
weixin_44793582的博客
11-17 2480
一对一，一对多，多对多 这三种关系该怎么理解。
Hibernate 双向多对多&拆分成两个一对多
Jintao_Ma的博客
04-22 4664
纸上得来终觉浅 1.双向多对多：B（Teacher）有多个A（Student），A也有多个B 注意要在一方加上inverse属性，否则一起维护关联关系可能会造成主键冲突： package roadArchitectWeb; import java.util.HashSet; import java.util.Set; public class Teacher { private Int
关于laravel中表关系的一对一、一对多、多对一、多对多实践
weixin_38112233的博客
01-31 1万+
首先关于表与表之间的关系 1.一对多 2.一对多 3.多对一 4.多对多 区分父表与子表 1.”一”的是父表 2.”多”的一方是子表 如何处理一对多关系 在子表中建一个字段(外键)指向父表 如何处理多对多关系 建立一张中间表，将”多对多”关系转化为”一对多” 案例分析 表一: 用户表(it_user) 表二: 用户详情表(it_user_info) 表
Django数据库连表查询（一对一、一对多、多对多）
weixin_43796223的博客
03-18 5222
1、一对一关系 比如某班级学生表和学生详细信息表 两张表结构如下 class Student(models.Model): stu_id = models.AutoField(primary_key=True) stu_name = models.CharField(max_length=32) class Stud...
Django实现一对多表模型的跨表查询
盖世英雄
09-14 5746
当有两个表，例如一个学生表，一个班级表，是多对一的关系。方法1：c = models.Class.object.get(pk=1) #查询到ID为1的班级 stus = models.Student.object.filter(cls=c) # 查询出来所有班级为c的学生 #stus是多个对象 #可以循环出结果 for stu in stus : print stu.id,stu.name方
一对多关系和多对多关系的实现
weixin_30289831的博客
11-28 274
一对多关系和多对多关系的实现 先来实现一对多关系 什么是一对多关系呢？ 一对多是关系型数据中两个表之间的一种关系，该关系中第一个表中的单个行可以与第二个表中的一个或多个行相关，但第二个表中的一个行只可以与第一个表中的一个行相关。 [br]-----我是分割线------[br] 举例 帖子与用户之间的关系 现有两张表,帖子表(tab_topic)，用户表(tab_user)...
数据库一对一、一对多、多对多关系理解（转载）
qq_34376868的博客
02-26 1万+
版本一 一、首先给出三种关系的实例 1、一对一关系实例 * 一个人对应一张身份证，一张身份证对应一个人 2、一对多关系实例 * 一个班级拥有多个学生，一个学生只能够属于某个班级 3、多对多实例 * 一个学生可以选修多门课程，一个课程可以被多个学生选修 二、一对一关系 一对一关系是最好理解的一种关系，在数据库建表的时候可以将人表的主键放置与身份证表里面，也可以将身份证表的主...
一次关于多对多的场景的解决方案讨论
dainandainan1的博客
12-10 487
某对象属性存在三个属性都是数组类型，分别是数组A[],数组B[],和数组C[]。这三个属性互不相关。 第一种设计：将list变成String，以逗号分割，以sql中like关键字作为查询。 表结构设计： 属性A 属性B 属性C ,x,y, ,x,y, ,x,y,   第二种设计：采用笛卡尔集形式,将所有字段拆成单个属性.这种方式查询简单，但是表内数据量大 ...
什么是一对一、一对多、多对多？什么是E-R图及如何绘制E-R图？什么是关系模式及怎样把E-R图转换成关系模式
sxww_zyt的博客
03-17 1万+
什么是一对一、一对多、多对多？什么是E-R图？如何绘制E-R图
一对多和多对一
oos
07-21 311
1.ORM:对象与表作映射 2.表与表之间关系(主外键):一对一、一对多、多对一、多对多 3.类与类之间利用属性实现关系:一对一、一对多、多对一、多对多 class Person{ Car car=new Car();//一对一 List<Car> list=new ArrayList<Car>(); //一对多 } class Car{ Perso...
尚筹网：用户维护之权限---多对多怎么设计
OceanStar的博客
12-30 454
权限概述 权限概念 “权”：能做的事情 “限”：限制 对登录系统的用户进行操作、行为方面的限制，对项目中的功能进行保护，让没有权力访问的用户不能访问。 具体概念 资源 项目中被保护的功能就是资源。 资源可以体现为多种形式： URL地址 http://localhost:8080/oa/save/emp.html Java方法 AdminServiceImpl.saveAdmin() 页面元素 ...
一对多和多对一双向关联
麦田守望者
06-02 188
一个组有多个用户 一个用户只能属于一个组 在用户表里面有组的外键   Annotation配置： package com.zchen.hibernate.mtootm; import java.util.HashSet; import java.util.Set; import javax.persistence.Entity; import javax.persistenc...
一对多的三种方式和多对一
weixin_30588907的博客
09-23 274
<!-- 对象级联 --> <resultMap type="Emp" id="emplist1"> <id property="empno" column="EMPNO"/> <result property="ename" column="ENAME"/> <result ...
多对1，一对多
zhouquanshidai的博客
11-11 1859
复杂环境搭建 多个学生，对应一个老师。对于学生这边而言，关联多个学生[多对一] 对于老师而言，集合，一个老师，有很多学生[一对多] 创建mysql create table teacher( id int(10) not null auto_increment , name varchar(30) default null, primary key(id) )engine=innodb default charset=utf8; insert into teacher(id,n
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值