hibernate之脏数据检查

脏数据检查：

什么是脏数据？脏数据并不是废弃和无用的数据，而是状态前后发生变化的数据。我们看下面的代码：

Transaction tx=session.beginTransaction();

//从数据库中加载符合条件的数据

User user=(User)session.load(User.class,”1”);

//改变了user对象的姓名属性，此时user对象成为了所谓的“脏数据”

user.setName(“zx”);

tx.commit();

当事务提交时，Hibernate会对session中的PO(持久化对象)进行检测，判断持久化对象的状态是否发生了改变，如果发生了改变就会将改变更新到数据库中,这种判断持久化对象状态称为脏查询。

---

禁止脏数据检查

---

pom.xml:

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>hibernateTest</groupId> <artifactId>hibernateTest</artifactId> <version>1.0-SNAPSHOT</version> <packaging>jar</packaging> <name>hibernateTest</name> <url>http://maven.apache.org</url> <dependencies> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>3.8.1</version> <scope>test</scope> </dependency> <dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-core</artifactId> <version>3.3.1.GA</version> </dependency> <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-nop</artifactId> <version>1.5.2</version> </dependency> <dependency> <groupId>javassist</groupId> <artifactId>javassist</artifactId> <version>3.4.GA</version> </dependency> <dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-proxool</artifactId> <version>3.3.1.GA</version> </dependency> <dependency> <groupId>com.oracle</groupId> <artifactId>ojdbc14</artifactId> <version>10.2.0.3.0</version> <scope>runtime</scope> </dependency> </dependencies> <build> <finalName>hibernateTest</finalName> <resources> <resource> <directory>src/main/resources</directory> </resource> <resource> <directory>src/main/java</directory> <excludes> <exclude>**/*.java</exclude> </excludes> </resource> </resources> <plugins> <plugin> <artifactId>maven-compiler-plugin</artifactId> <configuration> <source>1.6</source> <target>1.6</target> <encoding>UTF-8</encoding> </configuration> </plugin> </plugins> </build> </project>  

resources/proxool.xml:

<?xml version="1.0" encoding="UTF-8"?> <something-else-entirely> <proxool> <!-- 连接池的别名 --> <alias>proxool</alias> <!-- proxool只能管理由自己产生的连接 --> <driver-url>jdbc:oracle:thin:@localhost:1521:XE</driver-url> <!--JDBC驱动程序--> <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> <!-- 用户名与密码 --> <driver-properties> <property name="user" value="system" /> <property name="password" value="password" /> </driver-properties> <!-- 允许最大连接数 ,默认是15,这里设置为20--> <maximum-connection-count>20</maximum-connection-count> <!-- 最小连接数 ,默认是5,其实可以不用声明它--> <minimum-connection-count>5</minimum-connection-count> <!-- 测试连接的sql语句 --> <house-keeping-test-sql>select sysdate from dual</house-keeping-test-sql> </proxool> </something-else-entirely>  

resources/hibernate.cfg.xml:

<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory name="sessionFactory"> <property name="hibernate.connection.provider_class"> org.hibernate.connection.ProxoolConnectionProvider </property> <property name="hibernate.proxool.pool_alias">proxool</property> <property name="hibernate.proxool.xml">proxool.xml</property> <!-- 输出sql --> <property name="hibernate.show_sql">true</property> <!-- 格式化sql --> <property name="hibernate.format_sql">true</property> <!--指定数据库适配器 --> <property name="dialect"> org.hibernate.dialect.OracleDialect </property> <!-- 映射文件 --> <mapping resource="hibernateTest/Student.hbm.xml" /> </session-factory> </hibernate-configuration> 

HibernateTest/Student.java:

package hibernateTest; public class Student { private int id; private String name; private String address; private int age; public int getId() { return id; } public String getName() { return name; } public String getAddress() { return address; } public int getAge() { return age; } public void setId(int id) { this.id = id; } public void setName(String name) { this.name = name; } public void setAddress(String address) { this.address = address; } public void setAge(int age) { this.age = age; } }  

HibernateTest/Student.hbm.xml, 注意 mutable="false",这个参数。Hibernate进行一些优化,避免脏检查.

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping> <class name="hibernateTest.Student" table="STUDENT" mutable="false"> <id name="id" column="ID" type="int"> <generator class="sequence"> <!-- seq_student就是表student的主键自增的sequence --> <param name="sequence">seq_student</param> </generator> </id> <property name="name" column="name" type="string"/> <property name="address" column="address" type="string"/> <property name="age" column="age" type="int"/> </class> </hibernate-mapping> 

util/HibernateUtil.java:

package util; import org.hibernate.SessionFactory; import org.hibernate.cfg.Configuration; public class HibernateUtil { private static SessionFactory sessionFactory; static{ try { sessionFactory = new Configuration().configure().buildSessionFactory(); } catch (Throwable e) { throw new ExceptionInInitializerError(e); } } public static SessionFactory getSessionFactory(){ return sessionFactory; } public static void shutdown(){ getSessionFactory().close(); } }  

util/StudentManager.java:

package util; import hibernateTest.Student; import org.hibernate.Session; import org.hibernate.Transaction; public class StudentManager { public static void main(String[] args) { Session session = HibernateUtil.getSessionFactory().openSession(); Transaction transaction1 = session.beginTransaction(); Student stu = (Student) session.get(Student.class, 2); //改变状态，使之成为脏数据,因为设置了 mutable="false"这个参数,所以不会脏查询，这样数据就不会更新 stu.setName("kk000000000000"); transaction1.commit(); session.close(); } }  

输出的sql结果为:

Hibernate: select student0_.ID as ID0_0_, student0_.name as name0_0_, student0_.address as address0_0_, student0_.age as age0_0_ from STUDENT student0_ where student0_.ID=? 

---

允许脏查询

---

我们只需要改变Student.hbm.xml  ,这里去掉了mutable="false" ,或者设置mutable="true"也可以。

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping> <class name="hibernateTest.Student" table="STUDENT"> <id name="id" column="ID" type="int"> <generator class="sequence"> <!-- seq_student就是表student的主键自增的sequence --> <param name="sequence">seq_student</param> </generator> </id> <property name="name" column="name" type="string"/> <property name="address" column="address" type="string"/> <property name="age" column="age" type="int"/> </class> </hibernate-mapping> 

输出的sql:

Hibernate: select student0_.ID as ID0_0_, student0_.name as name0_0_, student0_.address as address0_0_, student0_.age as age0_0_ from STUDENT student0_ where student0_.ID=? Hibernate: update STUDENT set name=?, address=?, age=? where ID=?