@Entity(name = "chat")
public class chat {
	@Id
	@GeneratedValue(strategy = GenerationType.IDENTITY)
	@Column(name = "id")
	int id;
	@Lob
	@Basic(fetch = FetchType.LAZY)
	@Column(name = "msg", columnDefinition = "Text")
	String msg;
	@Lob
	@Basic(fetch = FetchType.LAZY)
	@Column(name = "hfmsg", columnDefinition = "Text")
	String hfmsg;
	@Column(name = "savetime")
	String savetime;
	@OneToOne
	@JoinColumn(name = "uid")
	patient patient;
	public int getId() {
		return id;
	}
	public patient getPatient() {
		return patient;
	}
	public void setPatient(patient patient) {
		this.patient = patient;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getMsg() {
		return msg;
	}
	public void setMsg(String msg) {
		this.msg = msg;
	}
	public String getHfmsg() {
		return hfmsg;
	}
	public void setHfmsg(String hfmsg) {
		this.hfmsg = hfmsg;
	}
	public String getSavetime() {
		return savetime;
	}
	public void setSavetime(String savetime) {
		this.savetime = savetime;
	}
}

@Entity(name="patient")
public class patient {
		@Id
		@GeneratedValue(strategy=GenerationType.IDENTITY)
		@Column(name="id")
		int id;
		@Column(name="uname")
		String uname;
		@Column(name="upass")
		String upass;
		@Column(name="tname")
		String tname;
		@Column(name="sex")
		String sex;
		@Column(name="age")
		String age;
		@Column(name="idcard")
		String idcard;
		@Column(name="tel")
		String tel;
		@Column(name="addr")
		String addr;
		@Column(name="delstatus")
		String delstatus;
		public int getId() {
			return id;
		}
		public void setId(int id) {
			this.id = id;
		}
		public String getUname() {
			return uname;
		}
		public void setUname(String uname) {
			this.uname = uname;
		}
		public String getUpass() {
			return upass;
		}
		public void setUpass(String upass) {
			this.upass = upass;
		}
		public String getTname() {
			return tname;
		}
		public void setTname(String tname) {
			this.tname = tname;
		}
		public String getSex() {
			return sex;
		}
		public void setSex(String sex) {
			this.sex = sex;
		}
		public String getAge() {
			return age;
		}
		public void setAge(String age) {
			this.age = age;
		}
		public String getIdcard() {
			return idcard;
		}
		public void setIdcard(String idcard) {
			this.idcard = idcard;
		}
		public String getTel() {
			return tel;
		}
		public void setTel(String tel) {
			this.tel = tel;
		}
		public String getAddr() {
			return addr;
		}
		public void setAddr(String addr) {
			this.addr = addr;
		}
		public String getDelstatus() {
			return delstatus;
		}
		public void setDelstatus(String delstatus) {
			this.delstatus = delstatus;
		}		
}

@Entity
@Table(name = "person")
public class Person {
    @Id
    @Column(name = "id")
    private String id;
    @Column
    private String name;
    /**
     * 由person表持有addr_id，保存address表的id
     * referencedColumnName是指addr_id指定的address的映射字段，默認是id主鍵
     */
    @OneToOne
    @JoinColumn(name = "addr_id", referencedColumnName = "id")
    private Address address;
}

@Entity
@Table(name = "address")
public class Address {
    @Id
    @Column(name = "id")
    private String id;
    @Column
    private String addrName;
    /**
     *  一對一的被維系方，指定由Person實體類中的address屬性進行關系映射管理
     *  從而獲取Person數(shù)據(jù)
     */
    @OneToOne(mappedBy = "address")
    private Person person;
}

@Entity
@Table(name = "department")
public class Department {
    @Id
    @Column(name = "id")
    private String id;
    @Column
    private String deptName;
    /**
     * 單向一對多時，使用JoinColumn進行連接字段映射
     * 此時name為對方也就是Person表中的外鍵dept_id字段，
     * 而映射的referencedColumnName是本表的主鍵id字段
     */
    @OneToMany
    @JoinColumn(name = "dept_id", referencedColumnName = "id")
    private List<Person> peopleList;
}

@Entity
@Table(name = "person")
public class Person {
    @Id
    @Column(name = "id")
    private String id;
    @Column
    private String name;
    /**
     * 多對一關系，由多方維系關系
     * 通過person表的dept_id字段和department表的id主鍵字段做關系映射
     */
    @ManyToOne
    @JoinColumn(name = "dept_id")
    private Department department;
}

@Entity
@Table(name = "department")
public class Department {
    @Id
    @Column(name = "id")
    private String id;
    @Column
    private String deptName;
    /**
     * OneToMany和ManyToOne配合使用時，由ManyToOne多方進行關系管理
     * 此時只需要指定管理映射屬性，為Person中的department屬性
     */
    @OneToMany(mappedBy = "department")
    private List<Person> peopleList;
}

@Entity
@Table(name = "person")
public class Person {
    @Id
    @Column(name = "id")
    private String id;
    @Column
    private String name;
    /**
     * 多對多，通過JoinTable生成第三方表，指定各自主鍵的存放列名
     * joinColumns：將本表id，存儲到第三方表，列名為per_id
     * inverseJoinColumns：將對方表id，存儲到第三方表，列名為dept_id
     * 注意：此處存放到第三方表的列名，需要和對方的外鍵名稱相一致
     */
    @ManyToMany
    @JoinTable(
            name = "pro_dept",    // 自動生成的第三方表名，可省略
            joinColumns = @JoinColumn(name = "per_id"),       // 將本表id，存儲到第三方表，列名為per_id
            inverseJoinColumns = @JoinColumn(name = "dept_id")       // 將對方表id，存儲到第三方表，列名為dept_id
    )
    private List<Department> department;
}

@Entity
@Table(name = "department")
public class Department {
    @Id
    @Column(name = "id")
    private String id;
    @Column
    private String deptName;
    /**
     * 通過mappedBy表明由Person實體的department屬性進行關系管理
     */
    @ManyToMany(mappedBy = "department")
    private List<Person> personList;
}