1. 导入oracle-jar包(在oracle安装目录中找到jar包,推荐ojdbc14.jar)
2. hibernate中修改配置文件,注意端口号为1521
<!-- Hibernate配置文件 --> <hibernate-configuration> <session-factory> <!-- 数据库驱动 --> <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property> <!-- 数据库连接的URL --> <property name="connection.url">jdbc:oracle:thin:@localhost:1521:lianxi</property> <!-- 数据库连接用户名 --> <property name="connection.username">scott</property> <!-- 数据库连接密码 --> <property name="connection.password">tiger</property> <!-- Hibernate方言 --> <property name="dialect">org.hibernate.dialect.OracleDialect</property> <!-- 打印SQL语句 --> <property name="show_sql">true</property>
<!-- 映射文件 --> <mapping resource="com/sichuang/oa/bean/User.hbm.xml" />
|
3. 在spring配置文件中修改
<!-- 配置连接数据库的数据源 --> <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"> <property name="driverClass" value="oracle.jdbc.driver.OracleDriver"/> <property name="jdbcUrl" value="jdbc:oracle:thin:@localhost:1521:lianxi"/> <property name="user" value="scott" /> <property name="password" value="tiger"/> </bean>
<!-- 配置SessionFactory --> <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> <property name="dataSource" ref="dataSource"/> <property name="mappingResources"> <list> <value>com/sichuang/oa/bean/User.hbm.xml</value>
</list> </property> <property name="hibernateProperties"> <value> hibernate.dialect=org.hibernate.dialect.OracleDialect hibernate.hbm2ddl.auto=update hibernate.show_sql=false hibernate.format_sql=false </value> </property> </bean> |
4. 在实体类的配置文件中修改,注意在oracle数据中id号不能自动增长,必修要创建“序列sequence”
create sequence SEQ_USER_ID;(建议的序列名:seq_数据库名_主键名)
|
配置:id主键 <id name="id" unsaved-value="null"> <generator class="sequence" > <param name="sequence">SEQ_USER_ID(所创建的序列)</param> </generator> </id> |