样例阅读说明

项目说明

motan 转 feign

packagetest.api;publicinterfaceDemoApi {Stringhello(Stringworld);UserupdateUser(Useruser);}

importcom.weibo.api.motan.config.springsupport.annotation.MotanService;importtest.api.DemoApi;importtest.api.User;@MotanService(export ="demoMotan:8002")publicclassDemoApiImplimplementsDemoApi {@OverridepublicStringhello(Stringworld) {return"hello:"+world;    }@OverridepublicUserupdateUser(Useruser) {user.setRemark("信息已经修改");returnuser;    }}

@MotanRefererDemoApidemoApi;

@FeignClient("demo")@RequestMapping("_api")publicinterfaceDemoRestApi {@RequestMapping("/")Stringhello(@RequestParam("world")Stringworld);@RequestMapping("/user")UserupdateUser(@RequestBodyUseruser);}

importorg.springframework.web.bind.annotation.RequestBody;importorg.springframework.web.bind.annotation.RequestMapping;importorg.springframework.web.bind.annotation.RequestParam;importorg.springframework.web.bind.annotation.RestController;importtest.api.DemoApi;importtest.api.User;@RestController@RequestMapping("_api")publicclassDemoApiRestfulImplimplementsDemoApi {@Override@RequestMappingpublicStringhello(@RequestParam("world")Stringworld) {return"restful hello !" +world;    }@Override@RequestMapping("user")publicUserupdateUser(@RequestBodyUseruser) {user.setRemark("restful 信息已经修改");returnuser;    }}

@AutowiredDemoRestApidemoRestApi;

demo:ribbon:listOfServers:http://localhost:8081

多参数改成单参数

/** * 替换例子，把motan 的多参数封装成一个参数传输 * @param rpcRequestVo * @return */@RequestMapping("update")List<User>update(RpcRequestVo<User>rpcRequestVo);

调用样例

//多参数封装例子RpcRequestVo<User>rpcRequestVo =newRpcRequestVo<>();//设置一些分页参数rpcRequestVo.setPageNumber(0);rpcRequestVo.setPageSize(10);//传递一些排序参数RpcRequestOrderVorpcRequestOrderVo =newRpcRequestOrderVo("name",RpcRequestOrderVo.ORDER_TYPE_DESC);rpcRequestVo.addOrder(rpcRequestOrderVo);rpcRequestVo.setArgs(user);demoRestApi.update(rpcRequestVo);

jpa 转 mybatic

样例说明

/*** jap 使用例子** @return*/@RequestMapping("jpa")publicObjectjpa() {//jpa 保存级联例子businessUserService.japSave();//jpa 查询例子businessUserService.jpaQuery();returnMaps.newHashMap();}@RequestMapping("mybatis")publicObjectmybatis() {// mybatis 保存例子，例子中使用了mybatis plus ，未使用过的同事请先阅读对应的文档List<User>userPos =businessUserService.mybatisSave();// mybatis 查询例子businessUserService.mybatis`();returnuserPos;}/**     * jpa 转 mybatis 显示     * @return     */@RequestMapping("j2m")publicObjectjpaToMybatis(){UserEntityuserEntity =newUserEntity();userEntity.setName("jpa to mybatis demo");businessUserService.jpaToMybatisDemo(userEntity);returnnull;}

//jpa code ...List<Order>orders =user.getOrders();//mybatis code ...LonguserId =user.getId();List<Order>orders =orderMappers.findByUserId(userId);

mybatis 编码建议

整合mybatis plus

        <dependency>            <groupId>org.springframework.boot</groupId>            <artifactId>spring-boot-starter-data-jpa</artifactId>        </dependency><!--        mybatis plus 依赖， generator 用于从数据库反向生成代码-->        <dependency>            <groupId>com.baomidou</groupId>            <artifactId>mybatis-plus-boot-starter</artifactId>            <version>3.2.0</version>        </dependency>        <dependency>            <groupId>com.baomidou</groupId>            <artifactId>mybatis-plus-generator</artifactId>            <version>3.4.1</version>            <scope>test</scope>        </dependency><!--        用于开发时输出对应的sql 日志-->        <dependency>            <groupId>com.googlecode.log4jdbc</groupId>            <artifactId>log4jdbc</artifactId>            <version>1.2</version>        </dependency><!--        方便演示使用内嵌的数据库，web 界面请见 application.yml-->        <dependency>            <groupId>com.h2database</groupId>            <artifactId>h2</artifactId>        </dependency>

MybatisPlug 插件配置

@Configuration@MapperScan("test.server.mybatis.mapper")publicclassMybatisConfig {/**     * 新的分页插件,一缓和二缓遵循mybatis的规则,需要设置 MybatisConfiguration#useDeprecatedExecutor = false 避免缓存出现问题(该属性会在旧插件移除后一同移除)     */@BeanpublicMybatisPlusInterceptormybatisPlusInterceptor() {MybatisPlusInterceptorinterceptor =newMybatisPlusInterceptor();interceptor.addInnerInterceptor(newPaginationInnerInterceptor(DbType.H2));returninterceptor;    }@BeanpublicConfigurationCustomizerconfigurationCustomizer() {returnconfiguration ->configuration.setUseDeprecatedExecutor(false);    }}

相关配置项

spring:jpa:hibernate:ddl-auto:updatedatasource:#    url: jdbc:h2:~/testurl:jdbc:log4jdbc:h2:~/testusername:sapassword:sadriver-class-name:net.sf.log4jdbc.DriverSpy#    driver-class-name: org.h2.Driverh2:console:enabled:truesettings:web-allow-others:truetrace:truepath:/h2logging:level:jdbc:errorjdbc.sqltiming:info

#    url: jdbc:h2:~/testurl:jdbc:log4jdbc:h2:~/test

driver-class-name:net.sf.log4jdbc.DriverSpy#    driver-class-name: org.h2.Driver

jdbc:errorjdbc.sqltiming:info

代码自动生成

packagetest.server;importcom.baomidou.mybatisplus.annotation.DbType;importcom.baomidou.mybatisplus.core.exceptions.MybatisPlusException;importcom.baomidou.mybatisplus.core.toolkit.StringPool;importcom.baomidou.mybatisplus.generator.AutoGenerator;importcom.baomidou.mybatisplus.generator.InjectionConfig;importcom.baomidou.mybatisplus.generator.config.*;importcom.baomidou.mybatisplus.generator.config.po.TableInfo;importcom.baomidou.mybatisplus.generator.config.rules.NamingStrategy;importcom.baomidou.mybatisplus.generator.engine.FreemarkerTemplateEngine;importorg.apache.commons.lang3.StringUtils;importjava.util.ArrayList;importjava.util.List;importjava.util.Scanner;publicclassMybatisGenerator {/*代码生成器        AutoGenerator 是 MyBatis-Plus 的代码生成器，通过 AutoGenerator 可以快速生成 Entity、Mapper、Mapper XML、Service、Controller 等各个模块的代码，极大的提升了开发效率。        特别说明:        自定义模板有哪些可用参数？Github Gitee AbstractTemplateEngine 类中方法 getObjectMap 返回 objectMap 的所有值都可用。        演示效果图：        relationship*/// 演示例子，执行 main 方法控制台输入模块表名回车自动生成对应项目目录中/**     * <p>     * 读取控制台内容     * </p>     */publicstaticStringscanner(Stringtip) {Scannerscanner =newScanner(System.in);StringBuilderhelp =newStringBuilder();help.append("请输入" +tip +"：");System.out.println(help.toString());if (scanner.hasNext()) {Stringipt =scanner.next();if (StringUtils.isNotBlank(ipt)) {returnipt;            }        }thrownewMybatisPlusException("请输入正确的" +tip +"！");    }publicstaticvoidmain(String[]args) {// 代码生成器AutoGeneratormpg =newAutoGenerator();// 全局配置GlobalConfiggc =newGlobalConfig();StringprojectPath ="D:\\dev\\motan-demo\\server";gc.setOutputDir(projectPath +"/src/main/java");gc.setAuthor("hgq@sinosoft");gc.setOpen(false);// gc.setSwagger2(true); 实体属性 Swagger2 注解mpg.setGlobalConfig(gc);// 数据源配置DataSourceConfigdsc =newDataSourceConfig();//        dsc.setUrl("jdbc:mysql://localhost:3306/ant?useUnicode=true&useSSL=false&characterEncoding=utf8");dsc.setUrl("jdbc:h2:~/test");dsc.setDbType(DbType.H2);// dsc.setSchemaName("public");dsc.setDriverName("org.h2.Driver");dsc.setUsername("sa");dsc.setPassword("sa");mpg.setDataSource(dsc);// 包配置PackageConfigpc =newPackageConfig();//        pc.setModuleName(scanner("模块名"));pc.setModuleName("mybatis");pc.setParent("test.server");mpg.setPackageInfo(pc);// 自定义配置InjectionConfigcfg =newInjectionConfig() {@OverridepublicvoidinitMap() {// to do nothing            }        };// 如果模板引擎是 freemarkerStringtemplatePath ="/templates/mapper.xml.ftl";// 如果模板引擎是 velocity// String templatePath = "/templates/mapper.xml.vm";// 自定义输出配置List<FileOutConfig>focList =newArrayList<>();// 自定义配置会被优先输出focList.add(newFileOutConfig(templatePath) {@OverridepublicStringoutputFile(TableInfotableInfo) {// 自定义输出文件名 ， 如果你 Entity 设置了前后缀、此处注意 xml 的名称会跟着发生变化！！returnprojectPath +"/src/main/resources/mapper/" +pc.getModuleName()                        +"/" +tableInfo.getEntityName() +"Mapper" +StringPool.DOT_XML;            }        });/*        cfg.setFileCreate(new IFileCreate() {            @Override            public boolean isCreate(ConfigBuilder configBuilder, FileType fileType, String filePath) {                // 判断自定义文件夹是否需要创建                checkDir("调用默认方法创建的目录，自定义目录用");                if (fileType == FileType.MAPPER) {                    // 已经生成 mapper 文件判断存在，不想重新生成返回 false                    return !new File(filePath).exists();                }                // 允许生成模板文件                return true;            }        });        */cfg.setFileOutConfigList(focList);mpg.setCfg(cfg);// 配置模板TemplateConfigtemplateConfig =newTemplateConfig();// 配置自定义输出模板//指定自定义模板路径，注意不要带上.ftl/.vm, 会根据使用的模板引擎自动识别// templateConfig.setEntity("templates/entity2.java");// templateConfig.setService();// templateConfig.setController();templateConfig.setXml(null);mpg.setTemplate(templateConfig);// 策略配置StrategyConfigstrategy =newStrategyConfig();strategy.setNaming(NamingStrategy.underline_to_camel);strategy.setColumnNaming(NamingStrategy.underline_to_camel);//        strategy.setSuperEntityClass("你自己的父类实体,没有就不用设置!");strategy.setEntityLombokModel(false);//        strategy.setEntityLombokModel(true);strategy.setRestControllerStyle(true);// 公共父类//        strategy.setSuperControllerClass("你自己的父类控制器,没有就不用设置!");// 写于父类中的公共字段strategy.setSuperEntityColumns("id");//        strategy.setInclude(scanner("表名，多个英文逗号分割").split(","));strategy.setInclude("USER,ORDERT".split(","));strategy.setControllerMappingHyphenStyle(true);strategy.setTablePrefix(pc.getModuleName() +"_");mpg.setStrategy(strategy);mpg.setTemplateEngine(newFreemarkerTemplateEngine());mpg.execute();    }}

<dependency>    <groupId>org.springframework.boot</groupId>    <artifactId>spring-boot-starter-freemarker</artifactId></dependency>

D:.├─controller│      OrdertController.java│      UserController.java│├─entity│      Ordert.java│      User.java│├─mapper│      OrdertMapper.java│      UserMapper.java│└─service    │  IOrdertService.java    │  IUserService.java    │    └─impl            OrdertServiceImpl.java            UserServiceImpl.java------------------------------D:.│  application.yml│└─mapper    └─mybatis            OrdertMapper.xml            UserMapper.xml

gc.setServiceName("I%sDao");gc.setServiceImplName("%sDaoImpl");

一对多关联配置

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPEmapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mappernamespace="test.server.mybatis.mapper.UserMapper">    <resultMapid="userResultMap"type="test.server.mybatis.entity.User">        <idcolumn="id"property="id"></id>        <resultproperty="name"column="name"/>        <collectionproperty="ordertList"column="id"select="selectOrderByUserId"/>    </resultMap>    <selectid="selectOrderByUserId"parameterType="int"resultMap="test.server.mybatis.mapper.OrdertMapper.orderResultMap">        select id,name,user_id from ordert where user_id = #{id}    </select>    <selectid="selectByUserId"parameterType="long"resultMap="userResultMap">        select id,name from user where id= #{id}    </select></mapper>

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPEmapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mappernamespace="test.server.mybatis.mapper.OrdertMapper">    <resultMapid="orderResultMap"type="test.server.mybatis.entity.Ordert">        <idcolumn="id"property="id"></id>        <resultproperty="name"column="name"/>        <resultproperty="userId"column="user_id"/>        <associationproperty="user"column="user_id"select="test.server.mybatis.mapper.UserMapper.selectByUserId"></association>    </resultMap></mapper>

packagetest.server.mybatis.entity;importcom.baomidou.mybatisplus.annotation.IdType;importcom.baomidou.mybatisplus.annotation.TableId;importcom.baomidou.mybatisplus.annotation.TableName;importjava.io.Serializable;importjava.util.Objects;/** * <p> * * </p> * * @author hgq@sinosoft * @since 2020-11-11 */@TableName(value ="ORDERT",resultMap ="orderResultMap")publicclassOrdertimplementsSerializable {privatestaticfinallongserialVersionUID =1L;@TableId(type =IdType.AUTO)privateLongid;privateStringname;privateUseruser;publicUsergetUser() {returnuser;    }publicvoidsetUser(Useruser) {this.user =user;    }//    private Long userId;publicLonggetId() {returnid;    }publicvoidsetId(Longid) {this.id =id;    }publicStringgetName() {returnname;    }publicvoidsetName(Stringname) {this.name =name;    }//    public Long getUserId() {//        return userId;//    }////    public void setUserId(Long userId) {//        this.userId = userId;//    }@OverridepublicStringtoString() {return"Ordert{" +"}";    }}

级联保存

注意事项