Hibernateの最も基本的な例
36475 ワード
Spring , Hibernate
hibernate-distribution-3.5.3-Final\hibernate3.jar
hibernate-distribution-3.5.3-Final\lib\required\slf4j-api-1.5.8.jar
hibernate-distribution-3.5.3-Final\lib\required\slf4j-api-1.5.8.jar
hibernate-distribution-3.5.3-Final\lib\required\slf4j-api-1.5.8.jar
hibernate-distribution-3.5.3-Final\lib\required\slf4j-api-1.5.8.jar
hibernate-distribution-3.5.3-Final\lib\required\slf4j-api-1.5.8.jar
hibernate :hibernate-distribution-3.5.3-Final\project\tutorials\web\src\main\resources\hibernate.cfg.xml, SRC , ,
Xml
1. <span style="font-size: large;"><span style="font-size: large;"><?xml version="1.0" encoding="utf-8" ?>
2. <!DOCTYPE hibernate-configuration PUBLIC
3. "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
4. "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
5. <hibernate-configuration>
6. <session-factory>
7. <!-- -->
8. <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
9. <property name="connection.url">jdbc:mysql:///test</property>
10. <property name="connection.username">root</property>
11. <property name="connection.password">root</property>
12.
13. <!--JDBC -->
14. <property name="connection.pool_size">2</property>
15. <!-- -->
16. <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
17. <!-- Hibernate -->
18. <property name="current_session_context_class">org.hibernate.context.ManagedSessionContext</property>
19. <!-- -->
20. <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
21. <!-- SQL -->
22. <property name="show_sql">true</property>
23. <!-- SQL -->
24. <property name="hibernate.format_sql">true</property>
25.
26. <!--
27. , ,
28. <property name="hbm2ddl.auto">create</property>
29. -->
30. <!--
31. , ,
32. <property name="hbm2ddl.auto">create-drop</property>
33. -->
34. <!--
35. , , ,
36. ( , ; , ; , )
37. <property name="hbm2ddl.auto">update</property>
38. -->
39. <!--
40. , , ,
41. <property name="hbm2ddl.auto">validate</property>
42. -->
43. <!-- Drop and re-create the database schema on startup -->
44. <property name="hbm2ddl.auto">create</property>
45.
46. <!-- -->
47. <mapping resource="com/javacrazyer/domain/Student.hbm.xml"/>
48. </session-factory>
49. </hibernate-configuration></span></span>
<?xml version="1.0" encoding="utf-8" ?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<!-- -->
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.url">jdbc:mysql:///test</property>
<property name="connection.username">root</property>
<property name="connection.password">root</property>
<!--JDBC -->
<property name="connection.pool_size">2</property>
<!-- -->
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<!-- Hibernate -->
<property name="current_session_context_class">org.hibernate.context.ManagedSessionContext</property>
<!-- -->
<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
<!-- SQL -->
<property name="show_sql">true</property>
<!-- SQL -->
<property name="hibernate.format_sql">true</property>
<!--
, ,
<property name="hbm2ddl.auto">create</property>
-->
<!--
, ,
<property name="hbm2ddl.auto">create-drop</property>
-->
<!--
, , ,
( , ; , ; , )
<property name="hbm2ddl.auto">update</property>
-->
<!--
, , ,
<property name="hbm2ddl.auto">validate</property>
-->
<!-- Drop and re-create the database schema on startup -->
<property name="hbm2ddl.auto">create</property>
<!-- -->
<mapping resource="com/javacrazyer/domain/Student.hbm.xml"/>
</session-factory>
</hibernate-configuration>
, org.hibernate.dialect.MySQLDialect
Java
1. <span style="font-size: large;"><span style="font-size: large;">Unknown table 'system_sequences' in information_schema</span></span>
Unknown table 'system_sequences' in information_schema
, Student.java
Java
1. <span style="font-size: large;"><span style="font-size: large;">package com.javacrazyer.domain;
2.
3. import java.util.Date;
4.
5. /**
6. * --> JavaBean
7. *
8. */
9. public class Student {
10. private int id; //OID
11. private String name;
12. private int age;
13. private boolean gender;
14. private Date birthday;
15. private double score;
16.
17. public int getId() {
18. return id;
19. }
20. public void setId(int id) {
21. this.id = id;
22. }
23. public String getName() {
24. return name;
25. }
26. public void setName(String name) {
27. this.name = name;
28. }
29. public int getAge() {
30. return age;
31. }
32. public void setAge(int age) {
33. this.age = age;
34. }
35. public boolean isGender() {
36. return gender;
37. }
38. public void setGender(boolean gender) {
39. this.gender = gender;
40. }
41. public Date getBirthday() {
42. return birthday;
43. }
44. public void setBirthday(Date birthday) {
45. this.birthday = birthday;
46. }
47. public double getScore() {
48. return score;
49. }
50. public void setScore(double score) {
51. this.score = score;
52. }
53.
54. @Override
55. public String toString(){
56. return "id=" + id + ",name=" + name + ",gender=" + gender + ",age=" + age
57. + ",birthday=" + this.birthday + ",score=" + score;
58. }
59.
60. }</span></span>
package com.javacrazyer.domain;
import java.util.Date;
/**
* --> JavaBean
*
*/
public class Student {
private int id; //OID
private String name;
private int age;
private boolean gender;
private Date birthday;
private double score;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
public boolean isGender() {
return gender;
}
public void setGender(boolean gender) {
this.gender = gender;
}
public Date getBirthday() {
return birthday;
}
public void setBirthday(Date birthday) {
this.birthday = birthday;
}
public double getScore() {
return score;
}
public void setScore(double score) {
this.score = score;
}
@Override
public String toString(){
return "id=" + id + ",name=" + name + ",gender=" + gender + ",age=" + age
+ ",birthday=" + this.birthday + ",score=" + score;
}
}
Student.hbm.xml, hibernate :
hibernate-distribution-3.5.3Final\project\tutorials\web\src\main\resources\org\hibernate\tutorial\
domain\Person.hbm.xml
Xml
1. <span style="font-size: large;"><span style="font-size: large;"><?xml version="1.0" encoding="UTF-8"?>
2. <!DOCTYPE hibernate-mapping SYSTEM "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
3. <hibernate-mapping>
4. <class name="com.javacrazyer.domain.Student" table="student">
5. <id name="id" column="id">
6. <generator class="native"/>
7. </id>
8. <property name="name" column="name"/>
9. <property name="age"/>
10. <property name="gender"/>
11. <property name="birthday"/>
12. <property name="score"/>
13. </class>
14. </hibernate-mapping></span></span>
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping SYSTEM "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
<hibernate-mapping>
<class name="com.javacrazyer.domain.Student" table="student">
<id name="id" column="id">
<generator class="native"/>
</id>
<property name="name" column="name"/>
<property name="age"/>
<property name="gender"/>
<property name="birthday"/>
<property name="score"/>
</class>
</hibernate-mapping>
hbm.xml
1.class
name:
table: ,
dynamic-update: , , false。
dynamic-insert: insert null
Proxy: ,
discriminator-value:
where: 。 : "where studentstatus='0'"
2.id
1.column
2.type
3.length
4.unsaved-value
5.generator-class
assigned
hilo
seqhilo
increment
identity
sequence
native
uuid.hex
uuid.string
foreign
---------------------------------------------------------------------------------------------------------------
increment( )
long, short int 。 。 。
identity
DB2,MySQL, MS SQL Server, Sybase HypersonicSQL 。 long, short int 。
sequence ( )
DB2,PostgreSQL, Oracle, SAP DB, McKoi (sequence), Interbase (generator)。 long, short int 。
hilo ( )
/ long, short int 。 ( hibernate_unique_key next_hi) 。 / 。 JTA , 。
seqhilo( )
/ long, short int , (sequence) 。
uuid.hex
128-bit UUID 。 ( IP )。UUID 32 16 。
uuid.string
UUID 。UUID 16 ASCII 。 PostgreSQL
native( )
identity, sequence hilo 。
assigned( )
save() 。
foreign( )
-------------------------------------------------------------------------------------------------------------------------
3.property
1.column
2.type
3.length
4.not-null
5.unique ( )
6.insert insert ,
7.update update ,
, , student , Student , , , hibernate.cfg.xml <property name="hibernate.hbm2ddl.auto">update</property> update ,
, , SQL ,hibernate API
DBScriptExport .Java
Java
1. <span style="font-size: large;"><span style="font-size: large;">package com.javacrazyer.common;
2.
3. import org.hibernate.cfg.Configuration;
4. import org.hibernate.tool.hbm2ddl.SchemaExport;
5.
6. /**
7. *
8. *
9. */
10. public class DBScriptExport {
11.
12. public static void main(String[] args) {
13. export2File("dbcript.sql");
14. }
15.
16. public static void export2DB(){
17. // Hibernate
18. Configuration config = new Configuration().configure();
19. SchemaExport export = new SchemaExport(config);
20. export.create(true, true);
21. }
22.
23. public static void export2File(String dest){
24. Configuration config = new Configuration().configure();
25. SchemaExport export = new SchemaExport(config);
26.
27. export.setOutputFile(dest)
28. .setDelimiter(";")
29. .setFormat(true)
30. .create(true, false);
31. }
32.
33. }
34. </span></span>
package com.javacrazyer.common;
import org.hibernate.cfg.Configuration;
import org.hibernate.tool.hbm2ddl.SchemaExport;
/**
*
*
*/
public class DBScriptExport {
public static void main(String[] args) {
export2File("dbcript.sql");
}
public static void export2DB(){
// Hibernate
Configuration config = new Configuration().configure();
SchemaExport export = new SchemaExport(config);
export.create(true, true);
}
public static void export2File(String dest){
Configuration config = new Configuration().configure();
SchemaExport export = new SchemaExport(config);
export.setOutputFile(dest)
.setDelimiter(";")
.setFormat(true)
.create(true, false);
}
}
session HibernateUtil.java
Java
1. <span style="font-size: large;"><span style="font-size: large;">package com.javacrazyer.common;
2.
3. import org.hibernate.Session;
4. import org.hibernate.SessionFactory;
5. import org.hibernate.cfg.Configuration;
6.
7. /**
8. * Hibernate
9. *
10. */
11. public class HibernateUtil {
12. private static final SessionFactory factory;
13.
14. private HibernateUtil(){}
15.
16. static{
17. // Hibernate , SessionFactory
18. factory = new Configuration().configure().buildSessionFactory();
19. }
20.
21. public static SessionFactory getSessionFactory(){
22. return factory;
23. }
24.
25. public static Session getSession(){
26. return factory.openSession();
27. }
28. }
29. </span></span>
package com.javacrazyer.common;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
/**
* Hibernate
*
*/
public class HibernateUtil {
private static final SessionFactory factory;
private HibernateUtil(){}
static{
// Hibernate , SessionFactory
factory = new Configuration().configure().buildSessionFactory();
}
public static SessionFactory getSessionFactory(){
return factory;
}
public static Session getSession(){
return factory.openSession();
}
}
HibernateTest.java
Java
1. <span style="font-size: large;"><span style="font-size: large;">package com.javacrazyer.test;
2.
3. import java.util.Date;
4. import java.util.List;
5.
6. import org.hibernate.Criteria;
7. import org.hibernate.HibernateException;
8. import org.hibernate.Query;
9. import org.hibernate.Session;
10. import org.hibernate.Transaction;
11. import org.hibernate.criterion.Order;
12. import org.junit.Assert;
13. import org.junit.Test;
14.
15. import com.javacrazyer.common.HibernateUtil;
16. import com.javacrazyer.domain.Student;
17.
18. /**
19. * Hibernate API CRUD
20. * Query
21. *
22. */
23. public class HibernateTest {
24.
25. @Test
26. public void testAdd(){
27. Student stu = new Student();
28. stu.setName("test");
29. stu.setBirthday(new Date());
30. stu.setAge(1);
31. stu.setGender(true);
32. stu.setScore(66.8);
33.
34. // Session
35. Session session = HibernateUtil.getSession();
36.
37. //
38. Transaction tx = session.beginTransaction();
39.
40. // session
41. session.save(stu);
42.
43. //
44. tx.commit();
45.
46. // Session
47. session.close();
48. }
49.
50. @Test
51. public void getStu(){
52.
53. //
54. Session session = null;
55. Transaction tx = null;
56. try{
57. session = HibernateUtil.getSession();
58.
59. tx = session.beginTransaction();
60.
61. // ID
62. Student stu = (Student)session.get(Student.class, 1);
63.
64. Assert.assertNotNull(stu);
65. System.out.println(stu);
66.
67. tx.commit();
68. }catch(HibernateException he){
69. he.printStackTrace();
70. tx.rollback();
71. }finally{
72. if(null != session && session.isOpen()){
73. try{
74. session.close();
75. }catch(HibernateException e){
76. e.printStackTrace();
77. }
78. }
79. }
80. }
81.
82. @Test
83. public void testUpdate(){
84. Session session = null;
85.
86. try{
87. session = HibernateUtil.getSession();
88.
89. session.beginTransaction();
90.
91. Student stu = (Student)session.get(Student.class, 1);
92. stu.setName("zs");
93. stu.setScore(52.1);
94.
95. session.update(stu);
96.
97. session.getTransaction().commit();
98. }catch(HibernateException e){
99. Assert.fail();
100. e.printStackTrace();
101. session.getTransaction().rollback();
102. }finally{
103. if(session != null && session.isOpen()){
104. session.close();
105. }
106. }
107. }
108.
109. @Test
110. public void testDelete(){
111. Session session = null;
112.
113. try{
114. session = HibernateUtil.getSession();
115. //session.beginTransaction();
116.
117. Student stu = (Student)session.get(Student.class, 2);
118. System.out.println(stu);
119. session.delete(stu);
120.
121. //session.getTransaction().commit();
122. }catch(HibernateException e){
123. Assert.fail();
124. e.printStackTrace();
125. //session.getTransaction().rollback();
126. }finally{
127. if(session != null && session.isOpen()){
128. session.close();
129. }
130. }
131. }
132.
133. @Test
134. public void testGet(){
135. Session session = null;
136.
137. try{
138. session = HibernateUtil.getSession();
139. session.beginTransaction();
140.
141. Student stu = (Student)session.get(Student.class, 2);
142.
143. System.out.println(stu);
144.
145. Student stu2 = (Student) session.get(Student.class, 2);
146.
147. System.out.println(stu2);
148.
149. session.getTransaction().commit();
150. }catch(HibernateException e){
151. Assert.fail();
152. e.printStackTrace();
153. session.getTransaction().rollback();
154. }finally{
155. if(session != null && session.isOpen()){
156. session.close();
157. }
158. }
159. }
160.
161. @Test
162. public void testGet2(){
163. Session session = null;
164.
165. session = HibernateUtil.getSession();
166. session.beginTransaction();
167. Student stu = (Student)session.get(Student.class, 2);
168. System.out.println(stu);
169. session.getTransaction().commit();
170. session.close();
171.
172. session = HibernateUtil.getSession();
173. session.beginTransaction();
174. Student stu2 = (Student) session.get(Student.class, 2);
175. System.out.println(stu2);
176. session.getTransaction().commit();
177. session.close();
178. }
179.
180. @SuppressWarnings("unchecked")
181. @Test
182. public void testQuery(){
183. Session session = null;
184. try{
185. session = HibernateUtil.getSession();
186. session.beginTransaction();
187.
188. Query query = session.createQuery("from Student");
189. List<Student> stus = query.list();
190.
191. for(Student stu : stus){
192. System.out.println(stu);
193. }
194.
195. session.getTransaction().commit();
196.
197. }catch(HibernateException e){
198. e.printStackTrace();
199. session.getTransaction().rollback();
200. }finally{
201. if(session != null && session.isOpen()){
202. session.close();
203. }
204. }
205. }
206.
207. @SuppressWarnings("unchecked")
208. @Test
209. public void testCriteria(){
210. Session session = null;
211. try{
212. session = HibernateUtil.getSession();
213. session.beginTransaction();
214.
215. Criteria criteria = session.createCriteria(Student.class);
216.
217. List<Student> stus = criteria.addOrder(Order.desc("id")).list();
218.
219. for(Student stu : stus){
220. System.out.println(stu);
221. }
222.
223. session.getTransaction().commit();
224.
225. }catch(HibernateException e){
226. e.printStackTrace();
227. session.getTransaction().rollback();
228. }finally{
229. if(session != null && session.isOpen()){
230. session.close();
231. }
232. }
233. }
234.
235. }</span></span>
package com.javacrazyer.test;
import java.util.Date;
import java.util.List;
import org.hibernate.Criteria;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.criterion.Order;
import org.junit.Assert;
import org.junit.Test;
import com.javacrazyer.common.HibernateUtil;
import com.javacrazyer.domain.Student;
/**
* Hibernate API CRUD
* Query
*
*/
public class HibernateTest {
@Test
public void testAdd(){
Student stu = new Student();
stu.setName("test");
stu.setBirthday(new Date());
stu.setAge(1);
stu.setGender(true);
stu.setScore(66.8);
// Session
Session session = HibernateUtil.getSession();
//
Transaction tx = session.beginTransaction();
// session
session.save(stu);
//
tx.commit();
// Session
session.close();
}
@Test
public void getStu(){
//
Session session = null;
Transaction tx = null;
try{
session = HibernateUtil.getSession();
tx = session.beginTransaction();
// ID
Student stu = (Student)session.get(Student.class, 1);
Assert.assertNotNull(stu);
System.out.println(stu);
tx.commit();
}catch(HibernateException he){
he.printStackTrace();
tx.rollback();
}finally{
if(null != session && session.isOpen()){
try{
session.close();
}catch(HibernateException e){
e.printStackTrace();
}
}
}
}
@Test
public void testUpdate(){
Session session = null;
try{
session = HibernateUtil.getSession();
session.beginTransaction();
Student stu = (Student)session.get(Student.class, 1);
stu.setName("zs");
stu.setScore(52.1);
session.update(stu);
session.getTransaction().commit();
}catch(HibernateException e){
Assert.fail();
e.printStackTrace();
session.getTransaction().rollback();
}finally{
if(session != null && session.isOpen()){
session.close();
}
}
}
@Test
public void testDelete(){
Session session = null;
try{
session = HibernateUtil.getSession();
//session.beginTransaction();
Student stu = (Student)session.get(Student.class, 2);
System.out.println(stu);
session.delete(stu);
//session.getTransaction().commit();
}catch(HibernateException e){
Assert.fail();
e.printStackTrace();
//session.getTransaction().rollback();
}finally{
if(session != null && session.isOpen()){
session.close();
}
}
}
@Test
public void testGet(){
Session session = null;
try{
session = HibernateUtil.getSession();
session.beginTransaction();
Student stu = (Student)session.get(Student.class, 2);
System.out.println(stu);
Student stu2 = (Student) session.get(Student.class, 2);
System.out.println(stu2);
session.getTransaction().commit();
}catch(HibernateException e){
Assert.fail();
e.printStackTrace();
session.getTransaction().rollback();
}finally{
if(session != null && session.isOpen()){
session.close();
}
}
}
@Test
public void testGet2(){
Session session = null;
session = HibernateUtil.getSession();
session.beginTransaction();
Student stu = (Student)session.get(Student.class, 2);
System.out.println(stu);
session.getTransaction().commit();
session.close();
session = HibernateUtil.getSession();
session.beginTransaction();
Student stu2 = (Student) session.get(Student.class, 2);
System.out.println(stu2);
session.getTransaction().commit();
session.close();
}
@SuppressWarnings("unchecked")
@Test
public void testQuery(){
Session session = null;
try{
session = HibernateUtil.getSession();
session.beginTransaction();
Query query = session.createQuery("from Student");
List<Student> stus = query.list();
for(Student stu : stus){
System.out.println(stu);
}
session.getTransaction().commit();
}catch(HibernateException e){
e.printStackTrace();
session.getTransaction().rollback();
}finally{
if(session != null && session.isOpen()){
session.close();
}
}
}
@SuppressWarnings("unchecked")
@Test
public void testCriteria(){
Session session = null;
try{
session = HibernateUtil.getSession();
session.beginTransaction();
Criteria criteria = session.createCriteria(Student.class);
List<Student> stus = criteria.addOrder(Order.desc("id")).list();
for(Student stu : stus){
System.out.println(stu);
}
session.getTransaction().commit();
}catch(HibernateException e){
e.printStackTrace();
session.getTransaction().rollback();
}finally{
if(session != null && session.isOpen()){
session.close();
}
}
}
}
:
hibernate.cfg.xml
<property name="hibernate.hbm2ddl.auto">create</property>
, src import.sql, , , , create , hibernate , , ,
import.sql
Java
1. <span style="font-size: large;">insert into student(name,age,gender,birthday,score) values('test2',10,false,now(),11.2);</span>
insert into student(name,age,gender,birthday,score) values('test2',10,false,now(),11.2);
, , , , import.sql , , import.sql , hibernate
ソース:http://javacrazyer.iteye.com/blog/802753#comments