使用annotation开发hibernate3程序

下载最新的hibernate3的jar包。http://www.hibernate.org/6.html

包括：Hibernate Core ，Hibernate Annotations ，Hibernate Validator

需要的jar列表如下(包括数据库jdbc)

antlr-2.7.6.jar
commons-collections-3.1.jar
dom4j-1.6.1.jar
javassist-3.4.GA.jar
jta-1.1.jar
slf4j-api-1.4.2.jar
hibernate-annotations.jar
ejb3-persistence.jar
hibernate-commons-annotations.jar
hibernate-validator.jar
hibernate3.jar
log4j.jar
slf4j-log4j12.jar
ehcache-1.2.3.jar
commons-logging-1.1.jar

mysql-connector-java-5.1.6-bin.jar

 

新建mysql数据库,名为global.

执行下面的sql文新建表

1. CREATE TABLE `t_user` (
2.   `USR_ID` int(11) NOT NULL auto_increment,
3.   `USR_LNM` varchar(20) NOT NULL,
4.   `USR_PSW` varchar(128) NOT NULL,
5.   `USR_AST` varchar(2) NOT NULL,
6.   `USR_NAME` varchar(128) NOT NULL,
7.   `USR_LLDT` datetime default NULL,
8.   `USR_CNT` int(11) default NULL,
9.   `USR_LGIP` varchar(20) default NULL,
10.   PRIMARY KEY  (`USR_ID`)
11. ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gbk;

自定义log4j.properties文件，这里略去。

 

hibernate.cfg.xml

1. <?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">
6. <hibernate-configuration>
8.     <session-factory>
9.         <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
10.         <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/global</property>
11.         <property name="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</property>
12.         <property name="connection.username">root</property>
13.         <property name="connection.password">root</property>
14.         <property name="jdbc.fetch_size">50</property>
15.         <property name="jdbc.batch_size">30</property>
16.         <property name="show_sql">true</property>
17.         <property name="use_outer_join">true</property>
18.         <property name="transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>
19.         <property name="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</property>
20.         <property name="hibernate.cache.use_query_cache">true</property>
21.         
22.         <mapping class="com.global.hb3.model.TUser"/>
23.         
24.     </session-factory>
26. </hibernate-configuration>

TUser.java

1. package com.global.hb3.model;
3. import static javax.persistence.GenerationType.IDENTITY;
5. import java.util.Date;
7. import javax.persistence.Column;
8. import javax.persistence.Entity;
9. import javax.persistence.GeneratedValue;
10. import javax.persistence.Id;
11. import javax.persistence.Table;
12. import javax.persistence.Temporal;
13. import javax.persistence.TemporalType;
15. import org.hibernate.validator.Length;
16. import org.hibernate.validator.NotNull;
18. @Entity
19. @Table(name = "t_user")
20. public class TUser implements java.io.Serializable {
22.     private static final long serialVersionUID = -8424250427606515536L;
23.     
24.     private Integer usrId;
25.     private String usrLnm;
26.     private String usrPsw;
27.     private String usrAst;
28.     private String usrName;
29.     private Date usrLldt;
30.     private Integer usrCnt;
31.     private String usrLgip;
33.     public TUser() {
34.     }
36.     public TUser(String usrLnm, String usrPsw, String usrAst, String usrName) {
37.         this.usrLnm = usrLnm;
38.         this.usrPsw = usrPsw;
39.         this.usrAst = usrAst;
40.         this.usrName = usrName;
41.     }
43.     public TUser(String usrLnm, String usrPsw, String usrAst, String usrName,
44.             Date usrLldt, Integer usrCnt, String usrLgip) {
45.         this.usrLnm = usrLnm;
46.         this.usrPsw = usrPsw;
47.         this.usrAst = usrAst;
48.         this.usrName = usrName;
49.         this.usrLldt = usrLldt;
50.         this.usrCnt = usrCnt;
51.         this.usrLgip = usrLgip;
52.     }
54.     @Id
55.     @GeneratedValue(strategy = IDENTITY)
56.     @Column(name = "USR_ID", unique = true, nullable = false)
57.     public Integer getUsrId() {
58.         return this.usrId;
59.     }
61.     public void setUsrId(Integer usrId) {
62.         this.usrId = usrId;
63.     }
65.     @Column(name = "USR_LNM", nullable = false, length = 20)
66.     @NotNull
67.     @Length(max = 20)
68.     public String getUsrLnm() {
69.         return this.usrLnm;
70.     }
72.     public void setUsrLnm(String usrLnm) {
73.         this.usrLnm = usrLnm;
74.     }
76.     @Column(name = "USR_PSW", nullable = false, length = 128)
77.     @NotNull
78.     @Length(max = 128)
79.     public String getUsrPsw() {
80.         return this.usrPsw;
81.     }
83.     public void setUsrPsw(String usrPsw) {
84.         this.usrPsw = usrPsw;
85.     }
87.     @Column(name = "USR_AST", nullable = false, length = 2)
88.     @NotNull
89.     @Length(max = 2)
90.     public String getUsrAst() {
91.         return this.usrAst;
92.     }
94.     public void setUsrAst(String usrAst) {
95.         this.usrAst = usrAst;
96.     }
98.     @Column(name = "USR_NAME", nullable = false, length = 128)
99.     @NotNull
100.     @Length(max = 128)
101.     public String getUsrName() {
102.         return this.usrName;
103.     }
105.     public void setUsrName(String usrName) {
106.         this.usrName = usrName;
107.     }
109.     @Temporal(TemporalType.TIMESTAMP)
110.     @Column(name = "USR_LLDT", length = 19)
111.     public Date getUsrLldt() {
112.         return this.usrLldt;
113.     }
115.     public void setUsrLldt(Date usrLldt) {
116.         this.usrLldt = usrLldt;
117.     }
119.     @Column(name = "USR_CNT")
120.     public Integer getUsrCnt() {
121.         return this.usrCnt;
122.     }
124.     public void setUsrCnt(Integer usrCnt) {
125.         this.usrCnt = usrCnt;
126.     }
128.     @Column(name = "USR_LGIP", length = 20)
129.     @Length(max = 20)
130.     public String getUsrLgip() {
131.         return this.usrLgip;
132.     }
134.     public void setUsrLgip(String usrLgip) {
135.         this.usrLgip = usrLgip;
136.     }
138. //  private String usrAstNm;
139. //
140. //  @Formula(value = "(select d.DVS_NM from T_DIVISION d where d.DVS_CD = USR_AST AND d.DVS_NO = 1)")
141. //  public String getUsrAstNm() {
142. //      return usrAstNm;
143. //  }
144. //
145. //  public void setUsrAstNm(String usrAstNm) {
146. //      this.usrAstNm = usrAstNm;
147. //  }
148. }

BusinessService.java

1. package com.global.hb3;
3. import org.hibernate.Session;
4. import org.hibernate.SessionFactory;
5. import org.hibernate.Transaction;
6. import org.hibernate.cfg.AnnotationConfiguration;
7. import org.hibernate.cfg.Configuration;
9. import com.global.hb3.model.TUser;
11. public class BusinessService {
13.     public static SessionFactory sessionFactory;
15.     static {
16.         try {
17.             Configuration config = new AnnotationConfiguration().configure("hibernate.cfg.xml");
18.             sessionFactory = config.buildSessionFactory();
19.         } catch (Exception e) {
20.             e.printStackTrace();
21.         }
22.     }
23.     
24.     public static void main(String[] args) {
25.         
26.         Session session = sessionFactory.openSession();
27.         Transaction tx = null;
28.         try {
29.             tx = session.beginTransaction();
30.             TUser user = (TUser) session.get(TUser.class, new Integer(1));
31.             System.out.println(user.getUsrName());
32.             tx.commit();
33.         } catch (Exception e) {
34.             if (tx != null) {
35.                 tx.rollback();
36.             }
37.             e.printStackTrace();
38.         } finally {
39.             session.close();
40.         }
41.     }
42. }