gbase的安装及使用

安装 创建用户

创建用户

# 创建linux用户
useradd gbase
# 设置新用户密码
passd gbase
# 123456

赋予root权限

# 修改文件
vim /etc/sudoers

# 去点注释这两行的
## Allos people in group heel to run all mands
# %heel ALL=(ALL) ALL

# 将用户放入root分组
usermod -g root gbase

# 切换用户
su - gbase

安装

下载

http://.gbase8a./Topic/173

get http://.gbase8a./forum.php?mod=attachment&aid=Mzc4fGI0MjQ3YzgfDE2NDgMjQ5MDN8ODU1MX4MTY=&filename=Gbase8a-8.6.2_build33-R3-rhel7.3--free.rar

加压

# 将 Gbase8a-8.6.2_build33-R3-rhel7.3--free.rar 重新打包 Gbase8a-8.6.2_build33-R3-rhel7.3--free.zip
unzip Gbase8a-8.6.2_build33-R3-rhel7.3--free.zip
tar -xvf Gbase8a-NoLicense-Free-8.6.2_build33-R3-redhat7.3-x86_64.tar.bz2

pd
/home/gbase/Gbase8a-8.6.2_build33-R3-rhel7.3--free/Gbase8a-8.6.2_build33-R3-rhel7.3--free/GbaseInstall

安装

sh ./Install_lin.sh
# 许可协议选择Y
# 安装路径可以修改默认为~/Gbase（即当前用户根目录下的Gbase目录），按Enter
# 实例名默认为gbase8a，如果不修改按Enter
# 端口默认为5258，不修改按Enter
# 显示“Your Gbase installation is suessful.”时，表示您已成功安装了 Gbase 8a 数据库

修改配置文件

# 在此文件中添加环境变量
vim /etc/profile
# 立即生效命令
source /etc/profile

新增

export Gbase_base=/home/gbase/Gbase
export Gbase_HOME=/home/gbase/Gbase/server
export Gbase_SID=gbase8a
export PATH=$Gbase_HOME/bin:$PATH

启动

su - gbase
cd /home/gbase/Gbase/server/bin
./gbase.server start

# 出现以下
# Starting Gbase. SUCCESS! 

登录

# 登录
gbase -uroot
# 设置密码
gbase> SET PASSWORD FOR root = PASSWORd('123456');
# 退出
gbase>  q

# 登录
gbase -uroot -p

客户端

下载地址

https://.gbase8s./index.php/gbase8s_tools.html  

http://.gbase8a./forum.php?mod=forumdisplay&fid=100

springboot整合

目录结构

├─java
│  └─
│   └─gbase
│    └─gbase
│     ├─controller
│     └─mapper
└─resources
 └─mapper

下载依赖

gbase-connector-java-8.3.81.53-build52.8-bin.jar

将依赖压入maven

mvn install:install-file -Dfile=D:gbase-connector-java-8.3.81.53-build52.8-bin.jar  -DgroupId=.gbase.jdbc -DartifactId=gbase-connector-java -Dversion=8.3.81.53-build52.8-bin -Dpackaging=jar -DgeneratePom=true

引入依赖

 .gbase.jdbc
 gbase-connector-java
 8.3.81.53-build52.8-bin	


 
  .alibaba
  druid


 .mybatis.spring.boot
 mybatis-spring-boot-starter


 .mybatis
 mybatis-typehandlers-jsr310

yml

server:
  port: 8080
spring:
  datasource:
 url: jdbc:gbase://192.168.1.110:5258/test
 username: root
 passord: 123456
 driver-class-name: .gbase.jdbc.Driver
 #maximum-pool-size: 10

mybatis:
  mapper-locations: classpath:mapper//Mapper.xml
  #type-aliases-package: .yuanlai.entiy

mybatis

mapper.java

@Mapper
public interface TestMapper {
 Integer findAll();
}

mapper.xml

 
 
  select count() from teacher;
 

controller

@RestController
public class TestController {

 @Autoired
 TestMapper testMapper;

 @GetMapping("/findAll")
 public Integer findAll(){
  return testMapper.findAll();
 }
}

测试

http://localhost:8080/findAll