1.创建项目并导入jar包
将获取的hibernate包解压,在解压所得文件夹的lib->required目录下获得所需的jar包
获取MySQL Server驱动以及log4j包
2.在MYSQL中创建一个新的数据库和demo表
启动mysql数据库,输入密码
接着创建一个新的数据库ORM
create database ORM;
启动ORM
use ORM;
新建一个ORMdemo
create table ORMdemo
(
id int not null primary key,
username varchar(20) not null,
password varchar(20)
);
结果如图:
接下来查看已建的ORMdemo表:
show tables;
创建类
在src目录下新建包ORMclass,新建类
创建
package ORMclass;
public class ORMdemo {
private int id;
private String username;
private String password;
public int getId() {
return id;
}
public String getUsername() {
return username;
}
public String getPassword() {
return password;
}
public void setId(int id){
this.id=id;
}
public void setUsername(String username){
this.username=username;
}
public void setPsaaword(String password) {
this.password=password;
}
}
编写映射文件ORMdemo.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="ORMdemo" table="ORMdemo">
<id name="id" column="id">
<generator class="increment" />
</id>
<property name="username" column="username" />
<property name="password" column="password" />
</class>
</hibernate-mapping>
编写hibernate.cfg.xml文件
在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="show_sql">true</property>
<property name="connection.driver_class">
com.mysql.jdbc.Driver
</property>
<property name="connection.url">
jdbc:mysql://localhost/ORM
</property>
<property name="connection.username">
root
</property>
<property name="connection.password">
root
</property>
<property name="dialect">
org.hibernate.dialect.MySQLDialect
</property>
<mapping resource="ORMclass/ORMdemo.hbm.xml" />
</session-factory>
</hibernate-configuration>
编写测试类并进行测试
新建test的source folder文件夹,创建cn.itcase.test包,在包中建ORMTest.java
package cn.itcast.test;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.junit.Test;
import ORMclass.ORMdemo;
public class ORMTest {
@Test
public void insertTest() {
//加载hibernate.cfg.xml配置
Configuration config = new Configuration().configure();
//获取SessionFactory
SessionFactory sessionFactory = config.buildSessionFactory();
//得到一个Session
Session session = sessionFactory.openSession();
//开启事务
Transaction t = session.beginTransaction();
//开始操作
ORMdemo o=new ORMdemo();
o.setUsername("zhuochenghao");
o.setPassword("654321");
//将数据存储到表
session.save(o);
//提交事务
t.commit();
//关闭资源
session.close();
sessionFactory.close();
}
}
其中,将鼠标移动至@Test处,在弹出窗口中选择Add JUnit4 library to the bulid path,Eclipes自动将JUnit4包加入项目中
之后在insertTest方法上右键,选择Run As->JUnit Test
待测试完毕,显示测试结果为成功
操作成功,打开My SQL Server,输入代码进行查询
查询结果