求一个简单的成功的读写ms access 2000数据库的javabean及jsp。我的老是不成功，不知怎么回事。(50分)

  • 主题发起人 主题发起人 WorldCreater
  • 开始时间 开始时间
W

WorldCreater

Unregistered / Unconfirmed
GUEST, unregistred user!
odbc数据源名：BorlandDemoDb
我的javabean源码
package myprj;
import java.sql.*;
import java.io.*;
public class MyBean {
private String value = "only a test";
public void setValue(String AValue)
{
value = AValue;
}
public String getValue()
{
return value;
}
public ResultSet DbQuery(String Sql)
{
try
{
//driver={Microsoft Access Driver (*.mdb)};DBQ=D://AAA.MDB
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection Cnn = DriverManager.getConnection("jdbc:odbc:BorlandDemoDb","admin","");
Statement Stmt = Cnn.createStatement();
ResultSet Rs = Stmt.executeQuery( Sql );
return Rs;
}
catch( Exception e )
{
System.out.println( "my bean's error:" + e.getMessage() );
}
return null;
}
}
我的jsp源码：
<%@ page contentType="text/html;
charset=GBK" import="java.sql.*" %>
<html>
<head>
<title>
MyJsp
</title>
</head>
<jsp:useBean id="MyJspBeanId" scope="session" class="myprj.MyJspBean" />
<body>
<h1>
JBuilder Generated JSP
</h1>
<form method="post">
<br>Enter new value : <input name="sample"><br>
<br><br>
<input type="submit" name="Submit" value="Submit">
<input type="reset" value="Reset">
<br>
Value of Bean property is :<jsp:getProperty name="MyJspBeanId" property="sample" />
</form>
<jsp:useBean id="DbBean" scope="session" class="myprj.MyBean" />
<br>
value is:<jsp:getProperty name="DbBean" property="value" />
<%
String Sql = "select * from customer";
ResultSet Rs = DbBean.DbQuery( Sql );
Rs.last();
out.println( Rs.getRow() );
Rs.first();
while( Rs.next() )
{
System.out.println( Rs.getString("Company"));
}
%>
</body>
</html>

jbuilder调试页面出错信息
Apache Tomcat/4.0.3 - HTTP Status 500 - Internal Server Errortype Exception reportmessage Internal Server Errordescription The server encountered an internal error (Internal Server Error) that prevented it from fulfilling this request.exception javax.servlet.ServletException: Result set type is TYPE_FORWARD_ONLY
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:463)
at org.apache.jsp.MyJsp$jsp._jspService(MyJsp$jsp.java:153)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:202)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:382)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:474)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1012)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1107)
at java.lang.Thread.run(Thread.java:484)
root cause java.sql.SQLException: Result set type is TYPE_FORWARD_ONLY
at sun.jdbc.odbc.JdbcOdbcResultSet.last(JdbcOdbcResultSet.java:2228)
at org.apache.jsp.MyJsp$jsp._jspService(MyJsp$jsp.java:135)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:202)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:382)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:474)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1012)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1107)
at java.lang.Thread.run(Thread.java:484)
 
我的email:
my.soft@sina.com
 
>>Statement Stmt = Cnn.createStatement();
>>ResultSet Rs = Stmt.executeQuery( Sql );
改成
[red]
PreparedStatement Stmt = Cnn.prepareStatement(Sql);
ResultSet Rs = Stmt.executeQuery();
[/red]
试试！另外，我觉得你写错SQL语句的可能性较大！问题可能出现在
你的 Rs.last()语句部分，因为如果没有检索出记录集，这样的操作
就会出错！所以我强列建议你仔细检查自己的SQL语句

 
呵呵，是tomcat有点问题
 
您必须登录或注册才可回复。

Similar threads

C
请各位DFW查看这个错误如何处理？没多少分了，有分一定再给。(43分)
回复
8
查看
381
yangxiao_jiang
Y
阿
***在JSP页面中使用Bean的问题*** ( 积分: 20 )
回复
6
查看
596
maching
M
H
关于jsp中自定义标志的初级问题,请大家指点一下.....急呀!!!(50分)
回复
2
查看
411
h_o_u_l_i
H
视
关于返回可滚动的数据集的问题，几天了，始终找不到问题所在，请大家帮我看看 (200分)
回复
8
查看
396
视觉音乐
视
寻
我以前写的JSP+JavaBean怎么现在运行不了？(50分)
回复
5
查看
316
lnboy
L
后退
顶部