BeetlSQL介紹

BeetlSQL的目標是提供開發(fā)高效，維護高效，運行高效的數(shù)據(jù)庫訪問框架，在一個系統(tǒng)多個庫的情況下，提供一致的編寫代碼方式。支持如下數(shù)據(jù)平臺

• 傳統(tǒng)數(shù)據(jù)庫：MySQL(國內(nèi)兼容MySQL協(xié)議的各種大數(shù)據(jù)庫),MariaDB,Oracle,Postgres,DB2,SQL Server，H2,SQLite,Derby，神通，達夢，華為高斯，人大金倉，PolarDB等
• 大數(shù)據(jù)：HBase，ClickHouse，Cassandar，Hive
• 物聯(lián)網(wǎng)時序數(shù)據(jù)庫：Machbase，TD-Engine，IotDB
• SQL查詢引擎:Drill,Presto，Druid
• 內(nèi)存數(shù)據(jù)庫:ignite，CouchBase

BeetlSQL 不僅僅是簡單的類似MyBatis或者是Hibernate，或者是二者的綜合，BeetlSQL遠大理想是對標甚至超越Spring Data，是實現(xiàn)數(shù)據(jù)訪問統(tǒng)一的框架，無論是傳統(tǒng)數(shù)據(jù)庫，還是大數(shù)據(jù)，還是查詢引擎或者時序庫，內(nèi)存數(shù)據(jù)庫。
官網(wǎng)資料：https://www.kancloud.cn/xiandafu/beetlsql3_guide/3033051

BeetlSQL適配

項目適配的gitee地址：https://gitee.com/gy297879328/beetlsql3.x_dm 代碼拉下來后，修改application.properties中達夢連接串可以直接跑項目

初始化sql語句

CREATE TABLE "SYS_USER" (
  "id" INT NOT NULL,
  "name" varchar(255) DEFAULT NULL,
  "department_id" int DEFAULT NULL,
  "create_time" date DEFAULT NULL,
  PRIMARY KEY ("id")
) ;


INSERT INTO "SYS_USER" VALUES (1, 'lijz', 1, NULL);
INSERT INTO "SYS_USER" VALUES (2, 'lucy', 1, NULL);
INSERT INTO "SYS_USER" VALUES (3, 'bear', 2, NULL);
INSERT INTO "SYS_USER" VALUES (4, 'mike', 1, NULL);
INSERT INTO "SYS_USER" VALUES (5, 'lisan', 1, NULL);
INSERT INTO "SYS_USER" VALUES (6, 'xb', 1, NULL);
INSERT INTO "SYS_USER" VALUES (7, 'duanwu', 2, NULL);
INSERT INTO "SYS_USER" VALUES (8, 'fenh', 1, NULL);
INSERT INTO "SYS_USER" VALUES (9, 'lj', 2, NULL);
INSERT INTO "SYS_USER" VALUES (10, 'gshen', 1, NULL);
INSERT INTO "SYS_USER" VALUES (11, 'lihui', 1, NULL);

pom引入依賴

        <dependency>
            <groupId>com.ibeetl</groupId>
            <artifactId>sql-springboot-starter</artifactId>
            <version>3.23.3-RELEASE</version>
        </dependency>

        <dependency>
            <groupId>com.dameng</groupId>
            <artifactId>DmJdbcDriver18</artifactId>
            <version>8.1.2.192</version>
        </dependency>

application.properties

spring.datasource.url=jdbc:dm://127.0.0.1:5236
spring.datasource.username=SYSDBA
spring.datasource.password=SYSDBA
spring.datasource.driver-class-name=dm.jdbc.driver.DmDriver
beetlsql.sqlManagers=sqlManager1
beetlsql.sqlManager1.ds=ds1
beetlsql.sqlManager1.basePackage=com.dameng.beetlsql3_x_dm
beetlsql.sqlManager1.dbStyle=org.beetl.sql.core.db.DamengStyle

SimpleDataSourceConfig

在com.dameng.beetlsql3_x_dm.DataSource目錄下新建連接類文章來源地址http://www.zghlxwxcb.cn/news/detail-697964.html

package com.dameng.beetlsql3_x_dm.DataSource;


import com.zaxxer.hikari.HikariDataSource;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.ApplicationContext;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.core.env.Environment;

import javax.sql.DataSource;


@Configuration
public class SimpleDataSourceConfig {
    @Autowired
    ApplicationContext ctx;

    @Primary
    @Bean(name = "ds1")
    public DataSource datasource(Environment env) {
        HikariDataSource ds = new HikariDataSource();
        ds.setJdbcUrl(env.getProperty("spring.datasource.url"));
        ds.setUsername(env.getProperty("spring.datasource.username"));
        ds.setPassword(env.getProperty("spring.datasource.password"));
        ds.setDriverClassName(env.getProperty("spring.datasource.driver-class-name"));
        return ds;
    }

}

UserService

package com.dameng.beetlsql3_x_dm.Service;

import com.dameng.beetlsql3_x_dm.Domain.UserInfo;
import com.dameng.beetlsql3_x_dm.Mapper.UserMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;

@Service
@Transactional
public class UserService {
    @Autowired
    UserMapper userMapper;

    public void selectUserList() {
        List<UserInfo> allList = userMapper.all();
        System.out.println(allList);
    }
}
  

到了這里，關(guān)于beetlsql3.x版本適配達夢數(shù)據(jù)庫的文章就介紹完了。如果您還想了解更多內(nèi)容，請在右上角搜索TOY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！