mybatis-puls配置（xml）分页、多条数据添加、批量删除

mybatis-pulsmybatis-plus依赖于com.baomidoumybatis-plus-boot-starter3.4.1应用。yml配置服务器：端口：8003spring:datasource:url:jdbc:mysql:/IP地址//database?serverTimezone=GMT%2B8&CharacterEncoding=utf8username:accountpassword:passwordmybatis-plus:#scanxmlfilemapper-locations:classpath:/mapper/*.xml配置:#控制台打印并执行SQL语句)公共类Springcloud03Application{publicstaticvoidmain(String[]args){SpringApplication.run(Springcloud03Application.class,args);}}pojoUser@Data//数据库表名@TableName("user")publicclassUserimplementsSerializable{privateIntegerId;私有字符串名称；私人我整数年龄；privateStringEmail;//对象privateMessagemessage;//嵌套集合privateListmessageList;}启用分页配置@ConfigurationpublicclassMybatisPlusConfig{@BeanpublicMybatisPlusInterceptormybatisPlusInterceptor(){//定义分页拦截器对象MybatisPlusInterceptorinterceptor=newMybatisPlus拦截器();interceptor.addInnerInterceptor(newPaginationInnerInterceptor(DbType.MARIADB));返回拦截器；}}Message@Data@TableName("message")publicclassMessageimplementsSerializable{StringId;}UserMapperinterface//InheritBaseMapper<>publicinterfaceUserMapperextendsBaseMapper{ListselectAll();ListselectLists();}UserMapper.xml文件selecta.id,a.name,a.age,a.email,b.messagefromuserajoinmessagebona.id=b.id从用户a中选择a.id,a.name,a.age,a.email,b.message加入消息bona.id=b.id添加多条数据IntegerinsertMessage(@Param("ListMessage")Listmessage);插入消息(id,message)值(#{message.id},#{message.message})分页Listpage(@Param("apiHistory")ApiHistoryapiHistory,@Param("pageSize")IntegerpageSize,@Param("currentPage")IntegercurrentPage);从api_history和task_name中选择api_history_id,task_name,url,request,create_timeconcat(concat('%',#{apiHistory.taskName},'%'))orderbyapi_history_iddesclimit#{currentPage},#{pageSize}批量删除intdeleteList(@Param("ids")String[]ids);从api_history中删除#{id}