工程截圖
這里寫圖片描述
配置文件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>
<!-- 必須配置的屬性 -->
<!-- 連接數(shù)據(jù)庫信息 -->
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.url">jdbc:mysql:///hibernate</property>
<property name="connection.username">root</property>
<property name="connection.password">admin</property>
<!-- 方言屬性:這個是實現(xiàn)跨數(shù)據(jù)庫關(guān)鍵類 -->
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<!-- 可選配置屬性 -->
<!-- 是否自動生成表:這里選用create便于測試 -->
<property name="hbm2ddl.auto">create</property>
<!-- 是否顯示sql -->
<property name="show_sql">true</property>
<!-- 是否格式化sql -->
<!-- <property name="format_sql">true</property> -->
<!-- 以文件路徑的方式加載映射文件 -->
<mapping resource="com/jege/hibernate/single/table/User.hbm.xml" />
</session-factory>
</hibernate-configuration>
映射文件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 package="com.jege.hibernate.single.table">
<!-- class表示由hibernate管理的一個持久對象,對應(yīng)數(shù)據(jù)庫的一個表 ,table表示數(shù)據(jù)庫的表名 -->
<class name="User" table="t_user">
<!-- id元素是必須的,對應(yīng)數(shù)據(jù)庫是表的主鍵 -->
<id name="id">
<!-- generator表示數(shù)據(jù)庫表的主鍵生成方式,一般都是使用native -->
<!-- native表示自動選擇數(shù)據(jù)庫本地的策略: -->
<!-- 對于mysql是AUTO_INCREMENT自增 -->
<!-- 對于oracle是序列 -->
<generator class="native" />
</id>
<!-- 使用property配置非主鍵屬性 -->
<!-- 可以column配置數(shù)據(jù)庫表的不同于模型User的屬性,如下username屬性對應(yīng)表的name字段 -->
<property name="username" column="name" />
<property name="password" />
</class>
</hibernate-mapping>
模型對象User.java
package com.jege.hibernate.single.table;
/**
* @author JE哥
* @email 1272434821@qq.com
* @description: 模型對象
*/
public class User {
private Long id;
private String username;
private String password;
public User() {
}
public User(Long id) {
this.id = id;
}
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
@Override
public String toString() {
return "User [id=" + id + ", username=" + username + ", password=" + password + "]";
}
}
測試類CrudTest.java
package com.jege.hibernate.single.table;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import org.junit.Before;
import org.junit.Test;
import com.jege.hibernate.util.HibernateUtils;
/**
* @author JE哥
* @email 1272434821@qq.com
* @description: crud測試類
*/
public class CrudTest {
// 在每個@Test之前自動執(zhí)行,先保存數(shù)據(jù)
@Before
public void before() throws Exception {
User user = new User();
user.setUsername("jege");
user.setPassword("1272434821");
Session session = HibernateUtils.INSTANCE.getSession();
session.beginTransaction();
session.save(user);
session.getTransaction().commit();
session.close();
}
@Test
public void save() throws Exception {
}
@Test
public void update() throws Exception {
Session session = HibernateUtils.INSTANCE.getSession();
session.beginTransaction();
User user = (User) session.get(User.class, 1L);
user.setUsername("JavaEEGe");
user.setPassword("1272434821@qq.com");
session.update(user);
session.getTransaction().commit();
session.close();
}
@Test
public void delete() throws Exception {
Session session = HibernateUtils.INSTANCE.getSession();
session.beginTransaction();
User user = (User) session.get(User.class, 1L);
if (user != null) {
session.delete(user);
}
session.getTransaction().commit();
session.close();
}
@Test
public void get() throws Exception {
Session session = HibernateUtils.INSTANCE.getSession();
User user = (User) session.get(User.class, 1L);
System.out.println(user);
session.close();
}
@Test
public void getAll() throws Exception {
Session session = HibernateUtils.INSTANCE.getSession();
Query query = session.createQuery("select u from User u");
List<User> list = query.list();
for (User user : list) {
System.out.println(user);
}
session.close();
}
}
源碼地址
https://github.com/je-ge/hibernate
如果覺得我的文章或者代碼對您有幫助,可以請我喝杯咖啡。
**您的支持將鼓勵我繼續(xù)創(chuàng)作!謝謝! **
微信打賞
支付寶打賞