import java.sql.*;
public class DBconn
{
String DBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String ConnStr  = "jdbc:odbc:db1";

Connection conn = null;
ResultSet  rs   = null;

public DBconn()
{
try
{
Class.forName( DBDriver);
}
catch( java.lang.ClassNotFoundException e )
{
System.err.println( " DBconn();" + e.getMessage() );
}
}

public ResultSet executeQuery( String sql )
{
//rs = null;
try
{
conn = DriverManager.getConnection( ConnStr );
Statement stmt = conn.createStatement();
rs = stmt.executeQuery( sql );
}

catch( SQLException ex )
{
System.err.println(" aq.executeQuery: " + ex.getMessage() );
}
return rs;
}
/* public static void main(String args[]){
DBconn dbconn = new DBconn();
ResultSet rs= dbconn.executeQuery("select * from db1");
System.out.println("resultset+++++++++++" + rs.toString() );
}
*/
}这个beans 我已经调试过了,应该没问题的!<html>
<head>
<meta http-equiv="Conten-Type" content="text/html;charset=gb2312">
<title> hello world </title>
<body>
<p> <b> hello world </b> </p>
<%@ page language="java" >
<%@ page import = "java.sql.*"%>
<jsp:useBean id="DBconn1" scope="page" class="DBconn"/>
<%ResultSet RS=DBconn1.executeQuery("SELECT * FROM db1");
while(RS.next())
{
out.print("<LI>"+RS.getString("name")+"</LI>");
out.print("<LI>"+RS.getString("address")+"</LI>");
out.print("<LI>"+RS.getString("info")+"</LI>");
}
RS.close();
%></body>
</head>
</html>
但是我运行tomcat就有错误.请大家帮我看看错误提示是:
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: /wj.jsp(7,0) Unterminated <%@ page tag
at org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:94)
at org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:428)
at org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:170)
at org.apache.jasper.compiler.Parser.parseDirective(Parser.java:388)
at org.apache.jasper.compiler.Parser.parseElements(Parser.java:800)
at org.apache.jasper.compiler.Parser.parse(Parser.java:122)
at org.apache.jasper.compiler.ParserController.parse(ParserController.java:199)
at org.apache.jasper.compiler.ParserController.parse(ParserController.java:153)
at org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:223)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:351)
at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:474)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:184)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
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:260)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530)
at java.lang.Thread.run(Thread.java:536)