Пытаюсь разобраться с Hibernate, подскажите как правильно сжоинить две таблицы, не могу разобраться в этой теме.
Есть две таблицы:
projects
SQL |
1
2
3
4
5
6
7
8
9
10
| CREATE TABLE `projects` (
`id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
`id_categories` TEXT NOT NULL,
`name` TEXT NOT NULL,
`description` TEXT,
`detail_description` TEXT,
`history` TEXT,
`dateStart` DATE,
`amount` INTEGER
); |
|
и
cost_projects_has_users
SQL |
1
2
3
4
5
6
7
8
9
| CREATE TABLE `cost_projects_has_users` (
`id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
`users_id` INTEGER NOT NULL,
`amount` INTEGER NOT NULL,
`date_invest` INTEGER NOT NULL,
`exist` INTEGER NOT NULL,
`projects_id` INTEGER NOT NULL,
`exist_id` INTEGER
); |
|
Доменные модели:
Java |
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
| package nikfisher.kickstarter.domain;
import javax.persistence.*;
@Entity
@Table(name = "cost_projects_has_users")
public class Exist {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "id")
private int id;
@Column(name = "users_id")
private String users_id;
@Column(name = "exist")
private String exist;
@Column(name = "date_invest")
private String date_invest;
@Column(name = "projects_id")
private String projects_id;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUsers_id() {
return users_id;
}
public void setUsers_id(String users_id) {
this.users_id = users_id;
}
public String getExist() {
return exist;
}
public void setExist(String exist) {
this.exist = exist;
}
public String getDate_invest() {
return date_invest;
}
public void setDate_invest(String date_invest) {
this.date_invest = date_invest;
}
public String getProjects_id() {
return projects_id;
}
public void setProjects_id(String projects_id) {
this.projects_id = projects_id;
}
} |
|
и
Java |
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
| package nikfisher.kickstarter.domain;
import javax.persistence.*;
import java.util.List;
@Entity
@Table(name = "projects")
public class Projects {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "id")
private int id;
@Column(name = "id_categories")
private String id_categories;
@Column(name = "name")
private String name;
@Column(name = "description")
private String description;
@Column(name = "detail_description")
private String detail_description;
@Column(name = "dateStart")
private String dateStart;
@Column(name = "amount")
private String amount;
@OneToOne(cascade=CascadeType.ALL)
@JoinTable(name="cost_projects_has_users",
joinColumns={@JoinColumn(name="projects_id", referencedColumnName="id")})
private Exist exist;
public String getAmount() {
return amount;
}
public void setAmount(String amount) {
this.amount = amount;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getId_categories() {
return id_categories;
}
public void setId_categories(String id_categories) {
this.id_categories = id_categories;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getDescription() {
return description;
}
public void setDescription(String description) {
this.description = description;
}
public String getDetail_description() {
return detail_description;
}
public void setDetail_description(String detail_description) {
this.detail_description = detail_description;
}
public String getDateStart() {
return dateStart;
}
public void setDateStart(String dateStart) {
this.dateStart = dateStart;
}
public Exist getExist() {
return exist;
}
public void setExist(Exist exist) {
this.exist = exist;
}
} |
|
Пытаюсь сделать следующее:
Java |
1
2
3
4
| @OneToOne(cascade=CascadeType.ALL)
@JoinTable(name="cost_projects_has_users",
joinColumns={@JoinColumn(name="projects_id", referencedColumnName="id")})
private Exist exist; |
|
А потом вывести данные:
Java |
1
2
3
4
5
6
7
8
| <%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<c:forEach items="${projects}" var="project" varStatus="loop">
<c:out value="${project.description}"/> <%-- Выводиться --%>
<c:out value="${project.exist}"/> <%-- Не выводиться --%>
</c:forEach> |
|
И никаких ошибок или исключений.