金仓数据库安装

news/2024/4/26 22:18:23/文章来源:https://blog.csdn.net/qq_22310551/article/details/129199860

一、麒麟操作系统安装金仓数据库

操作系统

DISTRIB_ID=Kylin

DISTRIB_RELEASE=V10

DISTRIB_CODENAME=juniper

按照安装文档的步骤安装，记得记住设置的数据库的用户名、密码

二、window安装连接数据库的工具软件

三、jdbc连接数据库

（1）连接工具or数据库如下路径找到jdbc的依赖jar，运行mvn命令安装到maven本地仓库

安装到maven本地仓库

mvn install:install-file -Dfile=D:\kingbase\KESRealPro\V008R006C007B0012\Interface\jdbc\kingbase8-8.6.0.jar -DgroupId=com.kingbase8 -DartifactId=kingbase8 -Dversion=8.6.0 -Dpackaging=jar

（2）pom添加依赖

    <dependencies><dependency><groupId>com.kingbase8</groupId><artifactId>kingbase8</artifactId><version>8.6.0</version></dependency></dependencies>

（3）spring boot 程序测试引入了 druid作为连接池


spring:datasource:username: kingbasepassword: kb6688??#?serverTimezone=UTC解决时区的报错url: jdbc:kingbase8://ip:54321/testdriverClassName: com.kingbase8.Drivertype:  com.alibaba.druid.pool.DruidDataSource#Spring Boot 默认是不注入这些属性值的，需要自己绑定#druid 数据源专有配置initialSize: 5minIdle: 5maxActive: 20maxWait: 60000timeBetweenEvictionRunsMillis: 60000minEvictableIdleTimeMillis: 300000validationQuery: SELECT 1 FROM DUALtestWhileIdle: truetestOnBorrow: falsetestOnReturn: falsepoolPreparedStatements: true

package com.example.oceanbase;import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.CommandLineRunner;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.jdbc.core.JdbcTemplate;import java.sql.Connection;
import java.sql.DriverManager;
import java.util.List;
import java.util.Map;@SpringBootApplication
public class Application implements CommandLineRunner {@Autowiredprivate JdbcTemplate jdbcTemplate;public static void main(String[] args) {SpringApplication.run(Application.class, args);}//重写CommandLineRunner接口中的run方法@Overridepublic void run(String... args) throws Exception {//调用业务方法List<Map<String, Object>> res =jdbcTemplate.queryForList("select * from test");System.out.println("str = " + res.get(0).toString());System.out.println("insert = " + jdbcTemplate.queryForList("select * from action_object").size());jdbcTemplate.update("update action_object set pic_url ='test' where id=45 ");System.out.println("update = " + jdbcTemplate.queryForList("select * from action_object").size());jdbcTemplate.update("delete from action_object where id=45");System.out.println("delete = " + jdbcTemplate.queryForList("select * from action_object").size());}
}

参考文档