spring+mybatis,通过mybatis访问mysql数据库拿到表的列名,写入到cSV,怎么通过mybatis去拿表的字段名称!!!
SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.columns WHERE TABLE_NAME=''表名
PreparedStatement pst = connection.prepareStatement(sql);//准备执行语句
ResultSet result = pst.executeQuery();
ResultSetMetaData method = result.getMetaData();
List methodList = new ArrayList();
for(int i=1;i<=method.getColumnCount();i++){
methodList.add(method.getColumnName(i));
}
谢谢