1.建立項目,項目名稱hibernatedemo5,目錄結構如圖所示 Hibernate5-動态參數綁定 2.在項目中建立lib目錄存儲jar檔案,目錄結構如圖所示 Hibernate5-動态參數綁定 3.在src目錄中建立實體Bean Forum,包名(com.mycompany.demo.bean),如圖所示 Hibernate5-動态參數綁定 4.實體Bean Forum的内容如下 package com.mycompany.demo.bean;
public class Forum {
private int fid;
private String name;
public Forum() {
super();
}
public Forum(String name) {
super();
this.name = name;
}
public int getFid() {
return fid;
}
public void setFid(int fid) {
this.fid = fid;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
@Override
public int hashCode() {
final int prime = 31;
int result = 1;
result = prime * result + fid;
result = prime * result + ((name == null) ? 0 : name.hashCode());
return result;
}
@Override
public boolean equals(Object obj) {
if (this == obj)
return true;
if (obj == null)
return false;
if (getClass() != obj.getClass())
return false;
Forum other = (Forum) obj;
if (fid != other.fid)
return false;
if (name == null) {
if (other.name != null)
return false;
} else if (!name.equals(other.name))
return false;
return true;
}
}
5.在src目錄中建立實體Bean Forum的映射檔案Forum.hbm.xml,包名(com.mycompany.demo.bean),如圖所示 Hibernate5-動态參數綁定 6.映射檔案Forum.hbm.xml的内容如下 <?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<!--
package:指定<class/>所在的包
-->
<hibernate-mapping package="com.mycompany.demo.bean">
<!--
name:類名
table:表名
catalog:資料庫名稱,預設為hibernate.cfg.xml中配置的資料庫名稱
-->
<class name="Forum" table="hnsq_forum" catalog="b_shequ_two">
<meta attribute="class-description">
This class contains the forum detail.
</meta>
<!--
name:屬性名
colum:列名
-->
<id name="fid" type="int" column="fid">
<!--
increment:hibernate維護主鍵值
identity:資料庫自增長
sequence:序列
native:根據不同的資料庫選擇生成政策
uuid:通過UUID算法生成,實際使用較多
assigned:手工設定
-->
<generator class="native"/>
</id>
<!--
length:位元組長度
type:字段類型,支援java和hibernate類型
not-null:非空限制
unique:唯一性限制
-->
<property name="name" column="name" type="string" length="50" not-null="true" unique="false"/>
</class>
</hibernate-mapping>
7.在src目錄中建立工具類 HbnUtil,包名(com.mycompany.demo.util),如圖所示 Hibernate5-動态參數綁定 8.工具類 HbnUtil的内容如下 package com.mycompany.demo.util;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
public class HbnUtil {
private static SessionFactory sessionFactory;
public static Session getSession(){
if(sessionFactory == null || sessionFactory.isClosed()){
sessionFactory = new Configuration().configure().buildSessionFactory();
}
return sessionFactory.getCurrentSession();
}
}
9.在src目錄中建立Hibernate的配置檔案hibernate.cfg.xml,如圖所示 Hibernate5-動态參數綁定 10.Hibernate的配置檔案hibernate.cfg.xml的内容如下 <?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-configuration SYSTEM
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<!-- 方言,可以從Hibernate核心jar(hibernate-core-x.x.x.Finall.jar)
檔案中的or.hibernate.dialect包中找到相應的類,類的全名就是 -->
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<!-- 驅動 -->
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<!-- 資料庫連接配接位址 -->
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/b_shequ_two</property>
<!-- 使用者名 -->
<property name="hibernate.connection.username">
root
</property>
<!-- 密碼 -->
<property name="hibernate.connection.password"></property>
<!--
create:每次都新建立,如果存在就删除
create-drop:建立新表,sessionFactory關閉,表會删除
update :表字段增加,會同步,字段減少不同步,資料改變會同步修改
-->
<property name="hibernate.hbm2ddl.auto">update</property>
<!-- 輸出sql -->
<property name="hibernate.show_sql">true</property>
<!-- 格式化sql -->
<property name="hibernate.format_sql">true</property>
<!-- 事務環境一個線程對一個事務
thread:本地事務環境
jta:分布式事務環境
SpringSessionContext:用于ssh整合
-->
<property name="hibernate.current_session_context_class">thread</property>
<!-- 使用c3p0資料源 -->
<property name="hibernate.connection.provider_class">
org.hibernate.c3p0.internal.C3P0ConnectionProvider
</property>
<!-- List of XML mapping files -->
<mapping resource="com/mycompany/demo/bean/Forum.hbm.xml"/>
</session-factory>
</hibernate-configuration>
11.在項目中建立test目錄存儲測試檔案,檔案名稱ManageForum,包名(com.mycompany.demo.bean),目錄結構如圖所示 12.ManageForum測試類的内容如下 package com.mycompany.demo.bean;
import java.util.List;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Restrictions;
import org.junit.Before;
import org.junit.Test;
import com.mycompany.demo.util.HbnUtil;
public class ManageForum {
private Session session;
@Before
public void init(){
session = HbnUtil.getSession();
}
/*
* 動态參數綁定查詢-SQL-"?"号占位方式-setXxx(int position,Object value)方法綁定參數
*/
@Test
public void testSetXxxForSQL(){
try {
session.beginTransaction();
String sql = "SELECT * FROM hnsq_forum where fid > ? AND fid < ?";
List<Forum> forums = session.createSQLQuery(sql).addEntity(Forum.class)
.setInteger(0, 20).setInteger(1, 50).list();
for (Forum forum : forums) {
System.out.println(forum.getName());
}
session.getTransaction().commit();
} catch (Exception e) {
session.getTransaction().rollback();
e.printStackTrace();
}
}
/*
* 動态參數綁定查詢-SQL-"?"号占位方式-setParamter(int position,Object value)
*/
@Test
public void testSetParamterForSQL(){
try {
session.beginTransaction();
String sql = "SELECT * FROM hnsq_forum where fid > ? AND fid < ?";
List<Forum> forums = session.createSQLQuery(sql).addEntity(Forum.class)
.setParameter(0, 20)
.setParameter(1, 50)
.list();
for (Forum forum : forums) {
System.out.println(forum.getName());
}
session.getTransaction().commit();
} catch (Exception e) {
session.getTransaction().rollback();
e.printStackTrace();
}
}
/*
* 動态參數綁定-SQL-":别名"占位-setParamter(String name,Object value)
*/
@Test
public void testAliasForSQL(){
try {
session.beginTransaction();
String sql = "SELECT * FROM hnsq_forum WHERE fid > :lfid AND fid < :gfid";
List<Forum> forums = session.createSQLQuery(sql).addEntity(Forum.class)
.setParameter("lfid", 20)
.setParameter("gfid", 50)
.list();
for (Forum forum : forums) {
System.out.println(forum.getName());
}
session.getTransaction().commit();
} catch (Exception e) {
session.getTransaction().rollback();
e.printStackTrace();
}
}
/*
* 動态參數綁定-HQL-"?"号占位方式-setParamter(int position,Object value)
*/
@Test
public void testSetXxxForHQL(){
try {
session.beginTransaction();
String sql = "FROM Forum WHERE fid > ? AND fid < ?";
List<Forum> forums = session.createQuery(sql)
.setInteger(0, 20).setInteger(1, 50).list();
for (Forum forum : forums) {
System.out.println(forum.getName());
}
session.getTransaction().commit();
} catch (Exception e) {
session.getTransaction().rollback();
e.printStackTrace();
}
}
/*
* 動态參數綁定查詢-HQL-"?"号占位方式-setParamter(int position,Object value)
*/
@Test
public void testSetParamterForHQL(){
try {
session.beginTransaction();
String sql = "FROM Forum WHERE fid > ? AND fid < ?";
List<Forum> forums = session.createQuery(sql)
.setParameter(0, 20)
.setParameter(1, 50)
.list();
for (Forum forum : forums) {
System.out.println(forum.getName());
}
session.getTransaction().commit();
} catch (Exception e) {
session.getTransaction().rollback();
e.printStackTrace();
}
}
/*
* 動态參數綁定-HQL-":别名"占位-setParamter(String name,Object value)
*/
@Test
public void testAliasForHQL(){
try {
session.beginTransaction();
String sql = "FROM Forum WHERE fid > :lfid AND fid < :gfid";
List<Forum> forums = session.createQuery(sql)
.setParameter("lfid", 20)
.setParameter("gfid", 50)
.list();
for (Forum forum : forums) {
System.out.println(forum.getName());
}
session.getTransaction().commit();
} catch (Exception e) {
session.getTransaction().rollback();
e.printStackTrace();
}
}
/*
* 動态參數綁定-QBC-Restrictions
*/
@Test
public void testParamterQBC(){
try {
session.beginTransaction();
List<Forum> forums = session.createCriteria(Forum.class)
.add(Restrictions.gt("fid", 20))
.add(Restrictions.lt("fid", 50))
.list();
for (Forum forum : forums) {
System.out.println(forum.getName());
}
session.getTransaction().commit();
} catch (HibernateException e) {
session.getTransaction().rollback();
e.printStackTrace();
}
}
}