java 没有返回结果集_java – 如何解决“语句没有返回结果集错误”？

当语句没有返回结果集时,我试图处理SQLServerException.我还是

java新手,所以我无法找到解决问题的方法.请问任何人都可以建议我如何解决错误？我遇到困难的地方是这个存储过程没有返回任何结果集,我想显示“找不到记录”之类的东西.我该如何解决？

stmt = conn.prepareCall("{call p_GetAllowedPublicIPs(?,?,?)}");

@Override

protected void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

//processRequest(request, response);

PrintWriter out = response.getWriter();

String IsLoginDisabled = null;

String BankID =null;

String publicip=null;

try {

//processRequest(request, response);

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

Connection conn = null;

CallableStatement myStmt = null;

int count =0;

conn = DriverManager.getConnection("jdbc:sqlserver://MPESA\\SQL2012;user=realm;password=friend;database=ElmaTest");

if(conn!=null)

{

out.println("Connection Succcesful");

myStmt = conn.prepareCall("{call sp_GetPortalUser(?,?,?)}");

myStmt.setString("Country", "Kenya");

myStmt.setString("BankName", "CS");

myStmt.setString("UserID", "Frank");

ResultSet rs= myStmt.executeQuery();

while(rs.next())

{

count++;

BankID = rs.getString("BankID");

String employeeid= rs.getString("EmployeeID");

String FirstName = rs.getString("FirstName");

String LastName= rs.getString("LastName");

String MiddleName = rs.getString("MiddleName");

String Address = rs.getString("Address");

String MobileNumber= rs.getString("MobileNumber");

String Emailid = rs.getString("EmailID");

String TypeofID= rs.getString("TypeOfID");

String IDNumber = rs.getString("IDNumber");

String ipaddress = rs.getString("IPAddress");

IsLoginDisabled = rs.getString("isLoginDisabled");

String LoginFailureIPaddress = rs.getString("LoginFailureIPAddress");

System.out.println("count"+count);

System.out.println("BankID" +BankID);

System.out.println("EmployeeId"+employeeid);

System.out.println("FirstName"+FirstName);

System.out.println("MiddleName"+MiddleName);

System.out.println("LastName"+LastName);

System.out.println("Address"+Address);

System.out.println("MobileNumber"+MobileNumber);

System.out.println("EmailId"+Emailid);

System.out.println("TypeoFiD"+TypeofID);

System.out.println("Idnumber"+IDNumber);

System.out.println("ipaddress"+ipaddress);

System.out.println("isLoginDisabled"+IsLoginDisabled);

System.out.println("LoginFailureIPaddress"+LoginFailureIPaddress);

}

if(count>0)

{

int logindisabled = Integer.valueOf(IsLoginDisabled);

CallableStatement stmt = null;

if (logindisabled!=1)

{

try {

stmt = conn.prepareCall("{call p_GetAllowedPublicIPs(?,?,?)}");

} catch (SQLException ex) {

Logger.getLogger(LoginController.class.getName()).log(Level.SEVERE, null, ex);

}

stmt.setString("Country", "Kenya");

stmt.setString("BankID", "99");

stmt.setString("PublicIP", "1");

ResultSet rp = stmt.executeQuery();

// System.out.println(rp.next());

while(rp.next())

{

String ipaddress = rp.getString("IPAddress");

System.out.println("ipaddress"+ipaddress);

}

}

}

}

} catch (ClassNotFoundException | SQLException ex) {

Logger.getLogger(Search.class.getName()).log(Level.SEVERE, null, ex);

}

}