可能是这样吧!看不太懂!
sqlRst=sqlStmt.executeQuery("select num,name from duanxin where
number<>'13093725933' and sex='男'");
while(sqlRst.next())
{String name =sqlRst.getString("name");
String num =sqlRst.getString("num");
sqlRst1=sqlStmt.executeQuery("select num from chaxun where number='13093725933' and num='"+num+"'");
if(sqlRst1.next())
{ sqlRst1.close();
sqlStmt.close();
sqlConn.close();
}
else
{
msg1="您的查询结果如下:"+num+"("+name+")";
sqlRst1.close();
sqlStmt.close();
sqlConn.close();
}
}
sqlRst=sqlStmt.executeQuery("select num,name from duanxin where
number<>'13093725933' and sex='男'");
while(sqlRst.next())
{String name =sqlRst.getString("name");
String num =sqlRst.getString("num");
sqlRst1=sqlStmt.executeQuery("select num from chaxun where number='13093725933' and num='"+num+"'");
if(sqlRst1.next())
{ sqlRst1.close();
sqlStmt.close();
sqlConn.close();
}
else
{
msg1="您的查询结果如下:"+num+"("+name+")";
sqlRst1.close();
sqlStmt.close();
sqlConn.close();
}
}
if(sqlRst1.next())
continue;
while(rs1.next())
{String1=rs1.getString(1)
rs2=sqlStmt.executeQuery("select 你要取的列名 from 表名 where "列名"=String1");
if(rs2.next())
退出循环:
}
试试应该可以了