1、sql文件内容
/*
Navicat MySQL Data Transfer
Source Server : mysql
Source Server Version : 50136
Source Host : localhost:3306
Source Database : test
Target Server Type : MYSQL
Target Server Version : 50136
File Encoding : 65001
Date: 2013-01-14 16:20:12
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `classes`
-- ----------------------------
DROP TABLE IF EXISTS `classes`;
CREATE TABLE `classes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of classes
-- ----------------------------
INSERT INTO `classes` VALUES ('1', 'java');
INSERT INTO `classes` VALUES ('2', 'net');
INSERT INTO `classes` VALUES ('3', 'jquery');
-- ----------------------------
-- Table structure for `stuinfo`
-- ----------------------------
DROP TABLE IF EXISTS `stuinfo`;
CREATE TABLE `stuinfo` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) DEFAULT NULL,
`age` int(11) DEFAULT NULL,
`address` varchar(200) DEFAULT NULL,
`classesid` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of stuinfo
-- ----------------------------
INSERT INTO `stuinfo` VALUES ('1', 'abc', '22', 'bb', '1');
INSERT INTO `stuinfo` VALUES ('2', 'bbb', '23', 'gg', '1');
INSERT INTO `stuinfo` VALUES ('3', 'ccc', '26', 'lll', '1');
2、在myeclipse中创建web项目并添加hibernate框架支持(添加时候要选中Annotation相关支持jar包)
3、在entity包下创建各个表所对应的实体类,并在实体类中添加注解
Classes类:
package com.tc.entity;
import java.util.HashSet;
import java.util.Set;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.OneToMany;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;
import org.hibernate.annotations.GenericGenerator;
@Entity
@Table(name="classes")
public class Classes {
private int id;
private String name;
private Set<Stuinfo> stuinfos=new HashSet<Stuinfo>(0);
public Classes() {
super();
}
public Classes(int id, String name) {
super();
this.id = id;
this.name = name;
}
@Id
@Column(name="id")
@GenericGenerator(name="sss",strategy="identity")
@GeneratedValue(generator="sss")
// @SequenceGenerator(name)
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
@Column(name="name")
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
@OneToMany
@JoinColumn(name="classesid")
public Set<Stuinfo> getStuinfos() {
return stuinfos;
}
public void setStuinfos(Set<Stuinfo> stuinfos) {
this.stuinfos = stuinfos;
}
}
Stuinfo类:
package com.tc.entity;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.Table;
@Entity
@Table(name="stuinfo")
public class Stuinfo {
private int id;
private String name;
private String address;
private int age;
private Classes classes;
public Stuinfo() {
super();
}
public Stuinfo(String name, String address, int age) {
super();
this.name = name;
this.address = address;
this.age = age;
}
public Stuinfo(int id, String name, String address, int age) {
super();
this.id = id;
this.name = name;
this.address = address;
this.age = age;
}
@Id
@Column(name="id")
@GeneratedValue(strategy=GenerationType.IDENTITY)
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
@Column(name="name")
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
@Column(name="address")
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
@Column(name="age")
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
@ManyToOne
@JoinColumn(name="classesid")
public Classes getClasses() {
return classes;
}
public void setClasses(Classes classes) {
this.classes = classes;
}
}
如果数据是oracle可以使用序列,代码如下:
@Id
@Column(name="id")
@GeneratedValue(strategy=GenerationType.SEQUENCE,generator="seq_stuid")
@SequenceGenerator(name="seq_stuid",sequenceName="seq_stu_id")
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
4、在hibernate配置文件中添加mapping,如下:
<mapping class="com.tc.entity.Classes"/>
<mapping class="com.tc.entity.Stuinfo"/>
5、创建测试类:
package com.tc.test;
import java.util.Iterator;
import java.util.Set;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.cfg.AnnotationConfiguration;
import org.hibernate.cfg.Configuration;
import com.tc.entity.Classes;
import com.tc.entity.Stuinfo;
public class Test {
public static void main(String[] args) {
Configuration acf=new AnnotationConfiguration().configure();
Session session=acf.buildSessionFactory().openSession();
Transaction tx=session.beginTransaction();
//添加班级信息
//Classes c=new Classes();
//c.setName("jquery");
//session.save(c);
//添加学生信息
//Stuinfo stu=new Stuinfo("abc", "bb", 22);
//session.save(stu);
//根据班级==》学生的一对多关系查找学生信息
//Classes c=(Classes)session.get(Classes.class, new Integer(1));
//System.out.println(c.getName());
//Set<Stuinfo> stus=c.getStuinfos();
//for (Iterator iterator = stus.iterator(); iterator.hasNext();) {
//Stuinfo stuinfo = (Stuinfo) iterator.next();
//System.out.println(stuinfo.getName());
//}
//根据学生信息查找班级信息
Stuinfo stu=(Stuinfo)session.get(Stuinfo.class, new Integer(1));
System.out.println(stu.getClasses().getName());
tx.commit();
session.close();
}
}