Class.forName("org.postgresql.Driver"); System.err.println("url=" + url); Connection conn = DriverManager.getConnection(url, ACCESS_ID, ACCESS_KEY); Statement st = conn.createStatement(); ResultSet rs = st.executeQuery(sql); List<String> columns = new ArrayList<>(); for (int i = 1; i < rs.getMetaData().getColumnCount(); i++) { columns.add(rs.getMetaData().getColumnName(i)); } List<Map<String, Object>> list = new ArrayList<>(); while (rs.next()) { Map<String, Object> row = new HashMap<>(); columns.stream().forEach( column -> { try { row.put(column, rs.getObject(column)); } catch (SQLException throwables) { throwables.printStackTrace(); } } ); list.add(row); } return list;
ResultSet获取行和列
最新推荐文章于 2024-07-13 02:30:30 发布