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.5MyEclipse 5.5.1 GA:C:/Program Files/MyEclipse 5.5.1 GAjdk1.5.0_15:C:/Program Files/Java/jdk1.5.0_15jre1.5.0_15:C:/Program Files/Java/jre1.5.0_15Oracle9i:E:/oracle/ora90log4j: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.sql2.src/db/StudentSequence.sql3.src/mappings/Student.hbm.xml4.src/model/Student.java5.src/test/TestStudent.sql6.src/hibernate.cfg.xml7.src/hibernate.properties8.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 1START WITH 1000NOMAXVALUENOCYCLECACHE 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.Oracle9Dialecthibernate.connection.driver_class=oracle.jdbc.driver.OracleDriverhibernate.connection.url=jdbc:oracle:thin:@127.0.0.1:1521:testhibernate.connection.username=testhibernate.connection.password=testhibernate.show_sql=true

8.src/log4j.properties内容

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