复合主键

来源:互联网 发布:网络信息办公室 编辑:程序博客网 时间:2024/06/10 04:40

复合主键 - 398198920 - 冰冻三尺非一日之寒

person3.sql

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[person3]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[person3]
GO

CREATE TABLE [dbo].[person3] (
 [name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
 [phone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
 [age] [int] NULL
) ON [PRIMARY]
GO

hibernate2.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">

<!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>

<session-factory>
 <property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
 <property name="connection.url">jdbc:sqlserver://localhost:1433;databaseName=mldn</property>
 <property name="connection.username">sa</property>
 <property name="connection.password"></property>
 <property name="connection.driver_class">com.microsoft.jdbc.sqlserver.SQLServerDriver</property>
 <property name="myeclipse.connection.profile">ss</property>
 <property name="show_sql">true</property>
 <mapping resource="org/lxh/hibernate02/Person3.hbm.xml" />

</session-factory>

</hibernate-configuration>

Person3.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">
<!--
    Mapping file autogenerated by MyEclipse - Hibernate Tools
-->
<hibernate-mapping>
    <class name="org.lxh.hibernate02.Person3" table="person3">
        <composite-id>
            <key-property name="name" type="java.lang.String">
                <column name="name" length="100" />
            </key-property>
            <key-property name="phone" type="java.lang.String">
                <column name="phone" length="50" />
            </key-property>
        </composite-id>
        <property name="age" type="java.lang.Integer">
            <column name="age" />
        </property>
    </class>
</hibernate-mapping>

Person3.java

package org.lxh.hibernate02;
import org.apache.commons.lang.builder.EqualsBuilder;
import org.apache.commons.lang.builder.HashCodeBuilder;
public class Person3 implements java.io.Serializable {
 private String name;
 private String phone;
 private int age;
 
    public int getAge() {
  return age;
 }
 public void setAge(int age) {
  this.age = age;
 }
 public String getName() {
  return name;
 }
 public void setName(String name) {
  this.name = name;
 }
 public String getPhone() {
  return phone;
 }
 public void setPhone(String phone) {
  this.phone = phone;
 }
 public boolean equals(Object obj) {
  if(this==obj){
   return true;
  }if(!(obj instanceof Person3)){
   return false;
  }
  Person3 p3=(Person3)obj;
  return new EqualsBuilder().append(this.name, p3.name).append(this.phone, p3.phone).append(this.age, p3.age).isEquals();
 }
 public int hashCode() {
  return new HashCodeBuilder().append(this.name).append(this.phone).append(this.age).toHashCode();
 }
  
}

Test.java

package org.lxh.hibernate02;

public class Test {
 public static void main(String[] args) {
  Person3 p3=new Person3();
  p3.setName("lixihua");
  p3.setPhone("666666");
  p3.setAge(28);
  PersonOperate po=new PersonOperate();
  po.insert(p3);
 }
}
PersonOperate.java

package org.lxh.hibernate02;

import org.hibernate.Session;
import org.hibernate.cfg.Configuration;

public class PersonOperate {
 private Session session=null;
 public PersonOperate(){
  this.session=new Configuration().configure("hibernate2.cfg.xml").buildSessionFactory().openSession();
 }
 public void insert(Person3 p3){
  this.session.save(p3);
  this.session.beginTransaction().commit();
 }
}

0 0