Spring+Hibernate框架整合-连接oracle

在整合步骤的基础上，把本来连接Mysql改为连接oracle
jar: ojdbc14_g.jar

• hbm
  
  设置自增长id为sequence
  

  <?xml version="1.0"?>
  <!DOCTYPE hibernate-mapping PUBLIC
          "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
          "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
   
  <hibernate-mapping package="com.how2java.pojo">
      <class name="Category" table="bigsword.category_">
          <id name="id" column="id">
              <generator class="native">        
                  <param name="sequence">bigsword.category_sequence</param>
              </generator>
          </id>
          <property name="name" />
   
      </class>
       
  </hibernate-mapping>

• applicationContext.xml
  
  设置连接oracle的 
  驱动 
  url 
  方言 
  账号密码
  

  <?xml version="1.0" encoding="UTF-8"?>
  <beans xmlns="http://www.springframework.org/schema/beans"
      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      xmlns:aop="http://www.springframework.org/schema/aop"
      xmlns:tx="http://www.springframework.org/schema/tx"
      xmlns:context="http://www.springframework.org/schema/context"
      xsi:schemaLocation="
     http://www.springframework.org/schema/beans
     http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
     http://www.springframework.org/schema/aop
     http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
     http://www.springframework.org/schema/tx
     http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
     http://www.springframework.org/schema/context     
     http://www.springframework.org/schema/context/spring-context-3.0.xsd">
    
      <bean name="c" class="com.how2java.pojo.Category">
          <property name="name" value="yyy" />
      </bean>
       
      <bean name="dao" class="com.how2java.dao.CategoryDAO">
          <property name="sessionFactory" ref="sf" />
      </bean>
   
      <bean name="sf"
          class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
          <property name="dataSource" ref="ds" />
          <property name="mappingResources">
              <list>
                  <value>com/how2java/pojo/Category.hbm.xml</value>
              </list>
          </property>
          <property name="hibernateProperties">
              <value>
                  hibernate.dialect=org.hibernate.dialect.OracleDialect
                  hibernate.show_sql=true
                  hbm2ddl.auto=update
              </value>
          </property>
      </bean>   
           
      <bean name="ds"
          class="org.springframework.jdbc.datasource.DriverManagerDataSource">
          <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
          <property name="url" value="jdbc:oracle:thin:@localhost:1521:XE" />
          <property name="username" value="bigsword" />
          <property name="password" value="bigsword" />
      </bean>  
   
  </beans>

• sql 语句
  
  首先用bigsword账号登录 
  创建sequence 
  创建table
  

  create sequence bigsword.category_sequence
   
  create table bigsword.category_(
  id number,
  name varchar2(30)
   
  )

• TestSpring
  
  运行测试代码
  

  package com.how2java.test;
    
  import java.util.List;
   
  import org.springframework.context.ApplicationContext;
  import org.springframework.context.support.ClassPathXmlApplicationContext;
   
  import com.how2java.dao.CategoryDAO;
  import com.how2java.pojo.Category;
    
  public class TestSpring {
    
      public static void main(String[] args) {
          ApplicationContext context = new ClassPathXmlApplicationContext(
                  new String[] { "applicationContext.xml" });
          CategoryDAO dao = (CategoryDAO) context.getBean("dao");
          Category c =new Category();
          c.setName("category 1");
          dao.save(c);
           
          List<Category> cs= dao.find("from Category c");
          System.out.println(cs);
      }
  }