Hibernate案例
工具:eclipse、SQLServer2008
一、新建JavaProject
二、导入用到的Jar包
(1)hibernate核心包
(2)Junit-4.10.jar
(3)sqljdbc4.jar
项目结构如下
三、Hibernate配置文档
(1)创建Hibernate配置文档(Hibernate Configuration File(cfg.xml))保存在src目录下
(2)配置文档属性
<hibernate-configuration>
<session-factory>
<!-- 数据库驱动 -->
<property name="hibernate.connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
<!-- 数据库地址 -->
<property name="hibernate.connection.url">jdbc:sqlserver://127.0.0.1:1433;DatabaseName=<span style="color:#ff0000;">DataBaseName</span></property>
<!-- 数据库用户名 -->
<property name="hibernate.connection.username"><span style="color:#ff0000;">username</span></property>
<!-- 数据库密码 -->
<property name="hibernate.connection.password"><span style="color:rgb(255,0,0);">password</span></property>
<!-- 数据库方言 -->
<property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</property>
<!-- 是否在控制台显示sql语句 -->
<property name="show_sql">true</property>
<!-- 是否格式化显示sql语句 -->
<property name="format_sql">true</property>
<!-- 当相同的表结构存在时,先删除再创建 -->
<property name="hbm2ddl.auto">create</property>
</session-factory>
</hibernate-configuration>
四、创建持久化类(本次案例以Students为例)
(1)符合javaBean的四个条件
1.类是public类型
2.类的属性为private
3.带有无参的public的构造方法
4.用setter和getter封装属性
import java.util.Date;
//学生类
public class Students {
private int sid;// 学号
private String Sname;// 姓名
private String gender;// 性别
private Date birthday;// 出生日期
private String address;// 地址
public Students() {
}
public int getSid() {
return sid;
}
public void setSid(int sid) {
this.sid = sid;
}
public String getSname() {
return Sname;
}
public void setSname(String sname) {
Sname = sname;
}
public String getGender() {
return gender;
}
public void setGender(String gender) {
this.gender = gender;
}
public Date getBirthday() {
return birthday;
}
public void setBirthday(Date birthday) {
this.birthday = birthday;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
//方便测试,添加了toString和带参数的构造方法
@Override
public String toString() {
return "Students [sid=" + sid + ", Sname=" + Sname + ", gender=" + gender + ", birthday=" + birthday
+ ", address=" + address + "]";
}
public Students(int sid, String sname, String gender, Date birthday, String address) {
//super();
this.sid = sid;
Sname = sname;
this.gender = gender;
this.birthday = birthday;
this.address = address;
}
}
五、对象关系映射文件
(1)在src下创建文件(Hibernate XML Mapping file(hbm.xml))
(2)在”下一步“中选择需要映射的类
(3)在xml配置文档中配置映射表(添加属性)
<!-- 关系映射表 -->
<mapping resource="Students.hbm.xml"/>
六、编写测试用例
(1)新建源文件夹
(2)编写测试类
import java.util.Date;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
import org.hibernate.service.ServiceRegistryBuilder;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;
//学生测试类
public class StudentsTest {
private SessionFactory sessionFactory;
private Session session;
private Transaction transaction;
@Before
public void init() {
// 创建配置对象
Configuration config = new Configuration().configure();
// 获得服务注册对象
ServiceRegistry serviceRegistry = new ServiceRegistryBuilder().applySettings(config.getProperties())
.buildServiceRegistry();
// 创建会话工厂
sessionFactory = config.buildSessionFactory(serviceRegistry);
// 打开会话
session = sessionFactory.openSession();
// 开始事务
transaction = session.beginTransaction();
}
@Test
public void testSaveStudents() {
Students student = new Students(1, "a", "a", new Date(), "s");
// 保存对象进数据库
session.save(student);
}
@After
public void destroy() {
// 提交事务
transaction.commit();
// 关闭会话
session.close();
// 关闭会话工厂
sessionFactory.close();
}
}