最高分求救:一个JAVABEAN+JSP的错误
正在学JAVA,可身边没有老师,望各位大虾,不吝赐教。
正在用jsp+javabean做一个bbs
文件一dbjsp.java,这个文件应该没错误
package bbs;
import java.sql.*;
import java.lang.String;
public class dbjsp {
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:jsp";
Connection conn = null;
ResultSet rs = null;
public dbjsp() {
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("dbjsp(): " + e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
rs = null;
try {
conn = DriverManager.getConnection(sConnStr,"lijian","123456");
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
{
}
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
return rs;
}
public void update(String sql){
try {
conn = DriverManager.getConnection(sConnStr,"lijian","123456");
Statement stmt = conn.createStatement();
stmt.executeUpdate(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
}
}
文件二bbs.java编译没有错误
用了一个递归调用
package bbs;
import java.sql.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import bbs.*;
import java.net.*;
import java.io.*;
import java.text.*;
public class bbs
{
public static String subtitle(int cid,String ns,String str,int pages)throws Exception{
String sql;
ResultSet rs=null;
sql="select * from bbs where pid="+cid+" order by bbs_id desc";
dbjsp conn=new dbjsp();
rs=conn.executeQuery(sql);
String backstr=str;
String nblank=ns+" ";
while(rs.next()){
int bbsid=rs.getInt("bbs_id");
String title=rs.getString("title");
String author=rs.getString("author");
String dates=rs.getString("content");
int counter=rs.getInt("counter");
backstr=backstr+"<tr><td>"+nblank+"<a href=answer.jsp?pid="+bbsid+"&pages="+pages+">"+title+"</a></td>";
backstr=backstr+"<td>"+author+"</td><td>"+counter+"</td></tr>";
backstr=subtitle(bbsid,nblank,backstr,pages);
}
rs.close();
return backstr;
}
}
文件三bbs.jsp显示帖子的页面
<%@ page language="java" import="java.sql.*" %>
<%@ page import="java.net.*"%>
<%@ page import="java.io.*"%>
<%@ page import="java.text.*"%>
<%@ page import="java.util.*"%>
<HTML>
<HEAD>
<META http-equiv="Content-Type" content="text/html;charset=gb2312">
<TITLE> kehudiaocha</TITLE>
</HEAD>
<BODY BGCOLOR="#FFFFFF">
<jsp:useBean id="DBconn1" scope="page" class="bbs.dbjsp"/>
<jsp:useBean id="bbs" scope="page" class="bbs.bbs"/>
<%
int count=0;
int pagecount=0;
int pages=0;
int pagesize=3;
ResultSet RS=DBconn1.executeQuery("select * from bbs where pid is
null");
while(RS.next()){
count++;
}
RS.close();
if(count%pagesize==0)pagecount=count/pagesize;
else pagecount=count/pagesize+1;
String strpages=request.getParameter("pages");
if(strpages==null)pages=1;
else{
pages=new Integer(strpages).intValue();
if(pages<=0)pages=1;
}
ResultSet pRS=DBconn1.executeQuery("select * from bbs where pid is
null order by bbs_id desc");
int i;
for(i=1;i<=(pages-1)*pagesize;i++){pRS.next();}
for(i=1;i<=pagesize;i++){
if(pRS.next()){%>
<%int counter=pRS.getInt("counter");
int bbsid=pRS.getInt("bbs_id");
out.print(bbsid);%>
<a
href="view.jsp?bbs_id=<%=bbsid%>"><%out.print(pRS.getString("title"));%
></a>
<%out.print(pRS.getString("author"));%>
<br>
<%//递归显示当前文章的所有子文章,估计就是这一块有错
String nb=" ";
String nstr="";
String htmlstr=bbs.subtitle(bbsid,nb,nstr,pages);
out.println(htmlstr);
%>
<% }
else{
break;
}
}
pRS.close();
%>
totle:<%=count%>
<%
if(pages<=1){%>
首页 上一页
<%
}
else{
%>
<a href=bbs.jsp?pages=1>首页</a>
<a href=bbs.jsp?pages=<%=(pages-1)%>>上一页</a>
<%
}
if(pages>=pagecount){
%>
下一页 尾页
<%
}
else{
%>
<a href=bbs.jsp?pages=<%=(pages+1)%>>下一页</a>
<a href=bbs.jsp?pages=<%=pagecount%>>尾页</a>
<%
}
%>
<br>
<a href="post.jsp">发表文章</a>
</BODY>
</HTML>
文件四:出错页面
500 Servlet Exception
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]郒勏?"
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6031)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6188)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataInteger(JdbcOdbc.java:3171)
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataInteger(JdbcOdbcResultSet.java:5317)
at sun.jdbc.odbc.JdbcOdbcResultSet.getInt(JdbcOdbcResultSet.java:548)
at sun.jdbc.odbc.JdbcOdbcResultSet.getInt(JdbcOdbcResultSet.java:566)
at _bbs._bbs__jsp._jspService(/bbs/bbs.jsp:42)
at com.caucho.jsp.JavaPage.service(JavaPage.java:87)
at com.caucho.jsp.JavaPage.subservice(JavaPage.java:81)
at com.caucho.jsp.Page.service(Page.java:407)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:166)
at com.caucho.server.http.Invocation.service(Invocation.java:273)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:128)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:216)
at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:158)
at com.caucho.server.TcpConnection.run(TcpConnection.java:140)
at java.lang.Thread.run(Thread.java:484)
--------------------------------------------------------------------------------
Resin 2.0.0 (built Fri Jun 8 12:04:24 PDT 2001)