jsonArray转SQL

package net.mingsoft;

import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;

import java.util.Iterator;
import java.util.Set;

public class Test {

    public static void main(String[] args) {
        String jsonStr = "";
        JSONArray jsonArray = JSON.parseArray(jsonStr);
        String tableName = "";
        String sql = "insert into %s (%s) values (%s)";
        for(int i = 0;i<jsonArray.size();i++){
            StringBuffer columns = new StringBuffer();
            StringBuffer values = new StringBuffer();
            JSONObject json = jsonArray.getJSONObject(i);

            Set<String> keys = json.keySet();
            Iterator<String> it = keys.iterator();
            while(it.hasNext()){

                    String k = it.next();
                if("create_date".equals(k) || "update_date".equals(k)){
                    continue;
                }
                columns.append(k).append(",");
                if(!"content_datetime".equals(k)){
                    Object v = json.get(k);
                    values.append("'").append(v).append("'").append(",");
                }else{
                    values.append("now()").append(",");
                }


            }
            String c = columns.substring(0,columns.length()-1);
            String d = values.substring(0,values.length()-1);
            String sql1 = String.format(sql,tableName,c,d);
            System.out.println(sql1+";");
        }
    }
}