<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD//EN"
        "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <!--創(chuàng)建數(shù)據(jù)源-->
    <session-factory>
        <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="connection.url">jdbc:mysql://127.0.0.1:3306/MySql</property>
        <property name="connection.username">root</property>
        <property name="connection.password">root</property>
        <!-- SQL 方言 -->
        <property name="dialect">org.hibernate.dialect.OracleDialect</property>

        <!-- 是否顯示SQL -->
        <property name="show_sql">true</property>
        <!-- 實(shí)現(xiàn)格式化的sql -->
        <property name="format_sql">true</property>

        <!-- 是否自動生成對象
     create 表示每次都重新建立所需對象
     update表示如果有就直接使用，如果修改則更新，如果沒有則創(chuàng)建
     <property name="hbm2ddl.auto">update</property>
     -->
        <!--配置hibernate映射文件  -->
         <!--配置映射文件-->
        <mapping resource="com/zrrd/mapper/Dept.hbm.xml"></mapping>
    </session-factory>
</hibernate-configuration>

package com.zrrd.vo;

public class Dept {
    private Integer deptno;
    private String dname;
    private String loc;

    public Integer getDeptno() {
        return deptno;
    }

    public void setDeptno(Integer deptno) {
        this.deptno = deptno;
    }

    public String getDname() {
        return dname;
    }

    public void setDname(String dname) {
        this.dname = dname;
    }

    public String getLoc() {
        return loc;
    }

    public void setLoc(String loc) {
        this.loc = loc;
    }
    //直接轉(zhuǎn)換，看著方便
    @Override
    public String toString() {
        return "Dept{" +
                "deptno=" + deptno +
                ", dname='" + dname + '\'' +
                ", loc='" + loc + '\'' +
                '}';
    }

    public Dept() {
        super();
    }
 
    public Dept(Integer deptno, String dname, String loc) {
        this.deptno = deptno;
        this.dname = dname;
        this.loc = loc;
    }
}

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC 
	"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
	"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- package="com.javashidai.hibernate001.domain" 指明持久化類所在的包 -->
<hibernate-mapping package="com.zrrd.vo">
	<!-- name="Dept" 表示類名 table="dept" 對應(yīng)的表名 -->
	<class name="Dept" table="dept" >
		<!-- 指明主鍵對應(yīng)的屬性和字段
		 name="deptno" 表示持久化類中的deptno對應(yīng)主鍵字段
		 column="deptno"表示是主鍵字段
		 -->
		<id name="deptno" column="deptno">
		   <!-- 主鍵生成策略 :序列 -->
			<generator class="sequence">
				<!-- 指明所需的序列名 -->
				<param name="sequence">SEQ_DEPT</param>
			</generator>
		</id>
		<!-- property指明非主鍵列  
		 name="dname"表示持久化類中的屬性名
		 length="14"指明數(shù)據(jù)庫中對應(yīng)字段接收的長度
		 column="dname" 指明對應(yīng)數(shù)據(jù)庫中的什么字段
		 type="string" 對應(yīng)的數(shù)據(jù)類型
		  -->
		<property name="dname" 	length="14"	column="dname" type="string"/>
		<property name="loc" length="13"	column="loc" type="string"/>
	</class>
	
</hibernate-mapping>

package com.zrrd.text;


import com.zrrd.vo.Dept;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

public class Text {
    public static void main(String[] args){
        //讀取Hibernate.cfg.xml配置文件
        Configuration configuration=new Configuration();
        configuration.configure("hibernate.cfg.xml");
        //創(chuàng)建sessionfactory工程
        SessionFactory sessionFactory=configuration.buildSessionFactory();
        //創(chuàng)建Session對象
        Session session=sessionFactory.openSession();
        //創(chuàng)建實(shí)體對象（與數(shù)據(jù)庫中表對應(yīng)的vo對象為實(shí)體對象,進(jìn)而操作數(shù)據(jù)庫（由Hibernate自動創(chuàng)建SQL語句）
        Dept dept=session.get(Dept.class,1);
        System.out.println(dept);

        session.close();
        sessionFactory.close();
    }
}

public class HibernateUtil {
	//一個Hibernate容器中只需要一個SessionFactory
	private static SessionFactory sessionFactory;
	//利用靜態(tài)代碼框創(chuàng)建SessionFactory對象
	static
	{
		//創(chuàng)建Configuration對象
		Configuration conf = new Configuration();
		//加載Hibernate配置文件
		conf.configure();//默認(rèn)加載src下的hibernate.cfg.xml
		//創(chuàng)建SessionFactory對象
		sessionFactory  = conf.buildSessionFactory();
	}
	//得到Session對象
	public static Session getSession()
	{
		return sessionFactory.openSession();
	}
}

public Dept selectOne(int deptno)
	{
		Dept dept= null;
		//得到session對象
		Session session = null;
		try
		{
			//得到Session對象
			session = HibernateUtil.getSession();
			//根據(jù)主鍵得到對應(yīng)的信息
			dept = (Dept) session.get(Dept.class, deptno);
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		finally
		{
			if(session != null)
			{
				session.close();
			}
		}
		return dept;
	}

public static List<Dept> queryDept()
	{
		List<Dept> deptList = null;
		//聲明session
		Session session = null;
		try
		{
			//創(chuàng)建Session對象
			session= HibernateUtil.getSession();
			//聲明HQL  ：其中Dept為實(shí)體類
			String hql="from Dept ";//from后寫的是類名
			//得到Query對象
			Query query = session.createQuery(hql);
			//執(zhí)行查詢
			deptList = query.list();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		finally
		{
			if(session != null)
			{
				session.close();
			}
		}
		return deptList;
	}

public List<Dept> queryDeptByLoc(String loc)
	{

		List<Dept> deptList = null;
		//聲明session
		Session session = null;
		try
		{
			//創(chuàng)建Session對象
			session= HibernateUtil.getSession();
			//聲明HQL  ：其中Dept為實(shí)體類
			String hql="from com.zrrd.vo.Dept where loc=:loc ";//:loc表示是參數(shù)
			//得到query對象
			Query query =  session.createQuery(hql);
			//給參數(shù)賦值
			query.setString("loc", loc);//給指定參數(shù)賦值
			//查詢返回List<Dept>
			deptList = query.list();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		finally
		{
			if(session != null)
			{
				session.close();
			}
		}
		return deptList;
	}

public void deleteDept(int deptno)
	{
		//聲明Session對象
		Session session = null;
		try
		{
			//得到Session對象
			session = HibernateUtil.getSession();
			//開啟事務(wù)保護(hù)
			Transaction  ta = session.beginTransaction();
			//根據(jù)id得到對應(yīng)的值
			Dept deleteObj = (Dept) session.get(Dept.class, deptno);
			//刪除該對應(yīng)
			session.delete(deleteObj);
			//提交事務(wù)
			ta.commit();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		finally
		{
			if(session != null)
			{
				session.close();
			}
		}
	}

/**
	 * 利用Hql進(jìn)行刪除
	 * 根據(jù)部門編號進(jìn)行刪除
	 */
	public int deleteDeptByLoc(String loc)
	{
		int result =0;
		//聲明Session對象
		Session session = null;
		try
		{
			//得到Session對象
			session = HibernateUtil.getSession();
			//開啟事務(wù)保護(hù)
			Transaction  ta = session.beginTransaction();
			//編寫刪除使用的HQL 這里的:loc表示參數(shù)名
			String hql="delete com.zrrd.vo.Dept where loc=:loc";
			//得到Query對象
			Query query =session.createQuery(hql);
			//給參數(shù)賦值
			query.setString("loc", loc);
			//執(zhí)行DML語句
			result = query.executeUpdate();
			//提交事務(wù)
			ta.commit();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		finally
		{
			if(session != null)
			{
				session.close();
			}
		}
		return result;
	}

public static void updateDept(Dept dept)
	{
		//聲明Session對象
		Session session = null;
		try
		{
			//得到Session對象
			session = HibernateUtil.getSession();
			//開啟事務(wù)保護(hù)
			Transaction  ta = session.beginTransaction();
			//根據(jù)持久化對象進(jìn)行修改
			session.update(dept);
			//提交事務(wù)
			ta.commit();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		finally
		{
			if(session != null)
			{
				session.close();
			}
		}
	}

public static int updateDeptLoc(String oldLoc,String newLoc)
	{
int result =0;
		//聲明Session對象
		Session session = null;
		try
		{
			//得到Session對象
			session = HibernateUtil.getSession();
			//開啟事務(wù)保護(hù)
			Transaction  ta = session.beginTransaction();
			//編寫刪除使用的HQL 這里的:loc表示參數(shù)名
			String hql="update Dept set loc=:newLoc where loc=:oldLoc";
			//得到Query對象
			Query query =session.createQuery(hql);
			//給參數(shù)賦值
			query.setString("newLoc", newLoc);
			query.setString("oldLoc", oldLoc);
			//執(zhí)行DML語句
			result = query.executeUpdate();
			//提交事務(wù)
			ta.commit();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		finally
		{
			if(session != null)
			{
				session.close();
			}
		}
		return result;
	}

	public static void saveDept(Dept dept)
	{
		Session session = null;
		try
		{
			//得到Session對象
			session = HibernateUtil.getSession();
			//得到事務(wù)對象
			Transaction ta = session.beginTransaction();
			//將持久化對象存入 數(shù)據(jù)庫
			session.save(dept);
			//提交事務(wù)
			ta.commit();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		finally
		{
			if(session != null)
			{
				session.close();
			}
		}
	}