1简介DB2是IBM的一款优秀的关系型数据库，简单了解一下。2Docker安装DB2为了快速启动，直接使用Docker安装DB2。首先下载镜像如下：dockerpullibmcom/db2:11.5.0.0启动数据库如下：dockerrun-itd\--namemydb2\--privileged=true\-p50000:50000\-eLICENSE=accept\-eDB2INST1_PASSWORD=pkslow\-eDBNAME=testdb\ibmcom/db2:11.5.0.0这样得到的数据库，具体信息如下：ConnectionURL:jdbc:db2://localhost:50000/testdbUsername:db2inst1密码：pkslow在IDEA上连接如下：默认schema为DB2INST1，测试SQL如下：建表：CREATETABLEEMPLOYEE_SALARY(DEPTNOCHAR(3)NOTNULL,DEPTNAMEVARCHAR(36)NOTNULL,EMPNOCHAR(6)NOTNULL,SALARYDECIMAL(9,2)NOTNULLWITHDEFAULT;插入数据：INSERTINTOEMPLOYEE_SALARY(DEPTNO,DEPTNAME,EMPNO,SALARY)VALUES('001','IT','001322',80000.00);INSERTINTOEMPLOYEE_SALARY(DEPTNO,DEPTNAME,EMPNO,SALARY)VALUES('001','IT','001323',20000.00);INSERTINTOEMPLOYEE_SALARY(DEPTNO,DEPTNAME,EMPNO,SALARY)VALUES('002','架构','001324',3220.00);插入EMPLOYEE_SALARY(,DEPTNAME,EMPNO,SALARY)VALUES('002','Architecture','001325',8000.00);插入EMPLOYEE_SALARY(DEPTNO,DEPTNAME,EMPNO,SALARY)VALUES('003','FrontOffice','001326',13320.00);插入EMPLOYEE_SALARY(DEPTNO,DEPTNAME,EMPNO,SALARY)VALUES('001','IT','001327',5433.00);查询：SELECT*FROMDB2INST1.EMPLOYEE_SALARY;SpringBoot整合DB2添加相关依赖：org.springframework.bootspring-boot-starter-weborg.springframework.bootspring-boot-starter-data-jpacom.ibm.db2jcc11.5.0.0配置相关属性：server.port=8082spring.datasource.url=jdbc:db2://localhost:50000/testdbspring.datasource.username=db2inst1spring.datasource.password=pkslowspring.jpa.generate-ddl=true创建实体：包com.pkslow.springboot.jpa.db2.entity；导入lombok.AllArgsConstructor；导入lombok.Data；导入lombok.NoArgsConstructor；导入javax.persistence.Entity；导入javax。persistence.Id;importjavax.persistence.Table;@Entity@Data@AllArgsConstructor@NoArgsConstructor@Table(name="EMPLOYEE",schema="DB2INST1")publicclassEmployee{@IdprivateLongid;privateStringname;}创建Repository类用于操作数据库：publicinterfaceEmployeeRepositoryextendsCrudRepository{}最后，写一个方法测试下：@Configuration@Slf4jpublicclassTestConfig{@AutowiredprivateEmployeeRepositoryrepository;@PostConstructpublicvoidinit(){Employeeemployee1=newEmployee(1L,"LarryDeng");Employeeemployee2=newEmployee(2L,"LarryDpk");Employeeemployee3=newEmployee(3L,"Pkslow");存储库.deleteAll();存储库.save(员工1);repository.save(employee2);repository.save(employee3);Listemployees=StreamSupport.stream(repository.findAll().spliterator(),false).collect(Collectors.toList());employees.forEach(e->log.info(e.toString()));}}启动后，日志正常打印如下：2022-02-2823:26:22.476INFO60847---[main]c.pkslow.springboot.jpa.db2.TestConfig:Employee(id=1,name=拉里邓)2022-02-2823:26:22.476信息60847---[主要]c.pkslow.springboot.jpa.db2。测试配置：员工（id=2，名称=LarryDpk）2022-02-2823：26：22.476INFO60847---[main]c.pkslow.springboot.jpa.db2.TestConfig：员工（id=3，名称=pkslow)表数据如下：代码代码请参考GitHub：https://github.com/LarryDpk/p...参考：DockerImageStatementsInsert
