我尝试执行以下代码:
<%String getComments = "select * from comments_tb where car_id = "
+ request.getParameter("id") + "\" order by time_stamp DESC";
KarimDatabase karim2 = new KarimDatabase();
Statement stm2 = karim2.getCon().createStatement();
ResultSet rs2 = stm2.executeQuery(query);
while (rs2.next()) {
out.println("<p>" + rs2.getString("comment_desc") + "</p>");
out.println("<p>" + rs2.getString("time_stamp") + "</p>");
}
karim2.getCon().close();
%>
但是我从我的tomcat服务器日志中得到了以下结果:
java.sql.SQLException: Column 'comment_desc' not found.
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)...
请注意,我是按数据库表检查的,comment_desc是一列。实际上,我尝试了另一列的输出字符串,得到了一个结果。
发布于 2018-06-05 06:19:36
如果你只需要这两列,你可以这样做:
<%String getComments = "select comment_desc,time_stamp from comments_tb where car_id = "
+ request.getParameter("id") + "\" order by time_stamp DESC";
KarimDatabase karim2 = new KarimDatabase();
Statement stm2 = karim2.getCon().createStatement();
ResultSet rs2 = stm2.executeQuery(query);
while (rs2.next()) {
out.println("<p>" + rs2.getString(1) + "</p>"); //get first column result
out.println("<p>" + rs2.getString(2) + "</p>"); //2nd
}
karim2.getCon().close();
%>
试着看看这是不是可行。关于你的错误,除非列不存在,或者因为它不是一个字符串,否则你为什么会得到这个错误呢?
https://stackoverflow.com/questions/50689237
复制相似问题