java-第二个sql语句得到的resultset对象是空的怎么办

public listgetall1(string name) throws exception {

listresult = new arraylist();

connection con = databaseconnection.getconnection();

string na=null;

string sql1= "select * from guanzhu where guanzhu=?";

preparedstatement ps1 = con.preparestatement(sql1);

ps1.setstring(1, name);

resultset rs1 = ps1.executequery();

while(rs1.next()){

connection con1 = databaseconnection.getconnection();

na=rs1.getstring("beiguanzhu");

string sql = "select * from message where author=? order by modified desc"; preparedstatement ps = con1.preparestatement(sql);

ps.setstring(1, na); resultset rs = ps.executequery();

while (rs.next()) {

message m = new message();

m.setid(rs.getint("id"));

m.settitle(rs.getstring("title"));

m.setcontent(rs.getstring("content"));

m.setmodified(rs.getdate("modified"));

m.setauthor(rs.getstring("author"));

result.add(m);

system.out.println(rs.getstring("author")+"");

}

}

return result;
}

DeepSeek

幻方量化公司旗下的开源大模型平台

10435

查看详情