Hibernate的性能优化之 dynamic-update dynamic-insert
Guestbook.java
代码：
package com.b510.examples;
import java.util.Date;
public class Guestbook implements java.io.Serializable {
private static final long serialVersionUID = -7004492417383895995L;
private Integer id;
private String name;
private String email;
private String phone;
private String title;
private String content;
private Date createdTime;
private Integer version;
// Constructors
/**
* @return the version
*/
public Integer getVersion() {
return version;
}
/**
* @param version
* the version to set
*/
public void setVersion(Integer version) {
this.version = version;
}
/**
* @return the name
*/
public String getName() {
return name;
}
public Integer getId() {
return this.id;
}
public void setId(Integer id) {
this.id = id;
}
/**
* @param name
* the name to set
*/
public void setName(String name) {
this.name = name;
}
/**
* @return the email
*/
public String getEmail() {
return email;
}
/**
* @param email
* the email to set
*/
public void setEmail(String email) {
this.email = email;
}
/**
* @return the phone
*/
public String getPhone() {
return phone;
}
/**
* @param phone
* the phone to set
*/
public void setPhone(String phone) {
this.phone = phone;
}
/**
* @return the title
*/
public String getTitle() {
return title;
}
/**
* @param title
* the title to set
*/
public void setTitle(String title) {
this.title = title;
}
/**
* @return the content
*/
public String getContent() {
return content;
}
/**
* @param content
* the content to set
*/
public void setContent(String content) {
this.content = content;
}
/**
* @return the createdTime
*/
public Date getCreatedTime() {
return createdTime;
}
/**
* @param createdTime
* the createdTime to set
*/
public void setCreatedTime(Date createdTime) {
this.createdTime = createdTime;
}
/** default constructor */
public Guestbook() {
}
}
Guestbook.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="com.b510.examples.Guestbook" table="guestbook"
catalog="users" optimistic-lock="version">
<id name="id" type="java.lang.Integer">
<column name="id" />
<generator class="increment" />
</id>
<version name="version" column="version" access="field"></version>
<property name="name" type="java.lang.String">
<column name="name" length="200" />
</property>
<property name="email" type="java.lang.String">
<column name="email" length="50" />
</property>
<property name="phone" type="java.lang.String">
<column name="phone" length="20" />
</property>
<property name="title" type="java.lang.String">
<column name="title" length="200" />
</property>
<property name="content" type="java.lang.String">
<column name="content" length="1000" />
</property>
<property name="createdTime" type="java.util.Date">
<column name="created_time" length="10" />
</property>
</class>
</hibernate-mapping>
测试代码：
HibernateTest.java
代码：
/**
*
*/
package com.b510.examples;
import org.hibernate.Session;
/**
*
* @author XHW
*
* @date 2011-7-18
*
*/
public class HibernateTest {
public static void main(String[] args) {
new HibernateTest().update();
}
public void update(){
Session session=HibernateSessionFactoryUtil.getSessionFactory().getCurrentSession();
session.beginTransaction();
Guestbook gb=(Guestbook)session.get(Guestbook.class, 2);
System.out.println(gb.getName());
gb.setName("北京");
System.out.println("----------------------------");
gb=(Guestbook)session.get(Guestbook.class, 2);
System.out.println(gb.getName());
session.getTransaction().commit();
}
}
运行效果：
log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Hibernate:
select
guestbook0_.id as id0_0_,
guestbook0_.version as version0_0_,
guestbook0_.name as name0_0_,
guestbook0_.email as email0_0_,
guestbook0_.phone as phone0_0_,
guestbook0_.title as title0_0_,
guestbook0_.content as content0_0_,
guestbook0_.created_time as created8_0_0_
from
users.guestbook guestbook0_
where
guestbook0_.id=?
广州
----------------------------
北京
Hibernate:
update
users.guestbook
set
version=?,
name=?,
email=?,
phone=?,
title=?,
content=?,
created_time=?
where
id=?
and version=?
我们看到的是我们只是跟新的是Guestbook对象的name属性值，但是呢，一个update语句却是
把所有的属性都给跟新了一遍，这样不就是很浪费时间吗？
怎样做才可以让Hibernate只是跟新我们所关注的东西，而不是我们所关注的东西，就不要去跟新他?
有一个办法可行滴！
Guestbook.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="com.b510.examples.Guestbook" table="guestbook"
catalog="users" optimistic-lock="version" dynamic-update="true"> <!-- 在这里加入动态跟新-->
<id name="id" type="java.lang.Integer">
<column name="id" />
<generator class="increment" />
</id>
<version name="version" column="version" access="field"></version>
<property name="name" type="java.lang.String">
<column name="name" length="200" />
</property>
<property name="email" type="java.lang.String">
<column name="email" length="50" />
</property>
<property name="phone" type="java.lang.String">
<column name="phone" length="20" />
</property>
<property name="title" type="java.lang.String">
<column name="title" length="200" />
</property>
<property name="content" type="java.lang.String">
<column name="content" length="1000" />
</property>
<property name="createdTime" type="java.util.Date">
<column name="created_time" length="10" />
</property>
</class>
</hibernate-mapping>
同样的测试代码：
运行效果：
log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Hibernate:
select
guestbook0_.id as id0_0_,
guestbook0_.version as version0_0_,
guestbook0_.name as name0_0_,
guestbook0_.email as email0_0_,
guestbook0_.phone as phone0_0_,
guestbook0_.title as title0_0_,
guestbook0_.content as content0_0_,
guestbook0_.created_time as created8_0_0_
from
users.guestbook guestbook0_
where
guestbook0_.id=?
广州
----------------------------
北京
Hibernate:
update
users.guestbook
set
version=?,
name=?
where
id=?
and version=?
我们看到这里显示的是跟新name和version属性
测试二：
HibernateTest.java
代码：
/**
*
*/
package com.b510.examples;
import org.hibernate.Session;
/**
*
* @author XHW
*
* @date 2011-7-18
*
*/
public class HibernateTest {
public static void main(String[] args) {
new HibernateTest().update();
}
public void update(){
Session session=HibernateSessionFactoryUtil.getSessionFactory().getCurrentSession();
session.beginTransaction();
Guestbook gb=new Guestbook();
gb.setName("南京");
gb.setPhone("119");
gb.setTitle("hello world!");
session.save(gb);
session.getTransaction().commit();
}
}
运行代码：
log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Hibernate:
select
max(id)
from
guestbook
Hibernate:
insert
into
users.guestbook
(version, name, email, phone, title, content, created_time, id)
values
(?, ?, ?, ?, ?, ?, ?, ?)
我们会发现一个问题，那就是，我们只是插入了name,phone,title属性值，但是，insert语句却同时把
其他的东西也给添加了进去，我们是不希望看到这样的结果的，要解决这样的问题，我们同样有办法滴！
Guestbook.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="com.b510.examples.Guestbook" table="guestbook"
catalog="users" optimistic-lock="version" dynamic-update="true" dynamic-insert="true"> 动态插入数据
<id name="id" type="java.lang.Integer">
<column name="id" />
<generator class="increment" />
</id>
<version name="version" column="version" access="field"></version>
<property name="name" type="java.lang.String">
<column name="name" length="200" />
</property>
<property name="email" type="java.lang.String">
<column name="email" length="50" />
</property>
<property name="phone" type="java.lang.String">
<column name="phone" length="20" />
</property>
<property name="title" type="java.lang.String">
<column name="title" length="200" />
</property>
<property name="content" type="java.lang.String">
<column name="content" length="1000" />
</property>
<property name="createdTime" type="java.util.Date">
<column name="created_time" length="10" />
</property>
</class>
</hibernate-mapping>
运行效果：
log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Hibernate:
select
max(id)
from
guestbook
Hibernate:
insert
into
users.guestbook
(version, name, phone, title, id)
values
(?, ?, ?, ?, ?)
这样就达到了我们的预期要求， 要说明的是：version属性是不可为空的，所以我们没有设置值的时候，Hibernate也会给我们添加记录的
