（开发笔记）JDBC模版增加数据给字符加引号

for (int i = 0; i < list.size(); i++) {
  List<Object> names=new ArrayList<>();
  List<Object> values=new ArrayList<>();
  for (int j = 0; j < sfieldassodetailList.size(); j++) {
    /*System.out.println("原表参数="+list.get(i).get(sfieldassodetailList.get(j).getSourcefield()));
    System.out.println("转换参数="+sfieldassodetailList.get(j).getTargetfield());*/
    names.add(sfieldassodetailList.get(j).getTargetfield());
    if("null".equals(String.valueOf(list.get(i).get(sfieldassodetailList.get(j).getSourcefield())))){
      values.add("null");
    } else if(StringUtils.isNumeric(String.valueOf(list.get(i).get(sfieldassodetailList.get(j).getSourcefield())))){//判断参数是否是纯数字
      values.add(list.get(i).get(sfieldassodetailList.get(j).getSourcefield()));
    } else {
      values.add("'"+list.get(i).get(sfieldassodetailList.get(j).getSourcefield())+"'");
    }

  }
  logger.info("INSERT INTO "+targetDA+" ("+StringUtils.join(names,",")+") VALUES ("+StringUtils.join(values,",")+") ");
  //JdbcTemplate.getJdbcTemplate("thams").execute("INSERT INTO "+targetDA+" ("+StringUtils.join(names,",")+") VALUES ("+StringUtils.join(values,",")+") ");
}

        for (int i = 0; i < values.size(); i++) {
            if(!StringUtils.isNumeric(values.get(i))){//判断参数是否是纯数字
                values.set(i,"'"+values.get(i)+"'");
            } else {

            }
        }