com.mysql.jdbc.sqlerror.createsqlexception_at com.mysql.jdbc.SQLError.createSQLException(SQLError.ja...

错误提示是这样的：java.sql.SQLExceptionatcom.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)atcom.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)atco...

错误提示是这样的：

java.sql.SQLException

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)

at com.mysql.jdbc.ResultSetImpl.checkRowPos(ResultSetImpl.java:815)

at com.mysql.jdbc.ResultSetImpl.getStringInternal(ResultSetImpl.java:5528)

at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5448)

at com.notebook.struts.action.ShowAction.execute(ShowAction.java:60)

at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)

at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)

at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)

at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

相关的action 代码如下：

public ActionForward execute(ActionMapping mapping, ActionForm form,

HttpServletRequest request, HttpServletResponse response) {

try

{

Class.forName("com.mysql.jdbc.Driver").newInstance();

String url = "jdbc:mysql://localhost:3306/notebook";

Connection con = DriverManager.getConnection(url, "root", "root");

Statement st=con.createStatement();

ResultSet rs=st.executeQuery("select * from notebook");

ArrayList list=new ArrayList();

while(rs!=null)

{

Note note=new Note();

note.setName(rs.getString("name"));

note.setTitle(rs.getString("title"));

note.setContent(rs.getString("comment"));

note.setEmail(rs.getString("email"));

note.setTime(rs.getString("time"));

rs.next();

list.add(note);

}

for(int count=0;count

{

System.out.println(((Note)(list.get(count))).getName());

}

// HttpSession session=request.getSession();

// session.setAttribute("note", );

if(rs!=null)

rs.close();

if(st!=null)

st.close();

if(con!=null)

con.close();

}

catch(Exception e)

{

e.printStackTrace();

}

return mapping.findForward("display");

}

}

我的数据库表名字是对的，notebook，表项为name，email，title，Comments，time 感觉上应该是rs.getstring()这里错了，不过错在哪里了？

展开