1.oracle数据库 建表、序列
create table Student(
id number(20) primary key,
name varchar2(20) not null,
age number(20) not null,
city varchar2(20) not null
)
create sequence Student_seq;
2.项目结构(注意导包)
3.实体类
package com.oracleoaec.hibernate.entity;
public class Student {
private Long id;
private String name;
private Long age;
private String city;
public Student(){
}
public Student(Long id, String name, Long age, String city) {
super();
this.id = id;
this.name = name;
this.age = age;
this.city = city;
}
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Long getAge() {
return age;
}
public void setAge(Long age) {
this.age = age;
}
public String getCity() {
return city;
}
public void setCity(String city) {
this.city = city;
}
@Override
public String toString() {
return "Student [id=" + id + ", name=" + name + ", age=" + age + ", city=" + city + "]";
}
}
4.hibernate.cfg.xml
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory >
<!-- Oracle数据库驱动 -->
<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<!-- Oracle数据库名称 -->
<property name="hibernate.connection.url">jdbc:oracle:thin:@127.0.0.1:1521:XE</property>
<!-- 数据库的登陆用户名 -->
<property name="hibernate.connection.username">mzd</property>
<!-- 数据库的登陆密码 -->
<property name="hibernate.connection.password">8341</property>
<!-- 方言:为每一种数据库提供适配器,方便转换 -->
<property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>
<!-- <property name="hibernate.show_sql">true</property> -->
<!-- 加载所有映射 -->
<mapping resource="com/oracleoaec/hibernate/entity/Student.hbm.xml"/>
</session-factory>
</hibernate-configuration>
5.Student.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 package="com.oracleoaec.hibernate.entity">
<class name="Student" table="Student">
<!-- 主键 ,映射-->
<id name="id" column="id">
<!-- 主键生成策略 -->
<generator class="sequence">
<param name="sequence">Student_seq</param>
</generator>
</id>
<!-- 非主键,映射 -->
<property name="name" column="name"/>
<property name="age" column="age"/>
<property name="city" column="city"/>
</class>
</hibernate-mapping>
6.测试类
package com.oracleoaec.hibernate.dao;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import com.oracleoaec.hibernate.entity.Student;
public class Test {
public static void main(String[] args) {
//实例化实体类,并写入数据
Student stu = new Student();
stu.setName("张三");
stu.setAge(22L);
stu.setCity("长沙");
// 获取加载配置文件的管理类对象
Configuration config = new Configuration();
config.configure(); // 默认加载src/hibenrate.cfg.xml文件
// 创建session的工厂对象
SessionFactory sf = config.buildSessionFactory();
// 创建session (代表一个会话,与数据库连接的会话)
Session session = sf.openSession();
// 通过session完成与数据库的DRUD操作
Transaction tx = null;
try{
// 开启事务
tx = session.beginTransaction();
//保存-数据库
session.save(stu);
// 提交事务
tx.commit();
}catch(Exception e){
e.printStackTrace();
//回滚事务
tx.rollback();
}finally {
// 关闭
session.close();
sf.close();
}
}
}
7.插入数据成功