说明:数据库:Oracle10g;连接池:c3p0
结构:
一、配置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">
<!-- c3p0连接池 -->
<hibernate-configuration>
<session-factory>
<!-- 显示实际操作数据库时的SQL -->
<property name="show_sql">true</property>
<!-- SQL方言,这边设定的是Oracle -->
<property name="dialect">org.hibernate.dialect.Oracle10gDialect</property>
<!--驱动程序:Oracle数据库的配置 -->
<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<!-- JDBC URL -->
<property name="connection.url">jdbc:oracle:thin:@localhost:1521:myorcl</property>
<!-- 数据库用户名 -->
<property name="connection.username">scott</property>
<!-- 数据库密码 -->
<property name="connection.password">root</property>
<!-- 指定连接池里最小连接数 -->
<property name="hibernate.cp30.minsize">5</property>
<!-- 指定连接池里的最大连接数 -->
<property name="hibernate.c3p0.maxsize">20</property>
<!-- 指定连接池里的超时时常 -->
<property name="hibernate.cp30.timeout">1800</property>
<!-- 指定连接池里最大缓存多少个Statement对象 -->
<property name="hibernate.cp30.max_statements">50</property>
<!-- 根据需要自动创建数据库表 -->
<property name="hbm2ddl.auto">update</property>
<!-- 对象与数据库表格映像文件 -->
<mapping resource="com/chen/vo/News.hbm.xml"/>
</session-factory>
</hibernate-configuration>
二、配置News.hbm.xml
说明:由于连接的数据库是Oracle,所有这里指定了序列:seq_news,如果设置<generator class="native"/>,则在插入数据时Hibernate默认会去查找Oracle中的hibernate_sequence序列(默认序列)。
<?xml version="1.0" encoding="utf-8"?>
<!-- 指定Hibernate映射文件的DTD信息 -->
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- hibernate-mapping是映射文件的根源素 -->
<hibernate-mapping>
<!-- 每个class对应一个持久化对象 -->
<class name="com.chen.vo.News" table="news_table">
<!-- id元素定义持久化类的标识属性 -->
<id name="id">
<generator class="sequence">
<param name="sequence">seq_news</param>
</generator>
</id>
<!-- property元素定义常规属性 -->
<property name="title"/>
<property name="content"/>
</class>
</hibernate-mapping>
三、创建vo
package com.chen.vo;
public class News
{
//消息类的标识属性
private Integer id;
//消息标题
private String title;
//消息内容
private String content;
//id属性的setter和getter方法
public void setId(Integer id)
{
this.id=id;
}
public Integer getId()
{
return this.id;
}
//title属性的setter和getter方法
public void setTitle(String title)
{
this.title=title;
}
public String getTitle()
{
return this.title;
}
//content 属性的setter和getter方法
public void setContent(String content)
{
this.content=content;
}
public String getContent()
{
return this.content;
}
}
四、创建测试类
package com.chen.vo;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
public class NewsManager {
public static void main(String[] args) throws Exception
{
//实例化configuration
Configuration conf =new Configuration().configure();
//以Configuration创建SessionFactory.注:buildSessionFactory方法已过时,不过仍可以获取SessionFactory。
// SessionFactory sf=conf.buildSessionFactory();
//采用ServiceRegistry获取SessionFactory
StandardServiceRegistryBuilder serviceRegistryBuilder = new StandardServiceRegistryBuilder();
ServiceRegistry serviceRegistry = serviceRegistryBuilder.applySettings(conf.getProperties()).build();
SessionFactory sf = conf.buildSessionFactory(serviceRegistry);
//创建session
Session sess = sf.openSession();
//开始事物
Transaction tx = sess.beginTransaction();
//创建消息实例
News n=new News();
//设置消息标题和消息内容
/**
* Oracle插入数据说明:
* 1.在News.hbm.xml中设置<generator class="native"/>
* 连接Oracle,默认序列(Default.sequence)为hibernate_sequence
* 使用native时Hibernate默认会去查找Oracle中的hibernate_sequence序列,所以插入数据时无需设置id。
* 2.在News.hbm.xml中设置指定序列:
* <generator class="sequence">
<param name="sequence">seq_news</param>
</generator>
* Hibernate会按照序列seq_news创建新数据。
*/
n.setTitle("title2");
n.setContent("content2");
//保存消息
sess.save(n);
//提交事务
tx.commit();
//关闭Session
sess.close();
sf.close();
}
}
测试结果:
五、创建junit测试类、HibernateSessionFactory,通过session实现增、删、查、改
1.创建HibernateSessionFactory
package com.chen.utils;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
public class HibernateSessionFactory {
private static final ThreadLocal<Session> threadLocal = new ThreadLocal<Session>();
//private static String configfile = "/hibernate.cfg.xml";
private static Configuration configuration = new Configuration().configure();
private static SessionFactory sessionFactory;
static {
try {
StandardServiceRegistryBuilder serviceRegistryBuilder = new StandardServiceRegistryBuilder();
ServiceRegistry serviceRegistry = serviceRegistryBuilder.applySettings(configuration.getProperties()).build();
sessionFactory = configuration.buildSessionFactory(serviceRegistry);
} catch (HibernateException e) {
e.printStackTrace();
}
}
private HibernateSessionFactory() {
}
public static Session getSession() {
Session session = (Session) threadLocal.get();
if (session == null || !session.isOpen()) {
session = (sessionFactory != null) ? sessionFactory.openSession()
: null;
threadLocal.set(session);
}
return session;
}
public static void closeSesssion() {
Session session = threadLocal.get();
threadLocal.set(null);
if (session != null) {
session.close();
}
}
public static SessionFactory getSessionFactory() {
return sessionFactory;
}
public static void setSessionFactory(SessionFactory sessionFactory) {
HibernateSessionFactory.sessionFactory = sessionFactory;
}
public static Configuration getConfiguration() {
return configuration;
}
public static void setConfiguration(Configuration configuration) {
HibernateSessionFactory.configuration = configuration;
}
}
2.在测试类进行测试
package com.chen.test;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.junit.Test;
import com.chen.utils.HibernateSessionFactory;
import com.chen.vo.News;
public class HibernateTest {
//获取session
@Test
public void sessionTest(){
Session session = HibernateSessionFactory.getSession();
System.out.println(session);
}
//查询News的列表信息
@Test
public void listNews(){
Session session = HibernateSessionFactory.getSession();
Query query = session.createQuery("from News");
List<?> list = query.list();
System.out.println(list);
}
//通过id查询指定的News
@Test
public void findById(){
Session session = HibernateSessionFactory.getSession();
Query query = session.createQuery("from News where id=?");
//设置参数
query.setParameter(0, 1);
//单值检索
News n = (News) query.uniqueResult();
System.out.println(n);
}
//添加News
@Test
public void saveNews(){
Session session = HibernateSessionFactory.getSession();
Transaction tx = session.beginTransaction();
News n=new News();
n.setTitle("title3");
n.setContent("content3");
session.saveOrUpdate(n);;
tx.commit();
session.close();
}
//修改News
@Test
public void updateNews(){
Session session = HibernateSessionFactory.getSession();
//先获取指定id的News
Query query = session.createQuery("from News where id=?");
query.setParameter(0, 5);
News n = (News) query.uniqueResult();
//再进行修改
Transaction tx = session.beginTransaction();
n.setContent("update_content5");
session.saveOrUpdate(n);
tx.commit();
session.close();
System.out.println(n);
}
//删除News
@Test
public void deteleNews(){
Session session = HibernateSessionFactory.getSession();
Query query = session.createQuery("from News where id=?");
query.setParameter(0, 4);
News n = (News) query.uniqueResult();
Transaction tx = session.beginTransaction();
session.delete(n);
tx.commit();
session.close();
}
}
小结:“查”的实现是通过查询hql语句实现的。
附:Oracle创建序列seq_news及相应的自动增长触发器
create sequence seq_news;
CREATE OR REPLACE TRIGGER "SCOTT"."trigger_news"
before insert on "SCOTT"."NEWS_TABLE"
for each row
begin
if inserting then
if :NEW."ID" is null then
select seq_news.nextval into :NEW."ID" from dual;
end if;
end if;
end;
/
ALTER TRIGGER "SCOTT"."trigger_news" ENABLE;