Hibernate多对一单向关联

2019独角兽企业重金招聘Python工程师标准>>>

模型user,address

user中有一个字段为address_id与addrees的addressid进行外键关联，为多对一关系，则一个地址对应多个用户

user sql

CREATE TABLE `NewTable` (
`userid`  int(11) NOT NULL AUTO_INCREMENT ,
`account`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`password`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`address_id`  int(11) NULL DEFAULT NULL ,
PRIMARY KEY (`userid`),
FOREIGN KEY (`address_id`) REFERENCES `address` (`addressid`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `address_id` (`address_id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=28
ROW_FORMAT=COMPACT
;

address sql

CREATE TABLE `NewTable` (
`addressid`  int(11) NOT NULL AUTO_INCREMENT ,
`addressinfo`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`addressid`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=29
ROW_FORMAT=COMPACT
;

user

package dto;

public class User{
	
	private int userid;
	
	private String account;
	
	private String password;
	
	private Address address;

	public Address getAddress() {
		return address;
	}
	public void setAddress(Address address) {
		this.address = address;
	}
	public int getUserid() {
		return userid;
	}
	public void setUserid(int userid) {
		this.userid = userid;
	}
	public String getAccount() {
		return account;
	}
	public void setAccount(String account) {
		this.account = account;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}

	
	
	

}

user.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2015-6-20 23:49:11 by Hibernate Tools 3.4.0.CR1 -->
<hibernate-mapping>
    <class name="dto.User" table="user" catalog="snlu">
        <id name="userid" type="java.lang.Integer">
            <column name="userid" />
            <generator class="identity" />
        </id>
        <many-to-one name="address" class="dto.Address"  fetch="select">
            <column name="address_id" />
        </many-to-one>
        <property name="account" type="string">
            <column name="account" />
        </property>
        <property name="password" type="string">
            <column name="password" />
        </property>
    </class>
</hibernate-mapping>

address

package dto;

public class Address {
	private String addressinfo;
	private int addressid;

	public String getAddressinfo() {
		return addressinfo;
	}

	public void setAddressinfo(String addressinfo) {
		this.addressinfo = addressinfo;
	}

	public int getAddressid() {
		return addressid;
	}

	public void setAddressid(int addressid) {
		this.addressid = addressid;
	}

}

address.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2015-6-20 23:49:11 by Hibernate Tools 3.4.0.CR1 -->
<hibernate-mapping>
    <class name="dto.Address" table="address" catalog="snlu">
        <id name="addressid" type="java.lang.Integer">
            <column name="addressid" />
            <generator class="identity" />
        </id>
        <property name="addressinfo" type="string">
            <column name="addressinfo" />
        </property>
    </class>
</hibernate-mapping>

main

package test;

import org.hibernate.Session;
import org.hibernate.Transaction;

import util.HibernateUtil;
import dto.Address;
import dto.User;

public class UserTest {
	public static void main(String[] args) {
		Session session = HibernateUtil.getSessionFactory().openSession();
		Transaction tx = session.beginTransaction();

		Address a = new Address();
		a.setAddressinfo("america");
		
		User user = new User();
		user.setAccount("jack");
		user.setPassword("111111");
		
		User user2 = new User();
		user2.setAccount("peter");
		user2.setPassword("111111");
		
		user.setAddress(a);
		user2.setAddress(a);
		
		session.save(a);
		session.save(user);
		session.save(user2);

		tx.commit();
		HibernateUtil.closeSession();
	}

}

转载于:https://my.oschina.net/enjoymore/blog/469185