求达人指教，jsp初学者问题..

gamekingkyo 2008-06-21 09:05:17

请问我这个代码有什么问题啊，搞了好久就是报错，我也找不到错的原因，求指教
<%@ page language="java" import="java.sql.ResultSet;" pageEncoding="gbk"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>

<title>My JSP 'NewsPage.jsp' starting page</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">

<%!
int pageNow;
int pageSize;
int rowCount;
int pageCount;
ResultSet rs;

%>

<%
DBManager db=new DBManager();
if(pageNow!=0)
pageNow=Integer.parseInt(request.getParameter("pageNow"));
else
pageNow=1;
int pageSize=10;
int rowCount=db.getRowCount();
if(rowCount%pageSize==0)
pageCount=rowCount/pageSize;
else
pageCount=rowCount/pageSize+1;

%>
</head>

<body>
<table border="1" align="center">
<tr><th><td>标题</td><th><td>正文</td><th></tr>
<%
rs=db.select(pageSize,pageNow);

while(rs.next())
{
out.print("<tr><td>"+rs.getString("title")+"</td><td>"+rs.getString("article")+"</td></tr>");
}
for(int i=1;i<=pageCount;i++)
{
out.println("<a href='NewsPage.jsp?pageNow="+pageCount+"'>"+i+"</a>");
}

%>
</table>
</body>
</html>

这个DBManage的代码是
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBManager
{
Connection ct;
ResultSet rs;
PreparedStatement ps;
public DBManager()
{

try
{
Class.forName("com.mysql.jdbc.Driver");
}
catch (ClassNotFoundException e)
{
e.printStackTrace();
}
}
public ResultSet select(int pageSize,int pageNow)
{
String selStr="select * from news limit ?,?";
int start=pageSize*(pageNow-1);
try
{
ct=DriverManager.getConnection("jdbc:mysql://localhost:3306/study","root","gameking");
ps=ct.prepareStatement(selStr);
ps.setInt(1, start);
ps.setInt(2, pageSize);
rs=ps.executeQuery();

}
catch (SQLException e)
{
e.printStackTrace();
}
finally
{
try
{
if(rs!=null)
rs.close();
if(ps!=null)
ps.close();
if(ct!=null)
ct.close();

}
catch (SQLException e)
{
e.printStackTrace();
}
return rs;

}
}
public int getRowCount()
{
int count=0;
String selStr="select count(*) from news";
try
{
ct=DriverManager.getConnection("jdbc:mysql://localhost:3306/study","root","gameking");
ps=ct.prepareStatement("selStr");
rs=ps.executeQuery();
count=rs.getInt(1);

} catch (SQLException e)
{
e.printStackTrace();
}
finally
{
try
{
if(rs!=null)
rs.close();
if(ps!=null)
ps.close();
if(ct!=null)
ct.close();

}
catch (SQLException e)
{
e.printStackTrace();
}
return count;

}

}

}

数据库里就3个字段，1个自增长的id ,一个title ,一个article ,这两个都是字符串

...全文