偶写了个嵌套查询
sql="select * from a ";
stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while(rs.next())
{
sql2="select * from b ";
stmt2 = conn.createStatement();
ResultSet rs2 = stmt2.executeQuery(sql2);
rs2.next();
在这里显示 rs2.getString(1); 居然报告有错,怎么会事情呢?}
sql="select * from a ";
stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while(rs.next())
{
sql2="select * from b ";
stmt2 = conn.createStatement();
ResultSet rs2 = stmt2.executeQuery(sql2);
rs2.next();
在这里显示 rs2.getString(1); 居然报告有错,怎么会事情呢?}
{
rs2.getString(1);
}
catch(Exception e)
{
e.printStackTrace();
}
看看具体是出的什么错误!