# RuoyiDB2

**Repository Path**: 5445/ruoyi-db2

## Basic Information

- **Project Name**: RuoyiDB2
- **Description**: No description available
- **Primary Language**: Java
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 2
- **Forks**: 2
- **Created**: 2022-04-28
- **Last Updated**: 2024-05-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 若依DB2版本

## 依赖及建立连接
pom.xml

```xml
        <db2.version>db2jcc4</db2.version>

        <!--db2驱动 admin -->
		<dependency>
		<groupId>com.ibm.db2.jcc</groupId>
		<artifactId>db2jcc</artifactId>
		<version>${db2.version}</version>
		</dependency>
```

application-druid.yml

```yaml
        driverClassName: com.ibm.db2.jcc.DB2Driver
        druid:
         # 主库数据源
         master:
          url: jdbc:db2://192.168.2.245:50000/HMHDDB:currentSchema=DEMO;
          username: root
          password: 123456
```
## 分页
application.yml

```yaml
pagehelper:
 helperDialect: DB2
```
## mybatis配置
mybatis-config.xml

```xml
<!--mybatis-config.xml-->
<properties>
 <property name="db2databaseName." value="demo."/><!-- db2数据库配置名称 后面加上一个点-->
 <property name="db2databaseName" value="demo"/><!-- db2数据库配置名称 后面不加点-->
</properties>
```

## Docker
```yaml
version: '3.1'
services:
  db2:
    image: ibmcom/db2
    restart: always
    container_name: db2
    privileged: true
    environment:
      LICENSE: accept
      DB2INST1_PASSWORD: 123456
      DBNAME: DB2DB
    volumes:
      - ./db2data:/database
    ports:
      - 50000:50000
```
## 创建数据库
```bash
#创建用户组
groupadd db2group
#添加用户到该组
useradd -m -g db2group -d /home/db2root db2root
#修改test密码
passwd db2root
#连续输入两次密码
#切换到db2inst1用户下给db2root赋予连接权限
su db2inst1
#连接数据库
db2 connect to db2db
#赋予连接权限
db2 grant connect on database to user db2root
#赋予增删改查权限
db2 grant DATAACCESS on database to user db2root
#赋予数据库权限
db2 grant DBADM on database to user db2root
#关闭连接
db2 connect reset
#其他常用命令
#创建数据库
db2 create db db2db using codeset utf-8 territory CN
#查看当前所有数据库
db2 list db direcotry
#查看库中的表名
db2 list tables
#更多命令省略
```