SSH整合（一）hibernat非Annotation配置

 

开发环境：MyEclipse6.5 + JDK1.6.0_33 + tomcat 6.0.32 + struts2.3.8 + spring3.2.1 + hibernate4.1.9

 

项目结构：

     SSO
        |----src
               |----com.login.junit
                                      |----SSOTest.java
               |----com.login.module
                                      |----User.java
                                      |----UserMapper.java
                                      |----User.hbm.xml
               |----hibernate.cfg.xml

 

步骤1：加入hibernate Jar

       

步骤2：建表

   

步骤3：新建java实体类

 

package com.login.module;

import java.io.Serializable;

public class User implements Serializable{
	
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	 
	
	private String id;
	private String name;
	private String pwd;
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getPwd() {
		return pwd;
	}
	public void setPwd(String pwd) {
		this.pwd = pwd;
	}
 
}

步骤4：实体与数据库的映射文件XX.hbm.xml；

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.login.module">
	<class name="User" table="user">
		<id name="id" type="java.lang.String">
		<!-- generator设置主键生成策略  assigned:主键由外部程序负责生成，无需Hibernate参与 -->
		 	<generator class="assigned"></generator>
		</id>
		<property name="name" type="java.lang.String">
			<column name="name" length="50"/>
		</property>
		<property name="pwd" type="java.lang.String">
			<column name="pwd" length="100" />
		</property>
	</class>
</hibernate-mapping>

 

步骤5：hibernate配置文件hibernate.cfg.xml；

<?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配置文件的开始 -->
<hibernate-configuration>
	<!-- session-factory主要配置Hibernate信息及对Session操作 -->
	<session-factory>
		<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
		<property name="hibernate.connection.url">jdbc:oracle:thin:@localhost:8080:test</property>
		<property name="hibernate.connection.username">admin</property>
		<property name="hibernate.connection.password">admin</property>
		
		
		<!-- 数据库连接池大小 -->
		<property name="hibernate.connection.pool.size">20</property>
		<!--是否在后台显示Hibernate用到的SQL语句，开发时设置为true，便于差错，程序运行时可以在Eclipse的控制台显示Hibernate的执行Sql语句。项目部署后可以设置为false，提高运行效率--> 
		<property name="hibernate.show_sql">true</property>
		<!--jdbc.fetch_size是指Hibernate每次从数据库中取出并放到JDBC的Statement中的记录条数。Fetch Size设的越大，读数据库的次数越少，速度越快，Fetch Size越小，读数据库的次数越多，速度越慢--> 
        <property name="hibernate.jdbc.fetch_size">50</property> 
        <!--jdbc.batch_size是指Hibernate批量插入,删除和更新时每次操作的记录数。Batch Size越大，批量操作的向数据库发送Sql的次数越少，速度就越快，同样耗用内存就越大--> 
        <property name="hibernate.jdbc.batch_size">23</property> 
        <!--jdbc.use_scrollable_resultset是否允许Hibernate用JDBC的可滚动的结果集。对分页的结果集。对分页时的设置非常有帮助--> 
        <property name="hibernate.jdbc.use_scrollable_resultset">false</property> 
        <!--connection.useUnicode连接数据库时是否使用Unicode编码--> 
        <property name="hibernate.Connection.useUnicode">true</property> 
        <!--connection.characterEncoding连接数据库时数据的传输字符集编码方式，最好设置为gbk，用gb2312有的字符不全--> 
    	<property name="hibernate.connection.characterEncoding">utf-8</property>      
        <!--hibernate.dialect 只是Hibernate使用的数据库方言,就是要用Hibernate连接那种类型的数据库服务器。--> 
        <property name="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</property><!-- 或者org.hibernate.dialect.OracleDialect -->
       
        <property name="hibernate.hbm2ddl.auto">update</property> 
       
        <!-- 非Annotation模式，需要关联实体类配置-->        
        <mapping resource="com/login/module/User.hbm.xml"/>
        
	</session-factory>
</hibernate-configuration>

 

步骤6：服务测试类UserManager.java

package com.login.module;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
import org.hibernate.service.ServiceRegistryBuilder;

public class UserMapper {

	/**
	*hibernate4的sessionFactory创建方式
	*/
	private SessionFactory buildSessionFactory() {
		Configuration cfg = new Configuration();
		cfg.configure();
		ServiceRegistry serviceRegistry = new ServiceRegistryBuilder()
				.applySettings(cfg.getProperties()).buildServiceRegistry();
		SessionFactory sf = cfg.buildSessionFactory(serviceRegistry);
		return sf;
	}
	public void add(User user){
		 Session s = buildSessionFactory().openSession();
		 s.beginTransaction();
		 s.save(user);
		 s.getTransaction().commit();
		 s.close();
	}
}

 

步骤7：Junit测试

package com.login.junit;

import com.login.module.User;
import com.login.module.UserMapper; 

import org.junit.Test; 

public class SSOTest{

	@Test
	public void testAdd() {
		  
		UserMapper userMapper = new UserMapper();
		
		User user = new User();
		user.setId("1");
		user.setName("lily");
		user.setPwd("123456");
		userMapper.add(user);
		 
		System.out.println("success add!");
	}
}

 输出：

 Hibernate: insert into user (id, name, pwd) values (?, ?, ?)
success add!