HQL语句

标签： JAVA框架

---

1.创建工程Day-HQL

2.在工程下创建lib文件夹

3.导入jar包

antlr-2.7.6.jar
backport-util-concurrent.jar
c3p0-0.9.1.jar
commons-collections-3.1.jar
commons-logging-1.1.1.jar
dom4j-1.6.1.jar
ehcache-1.5.0.jar
hibernate3.jar
javassist-3.9.0GA.jar
jta-1.1.jar
log4j.jar
mysql-connector-java-5.1.10-bin.jar
slf4j-api-1.5.8.jar
slf4j-log4j12.jar

4.在src下创建包com.cd.domain

创建可持续化类

    student.java代码如下

package com.cd.domain;

import java.io.Serializable;
import java.util.Set;

public class Student implements Serializable{
    private int sid;
    private String sname;
    private String sdescription;
    private Set<Course> courses;
    private Classes classes;
    public int getSid() {
        return sid;
    }
    public void setSid(int sid) {
        this.sid = sid;
    }
    public String getSname() {
        return sname;
    }
    public void setSname(String sname) {
        this.sname = sname;
    }
    public String getSdescription() {
        return sdescription;
    }
    public void setSdescription(String sdescription) {
        this.sdescription = sdescription;
    }
    public Set<Course> getCourses() {
        return courses;
    }
    public void setCourses(Set<Course> courses) {
        this.courses = courses;
    }
    public Classes getClasses() {
        return classes;
    }
    public void setClasses(Classes classes) {
        this.classes = classes;
    }
}

Course.java

package com.cd.domain;

import java.util.Set;

public class Course {
    private int cid;
    private String cname;
    private String cdescription;
    private Set<Student> students;
    public int getCid() {
        return cid;
    }
    public void setCid(int cid) {
        this.cid = cid;
    }
    public String getCname() {
        return cname;
    }
    public void setCname(String cname) {
        this.cname = cname;
    }
    public String getCdescription() {
        return cdescription;
    }
    public void setCdescription(String cdescription) {
        this.cdescription = cdescription;
    }
    public Set<Student> getStudents() {
        return students;
    }
    public void setStudents(Set<Student> students) {
        this.students = students;
    }

}

Classes.java

package com.cd.domain;

import java.util.Set;

public class Classes {
    private int cid;
    private String cname;
    private String cdescription;
    private Set<Student> students;
    public int getCid() {
        return cid;
    }
    public void setCid(int cid) {
        this.cid = cid;
    }
    public String getCname() {
        return cname;
    }
    public void setCname(String cname) {
        this.cname = cname;
    }
    public String getCdescription() {
        return cdescription;
    }
    public void setCdescription(String cdescription) {
        this.cdescription = cdescription;
    }
    public Set<Student> getStudents() {
        return students;
    }
    public void setStudents(Set<Student> students) {
        this.students = students;
    }

}

创建对应的映射文件
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>
    <class name="com.cd.domain.Student" table="student">
    <id name="sid" column="sid">
    <generator class="increment"></generator>
    </id>
    <property name="sname" length="10"></property>
    <property name="sdescription" length="50"></property>
    <set name="courses" table="student_course"  cascade="all">
    <key>
    <column name="sid"></column>
    </key>
    <many-to-many class="com.cd.domain.Course" column="cid"></many-to-many>
    </set>
    <many-to-one name="classes" class="com.cd.domain.Classes" column="cid"></many-to-one>
    </class>
    </hibernate-mapping>

Course.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>
    <class name="com.cd.domain.Course" table="course">
    <id name="cid" column="cid">
    <generator class="increment"></generator>
    </id>
    <property name="cname" length="10"></property>
    <property name="cdescription" length="50"></property>
    <set name="students" table="student_course" cascade="all">
    <key>
    <column name="cid"></column>
    </key>
    <many-to-many class="com.cd.domain.Student" column="sid"></many-to-many>
    </set>
    </class>
    </hibernate-mapping>

Classes.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>
    <class name="com.cd.domain.Classes" table="classes">
    <id name="cid" column="cid">
    <generator class="increment"></generator>
    </id>
    <property name="cname" length="10"></property>
    <property name="cdescription" length="50"></property>
    <set name="students"  inverse="false" lazy="true">
    <key>
    <column name="cid"></column>
    </key>
    <one-to-many class="com.cd.domain.Student" />
    </set>
    </class>
    </hibernate-mapping>

5.在src目录下创建配置文件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>
    <property name="connection.username">root</property>
    <property name="connection.password">123456</property>
    <property name="connection.driver_class">
        com.mysql.jdbc.Driver
    </property>
    <property name="connection.url">
        jdbc:mysql://localhost:3306/jdbc02
    </property>
    <property name="dialect">
        org.hibernate.dialect.MySQLDialect
    </property>

    <property name="hbm2ddl.auto">update</property>

    <mapping resource="com/cd/domain/Classes.hbm.xml" />
    <mapping resource="com/cd/domain/Student.hbm.xml" />
    <mapping resource="com/cd/domain/Course.hbm.xml" />
</session-factory>
</hibernate-configuration>

配置表，创建表之前千万不要复制粘贴把二级缓存配置上

6.创建表

创建CreateTabel.java类

package com.cd.db;

import org.hibernate.cfg.Configuration;

public class CreateTable {
    public static void main(String[ ] args){
        Configuration configuration = new Configuration();
        configuration.configure();
        configuration.buildSessionFactory();
    }
}