Question

Oracle11g里面如果在存储过程里面需要查找多次然后一次返回怎么写？

Answer 1

这是你要的么 String sql = "select id, password, name from user_sd1104 " +
"where id = 1001 and password = '1234'";
Statement stmt = conn.createStatement();
ResultSet rs
= stmt.executeQuery(sql);
while(rs.next()){
int id = rs.getInt(1);
String pwd = rs.getString(2);
String name = rs.getString(3);
System.out.println("welcome," + name);
}
rs.close();
stmt.close();
conn.close();

Answer 2

多查询结果union all在一起。

Answer 3

Oracle11g里面如果在存储过程里面需要查找多次然后一…2881

Answer 4

你这是问的什么稀奇古怪的问题了~！ 不知道！