1.创建一个表
create table Students(
ID int primary key,
name varchar(20),
gender varchar(20),
birthday date,
address varchar(100)
);
2.在Eclipse中创建一个工程,导入相关的类库,Hibernate需要hibernate3.jar,访问数据库的驱动包mysql-connector-java-5.0.8-bin.jar和
操作XML文件用到的jar包。接着创建一个持久化类。
//学生类
public class Students {
/*
* 1.公有类
* 2.提供公有的不带参数的默认构造方法
* 3.属性私有
* 4.属性setter/getter封装
*/
private int id;//学号
private String name;//姓名
private String gender;//性别
private Date birthday;//出生日期
private String address;//地址
public Students(){
}
public Students(int id, String name, String gender, Date birthday,
String address) {
super();
this.id = id;
this.name = name;
this.gender = gender;
this.birthday = birthday;
this.address = address;
}
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 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;
}
public String toString() {
return "Students [id=" + id + ", name=" + name + ", gender=" + gender
+ ", birthday=" + birthday + ", address=" + address + "]";
}
}
3.创建一个目录hibernate,其中包含两个配置文件:hibernate.cfg.xml和students.hdm.xml,其中
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="connection.username">root</property>
<property name="connection.password">123</property>
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.url">jdbc:mysql:///hibernate?useUnicode=true&charactreEncoding=UTF-8</property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="show_sql">true</property>
<property name="format_sql">true</property>
<property name="hbm2ddl.auto">create</property>
<mapping resource="Students.hbm.xml"/>
</session-factory>
</hibernate-configuration>
students.hdm.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">
<!-- Generated 2015-6-25 11:15:21 by Hibernate Tools 3.4.0.CR1 -->
<hibernate-mapping>
<class name="Students" table="STUDENTS">
<id name="id" type="int">
<column name="ID" />
<generator class="assigned" />
</id>
<property name="name" type="java.lang.String">
<column name="NAME" />
</property>
<property name="gender" type="java.lang.String">
<column name="GENDER" />
</property>
<property name="birthday" type="java.sql.Date">
<column name="BIRTHDAY" />
</property>
<property name="address" type="java.lang.String">
<column name="ADDRESS" />
</property>
</class>
</hibernate-mapping>
4.编写访问数据库的代码
import java.util.Date;
import java.util.List;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.Service;
import org.hibernate.service.ServiceRegistry;
import org.hibernate.service.ServiceRegistryBuilder;
public class Test {
public static void main(String[] args) {
//创建配置对象
Configuration config=new Configuration().configure();
//创建服务注册对象
ServiceRegistry serviceRegistry=new ServiceRegistryBuilder().applySettings(config.getProperties()).buildServiceRegistry();
//创建会话工厂对象
SessionFactory sessionFactory=config.buildSessionFactory(serviceRegistry);
//会话对象
Session session=sessionFactory.openSession();
//开启事务
Transaction transaction=session.beginTransaction();
Students s=new Students(2,"陈峰","男",new Date(),"武当山");
try {
session.save(s);//保存持久类对象
transaction.commit();//提交到数据库
//从数据库中查找刚才保存的数据
Query q=session.createSQLQuery("select * from Students").addEntity(Students.class);
List<Students> rs=q.list();
for(int i=0;i<rs.size();i++){
Students s1=rs.get(i);
System.out.println(s1.toString());
}
session.close();
} catch (Exception s1) {
// TODO Auto-generated catch block
s1.printStackTrace();
transaction.rollback();
}
}
}
程序运行结果为:
Hibernate:
insert
into
STUDENTS
(NAME, GENDER, BIRTHDAY, ADDRESS, ID)
values
(?, ?, ?, ?, ?)
Hibernate:
select
*
from
Students
Students [id=2, name=陈峰, gender=男, birthday=Sun Jul 05 10:26:49 CST 2015, address=武当山]
前面是Hibernate框架打印出的信息,最后一行是从数据库中查找到的信息。