hibernate ——helloWorld程序（XML配置）

1、项目结构

2、hibernate实现了Java类 和 数据库表的映射（Map）

　　先看一下Student的Java类和对应的数据库表

package com.pt.hibernate;

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;
    }
}

　　创建Student表的SQL语句

CREATE TABLE `student` (
  `Id` int(20) NOT NULL,
  `Name` varchar(20) DEFAULT NULL,
  `Age` int(3) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

3、通过student.xml配置文件，将Java类和数据库表关联起来

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="com.pt.hibernate">
    <class name="Student" table="student">
        <id name="id" column="id" ></id>
        <property name="name" column="name" ></property>
        <property name="age" column="age" ></property>
    </class>
</hibernate-mapping>

4、通过hibernate.cfg.xml配置文件，初始化hibernate所需要的信息

<?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">org.hsqldb.jdbcDriver</property>
                    <property name="connection.url">jdbc:hsqldb:hsql://localhost/TestDB</property> -->

        <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="connection.url">jdbc:mysql://localhost/test?useUnicode=true&amp;characterEncoding=UTF-8</property>
        <property name="connection.username">root</property>
        <property name="connection.password"></property>

        <!-- SQL dialect -->
        <property name="dialect">
            org.hibernate.dialect.MySQLInnoDBDialect
        </property>
        <property name="show_sql">true</property>
         <mapping resource="com/pt/hibernate/Student.xml"/>
    </session-factory>

</hibernate-configuration>

5、测试

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

import com.pt.hibernate.Student;


public class StudentTest {
    public static void main(String[] arges){
        Student s= new Student();
        s.setId(20111901);
        s.setName("panteng");
        s.setAge(23);
        Configuration cfg = new Configuration();
        SessionFactory sessionFactory = cfg.configure().buildSessionFactory();
        Session session = sessionFactory.openSession();
        session.beginTransaction();
        session.save(s);
        session.getTransaction().commit();
        session.close();
        sessionFactory.close();
        
    }
}