MySQL 与hibernate的整合使用

 1  加载驱动

    (1) mysql
    (2) hibernate解压包下的lib下驱动

2  编写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="persistence.Student" table="user">         
        <id name="id" column="id" unsaved-value="null">             
           <generator class="uuid.hex"></generator>
        </id>         
        <property name="username" column="username"
type="java.lang.String"/>
        <property name="password" column="password"
type="java.lang.String"/>
        <property name="age" column="age"
type="java.lang.String"/>
        <property name="sex" column="sex"
type="java.lang.String"/>
        
    </class>
</hibernate-mapping>

3  编写hibernate.cfg.xml

    <?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 2.0//EN"
          "http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">

<!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>
<session-factory>

    <property name="myeclipse.connection.profile">test</property>
    <property name="show_sql">true</property>
    <property name="connection.url">jdbc:mysql://localhost:3306/test</property>
            <!--数据库为test-->
    <property name="connection.driver_class">
        com.mysql.jdbc.Driver
    </property>
    <property name="connection.username">root</property>
    <property name="connection.password">root</property>
    
    <property name="dialect">
        org.hibernate.dialect.MySQLDialect
    </property>

    <mapping resource="Student.hbm.xml" />
</session-factory>
</hibernate-configuration>

4  测试bean   Student.java

    package persistence;

public class Student {
    public String id;
    public String username;
    public String password;
    public String age;
    public String sex;
    public String getAge() {
        return age;
    }
    public void setAge(String age) {
        this.age = age;
    }
    
    public String getPassword() {
        return password;
    }
    public void setPassword(String password) {
        this.password = password;
    }
    public String getSex() {
        return sex;
    }
    public void setSex(String sex) {
        this.sex = sex;
    }
    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }
    public String getId() {
        return id;
    }
    public void setId(String id) {
        this.id = id;
    }
    
    
}

5  测试类test.java

    package persistence;

import org.hibernate.*;
import org.hibernate.cfg.*;

public class Test {
    public static void main(String args[]){
        try{
            SessionFactory sessionFactory=new Configuration().configure().buildSessionFactory();
            Session session=sessionFactory.openSession();
            Transaction transaction=session.beginTransaction();
            
            Student student=new Student();
            student.setSex("ff");
            student.setId("45");
            student.setAge("18");
            student.setPassword("asdfa");
            student.setUsername("hj");
            session.save(student);
            transaction.commit();
            session.close();
        }catch(HibernateException e){
            e.printStackTrace();
        }
        
    }
}