Java示例(spring)

java动态生成初始化数据（spring框架）

示例提供来源：香喷喷的如歌

对应控制器 controllers/IndexController.java

  2. @RestController
  3. @RequestMapping("login")
  4. public class LoginController {
  5.     @Resource
  6.     private SysMenuService sysMenuService;
  8.     @GetMapping("/menu")
  9.     public Map<String, Object> menu() {
  10.         return sysMenuService.menu();
  11.     }
  12. }

对应Service逻辑层 service/SysLoginServiceImpl.java

  1. @Service
  2. public class SysMenuServiceImpl implements SysMenuService {
  3.     @Resource
  4.     private SysMenuRepository sysMenuRepository;
  5.     @Override
  6.     public Map<String, Object> menu() {
  7.         Map<String, Object> map = new HashMap<>(16);
  8.         Map<String,Object> home = new HashMap<>(16);
  9.         Map<String,Object> logo = new HashMap<>(16);
  10.         List<SysMenu> menuList = sysMenuRepository.findAllByStatusOrderBySort(true);
  11.         List<MenuVo> menuInfo = new ArrayList<>();
  12.         for (SysMenu e : menuList) {
  13.             MenuVo menuVO = new MenuVo();
  14.             menuVO.setId(e.getKey().getId());
  15.             menuVO.setPid(e.getPid());
  16.             menuVO.setHref(e.getKey().getHref());
  17.             menuVO.setTitle(e.getKey().getTitle());
  18.             menuVO.setIcon(e.getIcon());
  19.             menuVO.setTarget(e.getTarget());
  20.             menuInfo.add(menuVO);
  21.         }
  22.         map.put("menuInfo", TreeUtil.toTree(menuInfo, 0L));
  23.        home.put("title","首页");
  24.         home.put("href","/page/welcome-1");//控制器路由,自行定义
  25.         logo.put("title","后台管理系统");
  26.         logo.put("image","/static/images/back.jpg");//静态资源文件路径,可使用默认的logo.png 
  27.         map.put("homeInfo", "{title: '首页',href: '/ruge-web-admin/page/welcome.html'}}");
  28.         map.put("logoInfo", "{title: 'RUGE ADMIN',image: 'images/logo.png'}");
  29.         return map;
  30.     }
  31. }

TreeUtilutil/TreeUtil.java

  1. public class TreeUtil {
  3.     public static List<MenuVo> toTree(List<MenuVo> treeList, Long pid) {
  4.         List<MenuVo> retList = new ArrayList<MenuVo>();
  5.         for (MenuVo parent : treeList) {
  6.             if (pid.equals(parent.getPid())) {
  7.                 retList.add(findChildren(parent, treeList));
  8.             }
  9.         }
  10.         return retList;
  11.     }
  12.     private static MenuVo findChildren(MenuVo parent, List<MenuVo> treeList) {
  13.         for (MenuVo child : treeList) {
  14.             if (parent.getId().equals(child.getPid())) {
  15.                 if (parent.getChild() == null) {
  16.                     parent.setChild(new ArrayList<>());
  17.                 }
  18.                 parent.getChild().add(findChildren(child, treeList));
  19.             }
  20.         }
  21.         return parent;
  22.     }
  23. }

repository层 reposiroty/SysMenuRepository.java

  1. public interface SysMenuRepository extends JpaRepository<SysMenu, Long> {
  3.     //这里我只查询页面转态为启用,可自行定义和写
  4.     @Query(value = "select * from  permission_security.system_menu where STATUS = 1  ORDER BY  sort ",nativeQuery = true)
  5.     public List<SystemMenu> getSystemMenuByStatusAndSort(Long status,Integer sort);
  7.     List<SysMenu> findAllByStatusOrderBySort(Boolean status);
  8. }

entity层 entity/MenuEntity.java

  1. @Getter
  2. @Setter
  3. @Embeddable
  4. public class MenuKey implements Serializable {
  5.     private Long id;
  6.     private String title;
  7.     private String href;
  8. }
  12. @Getter
  13. @Setter
  14. @Entity
  15. @Table(name = "system_menu")
  16. public class SysMenu implements Serializable {
  17.   // 复合主键要用这个注解
  18.     @EmbeddedId
  19.     private MenuKey key;
  20.     private Long pid;
  21.     private String icon;
  22.     private String target;
  23.     private Integer sort;
  24.     private Boolean status;
  25.     private String remark;
  26.      @CreatedDate
  27.     private Date create_at;
  28.      @CreatedDate
  29.     private Date update_at;
  30.     private Date delete_at;
  31. }
  34. @Data
  35. @JsonInclude(JsonInclude.Include.NON_NULL)
  36. public class MenuVo {
  37.     private Long id;
  39.     private Long pid;
  41.     private String title;
  43.     private String icon;
  45.     private String href;
  47.     private String target;
  49.     private List<MenuVo> child;
  50. }
  52. //这里是常规写法不使用lombok
  54. /**
  55.  *  insert和update注解,解决新增和更新的时候没有使用默认值
  56.  * @Author wupeng 
  57.  * @Date 2020-04-25
  58.  * @Description   name ="表" 删掉permission_security. schema=""可删掉不必跟我，前提是你的表对应你的表空间就是数据库
  59.  */
  61. @Entity
  62. @Table ( name ="permission_security.system_menu" , schema = "root")
  63. @DynamicInsert
  64. @DynamicUpdate
  65. public class SystemMenu  implements Serializable {
  67.     private static final long serialVersionUID =  5421757630121636006L;
  69.     /**复合主键要用这个注解*/
  70.     @EmbeddedId
  71.     private MenuKey key;
  74.     /**
  75.      * 父ID
  76.      */
  77.        @Column(name = "pid" )
  78.     private Long pid;
  82.     /**
  83.      * 菜单图标
  84.      */
  85.        @Column(name = "icon")
  86.     private String icon;
  88.     /**
  89.      * 链接打开方式
  90.      */
  91.        @Column(name = "target",columnDefinition = "_self")
  92.     private String target;
  93.     /**
  94.      * 菜单排序
  95.      */
  96.        @Column(name = "sort" )
  97.     private Long sort;
  99.     /**
  100.      * 状态(0:禁用,1:启用)
  101.      */
  102.        @Column(name = "status",columnDefinition = "tinyint DEFAULT 1")
  103.     private Integer status;
  105.     /**
  106.      * 备注信息
  107.      */
  108.        @Column(name = "remark" )
  109.     private String remark;
  111.     /**
  112.      * 创建时间
  113.      */
  114.        @Column(name = "create_at" )
  115.     private Date createAt;
  117.     /**
  118.      * 更新时间
  119.      */
  120.        @Column(name = "update_at" )
  121.     private Date updateAt;
  123.     /**
  124.      * 删除时间
  125.      */
  126.        @Column(name = "delete_at" )
  127.     private Date deleteAt;
  129. /*    public Long getId() {
  130.         return this.id;
  131.     }
  133.     public void setId(Long id) {
  134.         this.id = id;
  135.     }*/
  137.     public Long getPid() {
  138.         return this.pid;
  139.     }
  141.     public void setPid(Long pid) {
  142.         this.pid = pid;
  143.     }
  147.     public String getIcon() {
  148.         return this.icon;
  149.     }
  151.     public void setIcon(String icon) {
  152.         this.icon = icon;
  153.     }
  157.     public String getTarget() {
  158.         return this.target;
  159.     }
  161.     public void setTarget(String target) {
  162.         this.target = target;
  163.     }
  165.     public Long getSort() {
  166.         return this.sort;
  167.     }
  169.     public void setSort(Long sort) {
  170.         this.sort = sort;
  171.     }
  173.     public Integer getStatus() {
  174.         return this.status;
  175.     }
  177.     public void setStatus(Integer status) {
  178.         this.status = status;
  179.     }
  181.     public String getRemark() {
  182.         return this.remark;
  183.     }
  185.     public void setRemark(String remark) {
  186.         this.remark = remark;
  187.     }
  189.     public Date getCreateAt() {
  190.         return this.createAt;
  191.     }
  193.     public void setCreateAt(Date createAt) {
  194.         this.createAt = createAt;
  195.     }
  197.     public Date getUpdateAt() {
  198.         return this.updateAt;
  199.     }
  201.     public void setUpdateAt(Date updateAt) {
  202.         this.updateAt = updateAt;
  203.     }
  205.     public Date getDeleteAt() {
  206.         return this.deleteAt;
  207.     }
  209.     public void setDeleteAt(Date deleteAt) {
  210.         this.deleteAt = deleteAt;
  211.     }
  213.     public MenuKey getKey() {
  214.         return key;
  215.     }
  217.     public void setKey(MenuKey key) {
  218.         this.key = key;
  219.     }
  221. }
  224. @Embeddable
  225. public class MenuKey implements Serializable {
  228.     @GeneratedValue(strategy = GenerationType.IDENTITY)
  229.     @Column(name = "id")
  230.     private Long id;
  231.     /**
  232.      * 名称
  233.      */
  234.     @Column(name = "title")
  235.     private String title;
  236.     /**
  237.      * 链接
  238.      */
  239.     @Column(name = "href")
  240.     private String href;
  242.     public Long getId() {
  243.         return id;
  244.     }
  246.     public void setId(Long id) {
  247.         this.id = id;
  248.     }
  250.     public String getTitle() {
  251.         return title;
  252.     }
  254.     public void setTitle(String title) {
  255.         this.title = title;
  256.     }
  258.     public String getHref() {
  259.         return href;
  260.     }
  262.     public void setHref(String href) {
  263.         this.href = href;
  264.     }
  265. }
  267. @JsonInclude(JsonInclude.Include.NON_NULL)
  268. public class MenuVo {
  270.     private Long id;
  272.     private Long pid;
  274.     private String title;
  276.     private String icon;
  278.     private String href;
  280.     private String target;
  282.     public Long getId() {
  283.         return id;
  284.     }
  286.     public void setId(Long id) {
  287.         this.id = id;
  288.     }
  290.     public Long getPid() {
  291.         return pid;
  292.     }
  294.     public void setPid(Long pid) {
  295.         this.pid = pid;
  296.     }
  298.     public String getTitle() {
  299.         return title;
  300.     }
  302.     public void setTitle(String title) {
  303.         this.title = title;
  304.     }
  306.     public String getIcon() {
  307.         return icon;
  308.     }
  310.     public void setIcon(String icon) {
  311.         this.icon = icon;
  312.     }
  314.     public String getHref() {
  315.         return href;
  316.     }
  318.     public void setHref(String href) {
  319.         this.href = href;
  320.     }
  322.     public String getTarget() {
  323.         return target;
  324.     }
  326.     public void setTarget(String target) {
  327.         this.target = target;
  328.     }
  330.     public List<MenuVo> getChild() {
  331.         return child;
  332.     }
  334.     public void setChild(List<MenuVo> child) {
  335.         this.child = child;
  336.     }
  338.     private List<MenuVo> child;
  339. }

yml配置文件 resource/application.yml

  1. #本地开发环境配置中心
  3. spring:
  4.   application:
  5.     name: springboot-webAdmin
  6.   jpa:
  7.     show-sql: true
  8.     database: mysql
  9.     #generate-ddl: true
  10.     database-platform: org.hibernate.dialect.MySQL5Dialect
  11.     hibernate:
  12.       naming:
  13.           #解决使用其他库的表时候，把小数点变成下划线，导致sql无法成功执行。
  14.           #这是由于物理命名策略引起的，大写字母变小写，加_下划线（hibernate5以上高版本）
  15.        physical-strategy: org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl
  16.       #ddl-auto: update
  17.     #ddl-auto: update
  18.   datasource:
  19.     url: jdbc:mysql://127.0.0.1:3306/数据库名称?characterEncoding=utf-8&serverTimezone=GMT%2B8
  20.     username: root
  21.     password: 123456
  22.     driver-class-name: com.mysql.jdbc.Driver
  23.     type: com.zaxxer.hikari.HikariDataSource
  24.     hikari:
  25.       auto-commit: true
  26.       minimum-idle: 2
  27.       idle-timeout: 60000
  28.       connection-timeout: 30000
  29.       max-lifetime: 1800000
  30.       pool-name: DatebookHikariCP
  31.   #thymeleaf模板配置
  32.   thymeleaf:
  33.     cache: false
  34.     enabled: true
  35.     prefix: classpath:/templates/
  36.     suffix: .html
  37.     #严格执行H5标准
  38.     mode: LEGACYHTML5
  39.     encoding: UTF-8
  40.     servlet:
  41.       content-type: text/html
  42.   #content-type: text/html
  43.   resources:
  44.     chain:
  45.       strategy:
  46.         content:
  47.           enabled: true
  48.           paths: /**
  50.   #静态资源路径
  51.   mvc:
  52.     static-path-pattern: /static/**
  53.     #关掉原生icon图标
  54.     favicon:
  55.       enabled: false
  57. #项目端口
  58. server:
  59.   port: 8080
  60.   #连接超时，单位为毫秒，-1永不超时
  61.   connection-timeout: 60000
  62.   #设置tomcat参数
  63.   tomcat:
  64.     uri-encoding: utf-8
  65.     max-connections: 10000
  66.     min-spare-threads: 10
  67.     #最大220个并发，可以达到不丢包（可以自己实测），默认为200。
  68.     max-threads: 220
  69.   #配置访问路径，默认为/
  70.   #servlet:
  71.     #context-path: /index/main
  75. #配置日志文件参数
  76. logging:
  77.   file:
  78.     path: F:/myLog/adminLog.log
  79.   level:
  80.     org:
  81.       springframework: debug
  82.     hibernate: debug

© zhongshaofa all right reserved，powered by Gitbook文件修订时间： 2021-04-06 22:10:57

results matching ""

No results matching ""

results matching ""

No results matching ""