第一天

【结构】

 

/CRM/src/cn/hk/bean/SysUserGroup.java：

 1 package cn.hk.bean;
 2 
 3 /*
 4  * 部门信息表
 5  */
 6 public class SysUserGroup {
 7     
 8     private Integer id; //编号
 9     private String remark; // 备注
10     private String name;  //部门名称
11     private String principal; //部门负责人
12     private String incumbent; //部门职能
13     public Integer getId() {
14         return id;
15     }
16     public void setId(Integer id) {
17         this.id = id;
18     }
19     public String getRemark() {
20         return remark;
21     }
22     public void setRemark(String remark) {
23         this.remark = remark;
24     }
25     public String getName() {
26         return name;
27     }
28     public void setName(String name) {
29         this.name = name;
30     }
31     public String getPrincipal() {
32         return principal;
33     }
34     public void setPrincipal(String principal) {
35         this.principal = principal;
36     }
37     public String getIncumbent() {
38         return incumbent;
39     }
40     public void setIncumbent(String incumbent) {
41         this.incumbent = incumbent;
42     }
43     
44     
45 
46 }

 

/CRM/src/cn/hk/bean/SysUserGroup.hbm.xml：

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
 3 "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
 4 
 5 <hibernate-mapping>
 6     <class name="cn.hk.bean.SysUserGroup" table="sys_user_group">
 7     
 8        <id name="id" type="integer">
 9            <column name="id"/>
10            <generator class="identity"/>
11        </id>
12        
13        <property name="name" type="string">
14            <column name="name" sql-type="varchar(100)" />
15        </property>
16        
17            <property name="principal" type="string">
18             <column name="principal" sql-type="varchar(50)" />
19         </property>
20 
21         <property name="incumbent" type="string">
22             <column name="incumbent" sql-type="varchar(200)" />
23         </property>
24 
25         <property name="remark" type="text">
26             <column name="remark" />
27         </property>
28     </class>
29     
30 </hibernate-mapping>

 

/CRM/src/junit/TestHibernate.java：

 1 package junit;
 2 
 3 import org.hibernate.Session;
 4 import org.hibernate.SessionFactory;
 5 import org.hibernate.Transaction;
 6 import org.hibernate.cfg.Configuration;
 7 import org.junit.Test;
 8 import cn.hk.bean.SysUserGroup;
 9 
10 import cn.hk.bean.SysUserGroup;
11 
12 public class TestHibernate {
13     
14     @Test
15     public void TestHibernateConf(){
16         Configuration config = new Configuration();
17         config.configure();
18         
19         SessionFactory sf = config.buildSessionFactory();
20         Session s = sf.openSession();
21         Transaction tx = s.beginTransaction();
22         SysUserGroup sysUserGroup = new SysUserGroup();
23         sysUserGroup.setName("销售部");
24         sysUserGroup.setPrincipal("xxx");
25         sysUserGroup.setIncumbent("职能是什么？");
26         s.save(sysUserGroup);
27         tx.commit();
28         s.close();
29     }
30 
31 }

 

/CRM/src/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">
 5     
 6 <hibernate-configuration>
 7     <session-factory>
 8         <property name="hibernate.connection.username">root</property>
 9         <property name="hibernate.connection.password">root</property>
10         <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/crm</property>
11         <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
12         
13         <property name="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</property>
14         <!-- 自动创建表 -->
15         <property name="hibernate.hbm2ddl.auto">update</property>
16         <!-- SQL语句 -->
17         <property name="hibernate.show_sql">true</property>
18         <mapping resource="cn/hk/bean/SysUserGroup.hbm.xml"/>
19     </session-factory>
20 </hibernate-configuration>

 

测试结果：

 

 

成功。

posted @ 2018-10-27 10:11  猩生柯北  阅读(185)  评论(0)  编辑  收藏  举报