搭建hibernate的使用环境
Idea 2020.2.3 Navicat Mysql
操作过程和运行截图
创建一个普通的Java工程
新建服务器表
引用相关包文件
导入后
链接数据库
创建对应数据库表实体类(User.java)
package entity;
public class User {
private int Id;
private String Name;
private int Number;
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 int getNumber() {
return Number;
}
public void setAge(int number) {
this.number = Number;
}
}
配置User实体类(user.hbm.xml)
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="entity.User" table="t_user">
<id name="Id" column="Id">
<generator class="native"/>
</id>
<property name="Name" column="Name"/>
<property name="Number" column="Number"/>
</class>
</hibernate-mapping>
Hibernate配置文件(hibernate.cfg.xml)
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/test?serverTimezone=Asia/Shanghai</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password"></property>
<property name="show_sql">true</property>
<mapping resource="entity/user.hbm.xml"/>
</session-factory>
</hibernate-configuration>
创建一个用于测试的文件manegeUser.java
package dao;
import entity.User;
import org.hibernate.*;
import org.hibernate.cfg.Configuration;
public class manageUser {
public static void main(String[] args){
Configuration cfg = null;
SessionFactory sf = null;
Session session = null;
Transaction ts = null;
User u = new User();
u.setName("王琦");
u.setNumber(1814010926);
try {
cfg = new Configuration().configure();
sf = cfg.buildSessionFactory();
session = sf.openSession();
ts = session.beginTransaction();
session.save(u);
ts.commit();
}catch (HibernateException e){
e.printStackTrace();
if(ts != null){
ts.rollback();
}
}finally {
session.close();
sf.close();
}
}
}
成功插入了一条记录
配置成功