需要向表中操作一行记录,如果不存在,执行insert,反之则update.我的代码是:String string =request.getParameter("string"); //取得提交表单的数据 strSQL = "select string from table where string = '"+string+"'";
sqlRst = stat.executeQuery(strSQL);
out.print(sqlRst.next()); //true or false
out.print("</br>"); if (sqlRst.next()){
out.print("strSQL1");
}
else {
out.print("strSQL2");
}可是不管string 提交的值如何,我得到的结果是:true
strSQL2
或者是:
false
strSQL2 请问如何判断select的结果集是否为空,谢谢
sqlRst = stat.executeQuery(strSQL);
out.print(sqlRst.next()); //true or false
out.print("</br>"); if (sqlRst.next()){
out.print("strSQL1");
}
else {
out.print("strSQL2");
}可是不管string 提交的值如何,我得到的结果是:true
strSQL2
或者是:
false
strSQL2 请问如何判断select的结果集是否为空,谢谢
String string =request.getParameter("string"); //取得提交表单的数据strSQL = "select string from table where string = '"+string+"'";
sqlRst = stat.executeQuery(strSQL);
boolean b = sqlRst.next();
out.print(b); //true or false
out.print("</br>");if (b){
out.print("strSQL1");
}
else {
out.print("strSQL2");
}