CrazyEnglishing等高手请进,还是上次那个新闻发布问题
我再发一次吧,希望能解决这个弱智问题
新闻类型表:NewsType
TypeID 主键
TypeContent 类型内容
新闻表:News
ID
TypeID
Title
Content
....
TypeID与NewsType的TypeID表一样,作为外键
然后我建了一个News_View的视图
SELECT dbo.News.ID, dbo.News.Title, dbo.News.Content, dbo.News.PictureID,
dbo.News.FileID, dbo.News.AddTime, dbo.News.FromIP, dbo.News.ReadCount,
dbo.NewsType.*
FROM dbo.News INNER JOIN
dbo.NewsType ON dbo.News.TypeID = dbo.NewsType.TypeID
然后我用自己的Bean查看该视图的信息,Bean没有错,其他的地方用得好好的,我在察看新闻页是这样写的
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="newsBean" scope="page" class="page.page"/>
<%
ResultSet newsrs=null;
String newsid=null;
newsid=request.getParameter("newsid");
String sql=null;
sql="select * from News_View where id="+newsid;
newsrs=newsBean.selQuery(sql);
if(newsrs.next())
{
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title><%=newsrs.getString("Title") %></title>
<link href="css.css" rel="stylesheet" type="text/css">
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="476" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="476"><img src="images/news_title.gif" width="476" height="24"></td>
</tr>
<tr>
<td align="center"><font color="black" size=4><%=newsrs.getString("Title") %></font></td>
</tr>
<tr>
<td align="center">新闻类型:<%=newsrs.getString("TypeContent")%>加入时间:<%=newsrs.getDate("AddTime")%> 阅读次数:<%=newsrs.getInt("ReadCount")+1%></td>
</tr>
<tr>
<td><br> <%=newsrs.getString("Content")%></td>
</tr>
<tr>
<td><img src="images/news_bottom.gif" width="473" height="35" border="0" usemap="#Map"></td>
</tr>
</table>
<map name="Map">
<area shape="rect" coords="394,18,450,32" href="javascript:window.close();">
</map>
</body>
</html>
<%
}
else
{
out.println("数据库中无此新闻");
}
newsrs.close();
%>
可是一加上这个新闻类型,这一项就出错,请大虾告诉我怎么回事