hibernate实现对Oracle数据库的增删改查

package com.itheima.domain;

import java.io.Serializable;
/**
 * 客户的实体类
 * @author zhang
 *
 */
public class Customer implements Serializable {

    private Long custId;
    private String custName;
    private String custSource;
    private String custIndustry;
    private String custLevel;
    private String custAddress;
    private String custPhone;
    public Long getCustId() {
        return custId;
    }
    public void setCustId(Long custId) {
        this.custId = custId;
    }
    public String getCustName() {
        return custName;
    }
    public void setCustName(String custName) {
        this.custName = custName;
    }
    public String getCustSource() {
        return custSource;
    }
    public void setCustSource(String custSource) {
        this.custSource = custSource;
    }
    public String getCustIndustry() {
        return custIndustry;
    }
    public void setCustIndustry(String custIndustry) {
        this.custIndustry = custIndustry;
    }
    public String getCustLevel() {
        return custLevel;
    }
    public void setCustLevel(String custLevel) {
        this.custLevel = custLevel;
    }
    public String getCustAddress() {
        return custAddress;
    }
    public void setCustAddress(String custAddress) {
        this.custAddress = custAddress;
    }
    public String getCustPhone() {
        return custPhone;
    }
    public void setCustPhone(String custPhone) {
        this.custPhone = custPhone;
    }
    @Override
    public String toString() {
        return "Customer [custId=" + custId + ", custName=" + custName + ", custSource=" + custSource
                + ", custIndustry=" + custIndustry + ", custLevel=" + custLevel + ", custAddress=" + custAddress
                + ", custPhone=" + custPhone + "]";
    }
    
    
    
}

<?xml version="1.0" encoding="UTF-8"?>
<!-- 在实体类所在的包下，创建一个xml文件。该文件建议名称为：实体类名称+.hbm+.xml 
导入约束：dtd约束
-->
<!DOCTYPE hibernate-mapping PUBLIC 
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.itheima.domain">
    <class name="Customer" table="Customer">
        <id name="custId" column="cust_id">
            <!-- generator：是指定主键的生成方式。取值是固定的几个之中选一个
                native是使用本地数据库的自动增长能力。
             -->
            <generator class="native"></generator>
        </id>
        <property name="custName" column="cust_name"></property>
        <property name="custSource" column="cust_source"></property>
        <property name="custIndustry" column="cust_industry"></property>
        <property name="custLevel" column="cust_level"></property>
        <property name="custAddress" column="cust_address"></property>
        <property name="custPhone" column="cust_phone"></property>
    </class>
</hibernate-mapping>

package com.itheima.utils;

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

/**
 * 抽取hibernate的工具类
 * @author zhy
 *
 */
public class HibernateUtil {

    private static SessionFactory factory;
    
    //了解：hibernate把可以预见的异常都转成了运行时异常
    static{
        try {
            Configuration cfg = new Configuration();
            cfg.configure();
            factory = cfg.buildSessionFactory();
            //System.out.println(factory);
        } catch (ExceptionInInitializerError e) {
            throw new ExceptionInInitializerError("初始化SessionFactory失败，请检查配置文件");
        }
    }
    
    /**
     * 获取一个新的Session对象
     * @return
     */
    public static Session openSession(){
        return factory.openSession();
    }
}

package com.itheima.test;

import java.util.List;

import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.junit.Test;

import com.itheima.domain.Customer;
import com.itheima.utils.HibernateUtil;

/**
 * hibernate的CRUD操作
 *     
 * 
 *
 */
public class Demo {
    
    //关于事务的回滚问题
    @Test
    public void testSave1(){//向数据库中添加信息
        Customer c = new Customer();
        c.setCustName("测试保存功能1");
        c.setCustAddress("铁道大学");
        c.setCustIndustry("教学");
        c.setCustLevel("一般");
        c.setCustPhone("12452335232");
        c.setCustSource("河北省");
        
        Transaction tx = null;
        Session s = null;
        try{
            s = HibernateUtil.openSession();
            tx = s.beginTransaction();
            //保存客户
            s.save(c);
            tx.commit();
        }catch(Exception e){
            tx.rollback();
        }finally{
            s.close();
        }
    }
    
    
    
    
    
    @Test
    public void testFindOne(){//查找
        Session s = HibernateUtil.openSession();
        Transaction tx = s.beginTransaction();
        //查询id为5的客户
        Customer c = s.get(Customer.class, 3L);
        System.out.println(c);
        tx.commit();
        s.close();
    }
    
    
    @Test
    public void testUpdate(){//数据更新操作
        Session s = HibernateUtil.openSession();
        Transaction tx = s.beginTransaction();
        //查询id为5的客户
        Customer c = s.get(Customer.class, 3L);
        //修改客户的地址为：北京市顺义区
        c.setCustAddress("石家庄铁道大学");
        c.setCustAddress("铁道大学更新");
        c.setCustIndustry("教学更新");
        c.setCustLevel("一般更新");
        c.setCustPhone("12452335232更新");
        c.setCustSource("河北省更新");
        //执行更新
        s.update(c);
        tx.commit();
        s.close();
    }
    
    @Test
    public void testDelete(){//删除数据记录
        Session s = HibernateUtil.openSession();
        Transaction tx = s.beginTransaction();
        //查询id为4的客户
        Customer c = s.get(Customer.class, 4L);
        //删除id为4
        s.delete(c);
        tx.commit();
        s.close();
    }
    
    @Test
    public void testFindAll(){//按条件查找信息
        Session s = HibernateUtil.openSession();
        Transaction tx = s.beginTransaction();
        //使用session对象，获取一个查询对象Query
        SQLQuery sqlquery = s.createSQLQuery("select * from demo where  cust_id= ? and cust_source= ? ");
        //使用sqlquery对象获取结果集
        //sqlquery.setParameter(0, "河北省");
        sqlquery.setParameter(0, 6l);
        sqlquery.setParameter(1, "河北省");
        List<Object[]> list = sqlquery.list();
        for(Object[] os : list){
            System.out.println("------------数组中的内容-----------");
            for(Object o : os){
                System.out.println(o);
            }
        }
        tx.commit();
        s.close();
    }
}