linux
// 开端口
firewall-cmd --zone=public --add-port=8086/tcp --permanent// 刷新防火墙:
firewall-cmd --reload// 从网络上下载文件:
wget https://example.com/file.zip// jar包运行命令
java -Dwmp.env.name=163 -Dlog4j2.formatMsgNoLookups=true -Xms3512m -Xmx5024m -jar wmpms-longaodata-service..jar --spring.profiles.active=prod
nginx
配置文件转发(http快内 server快上): include /etc/nginx/*.conf;
配置文件生效：nginx -s reload
启动：./nginx
sql
// case 和 json 语句
(case t.is_result ->> '$.siwang.status' when '1' then '是' else '否' end) // 清空表
TRUNCATE TABLE 表名;// 递归查询子节点 父子结构的数据，且查询结果不包括父节点<select id="getChildMenuIds" resultType="java.lang.Integer">WITH RECURSIVE menu_tree AS (SELECT idFROM sys_menuWHERE parent_id = #{menuId}UNION ALLSELECT m.idFROM sys_menu mJOIN menu_tree mt ON m.parent_id = mt.id)SELECT id FROM menu_tree</select>
mybatsi
// 时间格式处理
<if test="startTime != null and startTime != '' and endTime != null and endTime != ''">and date_format(cr.create_time , '%Y-%m-%d') between #{startTime} AND #{endTime}
</if>
windows
// 根据端口号杀死进程
netstat -aon|findstr "8096"
taskkill /pid 25876 /f
java
身份证号用于提取出生年份
public class Main {public static void main(String[] args) {String idCardNumber = "身份证号码"; // 替换为实际的身份证号码// 判断身份证号位数，根据位数提取出生年份int length = idCardNumber.length();int birthYear;if (length == 15) {String yearStr = idCardNumber.substring(6, 8);int year = Integer.parseInt(yearStr);birthYear = 1900 + year;} else if (length == 18) {String yearStr = idCardNumber.substring(6, 10);birthYear = Integer.parseInt(yearStr);} else {System.out.println("无效的身份证号码");return;}System.out.println("出生年份：" + birthYear);}
}
