public void checkColumns(String tableName,List<String> fields){
try{
//查询效率略低
SqlRowSet rowSet = jdbcTemplate.queryForRowSet("select * from "+tableName);
//获取字段
SqlRowSetMetaData metaData = rowSet.getMetaData();
int columnCount = metaData.getColumnCount();
List columnList = new ArrayList();
for (int i = 1; i <= columnCount; i++) {
columnList.add(metaData.getColumnName(i));
}
List<String> columns = new ArrayList();
for(String field : fields){
if(!columnList.contains(field.trim())){
columns.add(field.trim());
}
}