| Blog信息 |
|
blog名称:
日志总数:1304
评论数量:2242
留言数量:5
访问次数:7592189
建立时间:2006年5月29日 |
| |
|
 [Hibernate]hibernate多对多例子-方便以后查看(三)
软件技术
lhwork 发表于 2007/1/7 14:05:58 |
|
1.建表
500)this.width=500'>
create
table
student500)this.width=500'>(sid
varchar
(
32
)
not
null
primary
key
,500)this.width=500'> sname
varchar
(
16
),500)this.width=500'> sage
varchar
(
16
),500)this.width=500'>)500)this.width=500'>500)this.width=500'>
create
table
course500)this.width=500'>(cid
varchar
(
32
)
not
null
primary
key
,500)this.width=500'>cname
varchar
(
16
)500)this.width=500'>)500)this.width=500'>500)this.width=500'>
create
table
student_course_link500)this.width=500'>(sid
varchar
(
32
)
not
null
,500)this.width=500'>cid
varchar
(
32
)
not
null
,500)this.width=500'>
primary
key
(sid,cid)500)this.width=500'>)500)this.width=500'>
2.写VOStudentVO500)this.width=500'>package com.test;500)this.width=500'>import java.util.Set;500)this.width=500'>public class Student500)this.width=500'>500)this.width=500'>500)this.width=500'>{500)this.width=500'> private String sid;500)this.width=500'> private String sname;500)this.width=500'> private String sage;500)this.width=500'>500)this.width=500'> private Set course;500)this.width=500'> public Student()500)this.width=500'>500)this.width=500'> 500)this.width=500'>{500)this.width=500'> }500)this.width=500'> //写上get setCourse vo500)this.width=500'>package com.test;500)this.width=500'>500)this.width=500'>import java.util.Set;500)this.width=500'>500)this.width=500'>public class Course500)this.width=500'>500)this.width=500'>500)this.width=500'>{500)this.width=500'> private String cid;500)this.width=500'> private String cname;500)this.width=500'> private Set student;500)this.width=500'> //写上get set写配置文件Student.hbm.xml500)this.width=500'><?xml version="1.0"?>500)this.width=500'><!DOCTYPE hibernate-mapping500)this.width=500'> PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"500)this.width=500'> "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">500)this.width=500'>500)this.width=500'><hibernate-mapping>500)this.width=500'>500)this.width=500'> <class name="com.test.Student" table="student" >500)this.width=500'>500)this.width=500'> <id name="sid" type="string" unsaved-value="null" >500)this.width=500'> <column name="sid" sql-type="char(32)" not-null="true"/>500)this.width=500'> <generator class="uuid.hex"/>500)this.width=500'> </id>500)this.width=500'>500)this.width=500'> <property name="sname">500)this.width=500'> <column name="sname" sql-type="varchar(16)" not-null="true"/>500)this.width=500'> </property>500)this.width=500'>500)this.width=500'> <property name="sage">500)this.width=500'> <column name="sage" sql-type="varchar(16)" not-null="true"/>500)this.width=500'> </property>500)this.width=500'>500)this.width=500'> <set name="course" table="student_course_link" cascade="all" outer-join="false">500)this.width=500'> <key column="sid"/>500)this.width=500'> <many-to-many class="com.test.Course" column="cid"/>500)this.width=500'> </set>500)this.width=500'> 500)this.width=500'> </class>500)this.width=500'>500)this.width=500'></hibernate-mapping>Course.hbm.xml500)this.width=500'><?xml version="1.0"?>500)this.width=500'><!DOCTYPE hibernate-mapping500)this.width=500'> PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"500)this.width=500'> "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">500)this.width=500'>500)this.width=500'><hibernate-mapping>500)this.width=500'>500)this.width=500'> <class name="com.test.Course" table="course" >500)this.width=500'>500)this.width=500'> <id name="cid" type="string" unsaved-value="null" >500)this.width=500'> <column name="cid" sql-type="char(32)" not-null="true"/>500)this.width=500'> <generator class="uuid.hex"/>500)this.width=500'> </id>500)this.width=500'>500)this.width=500'> <property name="cname">500)this.width=500'> <column name="cname" sql-type="varchar(16)" not-null="true"/>500)this.width=500'> </property>500)this.width=500'>500)this.width=500'> <set name="student" table="student_course_link" lazy="false" cascade="all">500)this.width=500'> <key column="cid"/>500)this.width=500'> <many-to-many class="com.test.Student" column="sid"/>500)this.width=500'> </set>500)this.width=500'> 500)this.width=500'> </class>500)this.width=500'>500)this.width=500'></hibernate-mapping>接着把下面的hibernate.properties文件拷到classes目录下。。这里用的是mysql500)this.width=500'>hibernate.query.substitutions true 1, false 0, yes 'Y', no 'N'500)this.width=500'>## MySQL500)this.width=500'>hibernate.dialect net.sf.hibernate.dialect.MySQLDialect500)this.width=500'>hibernate.connection.driver_class org.gjt.mm.mysql.Driver500)this.width=500'>hibernate.connection.url jdbc:mysql://localhost:3306/wjcms500)this.width=500'>hibernate.connection.username root500)this.width=500'>hibernate.connection.password wujun500)this.width=500'>hibernate.connection.pool_size 1500)this.width=500'>hibernate.proxool.pool_alias pool1500)this.width=500'>hibernate.show_sql true500)this.width=500'>hibernate.jdbc.batch_size 0500)this.width=500'>hibernate.max_fetch_depth 1500)this.width=500'>hibernate.cache.use_query_cache true 写测试类了..500)this.width=500'>package com.test;500)this.width=500'>500)this.width=500'>import net.sf.hibernate.Session;500)this.width=500'>import net.sf.hibernate.SessionFactory;500)this.width=500'>import net.sf.hibernate.cfg.Configuration;500)this.width=500'>import net.sf.hibernate.*;500)this.width=500'>import java.util.Set;500)this.width=500'>import java.util.HashSet;500)this.width=500'>import java.sql.*;500)this.width=500'>import java.util.List;500)this.width=500'>import java.util.Iterator;500)this.width=500'>500)this.width=500'>public class TestManyToMany500)this.width=500'>500)this.width=500'>500)this.width=500'>{500)this.width=500'> SessionFactory sf;500)this.width=500'> Session session;500)this.width=500'> public TestManyToMany()500)this.width=500'>500)this.width=500'> 500)this.width=500'>{500)this.width=500'> try500)this.width=500'>500)this.width=500'> 500)this.width=500'>{500)this.width=500'> Configuration cfg = new Configuration();500)this.width=500'> sf = cfg.addClass(Student.class).addClass(Course.class).buildSessionFactory();500)this.width=500'> }500)this.width=500'> catch(HibernateException ex)500)this.width=500'>500)this.width=500'> 500)this.width=500'>{500)this.width=500'> ex.printStackTrace();500)this.width=500'> }500)this.width=500'> }500)this.width=500'> public void doCreate()500)this.width=500'>500)this.width=500'> 500)this.width=500'>{500)this.width=500'> try500)this.width=500'>500)this.width=500'> 500)this.width=500'>{500)this.width=500'> session = sf.openSession();500)this.width=500'>500)this.width=500'> Student student = new Student();500)this.width=500'> student.setSname("小王");500)this.width=500'> student.setSage("22");500)this.width=500'>500)this.width=500'> Set courseSet = new HashSet();500)this.width=500'> Course course = null;500)this.width=500'> for(int i=0;i<2;i++)500)this.width=500'>500)this.width=500'> 500)this.width=500'>{500)this.width=500'> course = new Course();500)this.width=500'> if(i==0)500)this.width=500'> course.setCname("c++");500)this.width=500'> else if(i==1)500)this.width=500'> course.setCname("java");500)this.width=500'> courseSet.add(course);500)this.width=500'> }500)this.width=500'> student.setCourse(courseSet);500)this.width=500'> 500)this.width=500'> session.save(student);500)this.width=500'> session.flush();500)this.width=500'> session.connection().commit();500)this.width=500'>500)this.width=500'> }500)this.width=500'> catch(HibernateException ex)500)this.width=500'>500)this.width=500'> 500)this.width=500'>{500)this.width=500'> ex.printStackTrace();500)this.width=500'> }500)this.width=500'> catch(SQLException ex1)500)this.width=500'>500)this.width=500'> 500)this.width=500'>{500)this.width=500'> ex1.printStackTrace();500)this.width=500'> }500)this.width=500'> finally500)this.width=500'>500)this.width=500'> 500)this.width=500'>{500)this.width=500'>500)this.width=500'> try500)this.width=500'>{500)this.width=500'> session.close();500)this.width=500'> }500)this.width=500'>500)this.width=500'> catch(HibernateException ex2)500)this.width=500'>{500)this.width=500'> }500)this.width=500'> }500)this.width=500'>500)this.width=500'> }500)this.width=500'> public void doQuery()500)this.width=500'>500)this.width=500'> 500)this.width=500'>{500)this.width=500'>500)this.width=500'> try500)this.width=500'>{500)this.width=500'> session = sf.openSession();500)this.width=500'> Query q = session.createQuery("select s from Student as s");500)this.width=500'> List l = q.list();500)this.width=500'> Student s = null;500)this.width=500'> Course course = null;500)this.width=500'> for(int i=0;i<l.size();i++)500)this.width=500'>500)this.width=500'> 500)this.width=500'>{500)this.width=500'> s = (Student)l.get(i);500)this.width=500'> System.out.println("姓名： "+s.getSname());500)this.width=500'> System.out.println("年龄： "+s.getSage());500)this.width=500'> System.out.println("所选的课程：");500)this.width=500'> Iterator it = s.getCourse().iterator();500)this.width=500'> while(it.hasNext())500)this.width=500'>500)this.width=500'> 500)this.width=500'>{500)this.width=500'> course = (Course)it.next();500)this.width=500'> System.out.println("课程名： "+course.getCname());500)this.width=500'> }500)this.width=500'>500)this.width=500'>500)this.width=500'> }500)this.width=500'>500)this.width=500'> }500)this.width=500'>500)this.width=500'> catch(HibernateException ex)500)this.width=500'>{500)this.width=500'> ex.printStackTrace();500)this.width=500'> }500)this.width=500'>500)this.width=500'> finally500)this.width=500'>{500)this.width=500'>500)this.width=500'> try500)this.width=500'>{500)this.width=500'> session.close();500)this.width=500'> }500)this.width=500'>500)this.width=500'> catch(HibernateException ex2)500)this.width=500'>{500)this.width=500'> }500)this.width=500'> }500)this.width=500'> }500)this.width=500'> public static void main(String[] args)500)this.width=500'>500)this.width=500'> 500)this.width=500'>{500)this.width=500'> TestManyToMany t = new TestManyToMany();500)this.width=500'> //t.doCreate();500)this.width=500'> t.doQuery();500)this.width=500'> }500)this.width=500'>}500)this.width=500'> 好。。可以了。。
|
|
|