hibernate整合遗留数据库之处理主键(复合外键引用非主键)

203 阅读 0 评论 134 点赞

我是靠谱客的博主鲜艳羽毛，这篇文章主要介绍hibernate整合遗留数据库之处理主键(复合外键引用非主键)，现在分享给大家，希望可以做个参考。

有些遗留schema相当复杂：外键可能是一个复合键，并且设计为引用一个复合的自然的非主键。为了映射这个，你需要按相同的名称给几个属性分组，否则无法在property-ref中给复合命名。应用<properties>元素来给映射分组,如你所见，<properties>元素不仅可以用于给几个属性命名，而且可以定义了一个多列的unique约束，或者使几个属性变成不可变。注意，对于关联映射，列的顺序仍然很重要。

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>c3p0</groupId>  
            <artifactId>c3p0</artifactId>  
            <version>0.9.1</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/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.driver_class">oracle.jdbc.driver.OracleDriver</property>  
          
        <property name="hibernate.connection.url">jdbc:oracle:thin:@localhost:1521:XE</property>  
        <property name="hibernate.connection.useUnicode">true</property>  
        <property name="hibernate.connection.characterEncoding">gbk</property>  
          
        <property name="hibernate.connection.username">system</property>  
          
        <property name="hibernate.connection.password">password</property>  
          
        <property name="hibernate.c3p0.max_size">20</property>  
          
        <property name="hibernate.c3p0.min_size">5</property>  
          
        <property name="hibernate.c3p0.timeout">120</property>  
          
        <property name="hibernate.c3p0.max_statements">100</property>  
          
        <property name="hibernate.c3p0.idle_test_period">120</property>  
          
        <property name="hibernate.c3p0.acquire_increment">2</property>  
          
        <property name="dialect">org.hibernate.dialect.OracleDialect</property>  
          
        <property name="show_sql">true</property>  
          
        <property name="hibernate.format_sql">true</property>  
          
        <mapping resource="pojo/User.hbm.xml" />
        <mapping resource="pojo/Item.hbm.xml" />
    </session-factory>  
</hibernate-configuration>

pojo/User.java:

pojo/User.hbm.xml:

pojo/Item.java:

pojo/Item.hbm.xml:

util/HibernateUtil.java:

util/Manager.java:

表结构：