（十一）Hibernate 高级配置

 1 <?xml version=‘1.0‘ encoding=‘utf-8‘?>
 2 <!DOCTYPE hibernate-configuration PUBLIC
 3         "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
 4         "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
 5 
 6 <hibernate-configuration>
 7 
 8     <session-factory>
 9 
10         <!--数据库连接设置 -->
11         <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
12         <property name="connection.url">jdbc:mysql://localhost:3306/hibernate</property>
13         <property name="connection.username">root</property>
14         <property name="connection.password">123456</property>
15 
16        
17         <!-- 方言 -->
18         <property name="dialect">org.hibernate.dialect.MySQL5Dialect</property>
19     
20         <!-- 控制台显示SQL -->
21         <property name="show_sql">true</property>
22 
23         <!-- 自动更新表结构 -->
24         <property name="hbm2ddl.auto">update</property>
25         
26         <!-- 最小连接数 --> 
27          <property name="c3p0.min_size">7</property> 
28          <!-- 最大连接数 -->   
29          <property name="c3p0.max_size">42</property> 
30          <!-- 获得连接的超时时间,如果超过这个时间,会抛出异常，单位毫秒 -->  
31          <property name="c3p0.timeout">1800</property> 
32          <!-- 最大的PreparedStatement的数量 -->   
33          <property name="c3p0.max_statements">50</property> 
34         
35           <mapping resource="com/wishwzp/model/Student.hbm.xml"/>
36           
37           
38 
39     </session-factory>
40 
41 </hibernate-configuration>

 1 package com.java1234.service;
 2 
 3 
 4 import java.util.Iterator;
 5 import java.util.List;
 6 
 7 import org.apache.log4j.Logger;
 8 import org.hibernate.Criteria;
 9 import org.hibernate.Query;
10 import org.hibernate.Session;
11 import org.hibernate.SessionFactory;
12 import org.hibernate.criterion.Criterion;
13 import org.hibernate.criterion.Order;
14 import org.hibernate.criterion.Restrictions;
15 import org.junit.After;
16 import org.junit.Before;
17 import org.junit.Test;
18 
19 import com.java1234.model.Student;
20 import com.java1234.util.HibernateUtil;
21 
22 public class StudentTest {
23 
24     private SessionFactory sessionFactory=HibernateUtil.getSessionFactory();
25     private Session session;
26     private Logger logger=Logger.getLogger(StudentTest.class);
27     
28     @Before
29     public void setUp() throws Exception {
30         session=sessionFactory.openSession(); // 生成一个session
31         session.beginTransaction(); // 开启事务
32     }
33 
34     @After
35     public void tearDown() throws Exception {
36          session.getTransaction().commit(); // 提交事务
37          session.close(); // 关闭session
38     }
39 
40     @Test
41     public void testSQLQuery() {
42         String sql="select * from t_student";
43         Query query=session.createSQLQuery(sql).addEntity(Student.class);
44         List studentList=query.list();
45         Iterator it=studentList.iterator();
46         while(it.hasNext()){
47             Student s=(Student)it.next();
48             System.out.println(s);
49         }    
50         logger.debug("这是一个debug信息");
51         logger.info("这是一个info信息");
52         logger.error("这是一个错误信息");
53     }
54     
55 
56     
57 }