将json解析成insert sql语句

    public String parseSQL(String tableName,String json)
    {
        JsonParser parser = new JsonParser();
        JsonObject obj = (JsonObject) parser.parse(json);;
        String sql = "";
            sql += "INSERT INTO " + tableName + " (";
        Set<Entry<String, JsonElement>> entry = obj.entrySet();
        Iterator<Entry<String, JsonElement>> it = entry.iterator();
            String vs = " values (";
            while(it.hasNext())
            {
                Entry<String, JsonElement> elem = it.next();
                String key = elem.getKey();
                String val = elem.getValue().toString();
                sql += key + ", ";
                vs += val + ", ";
            }
            sql = sql.replaceAll(",\\s*$", "");
            vs = vs.replaceAll(",\\s*$", "");
            sql += ") " + vs + ")";
        return sql;
    }