java.sql.SQLException: No data found 怎么解决

dushouhuiyi123 2015-11-26 10:27:24

package web;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.sql.*;

import acc.ConnectionManager;

import java.io.*;
import java.sql.*;
public class ListUser extends HttpServlet{
public void service(HttpServletRequest request
,HttpServletResponse response)throws
ServletException,IOException{
Connection conn=null;
Statement stat=null;
ResultSet rst=null;
try {
conn=ConnectionManager.getConnection();
//System.out.println("1");
stat=conn.createStatement();
rst=stat.executeQuery(
"select * from Users order by id");
PrintWriter out=response.getWriter();
//System.out.println("2");
out.println("<html>");
out.println("<head></head>");
out.println("<body>");
out.println("<table border='1'" +
"cellpadding='0'cellspacing='0'");
out.println("<tr><td>id</td><td>username</td>" +
"<td>password</td></tr>");

//System.out.println("3");
while(rst.next()){
long a =0;
String b=null;
String c=null;
//System.out.println("3...");
a =rst.getLong("id");

b=rst.getString("username");

c=rst.getString("password");

out.println("<tr><td>"+a+"</td><td>"+b+"</td><td>"+c
+"</td><td><a href='del?id="+rst.getInt("id")+"'>delete</a> " +
"<a href='load?id="+rst.getInt("id")+"'>modify</a></td></tr>");

}

// System.out.println("4");
out.println("</table>");
out.println("<a href='adduser.html'>addings</a>");
//out.println("<a href='DelUser.java'>delete</a>");
//out.println("<a href=''>modify</a>");
out.println("</body>");
out.println("</html>");
} catch (SQLException e) {
e.printStackTrace();
throw new ServletException(e);
}finally{
try {
rst.close();
stat.close();
conn.close();

} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
throw new ServletException(e);
}

}

}
}

错误提示是这样的
java.sql.SQLException: No data found
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7138)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataInteger(JdbcOdbc.java:3811)
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataInteger(JdbcOdbcResultSet.java:5638)
at sun.jdbc.odbc.JdbcOdbcResultSet.getInt(JdbcOdbcResultSet.java:583)
at sun.jdbc.odbc.JdbcOdbcResultSet.getInt(JdbcOdbcResultSet.java:601)
at web.ListUser.service(ListUser.java:46)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:662)

自己编译说out.println("<tr><td>"+a+"</td><td>"+b+"</td><td>"+c
+"</td><td><a href='del?id="+rst.getInt("id")+"'>delete</a> " +
"<a href='load?id="+rst.getInt("id")+"'>modify</a></td></tr>");这里有问题求大神指导，初学者求帮助。

...全文

255 4 打赏收藏转发到动态举报

写回复

用AI写文章

4 条回复

切换为时间正序

请发表友善的回复…

发表回复

dushouhuiyi123 2015-12-02

打赏
举报

好谢谢

xuteng1 2015-11-26

打赏
举报

out.println("<html>"); out.println("<head></head>"); out.println("<body>"); out.println("<table border='1'" + "cellpadding='0'cellspacing='0'"); out.println("<tr><td>id</td><td>username</td>" + "<td>password</td>"+"<td>超链接</td>"+"</tr>"); 把代码替换这

dushouhuiyi123 2015-11-26

打赏
举报

java.sql.SQLException: Column not found at sun.jdbc.odbc.JdbcOdbcResultSet.findColumn(JdbcOdbcResultSet.java:1850) at sun.jdbc.odbc.JdbcOdbcResultSet.getInt(JdbcOdbcResultSet.java:601) at web.ListUser.service(ListUser.java:46) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) 我检查了一下我建立的表格与其对应只是我表格中之后id username password 但是我最后输出在界面显示段后面加上了删除和修改的超链接这样的表格就对应不上么？谢谢您的帮忙很感激。

用户名无法显示 2015-11-26

打赏
举报

out.println("<tr><td>"+a+"</td><td>"+b+"</td><td>"+c +"</td><td><a href='del?id="+rst.getInt("+id+")+">delete</a> " + "<a href='load?id="+rst.getInt("+id+")+"'>modify</a></td></tr>");