Map<String, Object> tableMap = new HashMap<String, Object>();
tableMap.put("tableName", tableName);
tableMap.put("data", getTableData("select * from " + tableName));
private List<Map<String, Object>> getTableData(String sql) {
// TODO Auto-generated method stub
Connection connection = null;
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
ResultSetMetaData resultSetMetaData = null;
List<Map<String, Object>> data = new ArrayList<>();
try {
// 1.获取数据库链接对象
connection = JdbcUtil.getConnection();
// 2.获取preparedStatement对象。
preparedStatement = (PreparedStatement) connection.prepareStatement(sql);
// 1.得到ResultSet对象
resultSet = preparedStatement.executeQuery();
// 2.得到ResultSetMeta
jdbc查找表结构
最新推荐文章于 2023-07-09 14:23:53 发布
Map<String, Object> tableMap = new HashMap<String, Object>();tableMap.put("tableName", tableName);tableMap.put("data", getTableData("select * from " + tableName));private List<Map...
摘要由CSDN通过智能技术生成