送我一块糖的博客

发现很有年代的历史表， 没有主键， 增加主键 瞬间解决。

/** * 将xml格式的字符串转换成Map对象 * * @param xmlStr xml格式的字符串 * @return json字符串 * @throws Exception 异常 */ public static String xmlStrToJson(String xmlStr) throws Exception { Map<String, Object> map = new HashMap<.

先导入pom文件<dependency> <groupId>com.github.jsqlparser</groupId> <artifactId>jsqlparser</artifactId> <version>1.4</version></dependency>public class SqlParserHandler { /** * 由于jsqlpars.

<configuration> <!-- 控制台输出 --> <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender"> <encoder class="ch.qos.logback.classic.encoder.PatternLayoutEncoder"> <!--格式化输出：%d表示日期，%thread表示线程名.

public static List<WtmpLog> roundAuditAnalyzer(List<WtmpLog> WtmpLogs, JSONArray fortressIps) { List<WtmpLog> roundIpList = new ArrayList<>(); List<HashMap> fortressIpList = JSON.parseArray(fortressIps.to...

List<User> userList = new ArrayList<>(); userList.add(new User("1","李大锤","23","南京")); userList.add(new User("2","张无忌","18","西安")); userList.add(new User("3","刘德华","26","苏州")); userList.add(new U...

//日账单List<Object[]> dayList = myTask.getTransactionsDay(startDate,endDate);//List<Object[]> dayList = [["568b5d428a2e41708603694f4d3fdd88",2019-07-15,0.1,1563536654000],["6bc9f34982584...

publicstaticintgetRandom(intmin,intmax){Randomrandom=newRandom();inti=random.nextInt(max)%(max-min+1)+min;returni;}

首先需要排序的对象需要实现Comparable接口并且并复写compareto方法：public class SysOffice extends DataEntity&lt;SysOffice&gt; implements Comparable&lt;SysOffice&gt;{private static final long serialVersionUID = 1L;priv...

select colName, datetime from ( select  '05:00~06:00' as time1, '06:00~07:00' as time2, '07:00~08:00' as time3, '08:00~09:00' as time4, '09:00~10:00' as time5, '10:00~11:00' as time6, '11:00~...

SELECT TO_CHAR(to_timestamp('2018-05-03 00:00:00', 'syyyy-mm-dd hh24:mi:ss.ff')  +ROWNUM - 1, 'yyyy-MM-dd') as daylistFROM DUALCONNECT BY ROWNUM &lt;=extract(day from to_timestamp('2018-05-03 23:59:00...

public class ToSBCAndDBC {    public static void main(String[] args) {        String QJstr = "wch";        String QJstr1 = "ｈｅｌｌｏ";        String result = ToSBC(QJstr);        String result1

package com.dfans.util;import java.io.*;import java.net.HttpURLConnection;import java.net.URL;import com.itextpdf.text.pdf.PdfReader;  import com.itextpdf.text.pdf.parser.PdfRead

/** *  */package net.dxtek.toutiao.job;/** * @author spz * */public class KeyGenerator {    private static final String DIC = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ";        p

key 位 int类型String.format("%08d", key );

versionCode = versionCode.substring(versionCode.length()-n,versionCode.length());

UPDATE   private_funds_base e,   (SELECT LEFT(a.bgdz, 2) bgdz ,a.id FROM     (SELECT LEFT(private_funds_base.bgdz, 2) bgdz,id FROM private_funds_base ) c,    private_funds_base aWHERE 1=1 

如果是在IDE中开发项目，以MyEclipse为例， Window-&gt;Preferences-&gt;MyEclipse-&gt;Servers-&gt;Tomcat x.x-&gt;JDK-&gt;Optional Java VM arguments:添加-Xms256m-Xmx256m-XX:PermSize=512M-XX:MaxPermSize=512m根据情况可以更改指定的内存大小...

DELIMITER $$CREATE PROCEDURE join_num_pro()BEGINUPDATE join_num SET join_num=(join_num+FLOOR(5 + (RAND() * 5)));END$$DELIMITER ;DROP event IF EXISTS eventJob; CREATE event IF NOT EXI

public static String getLetter(String a) {        StringBuffer sb = new StringBuffer();        StringBuffer sb2 = new StringBuffer();        for(int i = 0;i            char c = a.charAt(i);