景区网站建设的好处,谷歌网站怎么做排名,多媒体应用设计师怎么报考,百度搜索推广开户SpringBoot整合Mybaties 创建maven工程整合mybaties逆向代码生成 创建maven工程
1.通过idea创建maven工程如下图 2.生成的工程如下 以上我们就完成了一个maven工程#xff0c;接下来我们改造成springboot项目。 这里主要分为三步#xff1a;添加依赖#xff0c;增加配置接下来我们改造成springboot项目。 这里主要分为三步添加依赖增加配置增加注解 1.添加依赖
!--添加springboot父依赖--parentgroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-parent/artifactIdversion2.5.4/version/parentdependencies!--web依赖--dependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-web/artifactId/dependency!--test测试依赖--dependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-test/artifactIdscopetest/scope/dependency/dependencies2.添加配置文件application.yml增加端口号
3.修改启动类.增加SpringBootApplication注解 和修改主类SpringApplication.run(Main.class,args);如下
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;SpringBootApplication
public class Main {public static void main(String[] args) {SpringApplication.run(Main.class,args);}
}通过以上三步恭喜springboot项目搭建完成运行看下效果
整合mybaties
springboot整合任何中间件都是三步:依赖配置注解 1.依赖: dependencygroupIdorg.mybatis/groupIdartifactIdmybatis/artifactIdversion3.5.5/version/dependencydependencygroupIdorg.mybatis.generator/groupIdartifactIdmybatis-generator-core/artifactIdversion1.3.7/version/dependencydependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactIdversion8.0.21/version/dependency这里引入了三个依赖:第一个是springboot整合mybaties依赖后面两个是逆向工程的相关依赖 2.配置增加如下配置到配置文件根据需要修改用户名密码和数据库并且注意mapper-locations: classpath:mappers/*.xml的mappers路径 spring:datasource:url: jdbc:mysql://localhost:3306/course?useSSLfalseserverTimezoneGMTusername: rootpassword: 565
#指定mybatis映射文件的地址
mybatis:mapper-locations: classpath:mappers/*.xml
2.注解 Mapper这里先用这个注解在所有Mapper下的文件都加上该注解如下
逆向代码生成
增加配置
?xml version1.0 encodingUTF-8?
!DOCTYPE generatorConfigurationPUBLIC -//mybatis.org//DTD MyBatis Generator Configuration 1.0//ENhttp://mybatis.org/dtd/mybatis-generator-config_1_0.dtdgeneratorConfiguration!-- mysql-connector-java 版本需要与pom中引得版本一致 --classPathEntry locationE:\repository\mysql\mysql-connector-java\8.0.21\mysql-connector-java-8.0.21.jar /context idDB2Tables targetRuntimeMyBatis3!-- 不加注释因为默认注释是英文的 --commentGeneratorproperty nameaddRemarkComments valuetrue/property namesuppressDate valuetrue//commentGenerator!-- 数据库连接信息 --jdbcConnection driverClasscom.mysql.jdbc.DriverconnectionURLjdbc:mysql://localhost:3306/course?characterEncodingutf-8amp;useSSLfalseamp;serverTimezoneUTCuserIdrootpasswordluyao520/jdbcConnectionjavaTypeResolver property nameforceBigDecimals valuefalse //javaTypeResolver!-- targetPackage 文件生成在指定包下targetProject 路径--javaModelGenerator targetPackageedu.hbgy.rjz.entity targetProjectsrc/main/javaproperty nameenableSubPackages valuetrue /property nametrimStrings valuetrue //javaModelGeneratorsqlMapGenerator targetPackagemappers targetProjectsrc/main/resourcesproperty nameenableSubPackages valuetrue //sqlMapGeneratorjavaClientGenerator typeXMLMAPPER targetPackageedu.hbgy.rjz.dao targetProjectsrc/main/javaproperty nameenableSubPackages valuetrue //javaClientGenerator!-- domainObjectName 即生成后entity的名字 --table tableName order domainObjectNameOrder //context
/generatorConfiguration classPathEntry locationE:\repository\mysql\mysql-connector-java\8.0.21\mysql-connector-java-8.0.21.jar /这个路径要写自己jar包的路径2.引入插件 在pom.xml中加入
buildfinalName${artifactId}/finalNamepluginsplugingroupIdorg.mybatis.generator/groupIdartifactIdmybatis-generator-maven-plugin/artifactIdversion1.3.7/versionconfiguration!-- generator 工具配置文件的位置 --configurationFilesrc/main/resources/generatorConfig.xml/configurationFileverbosetrue/verboseoverwritetrue/overwrite/configuration!-- 添加这部分的依赖 --/pluginplugingroupIdorg.springframework.boot/groupIdartifactIdspring-boot-maven-plugin/artifactId/plugin/plugins/build如下所示: 加入之后maven插件如下所示 运行之后会生成代码目录结构: 再次启动项目确认启动成功:
至此我们的整合工作结束
测试一下创建一个controller包并创建类UserController
package edu.hbgy.rjz.controller;import edu.hbgy.rjz.dao.UserMapper;
import edu.hbgy.rjz.entity.User;
import edu.hbgy.rjz.entity.UserExample;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;import javax.annotation.Resource;
import java.util.List;RestController
public class UserController {Resourceprivate UserMapper userMapper;RequestMapping(valueuser/del, method RequestMethod.POST)public Integer del(RequestBody User user){UserExample example new UserExample();example.createCriteria().andIdEqualTo(user.getId());Integer count userMapper.deleteByExample(example);return count;}
}启动运行: