一下是一个BEAN和一个JSP页面,,但在运行时报错。大家帮我找找哪里出了问题谢谢啊!!错误提示是:
org.apache.jasper.JasperException: An exception occurred processing JSP page /jsp/findAll.jsp at line 1714:
15: T_message Tm = new T_message();
16:
17: Collection messages = Tm.getMessage();
18:
19: Iterator it = messages.iterator();
public List getMessage(){
Connection conn = null;
Statement st = null;
ResultSet rss = null;
List ret = new ArrayList();
try {
conn = DBConnect.getConnect();
String sql = "select count(*) from message";
int message_count = 0;
rss = st.executeQuery(sql);
if(rss.next()){
message_count = rss.getInt(1); //获得数据库中INT类型的第一条数据
rss.close(); //此处加CATCH后,后面的IF判断无法继续
}
if(message_count > 0){
rss = st.executeQuery("select * from message order by id desc");
while(rss.next()){
String name = rss.getString("name"); //从数据库中取值!
String email = rss.getString("email");
String title = rss.getString("title");
String content = rss.getString("content");
String date = rss.getString("date");
MessageInfo messageInfo = new MessageInfo();
messageInfo.setName(name);
messageInfo.setEmail(email);
messageInfo.setTitle(title);
messageInfo.setContent(content);
messageInfo.setDate(date);
ret.add(messageInfo);
} rss.close();
st.close();
}
conn.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace(); }
finally{
try {
rss.close();
st.close();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} return ret;
}<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="utf-8"%>
<%@ page import="bean.T_message" %>
<%@ page import="vo.MessageInfo" %><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body>
<%
int message_count = 1 ;
T_message Tm = new T_message();
List messages = Tm.getMessage();
Iterator it = messages.iterator();
while(it.hasNext()){
MessageInfo mi = (MessageInfo)it.next();
%> <table>
<tr>
<td>主题:</td>
<td colspan = "3"><%=mi.getTitle() %></td>
</tr>
<tr>
<td>留言人:</td>
<td><%=mi.getName() %></td>
<td>E-mail:</td>
<td><%=mi.getEmail() %></td>
</tr>
<tr>
<td>留言时间:</td>
<td colspan = "3"><%=mi.getDate() %></td>
</tr>
<tr>
<td><%out.println("("+message_count+")"); %></td>
<td colspan = "3"><%=mi.getContent() %></td>
</tr>
</table>
<%} %>
</body>
</html>
org.apache.jasper.JasperException: An exception occurred processing JSP page /jsp/findAll.jsp at line 1714:
15: T_message Tm = new T_message();
16:
17: Collection messages = Tm.getMessage();
18:
19: Iterator it = messages.iterator();
public List getMessage(){
Connection conn = null;
Statement st = null;
ResultSet rss = null;
List ret = new ArrayList();
try {
conn = DBConnect.getConnect();
String sql = "select count(*) from message";
int message_count = 0;
rss = st.executeQuery(sql);
if(rss.next()){
message_count = rss.getInt(1); //获得数据库中INT类型的第一条数据
rss.close(); //此处加CATCH后,后面的IF判断无法继续
}
if(message_count > 0){
rss = st.executeQuery("select * from message order by id desc");
while(rss.next()){
String name = rss.getString("name"); //从数据库中取值!
String email = rss.getString("email");
String title = rss.getString("title");
String content = rss.getString("content");
String date = rss.getString("date");
MessageInfo messageInfo = new MessageInfo();
messageInfo.setName(name);
messageInfo.setEmail(email);
messageInfo.setTitle(title);
messageInfo.setContent(content);
messageInfo.setDate(date);
ret.add(messageInfo);
} rss.close();
st.close();
}
conn.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace(); }
finally{
try {
rss.close();
st.close();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} return ret;
}<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="utf-8"%>
<%@ page import="bean.T_message" %>
<%@ page import="vo.MessageInfo" %><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body>
<%
int message_count = 1 ;
T_message Tm = new T_message();
List messages = Tm.getMessage();
Iterator it = messages.iterator();
while(it.hasNext()){
MessageInfo mi = (MessageInfo)it.next();
%> <table>
<tr>
<td>主题:</td>
<td colspan = "3"><%=mi.getTitle() %></td>
</tr>
<tr>
<td>留言人:</td>
<td><%=mi.getName() %></td>
<td>E-mail:</td>
<td><%=mi.getEmail() %></td>
</tr>
<tr>
<td>留言时间:</td>
<td colspan = "3"><%=mi.getDate() %></td>
</tr>
<tr>
<td><%out.println("("+message_count+")"); %></td>
<td colspan = "3"><%=mi.getContent() %></td>
</tr>
</table>
<%} %>
</body>
</html>
16:
17: Collection messages = Tm.getMessage(); //这里的Tm中的message你确定在对象声明的时候出初始化了吗?
18: