介绍 Lazy Jpa 是 lazy orm 框架衍生出类似 Spring JPA 框架

开源中国社区团队直播首秀，以分享为名讲述开源中国社区背后的故事”

介绍Lazy Jpa 是lazy orm框架衍生出类似Spring JPA 框架

非Spring项目使用

安装

         <dependency>             <groupId>top.wu2020groupId>             <artifactId>wu-database-lazy-jpaartifactId>             <version>1.2.6-JDK17-SNAPSHOTversion>         dependency>

声明接口

 public interface TestLazyJpaRepository extends LazyJpaRepository<SysUser,Long> { }

接口调用（基础CRUD）

     public static void main(String[] args) {         LazyLambdaStream lazyLambdaStream = LazyLambdaStreamFactory.createLazyLambdaStream("jdbc:mysql://127.0.0.1:3306/wu_database_lazy_simple?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai",                 "root", "wujiawei");         TestLazyJpaRepository lazyJpaRepository = LazyRepositoryFactorySupport.createLazyJpaRepository(lazyLambdaStream, TestLazyJpaRepository.class);              // 统计数据库数量         long count = lazyJpaRepository.count();         // 获取所有数据         Iterable<SysUser> all = lazyJpaRepository.findAll();         for (SysUser sysUser : all) {             System.out.println(sysUser);         }     }

Spring 项目使用

安装

         <dependency>             <groupId>top.wu2020groupId>             <artifactId>wu-framework-lazy-orm-spring-starterartifactId>             <version>1.2.6-JDK17-SNAPSHOTversion>         dependency>

声明接口

 @LazyRepository public interface TestLazyJpaRepository extends LazyJpaRepository<SysUser,Long> { }

接口配置

 @LazyRepositoryScan(scanBasePackages = "com.wu.xxx.mapper")// 扫描你使用的repository接口 @SpringBootApplication public class WuDatabaseLazyStarterSimpleApplication {      public static void main(String[] args) {         SpringApplication.run(WuDatabaseLazyStarterSimpleApplication.class, args);     } }

接口使用

 @LazyRepository public interface SysMenuLazyJpaRepository extends LazyJpaRepository<SysMenu, Integer> {          // 自定义查询     @LazySelect("select * from sys_menu where parent_id={parentId}")     List<SysMenu> findListByParentId(Integer parentId);       @LazySelect("select * from sys_menu where id ={id}")     SysMenu findMenuById(@LazyParam("id") Integer menuId);       @LazySelect("select * from sys_menu where id ={id}")     List<Map ?>> findListMapByParentId(@LazyParam("id") Integer menuId);      @LazyInsert("INSERT Ignore INTO `sys_menu` ( `id`, `name`, `url`, `icon`, `parent_id`,`parent_name`,`sort`,`status`) VALUES ({id},{name},{url},{icon},{parentId},{parentName},{sort},{status});")     void insert(Integer id,                 String name,                 String url,                 String icon,                 Integer parentId,                 String parentName,                 Integer sort,                 Integer status     );      @LazyUpdate("UPDATE `sys_menu` SET  `name` = {name} WHERE `id` = {id};")     void updateNameById(Integer id, String name);       @LazyDelete("DELETE FROM sys_menu  WHERE `id` = {id};")     void removeById(int id);     /**      * 执行sql select * from sys_menu where id={id}      * 根据ID获取数据      * @param id 数据ID      */     SysMenu findById(int id);      /**      * 执行sql select id,name,url,icon from sys_menu where id={id}      * 获取ID、名称、url、icon      * @param id 主键ID      * @return 查询信息      */     SysMenu findIdAndNameAndUrlAndIconById(int id); }