Hibernate单表操作

单表操作是Hibernate中的最简单的操作了。因此简单的说明一下。

首先编写hibernate.cfg.xml文件

<?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="connection.username">user</property>
<property name="connection.url">db2...</property>
<property name="connection.password">pswd</property>
<property name="dialect">org.hibernate.dialect.DB2Dialect</property>
<property name="connection.driver_class">com.ibm.db2.jcc.DB2Driver</property>
<property name="show_sql">true</property>
<property name="hibernate.hbm2ddl.auto">update</property>
<mapping resource="bean/ZqTest.hbm.xml"/>
</session-factory>

</hibernate-configuration>

编写bean（略） 和 对应的 hbm.xml文件

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="bean.ZqTest" table="ZQTEST">
<id name="id" column="ID" type="int">
<generator class="increment"/>
</id>
<property name="name" column="NAME" type="string" not-null="true"/>
<property name="age" column="AGE" type="int" not-null="true"/>
</class>
</hibernate-mapping>

这就是一个最简单的hibernate映射

以下是测试代码

Configuration config = new Configuration().configure();
SessionFactory sessionFactory = config.buildSessionFactory();
Session session = sessionFactory.openSession();

Transaction tx = null;

tx = session.beginTransaction();

//创建一个新的实例
ZqTest z = new ZqTest();
z.setName("dd");
z.setAge(80);

//保存
//session.save(z);

//检索
List testlist = session.createQuery("from ZqTest").list();
Iterator it = testlist.iterator();

//打印出查询结果的个数
System.out.println("append:"+testlist.size());

//迭代出所有的查询内容
while(it.hasNext())
{
ZqTest test = (ZqTest)it.next();
System.out.print("ID:" + test.getId());
System.out.print(" Name:" + test.getName());
System.out.println(" Age:" + test.getAge());
}

//检索一个
ZqTest zz = (ZqTest)session.load(ZqTest.class,3);
System.out.print(zz.getName());

//更新 这里直接将数据库中的内容进行更新操作
zz.setName("ffff");
//session.saveOrUpdate(zz);
tx.commit();