为什么
Statement stm=con.createStatement();
stm.execute("select name from scott.test;select * from scott.test");
while(stm.getMoreResults())
{
ResultSet rs=stm.getResultSet();
while(rs.next())
out.println(rs.getString("name"));
}
得不到任何输出.
Statement stm=con.createStatement();
stm.execute("select name from scott.test;select * from scott.test");
while(stm.getMoreResults())
{
ResultSet rs=stm.getResultSet();
while(rs.next())
out.println(rs.getString("name"));
}
得不到任何输出.
只能用一个语句
stm.execute("select name from scott.test");
stm.execute("select * from scott.test");
...
这样写也不行啊
stm.execute("select name from scott.test");
stm.execute("select * from scott.test");
...
这样写也不行啊这样写没有问题,起作用的是
stm.execute("select * from scott.test");
可能是scott.test没有name字段