Java笔记8：Hibernate连接Oracle



1下载hibernate-3.6.0 Final.zip到任意目录，解压缩后得到hibernate目录

 

2下载slf4j-1.7.13.zip到任意目录，解压缩后得到slf4j-1.7.13

 

3操作数据库

sqlplus system/oracle

创建表

create table Student

(
 Student_ID  number(6) NOT NULLPRIMARY KEY,
 Student_Name varchar2(10) NOT NULL,
 Student_Age number(2) NOT NULL
);

创建序列号用于给表Student的Student_ID赋值

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

 

4新建一个名为Hiber的工程

 

5添加包

添加hibernate\jar中的所有包

 

添加slf4j-1.7.13中的slf4j-nop-1.7.13.jar

 

添加oracle的jdbc驱动程序ojdbc6.jar

 

添加完成后

6 添加两个配置文件和两个类

（1）hibernate.cfg.xml

<!DOCTYPE hibernate-configuration PUBLIC
 "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
 "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
    <!--程序执行的时候是否显示真正的sql语句-->
    <property name="show_sql">true</property>
    <!--使用的SQL对应的“方言”，此处是Oracle11的“方言”-->
    <property name="dialect">org.hibernate.dialect.OracleDialect
    </property>
    <!--连接数据库的Driver-->
    <property name="connection.driver_class">
        oracle.jdbc.driver.OracleDriver
    </property>
    <!--数据库连接url-->
    <property name="connection.url">
        jdbc:oracle:thin:@localhost:1521:orcl
    </property>
    <!--用户名-->
    <property name="connection.username">system</property>
    <!--密码-->
    <property name="connection.password">oracle</property>
    <mapping resource="Student.hbm.xml"/>
</session-factory>
</hibernate-configuration>

（2）Student.java

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;
    }
}

（3）Student.hbm.xml

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

 

（4）Test.java

importorg.hibernate.*;
import org.hibernate.cfg.*;

public class Test
{
    public static voidmain(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("zhangsan");
            stu.setStudent_age(18);
            //通过session的save()方法将Student对象保存到数据库中
            session.save(stu);
            //提交事务
            tx.commit();
            //关闭会话
            session.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
    }
}

 

7 验证

（1）运行Test.java，结果为

Hibernate: select student_sequence.nextvalfrom dual

Hibernate: insert into Student(Student_Name, Student_Age, student_id) values (?, ?, ?)

 

（2）从Oracle数据库中查询