我正在try 使用H2数据库从一个查询返回两个表.然而,结果我只得到了一张桌子
以下是我的代码:
try {
Connection connection = DriverManager.getConnection(h2_conn);
Statement statement = connection.createStatement();
// Execute a SQL query that returns multiple result sets
String sql = "select * from `test1234` limit 1;" +
"select * from `test1234` limit 2;";
boolean hasMoreResults = statement.execute(sql);
// Process each result set
int resultSetNumber = 1;
do {
ResultSet resultSet = statement.getResultSet();
while (resultSet.next()) {
// Process the current result set
System.out.println("Result Set " + resultSetNumber);
System.out.println(resultSet.getString(1));
System.out.println(resultSet.getString(2));
}
resultSetNumber++;
hasMoreResults = statement.getMoreResults();
} while (hasMoreResults);
statement.close();
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
这是否意味着不可能在一个查询中获得两个表结果?
关于这份文件,http://www.h2database.com/javadoc/org/h2/jdbc/JdbcStatement.html#getMoreResults--.
移动到下一个结果集-但是始终只有一个结果集.此调用还关闭当前结果集(如果有).如果有下一个结果集,则返回TRUE(这意味着-它总是返回FALSE).