java数据库mysql计算机jsp
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;
}
