程序博客网 > 淘宝客做什么产品好

jsp常见错误-不定时连载

来源：互联网 发布：淘宝客做什么产品好 编辑：程序博客网 时间：2024/05/21 20:26

jsp常见错误-不定时连载
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Object has been closed.//数据库连接别强制关闭
 at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
 at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
 at com.microsoft.jdbc.base.BaseConnection.validateClosedState(Unknown Source)
 at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown Source)
 at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown Source)
 at com.shop.model.UserBeanBo.check(UserBeanBo.java:16)
 at com.yourcompany.struts.action.IndexAction.login(IndexAction.java:41)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:597)
 at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
 at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
 at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
 at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
 at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
 at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
 at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
 at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
 at java.lang.Thread.run(Thread.java:619)
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Object has been closed.
 at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
 at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
 at com.microsoft.jdbc.base.BaseConnection.validateClosedState(Unknown Source)
 at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown Source)
 at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown Source)
 at com.shop.model.UserBeanBo.check(UserBeanBo.java:16)
 at com.yourcompany.struts.action.IndexAction.login(IndexAction.java:41)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:597)
 at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
 at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
 at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
 at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
 at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
 at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
 at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
 at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
 at java.lang.Thread.run(Thread.java:619)

 

可能是JDBC的错误，目前还没找到

今天找到了
是这里的错误：
package com.shop.model;
import java.sql.*;
public class Conn {
 private Connection conn =null;
 public Connection getConn(){
  try {
   Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
   conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databaseName=spdb1","sa","zhuseahui");
  } catch (Exception e) {
   e.printStackTrace();
   // TODO: handle exception
  }
  finally   //在这我关闭了数据库的连接了，所以后面就连不上数据库了
  {
   try {
    conn.close();// //在这我关闭了数据库的连接了，所以后面就连不上数据库了
   } catch (Exception e) {
    e.printStackTrace();
    // TODO: handle exception
   }
  }
  return conn;
 }

}


在连接数据库的时候关闭数据库了，还怎么能连呢
如果是在调用页面重新写个连接的类，那样会解决问题的

jsp常见错误-不定时连载
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Object has been closed.//数据库连接别强制关闭
 at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
 at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
 at com.microsoft.jdbc.base.BaseConnection.validateClosedState(Unknown Source)
 at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown Source)
 at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown Source)
 at com.shop.model.UserBeanBo.check(UserBeanBo.java:16)
 at com.yourcompany.struts.action.IndexAction.login(IndexAction.java:41)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:597)
 at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
 at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
 at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
 at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
 at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
 at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
 at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
 at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
 at java.lang.Thread.run(Thread.java:619)
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Object has been closed.
 at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
 at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
 at com.microsoft.jdbc.base.BaseConnection.validateClosedState(Unknown Source)
 at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown Source)
 at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown Source)
 at com.shop.model.UserBeanBo.check(UserBeanBo.java:16)
 at com.yourcompany.struts.action.IndexAction.login(IndexAction.java:41)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:597)
 at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
 at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
 at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
 at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
 at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
 at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
 at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
 at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
 at java.lang.Thread.run(Thread.java:619)

 

可能是JDBC的错误，目前还没找到

今天找到了
是这里的错误：
package com.shop.model;
import java.sql.*;
public class Conn {
 private Connection conn =null;
 public Connection getConn(){
  try {
   Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
   conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databaseName=spdb1","sa","zhuseahui");
  } catch (Exception e) {
   e.printStackTrace();
   // TODO: handle exception
  }
  finally   //在这我关闭了数据库的连接了，所以后面就连不上数据库了
  {
   try {
    conn.close();// //在这我关闭了数据库的连接了，所以后面就连不上数据库了
   } catch (Exception e) {
    e.printStackTrace();
    // TODO: handle exception
   }
  }
  return conn;
 }

}


在连接数据库的时候关闭数据库了，还怎么能连呢
如果是在调用页面重新写个连接的类，那样会解决问题的

淘宝客做什么产品好 淘宝客做什么产品好
原创粉丝点击
热门IT博客
知乎 nwa原画知乎 nwa原画
淘宝网摩托车头盔淘宝网摩托车头盔
snmp trap 端口
好吃的巧克力 知乎
服装设计专用软件
微信群控系统源码
linux tcp
淘宝服饰
mac safari 弹广告
医疗网络新技术
淘宝刷机
2015年淘宝双11销售额
帝国cms怎么二次开发
淘宝抢购秒杀器 安卓
电信能群发短信的软件
asm4 java
结婚证照片制作软件
mac装好的软件在哪里
win7 vmware mac os x
js 银行卡 4位 空格
热门问题 老师的惩罚 人脸识别 我在镇武司摸鱼那些年 重生之率土为王 我在大康的咸鱼生活 盘龙之生命进化 天生仙种 凡人之先天五行 春回大明朝 姑娘不必设防，我是瞎子 李德华笛子 李德印太极拳 李德印24式太极拳 李德印42式太极拳分解教学 李德印功夫扇第一套分解教学 李德印32太极剑全教学 李德印太极扇 李德印太极功夫扇 李德印太极剑 李德印十六式太极拳 李德印24式太极拳mp3 李德印48式太极拳分解教学 李德印24式太极拳口令 李德印56式陈式太极拳教学 李德印四十八式太极拳 李德修小儿推拿秘笈 李德印24式太极拳下载 李德印太极扇分解教学 李德戈景中国好舞蹈 雍正为什么杀死李德全 32式太极拳分解教学李德印 二十四式简化太极拳李德印 李志的歌 李志怎么了 李志怎么 丧尸李志 热河李志 忽然李志 李志热河 李志为什么 南京李志 李志忽然 下雨李志 李志演唱会 李志下雨 李志的歌曲 李志广场 我不李志 李志结婚 李志他们 李志 结婚

程序博客网，程序员的互联网技术博客家园。csdn论坛精品 msdn技术资料都在这里