Java Hibernate3 添加和删除数据，javahibernate3,hibernate.cf

Java Hibernate3 添加和删除数据，javahibernate3,hibernate.cf

hibernate.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"><hibernate-configuration>  <session-factory>    <!-- Database connection settings -->    <property name="connection.driver_class">com.mysql.jdbc.Driver</property>    <property name="connection.url">jdbc:mysql://localhost:3306/struts2_blog</property>    <property name="connection.username">root</property>    <property name="connection.password">admin</property>    <!-- JDBC connection pool (use the built-in) -->    <!-- <property name="connection.pool_size">1</property> -->    <!-- SQL dialect -->    <property name="dialect">org.hibernate.dialect.MySQLDialect</property>    <!-- Enable Hibernate's automatic session context management -->    <!-- <property name="current_session_context_class">thread</property> -->    <!-- Disable the second-level cache  -->   <!-- <property name="cache.provider_class">org.hibernate.cache.internal.NoCacheProvider</property>-->    <!-- Echo all executed SQL to stdout -->    <property name="show_sql">true</property>    <!-- Drop and re-create the database schema on startup -->    <!-- <property name="hbm2ddl.auto">update</property> -->    <mapping resource="com/Student.hbm.xml"/>    <mapping resource="com/Score.hbm.xml"/>  </session-factory></hibernate-configuration>

Student.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">    <hibernate-mapping package="com" >    <class name="Student" table="student">      <id name="id" column="id"></id>      <property name="name" column="name"></property>      <property name="age" column="age"></property>      <set name="score" cascade="all-delete-orphan">      <key column="student_id"></key>      <one-to-many class="Score"/>      </set>    </class>    </hibernate-mapping>

Student.java

package com;import java.util.HashSet;import java.util.Set;public class Student {    private int id;    private String name;    private int age;    public int getId() {        return id;    }    public void setId(int id) {        this.id = id;    }    public String getName() {        return name;    }    public void setName(String name) {        this.name = name;    }    public int getAge() {        return age;    }    public void setAge(int age) {        this.age = age;    }    private Set score=new HashSet();    public Set getScore() {        return score;    }}

Student_Test.java

package com;import java.util.ArrayList;import java.util.Iterator;import java.util.Set;import org.hibernate.Query;import org.hibernate.SessionFactory;import org.hibernate.cfg.Configuration;import org.hibernate.classic.Session;public class Student_Test {    /**     * @param args     */    public static void main(String[] args) {        Student student=new Student();        student.setAge(10);        student.setId(2);        student.setName("liyan");        Configuration cfg=new Configuration();        SessionFactory sf=cfg.configure().buildSessionFactory();        Session session=sf.openSession();        session.beginTransaction();        session.save(student);        session.getTransaction().commit();        Configuration cfg2=new Configuration();        SessionFactory sf2=cfg2.configure().buildSessionFactory();        Session session2=sf2.openSession();        session2.beginTransaction();        Student stu=(Student)session2.get(Student.class, 5);        session2.delete(stu);        session2.getTransaction().commit();        //Score score=new Score();//      Configuration cfg=new Configuration();//      SessionFactory sf=cfg.configure().buildSessionFactory();//      Session session=sf.openSession();//      session.beginTransaction();//      Query qq=session.createQuery("select student.name,score.score_number,score.course_name from score,student where score.student_id=student.id ");//      ArrayList list=(ArrayList) qq.list();//      //session.getTransaction().commit();//      Iterator i=list.iterator();//       while(i.hasNext())//       {//           Student stu=(Student)i.next();//           System.out.println(stu.getName());//           Set<Score> set=stu.getScore();//           for(Score s:set)//           {//               System.out.println(s.getCourseName()+"   "+s.getScore());//           }//       }    }}