Spring Boot 整合达梦数据库1、SQLCREATETABLEMYTEST.students(idINTPRIMARYKEY,-- 学生编号主键nameVARCHAR(50)NOTNULL,-- 学生姓名非空ageINT,-- 学生年龄genderCHAR(1),-- 学生性别gradeVARCHAR(20)-- 学生年级);INSERTINTOMYTEST.students(id,name,age,gender,grade)VALUES(1,张三,18,M,高一),(2,李四,17,F,高二),(3,王五,19,M,高三),(4,赵六,16,F,高一),(5,孙七,18,M,高二);2、Settingspom.xmlparentgroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-parent/artifactIdversion3.0.5/version/parentpropertiesmaven.compiler.source17/maven.compiler.sourcemaven.compiler.target17/maven.compiler.targetproject.build.sourceEncodingUTF-8/project.build.sourceEncodingmybatis.version3.0.1/mybatis.versiondameng.version8.1.1.49/dameng.versionlombok.version1.18.20/lombok.version/propertiesdependencies!-- springboot 开发所需要的起步依赖 --dependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-web/artifactId/dependency!-- mybatis 和 springboot 整合的起步依赖 --dependencygroupIdorg.mybatis.spring.boot/groupIdartifactIdmybatis-spring-boot-starter/artifactIdversion${mybatis.version}/version/dependency!-- 达梦数据库驱动 --dependencygroupIdcom.dameng/groupIdartifactIdDm8JdbcDriver18/artifactIdversion${dameng.version}/version/dependency!-- lombok --dependencygroupIdorg.projectlombok/groupIdartifactIdlombok/artifactIdversion${lombok.version}/version/dependency/dependencies3、EntityStudent.javaDataAllArgsConstructorNoArgsConstructorpublicclassStudent{privateintid;privateStringname;privateintage;privatechargender;privateStringgrade;}4、MapperStudentMapper.javaMapperpublicinterfaceStudentMapper{ListStudentqueryAll();}StudentMapper.xml?xml version1.0 encodingUTF-8 ?!DOCTYPEmapperPUBLIC-//mybatis.org//DTD Mapper 3.0//ENhttp://mybatis.org/dtd/mybatis-3-mapper.dtdmappernamespacecom.my.mapper.StudentMapperresultMapidstudentMaptypecom.my.model.entity.Studentidpropertyidcolumnid/resultpropertynamecolumnname/resultpropertyagecolumnage/resultpropertygendercolumngender/resultpropertygradecolumngrade//resultMapselectidqueryAllresultMapstudentMapselect * from students/select/mapper5、ServiceStudentService.javapublicinterfaceStudentService{ListStudentstudents();}StudentServiceImpl.javaServicepublicclassStudentServiceImplimplementsStudentService{AutowiredprivateStudentMapperstudentMapper;OverridepublicListStudentstudents(){returnstudentMapper.queryAll();}}6、ControllerStudentController.javaRestControllerRequestMapping(/student)publicclassStudentController{AutowiredprivateStudentServicestudentService;RequestMapping(/students)publicListStudentstudents(){returnstudentService.students();}}