Hibernate整合DM數據庫

本次的項目的目錄結構如下

一、建庫的SQL語句

CREATE TABLE "SYSDBA"."DM_BRAND" ( "ID" INT IDENTITY(1, 1) NOT NULL, "BRAND_ID" VARCHAR(50), "BRAND_NAME" VARCHAR(50), "BRAND_JC" CHAR(10), CLUSTER PRIMARY KEY("ID"), UNIQUE("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;COMMENT ON TABLE "SYSDBA"."DM_BRAND" IS '商品品牌表'; COMMENT ON COLUMN "SYSDBA"."DM_BRAND"."BRAND_ID" IS 'UUID'; COMMENT ON COLUMN "SYSDBA"."DM_BRAND"."BRAND_NAME" IS '品牌名稱'; COMMENT ON COLUMN "SYSDBA"."DM_BRAND"."BRAND_JC" IS '品牌簡稱';INSERT INTO "DM_BRAND"("BRAND_ID","BRAND_NAME","BRAND_JC") VALUES('597059da5f214a538651a7aec378d111','華為','HW'); INSERT INTO "DM_BRAND"("BRAND_ID","BRAND_NAME","BRAND_JC") VALUES('219bdf86ae8a4f659bb0fc414c75a2e4','聯想','LX'); INSERT INTO "DM_BRAND"("BRAND_ID","BRAND_NAME","BRAND_JC") VALUES('2d161e6594b344b287b469808dddc95f','三星','SX'); INSERT INTO "DM_BRAND"("BRAND_ID","BRAND_NAME","BRAND_JC") VALUES('191aa9565cf344b1afca6821e04da81e','小米','MI');

二、引入依賴

還有 drives目錄下jdbc的包跟方言包

<dependencies><dependency><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId><version>1.16.10</version><scope>provided</scope></dependency><dependency><groupId>org.hibernate</groupId><artifactId>hibernate-core</artifactId><version>5.4.10.Final</version></dependency></dependencies><build><resources><resource><directory>src/main/java</directory><includes><include> **/*.xml</include></includes></resource></resources></build>

三、resources下新建hibernate.cfg.xml

<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE hibernate-configuration SYSTEM"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd"><hibernate-configuration><session-factory><!-- 這個屬性使 Hibernate 應用為被選擇的數據庫生成適當的 SQL --><property name="hibernate.dialect">org.hibernate.dialect.DmDialect</property><!-- JDBC 驅動程序類 --><property name="hibernate.connection.driver_class">dm.jdbc.driver.DmDriver</property><!-- Assume test is the database name --><!-- 數據庫實例的 JDBC URL --><property name="hibernate.connection.url">jdbc:dm://localhost:5236</property><!-- 數據庫用戶名 --><property name="hibernate.connection.username">SYSDBA</property><!-- 數據庫密碼 --><property name="hibernate.connection.password">SYSDBA</property><!-- 是否顯示 SQL --><property name="hibernate.show_sql">true</property><!-- 是否將 SQL 格式化 --><property name="hibernate.format_sql">true</property><!-- 是否自動在數據庫中生成表 --><property name="hibernate.hbm2ddl.auto">update</property><!-- 事物自動提交 --><property name="hibernate.connection.autocommit">true</property><!-- 針對大字段處理 --><property name="hibernate.connection.SetBigStringTryClob">true</property><!-- List of XML mapping files --><!-- 下面是映射的類 --><mapping resource="com/dameng/entity/DMBRAND.hbm.xml"/></session-factory> </hibernate-configuration>

四、新建實體類DMBRAND

package com.dameng.entity;import lombok.Data;@Data public class DMBRAND {private Integer ID;private String BRAND_ID;private String BRAND_NAME;private String BRAND_JC; }

五、新建配置類DMBRAND.hbm.xml

<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE hibernate-mapping PUBLIC"-//Hibernate/Hibernate Mapping DTD 3.0//EN""http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping><class name="com.dameng.entity.DMBRAND" table="DM_BRAND"><id name="ID" type="java.lang.Integer"><column name="ID" /><generator class="identity" /></id><property name="BRAND_ID" type="java.lang.String"><column name="BRAND_ID" length="50" not-null="true" /></property><property name="BRAND_NAME" type="java.lang.String"><column name="BRAND_NAME" length="50" not-null="true" /></property><property name="BRAND_JC" type="java.lang.String"><column name="BRAND_JC" length="50" not-null="true" /></property></class> </hibernate-mapping>

六、新建測試類

package com.dameng.test;import com.dameng.entity.DMBRAND; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.cfg.Configuration; import org.hibernate.query.Query;import java.util.List;/*** @author xgt(小光頭)* @version 1.0* @date 2022-1-25 16:11*/ public class T_CRUD {public static void main(String[] args) {Configuration configuration = new Configuration().configure();System.out.println(configuration);SessionFactory sessionFactory = configuration.buildSessionFactory();Session session = sessionFactory.openSession();DMBRAND dmbrand = new DMBRAND();dmbrand.setBRAND_JC("XX");dmbrand.setBRAND_NAME("Test");dmbrand.setBRAND_ID("ss");session.save(dmbrand);session.beginTransaction().commit();Query query = session.createQuery("from DMBRAND WHERE BRAND_NAME=?0").setParameter(0,"Test");List<DMBRAND> list = query.list();for (DMBRAND dmbrand1 : list) {System.out.println(dmbrand1.getBRAND_NAME()+"========="+dmbrand1.getBRAND_JC());}session.close();} }

資料

鏈接：https://pan.baidu.com/s/1xGr4Jg8bfxq28Wi3PROLWg

提取碼：zd1w

總結

以上是生活随笔為你收集整理的Hibernate框架整合DM数据库的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。