代码拉取完成,页面将自动刷新
<dependency>
<groupId>top.wu2020</groupId>
<artifactId>wu-database-lazy-jpa</artifactId>
<version>1.2.8-JDK17-SNAPSHOT</version>
</dependency>
public interface TestLazyJpaRepository extends LazyJpaRepository<SysUser,Long> {
}
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);
}
}
<dependency>
<groupId>top.wu2020</groupId>
<artifactId>wu-framework-lazy-orm-spring-starter</artifactId>
<version>1.2.8-JDK17-SNAPSHOT</version>
</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);
}
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。