Saturday, July 13, 2013

Example about Hibernate

Phần này tôi sẽ lấy ví dụ về Hibernate là một framework dùng để đơn giản hóa, tự động quá trình thao tác với CSDL.
B1: Tạo CSDL với bảng User
id int(11)
name varchar(255)
B2: Tạo Project trên Eclipse
B3: Tạo file 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>
    <!-- ________________ To be Edited _________________ -->
    <!--<property name="connection.url">jdbc_URL</property>
    <property name="connection.username">jdbc_Username</property>
    <property name="connection.password">jdbc_Password</property>-->
    <!-- _____________ End of To be Edited ______________ -->
   
      <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
      <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/test</property>
      <property name="hibernate.connection.username">root</property>
      <property name="hibernate.connection.password">admin</property>
      <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
      <property name="hibernate.default_schema">test</property>
      <property name="show_sql">true</property>
      <property name="hibernate.hbm2ddl.auto">create</property>
      <!-- _________ Defining the Mapping Files ___________ -->
      <mapping resource="User.hbm.xml"/>
    </session-factory>
</hibernate-configuration>

B4: Tạo file User.hbm.xml

<?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>
    <class name="com.fis.demo.User" table="User">
        <id  name="id" type="int">
            <column name="id" precision="20" scale="0"/>
            <generator class="increment"></generator>
        </id>
        <property name="name">
            <column name="name"></column>
        </property>
    </class>
</hibernate-mapping>

 B5: Tạo file class User Entity


private int id;
    private String name;
   
    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;
    }



B6: Tạo file Test Hibernate

    public static void main(String[] args) {
        // TODO Auto-generated method stub
        Configuration cfg=new Configuration();
        cfg.configure("hibernate.cfg.xml");
        SessionFactory sessionFactory=cfg.buildSessionFactory();
        Session session=sessionFactory.openSession();
        Transaction tx=session.beginTransaction();
       
        User user1=new User();
        user1.setName("Le Van Trung");

        session.save(user1);
        tx.commit();
       
        System.out.println("User " + user1.getName() + "||" + " insert success");
    }


------------------------- Chúc các bạn thành công------------------------------

No comments:

Post a Comment