1. Person.hbm.xml
<?xml version="1.0" encoding="GBK"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="test">
<class name="Person" table="person_inf">
<id name="id" column="id">
<!-- 定义主键生成器策略 -->
<generator class="identity"/>
</id>
<property name="name" type="string"/>
<many-to-one name="address" cascade="all" class="Address" column="address_id" lazy="false"/>
</class>
<query name="myNamedQuery">
from Person p where p.address.name = ?
</query>
</hibernate-mapping>
2. Address.hbm.xml
<?xml version="1.0" encoding="GBK"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="test">
<class name="Address" table="address_inf">
<id name="id" column="id">
<generator class="identity"/>
</id>
<property name="name"/>
</class>
</hibernate-mapping>
3. 查询
package test;
import java.util.Iterator;
import java.util.List;
import org.hibernate.Transaction;
import org.hibernate.Session;
public class PersonManager{
public static void main(String[] args){
PersonManager mgr = new PersonManager();
mgr.testPerson();
HibernateUtil.sessionFactory.close();
}
private void testPerson(){
Session session = HibernateUtil.currentSession();
Transaction tx = session.beginTransaction();
// 1. 显式连接
List p1 = session.createQuery("select p from Person p join p.address a where a.name=:addressname")
.setString("addressname", "address111")
.list();
for(Iterator pit = p1.iterator(); pit.hasNext();){
Person p = (Person)pit.next();
System.out.println(p.getName() + "----1-----" + p.getAddress().getName());
}
// 2. 隐式连接
List p2 = session.createQuery("select p from Person p where p.address.name=:addressname")
.setString("addressname", "address111")
.list();
for(Iterator pit = p2.iterator(); pit.hasNext();){
Person p = (Person)pit.next();
System.out.println(p.getName() + "----2-----" + p.getAddress().getName());
}
// 3. 直接返回Person数组
List<Person> p3 = session.createQuery("select p from Person p where p.address.name=:addressname")
.setString("addressname", "address111")
.list();
for(Person p: p3){
System.out.println(p.getName() + "----3-----" + p.getAddress().getName());
}
// 4. 聚集函数(avg、count、max、min、sum)
List p4 = session.createQuery("select count(p) from Person p join p.address a").list();
System.out.println(p4.get(0));
// 5. 命名查询,将hql语句放在hbm文件里
List<Person> p5 = session.getNamedQuery("myNamedQuery")
.setString(0, "address111")
.list();
for(Person p: p5){
System.out.println(p.getName() + "----5-----" + p.getAddress().getName());
}
tx.commit();
HibernateUtil.closeSession();
}
}