【Hibernate】---Query、Criteria、SQLQuery

一、核心配置文件

<?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">
<hibernate-configuration>
    <session-factory>
        <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="hibernate.connection.password">root</property>
        <property name="hibernate.connection.url">jdbc:mysql:///test</property>
        <property name="hibernate.connection.username">root</property>
        
        <property name="hibernate.show_sql">true</property>
        <property name="hibernate.format_sql">true</property>
        <property name="hibernate.hbm2ddl.auto">update</property>
        <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
        
        <property name="current_session_context_class">thread</property>

        <mapping resource="com/chinasofti/entity/EUser.hbm.xml"/>
        
    </session-factory>
</hibernate-configuration>

二、实体类

package com.chinasofti.entity;

public class EUser {
    private int id;
    private String username;
    private String password;

    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }
    public String getPassword() {
        return password;
    }
    public void setPassword(String password) {
        this.password = password;
    }
    @Override
    public String toString() {
        return "EUser [id=" + id + ", username=" + username + ", password="
                + password + "]";
    }
    
}

三、映射文件

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2017-8-10 10:27:23 by Hibernate Tools 3.4.0.CR1 -->
<hibernate-mapping>
    <class name="com.chinasofti.entity.EUser" table="EUSER">
        <id name="id" type="int">
            <column name="ID" />
            <generator class="native" />
        </id>
        <property name="username" type="java.lang.String">
            <column name="USERNAME" />
        </property>
        <property name="password" type="java.lang.String">
            <column name="PASSWORD" />
        </property>
    </class>
</hibernate-mapping>

四、封装类

package com.chinasofti.entity;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

public class HibernateUtil {
    static Configuration CONFIGURATION = null;
    static SessionFactory SESSION_FACTORY = null;
    static Session SESSION = null;
    static{
        CONFIGURATION = new Configuration();
        CONFIGURATION.configure();
        SESSION_FACTORY = CONFIGURATION.buildSessionFactory();
        SESSION    = SESSION_FACTORY.openSession();
    }
    public static SessionFactory getSessionFactory(){
        return SESSION_FACTORY;
    }
    public static Session openSession(){
        return SESSION;
    }
}

五、测试类

package com.chinasofti.test;

import java.util.List;

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

import com.chinasofti.entity.EUser;
import com.chinasofti.entity.HibernateUtil;

public class TestHibernateTestQuery {

    @Test
    public void TestQuery(){
        Session session = HibernateUtil.openSession();
        Query query = session.createQuery("from EUser");
        List<EUser> list = query.list();
        for (EUser eUser : list) {
            System.out.println(eUser.getUsername());
        }
    }

    
    @Test
    public void TestCriteriaQuery(){
        Session session = HibernateUtil.openSession();
        Criteria criteria = session.createCriteria(EUser.class);
        List<EUser> list = criteria.list();
        for (EUser eUser : list) {
            System.out.println(eUser.getUsername());
        }
    }
    @Test
    public void TestSqlQuery(){
        Session session = HibernateUtil.openSession();
        //创建SQLQuery对象
        SQLQuery sQLQuery = session.createSQLQuery("select * from euser");
        //添加一个实体类
        sQLQuery.addEntity(EUser.class);
        List<EUser> list = sQLQuery.list();
        for (EUser eUsers : list) {
            System.out.println(eUsers.getUsername());
        }
    }
    
    
    @Test
    public void testRollback(){
        Session session=null;
        //注意：先查询再修改
        Transaction transaction=null;
        try {
            session = HibernateUtil.openSession();
            transaction = session.beginTransaction();
            EUser user = session.get(EUser.class, 4);
            //给user对象设置新的值
            user.setUsername("滚回来");
            session.save(user);
            System.out.println(10/0);
            transaction.commit();
            //注意：mysql和oracle数据不一样，如果这里操作的是oracle，这里数据就不会变。因为mysql是自动提交的（默认）
        } catch (Exception e) {
            // TODO Auto-generated catch block
            transaction.rollback();
        }finally{
            session.close();
        }
    }

    
}

之前Hibernate API的使用（Query、Criteria、SQLQuery对象） 没有附代码    今天补上