20160419__第1课_第6课

1、

我封装的 操作Hibernate的类：

package hibernateOper;

import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

@SuppressWarnings("deprecation")
final public class ThibernateOper
{// ZC: 上面的"final"，让别人无法再继承该类
    public ThibernateOper()
    {}
    
    // 一般连接一个数据库，只用一个SessionFactory。
    private static SessionFactory FsessionFactory = null;
    static // 静态块，只会执行一次
    {
        // Configuration.configure() 中可以参入参数[hibernate.cfg.xml的文件名和路径]
        FsessionFactory = (new Configuration()).configure().buildSessionFactory();
    }
    
    public static SessionFactory GetSessionFactory()
    {
        return FsessionFactory;
    }
    
    public static void main(String[] args)
    {
    }
}

 

2、

对Oracle的简单操作：

package test;

import java.util.Date;

import hibernateOper.ThibernateOper;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;

import domain.Employee;

public class TTest
{
    public static void SimpleInsert()
    {
        SessionFactory sf = ThibernateOper.GetSessionFactory();
        Session session = sf.openSession();
        Transaction ts = session.beginTransaction();
        
        try
        {
            Employee e = new Employee();
            e.setName("zz");
            e.setEmail("zzz@163.com");
            e.setHiredate(new Date());
            
            session.save(e);
            ts.commit();
            session.close();
        }
        catch(Exception ex)
        {
            ts.rollback();
            if ( (session != null)&&(session.isOpen()) )
                session.close();
            ex.printStackTrace();
        }
    }
    
    public static void SimpleUpdate()
    {
        SessionFactory sf = ThibernateOper.GetSessionFactory();
        Session session = sf.openSession();
        Transaction ts = session.beginTransaction();
        
        try
        {
            // 强转
            Employee e = (Employee)session.load(Employee.class, 1);
            e.setName("zxcvb");
            
            ts.commit();
            session.close();
        }
        catch(Exception ex)
        {
            ts.rollback();
            if ( (session != null)&&(session.isOpen()) )
                session.close();
            ex.printStackTrace();
        }
    }
    
    public static void SimpleDelete()
    {
        SessionFactory sf = ThibernateOper.GetSessionFactory();
        Session session = sf.openSession();
        Transaction ts = session.beginTransaction();
        
        try
        {
            // 强转
            Employee e = (Employee)session.load(Employee.class, 2);
            e.setName("zxcvb");
            
            session.delete(e);
            ts.commit();
            session.close();
        }
        catch(Exception ex)
        {
            ts.rollback();
            if ( (session != null)&&(session.isOpen()) )
                session.close();
            ex.printStackTrace();
        }
    }
    
    public static void main(String[] args)
    {
        //SimpleInsert();
        //SimpleUpdate();
        SimpleDelete();
    }

}

 

 

 

 

 

3、

hibernate.cfg.xml

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>

    <session-factory>
        <property name="dialect">
            org.hibernate.dialect.Oracle10gDialect
        </property>
        <property name="connection.url">
            jdbc:oracle:thin:@localhost:1521:orcl
        </property>
        <property name="connection.username">scott</property>
        <property name="connection.password">tiger</property>
        <property name="connection.driver_class">
            oracle.jdbc.driver.OracleDriver
        </property>
        <property name="myeclipse.connection.profile">
            OracleLocal
        </property>
        <property name="show_sql">true</property>
        <property name="format_sql">true</property>
        <mapping resource="domain/Employee.hbm.xml" />

    </session-factory>

</hibernate-configuration>

 

4、

Employee.hbm.xml

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<!-- 
    Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
    <class name="domain.Employee" table="EMPLOYEE" schema="SCOTT">
        <id name="id" type="java.lang.Integer">
            <column name="ID" precision="22" scale="0" />
            <!-- 
            <generator class="assigned" />
             -->
             <generator class="sequence">
                 <param name="sequence">emp_seq</param>
             </generator>
        </id>
        <property name="name" type="java.lang.String">
            <column name="NAME" length="64" not-null="true" />
        </property>
        <property name="email" type="java.lang.String">
            <column name="EMAIL" length="64" not-null="true" />
        </property>
        <property name="hiredate" type="java.util.Date">
            <column name="HIREDATE" length="7" not-null="true" />
        </property>
    </class>
</hibernate-mapping>

 

5、

Employee.java

package domain;

import java.math.BigDecimal;
import java.util.Date;

/**
 * Employee entity. @author MyEclipse Persistence Tools
 */

public class Employee implements java.io.Serializable {

    // Fields

    private static final long serialVersionUID = 1L;
    
    //private BigDecimal id;
    private Integer id;
    private String name;
    private String email;
    private Date hiredate;

    // Constructors

    /** default constructor */
    public Employee() {
    }

    /** full constructor */
    public Employee(Integer id, String name, String email, Date hiredate) {
        this.id = id;
        this.name = name;
        this.email = email;
        this.hiredate = hiredate;
    }

    // Property accessors

    public Integer getId() {
        return this.id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return this.name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getEmail() {
        return this.email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public Date getHiredate() {
        return this.hiredate;
    }

    public void setHiredate(Date hiredate) {
        this.hiredate = hiredate;
    }

}

 

6、