tkmybatis能连接oracle吗,spring boot集成tk.mybatis 返回主键(oracle序列)

最新推荐文章于 2024-07-23 00:23:31 发布

转载最新推荐文章于 2024-07-23 00:23:31 发布 · 301 阅读

文章标签：

本文介绍了一个SpringBoot项目的启动配置，包括使用@EnableScheduling开启定时任务支持、@ServletComponentScan进行Servlet组件扫描、@EnableTransactionManagement开启事务管理，并通过自定义配置实现MyBatis Plus的集成，包括PageHelper分页插件和Mapper接口扫描配置。

spring boot启动类代码 (重点:删除@MapperScan(basePackages = “com.zr.mapper”) 注解)` package com.zr; import java.util.Properties; import org.springframework.beans.factory.annotation.Value; import org.springframework.boot.Banner; import org.springframework.boot.autoconfigure.SpringBootApplication; import org.springframework.boot.builder.SpringApplicationBuilder; import org.springframework.boot.web.servlet.ServletComponentScan; import org.springframework.context.annotation.Bean; import org.springframework.scheduling.annotation.EnableScheduling; import org.springframework.transaction.annotation.EnableTransactionManagement; import com.github.pagehelper.PageHelper; import tk.mybatis.spring.mapper.MapperScannerConfigurer; @EnableScheduling @SpringBootApplication // 启动 @ServletComponentScan // 拦截器 @EnableTransactionManagement // 事务管理 // @MapperScan(basePackages = "com.zr.mapper") public class Startup { @Value("${myData.port.ajpport}") private int ajpport; @Bean public PageHelper pageHelper() { PageHelper pageHelper = new PageHelper(); Properties p = new Properties(); p.setProperty("offsetAsPageNum", "true"); p.setProperty("rowBoundsWithCount", "true"); p.setProperty("reasonable", "true"); p.setProperty("dialect", "oracle"); pageHelper.setProperties(p); return pageHelper; } /**重点**/ @Bean public MapperScannerConfigurer mapperScannerConfigurer() { MapperScannerConfigurer mapperScannerConfigurer = new MapperScannerConfigurer(); mapperScannerConfigurer.setBasePackage("com.zr.mapper"); Properties propertiesMapper = new Properties(); // 通用mapper位置，不要和其他mapper、dao放在同一个目录 propertiesMapper.setProperty("mappers", "com.zr.bean.MyMapper"); propertiesMapper.setProperty("notEmpty", "false"); // 主键UUID回写方法执行顺序,默认AFTER,可选值为(BEFORE|AFTER) propertiesMapper.setProperty("ORDER", "BEFORE"); mapperScannerConfigurer.setProperties(propertiesMapper); return mapperScannerConfigurer; } public static void main(String[] args) { SpringApplicationBuilder builder = new SpringApplicationBuilder(Startup.class); // 修改Banner的模式为OFF builder.bannerMode(Banner.Mode.OFF).run(args); } }

实体类 @Id @GeneratedValue(strategy = GenerationType.IDENTITY, generator = "select SEQ_ID.nextval from dual")//前提是先创建了oracle序列 private Long id; private String name;