Create sql insert statement from GBK priliminary tuple description, seperated by "、", and auto add quotation marks.

DBTrick.java

/**
 * Input sample:
 * 
 * TableName
 * （1，样例，example）、（2，样例，example）
 * ;
 * EOF
 *
 * Output:
 * insert into TableName values (1, "样例", "example");
 * insert into TableName values (2, "样例", "example");
 */

import java.util.Scanner;

public class DBTrick {
  public static String quote(String sql) {
    StringBuilder sb = new StringBuilder();
    int state = 0; // 1 - (...), 2 - "..."
    for (char ch : sql.toCharArray()) {
      switch (state) {
        case 0:
          sb.append(ch);
          if (ch == '(') {
            state = 1;
          }
          break;
        case 1:
          if (ch == ',' || ch == ' ' || ch == ';' || ch == ')' || Character.isDigit(ch)) {
            sb.append(ch);
          }
          else {
            sb.append('\'');
            sb.append(ch);
            state = 2;
          }
          break;
        case 2:
          if (ch == ',' || ch == ' ' || ch == ';' || ch == ')' || Character.isDigit(ch)) {
            sb.append('\'');
            sb.append(ch);
            state = 1;
          }
          else {
            sb.append(ch);
          }
          break;
      }
    }
    return sb.toString();
  }

  public static void main(String[] args) {
    Scanner input = new Scanner(System.in);

    while (input.hasNext()) {
      String table = input.next();
      while (input.hasNext()) {
        String line = input.nextLine();
        if (line.equals(";")) {
          break;
        }
        for (String tuple : line.split("、")) {
          String sql = tuple
              .replace("（", "insert into " + table + " values (")
              .replace("）", ");")
              .replace("，", ", ");
          System.out.println(quote(sql));
        }
      }
    }
  }
}