description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: An exception occurred processing JSP page /shownews.jsp at line 4744: <td align="center" colspan="3"><%=rs.getString("title") %></td> 45: </tr> 46: <tr> 47: <td colspan="3"><%=rs.getString("content")%></td> 48: </tr> 49: <tr> 50: <td>发布时间:<%=rs.getString("times") %></td> Stacktrace: org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) root cause javax.servlet.ServletException: java.sql.SQLException: Column 'content' not found. org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:852) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781) org.apache.jsp.shownews_jsp._jspService(shownews_jsp.java:139) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) root cause java.sql.SQLException: Column 'content' not found. com.mysql.jdbc.ResultSet.findColumn(ResultSet.java:2680) com.mysql.jdbc.ResultSet.getString(ResultSet.java:2195) org.apache.jsp.shownews_jsp._jspService(shownews_jsp.java:108) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) note The full stack trace of the root cause is available in the Apache Tomcat/6.0.18 logs.
description The server encountered an internal error () that prevented it from fulfilling this request. exception:An exception occurred processing JSP page /shownews.jsp at line 47 说明异常在47行47: <td colspan="3"> <%=rs.getString("content")%> </td> 然后在后面的异常中:Column 'content' not found. 可以得知是列content不存在!
MySQL中,如何改变一个列的列名?急,急,急,急,急……
alter table XX change column oldColumn new Column colType
45: </tr>
46: <tr>
47: <td colspan="3"><%=rs.getString("content")%></td>
48: </tr>
49: <tr>
50: <td>发布时间:<%=rs.getString("times") %></td>
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause javax.servlet.ServletException: java.sql.SQLException: Column 'content' not found.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:852)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.shownews_jsp._jspService(shownews_jsp.java:139)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause java.sql.SQLException: Column 'content' not found.
com.mysql.jdbc.ResultSet.findColumn(ResultSet.java:2680)
com.mysql.jdbc.ResultSet.getString(ResultSet.java:2195)
org.apache.jsp.shownews_jsp._jspService(shownews_jsp.java:108)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.18 logs.
说明异常在47行47: <td colspan="3"> <%=rs.getString("content")%> </td> 然后在后面的异常中:Column 'content' not found. 可以得知是列content不存在!
alter table XX change column oldColumn new Column colType