Integer selectA=Integer(request.getParameter("select")); -> int selectA=Integer.parseInt(request.getParameter("select").toString()); ResultSet RS=null; String sql="select * from person where person_id='"+strPERSONID+"'"; RS=workM.callselect(sql); while(RS.next()){ String strKJDEP=getStr(RS.getString("department")); ResultSet RSKJ=workM.callselect("select person_name from person where department='"+strKJDEP+"' and zwmc='副科长' and zwmc='科长'"); while(RSKJ.next()) { String strNAME=getStr(RSKJ.getString("person_name")); ???????很不提倡这样写,为什么不用复合查询呢!
->
int selectA=Integer.parseInt(request.getParameter("select").toString());
ResultSet RS=null;
String sql="select * from person where person_id='"+strPERSONID+"'";
RS=workM.callselect(sql);
while(RS.next()){
String strKJDEP=getStr(RS.getString("department"));
ResultSet RSKJ=workM.callselect("select person_name from person where department='"+strKJDEP+"' and zwmc='副科长' and zwmc='科长'");
while(RSKJ.next()) {
String strNAME=getStr(RSKJ.getString("person_name"));
???????很不提倡这样写,为什么不用复合查询呢!
呵呵,但是那些错误是什么意思呢?