代码拉取完成,页面将自动刷新
新功能建议@注解实现自定义SQL
例如
String sqlstr = " select distinct m.menu_id, m.parent_id, m.menu_name, m.path, m.component, m.`query`, " +
" m.visible, m.status, ifnull(m.perms,'') as perms, m.is_frame, m.is_cache, m.menu_type, m.icon, " +
" m.order_num, m.create_time " +
" from sys_menu m " +
" left join sys_role_menu rm on m.menu_id = rm.menu_id " +
" left join sys_user_role ur on rm.role_id = ur.role_id " +
" left join sys_role ro on ur.role_id = ro.role_id " +
" where ur.user_id = @userId";
if (Strings.isNotBlank(menu.getMenuName())) {
sqlstr += " AND m.menu_name like concat('%', @menuName, '%')";
}
if (Strings.isNotBlank(menu.getVisible())) {
sqlstr += " AND m.visible = @visible";
}
if (Strings.isNotBlank(menu.getStatus())) {
sqlstr += " AND m.status = @status";
}
sqlstr += " order by m.parent_id, m.order_num";
Sql sql = Sqls.create(sqlstr);
sql.params().set("userId" , userId);
sql.params().set("menuName" , menu.getMenuName());
sql.params().set("visible" , menu.getVisible());
sql.params().set("status" , menu.getStatus());
sql.setCallback(Sqls.callback.entities());
Entity<SysMenu> entity = dao().getEntity(SysMenu.class);
sql.setEntity(entity);
dao().execute(sql);
酱紫 自定义SQL 过于冗余 希望能通过反射 用注解实现自定义SQL
https://nutz.cn/yvr/t/238ph8f60ejqvredoav1pcl2dd