gbase的安装及使用

创建用户

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

赋予root权限

# 修改文件
vim /etc/sudoers

# 去点注释这两行的
## Allows people in group wheel to run all commands
# %wheel ALL=(ALL) ALL

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

# 切换用户
su - gbase

下载

http://www.gbase8a.com/Topic/173

wget http://www.gbase8a.com/forum.php?mod=attachment&aid=Mzc4fGI0MjQ3YzgwfDE2NDgwMjQ5MDN8ODU1MXw4MTY=&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

pwd
/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 successful.”时，表示您已成功安装了 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://www.gbase8s.com/index.php/gbase8s_tools.html  

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

目录结构

├─java
│  └─com
│      └─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=com.gbase.jdbc -DartifactId=gbase-connector-java -Dversion=8.3.81.53-build52.8-bin -Dpackaging=jar -DgeneratePom=true

引入依赖

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


 
     com.alibaba
     druid


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


    org.mybatis
    mybatis-typehandlers-jsr310

yml

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

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

mybatis

mapper.java

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

mapper.xml

    
    
        select count(*) from teacher;
    

controller

@RestController
public class TestController {

    @Autowired
    TestMapper testMapper;

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

测试

http://localhost:8080/findAll