为了账号安全,请及时绑定邮箱和手机立即绑定

求教大神jsp+sql新闻管理系统

求教大神jsp+sql新闻管理系统

慕瓜1884485 2016-12-26 12:33:27
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

TA贡献5条经验 获得超1个赞

String id;
String caId,caTitle,newsTitle,createTime;赋个null值

查看完整回答
反对 回复 2017-02-20
  • 1 回答
  • 0 关注
  • 3551 浏览

添加回答

举报

0/150
提交
取消
意见反馈 帮助中心 APP下载
官方微信