获取数据库表字段

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());
                }
            }