Hibernate增删改查Oracle数据库

本文开发环境:Win2003+Tomcat 5.5+MyEclipse 5.5.1 GA+jdk1.5.0_15+Oracle9i

软件安装路径:

Tomcat 5.5:C:/Program Files/Apache Software Foundation/Tomcat 5.5
MyEclipse 5.5.1 GA:C:/Program Files/MyEclipse 5.5.1 GA
jdk1.5.0_15:C:/Program Files/Java/jdk1.5.0_15
jre1.5.0_15:C:/Program Files/Java/jre1.5.0_15
Oracle9i:E:/oracle/ora90
log4j:D:/jar/log4j-1.2.15/log4j-1.2.15.jar

第一步：建立一个Myeclipse连接Oracle9i数据库连接

在MyEclipse打开MyEclipse Java Enterprise Data Exploer Perspective窗体，左边DB Broswer中点鼠标右

键－－“New”,在窗体中进行如下操作：

1.点击"Add JARs"按钮，找到Oracle安装目录下的E:/oracle/ora90/jdbc/lib/classes12.jar

2.Driver Template下拉列表中选择Oracle (Thin driver)

3.Driver Name 中输入test

4.Connect URL: jdbc:oracle:thin:@127.0.0.1:1521:test(此处test为数据库名)

5.UserName: system(此处system为数据库登录用户名)

6.Password: Manager(此处Manager为数据库登录用户对应的密码)

7.勾选中"Save Password"，点击"Finishe"按钮。

至此设置MyEclipse到Oracle数据库完成。在左边DB Broswer中多出一名称为test的数据库连接。

点鼠标右键可打开数据库连接或者是进行编辑等操作。

第二步：完成项目的新建和Hibernate库、log4j库引用

1.在MyEclipse打开MyEclipse Java Enterprise Development Perspective窗体，左边新建立一WebProject命

名为HibernateTest，

2.选种WebProject项目后点鼠标右键选择MyEclipse--Add Hibernate Capebilites--选择Hibnernate3.1,勾选

Hibernate 3.1 core Libraries,点击"Next"按钮，进入数据库设置窗体,在DB Driver中选中第一步新建的

test连接即可。点击"Next"按钮，随便输入一个SessionFactory包名字如SessionFolder.

3.选种WebProject项目后点鼠标右键, 选择"Build Path"--"Add Librarys"--"User Library"--找到你本地的

log4j相关的jar文件。

第三步：完成相关文件代码编写:

文件目录结构如下：

1.src/db/Student.sql
2.src/db/StudentSequence.sql
3.src/mappings/Student.hbm.xml
4.src/model/Student.java
5.src/test/TestStudent.sql
6.src/hibernate.cfg.xml
7.src/hibernate.properties
8.src/log4j.properties

1.src/db/Student.sql数据库脚本内容

create table Student(
Student_ID number(6) NOT NULL PRIMARY KEY,
Student_Name varchar2(10) NOT NULL,
Student_Age number(2) NOT NULL
);

2.src/db/StudentSequence.sql数据库脚本内容

CREATE SEQUENCE student_sequence
INCREMENT BY 1
START WITH 1000
NOMAXVALUE
NOCYCLE
CACHE 10;

3.src/mappings/Student.hbm.xml文件内容

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="model.Student" table="Student">
<id name="student_id" column="student_id" type="java.lang.Integer">
<generator class="native">
<param name="sequence">student_sequence</param>
</generator>
</id>
<property name="student_name" column="Student_Name" type="java.lang.String"/>
<property name="student_age" column="Student_Age" type="java.lang.Integer"/>
</class>
</hibernate-mapping>

4.src/model/Student.java内容

package model;

public class Student
{
private int student_id;
private String student_name;
private int student_age;

public int getStudent_id()
{
return student_id;
}
public String getStudent_name()
{
return student_name;
}
public int getStudent_age()
{
return student_age;
}
public void setStudent_id(int id)
{
this.student_id = id;
}
public void setStudent_name(String name)
{
this.student_name = name;
}
public void setStudent_age(int age)
{
this.student_age = age;
}
}

5.src/test/TestStudent.sql内容

package test;
import model.Student;
import org.hibernate.*;
import org.hibernate.cfg.*;

public class TestStudent {
public static void main(String[] args)
{
try
{
//通过Configuration获得一个SessionFactory对象
SessionFactory sf = new Configuration().configure().buildSessionFactory();
//打开一个Session
Session session = sf.openSession();
//开始一个事务
Transaction tx = session.beginTransaction();
//创建一个Student对象
Student stu = new Student();
//通过Student的setter方法改变它的属性
//注意student_id不用我们设置
stu.setStudent_name("test");
stu.setStudent_age(20);
//通过session的save()方法将Student对象保存到数据库中
session.save(stu);
//提交事务
tx.commit();
//关闭会话
session.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}

6.src/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">

<!-- Generated by MyEclipse Hibernate Tools. -->
<hibernate-configuration>
<session-factory>

<!-- Oracle数据库连接字符串 -->
<property name="hibernate.connection.url">jdbc:oracle:thin:@127.0.0.1:1521:test
</property>
<!-- Oracle驱动类 -->
<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<!-- Oracle用户名 -->
<property name="hibernate.connection.username">test</property>
<!-- Oracle密码 -->
<property name="hibernate.connection.password">test</property>
<!-- Oracle适配器(反译) -->
<property name="hibernate.dialect">
org.hibernate.dialect.Oracle9Dialect
</property>
<!-- 可以防表被重新建立 -->
<property name="hibernate.hbm2ddl.auto">update</property>
<!-- 方便跟踪SQL执行，在hibernate.cfg.xml中加入 -->
<property name="hibernate.show_sql">true</property>
<mapping resource="mappings/Student.hbm.xml" />

</session-factory>
</hibernate-configuration>

7.src/hibernate.properties内容

hibernate.dialect=org.hibernate.dialect.Oracle9Dialect
hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
hibernate.connection.url=jdbc:oracle:thin:@127.0.0.1:1521:test
hibernate.connection.username=test
hibernate.connection.password=test
hibernate.show_sql=true

8.src/log4j.properties内容

log4j.rootLogger=DEBUG,CONSOLE,FILE
log4j.addivity.org.apache=true