hibernate注解示例

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();

}

}

 

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值