求教大神jsp+sql新闻管理系统
org.apache.jasper.JasperException: An exception occurred processing JSP page /index.jsp at line 35
32: ResultSet rs = newsBean.selectNewNewsWithCaName();
33: String id;
34: String caId,caTitle,newsTitle,createTime;
35: while(rs.next()){
36: caTitle = rs.getString("caTitle");
37: id = rs.getString("id");
38: caId = rs.getString("caId");出现这个问题！
下面是各部分代码和截图 
index.jsp
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import ="edu.tjau.*,java.sql.*" %>
<jsp:useBean id="newsBean" class="edu.tjau.NewsBean"></jsp:useBean>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>新闻管理系统首页</title>
</head>
<body>
<div class="mainDiv">
<div class="newNews">
<div class=newNews_Top>
<div class="top_title">最新新闻</div>
<div class="top_more">更多...</div>
</div>
<table>
<!--
<tr>
<th class="newNews_Title">所属分类</th>
<th class="newNews_Content">新闻标题</th>
<th class="newNews_Time">发布时间</th>
</tr>
-->
<%
ResultSet rs = newsBean.selectNewNewsWithCaName();
String id;
String caId,caTitle,newsTitle,createTime;
while(rs.next()){
caTitle = rs.getString("caTitle");
id = rs.getString("id");
caId = rs.getString("caId");
newsTitle = rs.getString("newsTitle");
createTime = rs.getDate("createTime").toString();
%>
<tr>
<td class="newNews_Title"><a href="<%=path%>/showCategory.jsp?caid=<%= caId %>">[<%= caTitle %>]</a></td>
<td class="newNews_Content"><a href="<%=path%>/showContent.jsp?id=<%= id %>"><%= newsTitle %></a></td>
<td class="newNews_Time"><%= createTime %></td>
</tr>
<% } %>
<!--
<tr>
<td class="newNews_Title"><a href="<%=path%>/showCategory.jsp?id=1">[娱乐新闻]</a></td>
<td class="newNews_Content"><a href="<%=path%>/showContent.jsp?id=1">人再囧途之泰囧在今年春节档大获成功！</a></td>
<td class="newNews_Time">2013.2.1</td>
</tr>
-->
</table>
</div>
<div class="hotNews">
<div class=newNews_Top>
<div class="top_title">热点新闻</div>
<div class="top_more">更多...</div>
</div>
<table>
<!--
<tr>
<th class="newNews_Title">所属分类</th>
<th class="newNews_Content">新闻标题</th>
<th class="newNews_Time">发布时间</th>
</tr>
-->
<jsp:useBean id="categoryBean" class = "edu.tjau.CategoryBean"></jsp:useBean>
<%
rs=newsBean.selectHotNewsWithCaName();
while(rs.next()){
caTitle = rs.getString("caTitle");
id = rs.getString("id");
caId = rs.getString("caId");
newsTitle = rs.getString("newsTitle");
createTime = rs.getDate("createTime").toString();
categoryBean.setCaTitle(caTitle);
newsBean.setNewsTitle(newsTitle);
newsBean.setCreateTime(createTime);
%>
<tr>
<td class="newNews_Title"><a href="<%=path%>/showCategory.jsp?caid=<%=caId %>">[<jsp:getProperty property="caTitle" name="categoryBean"/>]</a></td>
<td class="newNews_Content"><a href="<%=path%>/showContent.jsp?id=<%=id %>"><jsp:getProperty property="newsTitle" name="newsBean"/></a></td>
<td class="newNews_Time"><jsp:getProperty property="createTime" name="newsBean"/></td>
</tr>
<%} %>
</table>
</div>
</div>
</body>
</html>
1回答
-
慕侠7578997
String id;String caId,caTitle,newsTitle,createTime；赋个null值00
相关分类