I am a chinese student,i want to ask a JSP problem,ok?

I am a chinese student,i want to ask a JSP problem,ok?

the problem is:

ResultSet rs=null,rs2=null;

rs=cqpsql.query("select * from cqp_news_class where pid=0 order by sort_id");

rs2=cqpsql.query("select * from cqp_news_class where pid=2 order by sort_id");

i want to open 2 ResultSet (rs,rs2) in the same time,but i cannt,

It seams i just only can open one ResultSet in the same time,

anyone can help me?

[452 byte] By [andy_cqqppa] at [2007-11-27 2:41:14]