Spring中整合了Hibernate,数据库的连接配置也可以写在applicationContext.xml文件中,下面是hibernate.cfg.xml文件内容,数据库用的是postgresql
<?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="hibernate.connection.username">postgres</property>
<property name="hibernate.connection.password">123456</property>
<property name="hibernate.connection.driver_class">org.postgresql.Driver</property>
<property name="hibernate.connection.url">jdbc:postgresql://172.17.197.1:5432/smart_tp_duty</property>
<property name="hibernate.connection.autocommit">true</property>
<property name="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</property>
<property name="hibernate.hbm2ddl.auto">update</property>
<property name="hibernate.show_sql">true</property>
<mapping resource="cn/itcast/elec/domain/ElecText.hbm.xml"/>
</session-factory>
</hibernate-configuration>
下面是测试数据库连接是否成功的测试代码HibernateTest.java
package junit;
import java.util.Date;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.junit.Test;
import cn.itcast.elec.domain.ElecText;
public class TestHibernate {
@Test
public void testElecText(){
Configuration config = new Configuration();
config.configure("/hibernate.cfg.xml");
//创建sessionFactory对象
SessionFactory sf = config.buildSessionFactory();
//打开session,操作数据库
Session session = sf.openSession();
//开启事务
Transaction tr = session.beginTransaction();
//实例化ElecText对象,添加数据,执行保存操作
ElecText elecText = new ElecText();
elecText.setTextName("测试Hibernate_liu");
elecText.setTextDate(new Date());
elecText.setTextRemark("测试Hibernate_liu");
//保存
session.save(elecText);
//提交事务
tr.commit();
session.close();
// if(session!=null){
// System.out.println("Contection Success!");
// session.close();
// }else{
// System.out.println("Contection Failed!");
// }
}
}