qlong8807

springboot项目添加如下依赖：
<dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.2.0</version>

qlong8807

使用Oracle函数生成主键，时间+4位随机
CREATE OR REPLACE PACKAGE BODY sys_helper_pkg IS
    FUNCTION get_key_id RETURN INTEGER IS
    v_key_id         INTEGER;
    v_unix_timestamp INTEGER;
    v_random_value   CHAR(4);
    BEGIN
    v_unix_timestamp := (SYSDATE - to_date('2019-10-01', 'yyyy-mm-dd')) *
    86400;
    v_random_value   := lpad(seq_random_value.nextval, 4, 0);

qlong8807

//循环遍历多级文件名并打印
public static void getFile(File file){
        if(file != null){
            File[] f = file.listFiles();
            if(f != null){
                for (File value : f) {
                    getFile(value);
                }
            }else{
                System.out.println(file);

qlong8807

#!/bin/bash
ps -ef | grep dbservice | grep -v grep | awk '{print $2}' | xargs kill -9
sleep 3
cd /home/user/dbservice
nohup /usr/local/java/jdk1.8.0_231/bin/java -jar dbservice-1.0-SNAPSHOT.jar >> dbservice.log 2>&1 &



Windows

qlong8807

    server {
        listen       8081;
        server_name  10.255.203.162;
        #charset koi8-r;
        #access_log  logs/host.access.log  main;
        location / {
            root   C:\Users\zyl\Documents\Axure\HTML;
			try_files $uri $uri/ @router;
            index  index.html start.html;