SpringDataJPA笔记(10)-动态设置表名

落日映苍穹つ 2023-07-17 14:05 10阅读 0赞

在实际使用中可能会遇到需要动态设置表名的情况，特别是通常在后台管理系统里面，总有一些相似的功能需要抽象出来写一些公共的方法，以减少代码开发量，降低重复劳动

首先看BaseRepository的代码

@NoRepositoryBean
    public interface BaseRepository<T, ID extends Serializable> extends JpaRepository<T, ID>, JpaSpecificationExecutor<T>, Serializable {
    
        @Transactional
        @Modifying(clearAutomatically = true)
        @Query("update #{#entityName} t set t.age=?2 where t.id = ?1")
        int updateAge(ID id, int age);
    
        @Query("select t.id from #{#entityName} t ")
        List<ID> findIds();
    }

然后创建一个BaseController

@Slf4j
    public class BaseController<R extends BaseRepository<T, ID>, T extends AnimalEntity, ID extends Serializable> {
        @Autowired
        private R repository;
    
        @ApiOperation(value = "baseAll", httpMethod = "GET")
        @GetMapping(value = "/base/all")
        public List<T> baseAll() {
            log.info("BaseController list");
            return repository.findAll();
        }
    
        @ApiOperation(value = "update age by id", httpMethod = "GET")
        @GetMapping(value = "/update/age/{id}")
        public T baseAll(@PathVariable ID id, @RequestParam int age) {
            log.info("BaseController list");
            repository.updateAge(id, age);
            Optional<T> optional = repository.findById(id);
            if(optional.isPresent()){
                return optional.get();
            }
            return null;
        }
    
    
        @ApiOperation(value = "base ids", httpMethod = "GET")
        @GetMapping(value = "/base/ids")
        public List<ID> findIds() {
            log.info("BaseController list");
            return repository.findIds();
        }
    
    
    }

在分别创建两个不同的controller

ChapterTenCatController

@RestController
    @RequestMapping("/chapter/ten/cat")
    public class ChapterTenCatController extends BaseController<CatRepository, CatEntity, Long> {
    }

ChapterTenDogController

@RestController
    @RequestMapping("/chapter/ten/dog")
    public class ChapterTenDogController extends BaseController<DogRepository, DogEntity, Long> {
    }

运行代码之后，查看swagger-ui的页面

可以看到多了两个controller

![在这里插入图片描述][20200321230325225.png]

打开这两个controller，看到里面的接口是在BaseController里面写的

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpbmd6aWlzbWU_size_16_color_FFFFFF_t_70]

分别运行里面的接口，可以看到是分别查询和更新了cat表和dog表的数据

欢迎关注微信交流  
![在这里插入图片描述][70]

[20200321230325225.png]: /images/20230528/29f0ea5cc15348d8aefc86979f3dd78d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpbmd6aWlzbWU_size_16_color_FFFFFF_t_70]: /images/20230528/93245e6061fb4d9f9ebefe99ad94ad5d.png
[70]: /images/20230528/1ae0f477462d4a5089a486213d9cec07.png