大家帮我看看这个Bean错在那里

/*conn.java*/
import java.io.*;
import java.sql.*;
import java.net.*;
import java.util.*;public class conn{
private String sqlDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";//数据库驱动
private String sqlUrl    = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Sports";//数据库连接字串
private String sqlUser   = "sa";//数据库用户名
private String sqlPsw    = "asd123";//数据库密码//private Connection conn = null;
//private Statement stmt = null;
//ResultSet rs;
//int iCount;
public void conn()//构造函数类化驱动
{
try
{
Class.forName(sqlDriver);
}
    catch(ClassNotFoundException e)
{
System.out.println(e.toString());
    }
}public int UpdateRecord(String SQL)//不返回记录集的操作
{
Connection con = null;
Statement stmt = null;
int iCount = 0;
try
{
con  = DriverManager.getConnection(sqlUrl,sqlUser,sqlPsw);
stmt = con.createStatement();
iCount = stmt.executeUpdate(SQL);
con.close();
stmt.close();
}
catch(SQLException ex)
{
System.out.println(ex.toString());
}
return iCount;//返回更新的记录数
}public ResultSet SelectRecord(String SQL)//返回记录集的操作
{
Connection con = null;
Statement stmt = null;
ResultSet rs   = null;
try
{
con  = DriverManager.getConnection(sqlUrl,sqlUser,sqlPsw);
stmt = con.createStatement();
rs   = stmt.executeQuery(SQL);
con.close();
stmt.close();
}
catch(SQLException ex)
{
System.out.println(ex.toString());
}
return rs;
}
}我在调用的时候报错说
org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 3 in the jsp file: /Sports/index.jspGenerated servlet error:
    [javac] Compiling 1 source fileD:\Tomcat\work\Standalone\localhost\_\Sports\index_jsp.java:45: cannot resolve symbol
symbol  : class conn 
location: class org.apache.jsp.index_jsp
      conn dbopen = null;
      ^An error occurred at line: 3 in the jsp file: /Sports/index.jspGenerated servlet error:
D:\Tomcat\work\Standalone\localhost\_\Sports\index_jsp.java:47: cannot resolve symbol
symbol  : class conn 
location: class org.apache.jsp.index_jsp
        dbopen = (conn) pageContext.getAttribute("dbopen", PageContext.PAGE_SCOPE);
                  ^An error occurred at line: 3 in the jsp file: /Sports/index.jspGenerated servlet error:
D:\Tomcat\work\Standalone\localhost\_\Sports\index_jsp.java:50: cannot resolve symbol
symbol  : class conn 
location: class org.apache.jsp.index_jsp
            dbopen = (conn) java.beans.Beans.instantiate(this.getClass().getClassLoader(), "conn");
刚学jsp各位大侠帮忙！

解决方案 »

  1.   

    在JSP上面写一行<%@ page import="***.***.conn"%>
      

  2.   

    有没注意。楼主的JAVA文件少了  package ...呵呵。加上看看
      

  3.   

    public void conn()//构造函数类化驱动
    {
    try
    {
    Class.forName(sqlDriver);
    }
        catch(ClassNotFoundException e)
    {
    System.out.println(e.toString());
        }
    }搂住你的构造函数有问题，声明的时候
    public conn(){
    ..........
    }
    是不需要void的，你这个类肯定没有编译过
      

  4.   

    两处地方都改了，还是不行，报错还是老样子
    再得class文件应该是放在web-inf的classes文件夹中呀
      

  5.   

    就是编译通过了，才会在访问jsp文件的时候出现错误
      

  6.   

    你是用Jbuilder吗？如果是的话，在工程中把tomcat5.0换成5.5 ，反正更改一下服务器。我之前出现过类似的情况
      

  7.   

    不是用jbuilder，用editplus写的程序
      

  8.   

    检查一下你在index.jsp里引用这个bean是否正确，这个bean的位置放正确了没有。
      

  9.   

    /*index.jsp*/
    <%@ page language="java"%> 
    <%@ page contentType="text/html; charset=GB2312" %>
    <%@ page import="java.sql.*"%>
    <jsp:useBean id="dbopen" class="conn" scope="page"/>
    <html><title></title>
    <head></head>
    <body>
    <table>
    <%
    ResultSet rs=null;
    rs = dbopen.SelectRecord("select * from s_deputy");
    rs.last();
    int number = rs.getRow();
    out.println(number);
    while(rs.next())
    {
    out.println("<TR>");
    for(int i=1;i<6;i++)
    {
    out.println("<TD>"+rs.getString(i)+"</TD>");
    }
    out.println("</TR>");
    }
    %>
    </td></tr></table></body></html>
      

  10.   

    我的conn.class文件放在了web-inf中的classes文件夹中
      

  11.   

    楼主。。好像应该在classes文件夹中另外新建一个文件如temp  然后在java类上面放上一个package temp;  编译通过后，再把.class文件放到temp文件夹中去，　　而后网页要添加
    <%@ page import="temp.conn"%>　这样应该就可以了。。记住要在classes文件夹中新建一个文件夹　然后放入.class文件
      

  12.   

    楼上的还是不行，我也这么尝试啦，但是还是不行
    org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 4 in the jsp file: /Sports/index.jspGenerated servlet error:
        [javac] Compiling 1 source fileD:\Tomcat\work\Standalone\localhost\_\Sports\index_jsp.java:8: package db does not exist
    import db.conn;
              ^
    D:\Tomcat\work\Standalone\localhost\_\Sports\index_jsp.java:47: package db does not exist
          db.conn dbopen = null;
            ^An error occurred at line: 4 in the jsp file: /Sports/index.jspGenerated servlet error:
    D:\Tomcat\work\Standalone\localhost\_\Sports\index_jsp.java:49: package db does not exist
            dbopen = (db.conn) pageContext.getAttribute("dbopen", PageContext.PAGE_SCOPE);
                        ^An error occurred at line: 4 in the jsp file: /Sports/index.jspGenerated servlet error:
    D:\Tomcat\work\Standalone\localhost\_\Sports\index_jsp.java:52: package db does not exist
                dbopen = (db.conn) java.beans.Beans.instantiate(this.getClass().getClassLoader(), "db.conn");
                            ^
    4 errors
      

  13.   

    我的站点在Root/Sports下面，我的class应该放在
    Root/Sports/WEB-INF/classes
    还是Root/WEB-INF/classes下面
      

  14.   

    我将之放到Root/WEB-INFO/classes文件夹中报这个错
    org.apache.jasper.JasperException: [Microsoft][SQLServer 2000 Driver for JDBC]Object has been closed.
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:248)
    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:534)
    root cause javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Object has been closed.
    at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:533)
    at org.apache.jsp.index_jsp._jspService(index_jsp.java:206)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:204)
    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:534)
      

  15.   

    要注意:在引用conn时,看有没有被关闭!如: if (conn==null) ...
      

  16.   

    public ResultSet SelectRecord(String SQL)//返回记录集的操作
    {
    Connection con = null;
    Statement stmt = null;
    ResultSet rs = null;
    try
    {
    con = DriverManager.getConnection(sqlUrl,sqlUser,sqlPsw);
    stmt = con.createStatement();
    rs = stmt.executeQuery(SQL);
    con.close();
    stmt.close();
    }
    catch(SQLException ex)
    {
    System.out.println(ex.toString());
    }
    return rs;
    }这里返回rs时,已经是空的了,因为连接已关闭,建议链接在返回后关闭再说你这种方法不太合理,建议你使用连接池!!!
      

  17.   

    con.close();
    stmt.close();应改成:
    stmt.close();
    con.close();
      

  18.   

    在你的conn代码有许多地方写的不妥，我改进了下：
    package a;import java.io.*;
    import java.sql.*;
    import java.net.*;
    import java.util.*;public class Conn{
    private String sqlDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";//数据库驱动
    private String sqlUrl = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Sports";//数据库连接字串
    private String sqlUser = "sa";//数据库用户名
    private String sqlPsw = "asd123";//数据库密码private Connection con = null;
    private Statement stmt = null;
    ResultSet rs;
    //int iCount;
    public Conn()//构造函数类化驱动
    {
    try
    {
    Class.forName(sqlDriver);
    con = DriverManager.getConnection(sqlUrl,sqlUser,sqlPsw);
    }
    catch(Exception e)
    {
    System.out.println(e.toString());
    }
    }public int UpdateRecord(String SQL)//不返回记录集的操作
    {int iCount = 0;
    try
    {stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
    iCount = stmt.executeUpdate(SQL);
    //con.close();
    //stmt.close();
    }
    catch(SQLException ex)
    {
    System.out.println(ex.toString());
    }
    return iCount;//返回更新的记录数
    }public ResultSet SelectRecord(String SQL)//返回记录集的操作
    {
    try
    {
    //你写的是stmt = con.createStatement();这样写效率是高，但是只能够用rs.next()，不可以用rs.last()等方法
    stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
    rs = stmt.executeQuery(SQL);
    //con.close();
    //stmt.close();
    }
    catch(SQLException ex)
    {
    System.out.println(ex.toString());
    }
    return rs;
    }//关闭连接
    public int closeConn(){
    int result = 0;
    try{
    rs.close();
    stmt.close();
    con.close();
    result = 1;
    }catch(SQLException e){
    System.out.println(e.getMessage());
    }
    return result;
    }
    }<%@ page language="java"%>
    <%@ page contentType="text/html; charset=GB2312" %>
    <%@ page import="java.sql.*"%>
    <jsp:useBean id="dbopen" class="a.Conn" scope="page"/>
    <html><title></title>
    <head></head>
    <body>
    <table>
    <%
    ResultSet rs=null;rs = dbopen.SelectRecord("select * from s_deputy");
    boolean s = rs.last();
    int number = rs.getRow();
    out.println(number);
    rs.beforeFirst();//返回结果集开始
    while(rs.next())
    {
    out.println("<TR>");
    for(int i=1;i<4;i++)
    {
    out.println("<TD>"+rs.getString(i)+"</TD>");
    }
    out.println("</TR>");
    }
    rs.close();
    int a = 0;
    a = dbopen.closeConn();
    %>
    </td></tr></table></body></html>
    <script>
    if(<%=a%>==0)
    alert("关闭数据库连接错误！");
    </script>
    LZ先拿去试下，有什么问题在说
      

  19.   

    楼上的，按照你的程序写出来还是报以下错误
    org.apache.jasper.JasperException: [Microsoft][SQLServer 2000 Driver for JDBC]Object has been closed.
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:248)
    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:534)
    root cause javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Object has been closed.
    at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:533)
    at org.apache.jsp.test_jsp._jspService(test_jsp.java:102)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:204)
    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:534)我就不懂，为什么会说sql server的对象被关闭
      

  20.   

    你直接把我的代码COPY了，然后也提示Object has been closed？
      

  21.   

    对，但是我不用bean，真接写jsp文件链接数据又是正确的
      

  22.   

    这个程序我自己调试了没有问题，你试下自己调试，例如可以打开MSSQL的事件探查器，看看BEAN是否执行了SQL语句，还有可以在BEAN的一些地方打印一些消息等等
      

  23.   

    我重启了tomcat，然后删除了work下的servelet文件，再开始就可以啦