数据库连接成功，执行语句失败（配置win7+sqlserver2000+myeclipse8.5+tomcat6.0 ）
package lwl.model;
import java.sql.*;
public class GoodsBeanBO {
private ResultSet rs = null;
private Connection ct = null;
private PreparedStatement ps = null;
//根据一个商品的货物Id，得到货物具体信息的函数
public GoodsBean getGoodsBean(String id){
GoodsBean gb = new GoodsBean();
try {
ct = new ConnDB().getConn();
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
System.out.println("数据库连接失败");
}finally{
this.close();
}
try {
ps = ct.prepareStatement("select * from goods where goodsId=?");
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
System.out.println("ps = ct.prepareStatement('select * from goods where goodsId=?')执行失败");
}finally{
this.close();
}
try {
ps.setString(1, id);
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
System.out.println(" ps.setString(1, id);执行失败");
}finally{
this.close();
}
try {
rs = ps.executeQuery();
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
System.out.println("rs = ps.executeQuery();执行失败");
}finally{
this.close();
}
try{
if(rs.next()){
gb.setGoodsId(rs.getInt(1));
gb.setGoodsName(rs.getString(2));
gb.setGoodsIntro(rs.getString(3));
gb.setGoodsPrice(rs.getFloat(4));
gb.setGoodsNum(rs.getInt(5));
gb.setPublisher(rs.getString(6));
gb.setPhoto(rs.getString(7));
gb.setType(rs.getString(8));
}
}catch(Exception ex){
ex.printStackTrace();
System.out.println("rs.next()执行失败");
}finally{
this.close();
}
return gb;
}
public void close(){
try{
if(rs!=null){
rs.close();
rs = null;
}
if(ps!=null){
ps.close();
ps = null;
}
if(ct!=null){
ct.close();
ct = null;
}
}catch(Exception ex){
ex.printStackTrace();
}
}
}
2012-4-25 23:09:14 org.apache.catalina.core.AprLifecycleListener init
信息: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Users\lwl\AppData\Local\Genuitec\Common\binary\com.sun.java.jdk.win32.x86_1.6.0.013\bin;C:\Program Files\Apache Software Foundation\Tomcat 6.0\bin
2012-4-25 23:09:15 org.apache.coyote.http11.Http11Protocol init
信息: Initializing Coyote HTTP/1.1 on http-8080
2012-4-25 23:09:15 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 2031 ms
2012-4-25 23:09:15 org.apache.catalina.core.StandardService start
信息: Starting service Catalina
2012-4-25 23:09:15 org.apache.catalina.core.StandardEngine start
信息: Starting Servlet Engine: Apache Tomcat/6.0.35
2012-4-25 23:09:15 org.apache.catalina.startup.HostConfig deployDescriptor
信息: Deploying configuration descriptor manager.xml
2012-4-25 23:09:16 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory docs
2012-4-25 23:09:16 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory ROOT
2012-4-25 23:09:16 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory wxgww
2012-4-25 23:09:17 org.apache.coyote.http11.Http11Protocol start
信息: Starting Coyote HTTP/1.1 on http-8080
2012-4-25 23:09:18 org.apache.jk.common.ChannelSocket init
信息: JK: ajp13 listening on /0.0.0.0:8009
2012-4-25 23:09:18 org.apache.jk.server.JkMain start
信息: Jk running ID=0 time=0/94 config=null
2012-4-25 23:09:18 org.apache.catalina.startup.Catalina start
信息: Server startup in 2617 ms
2012-4-25 23:09:27 org.apache.catalina.startup.HostConfig checkResources
信息: Reloading context [/wxgww]
2012-4-25 23:10:08 org.apache.catalina.core.ApplicationContext log
信息: HTMLManager: init: Associated with Deployer 'Catalina:type=Deployer,host=localhost'
2012-4-25 23:10:08 org.apache.catalina.core.ApplicationContext log
信息: HTMLManager: init: Global resources are available
2012-4-25 23:10:08 org.apache.catalina.core.ApplicationContext log
信息: HTMLManager: list: Listing contexts for virtual host 'localhost'
java.lang.ClassNotFoundException: com.microsoft.sqlserver.SQLServerDriver
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1680)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1526)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at lwl.model.ConnDB.getConn(ConnDB.java:10)
at lwl.model.GoodsBeanBO.getGoodsBean(GoodsBeanBO.java:15)
at lwl.servlet.ShowGoodsClServlet.doGet(ShowGoodsClServlet.java:43)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:619)
java.lang.NullPointerException
at lwl.model.GoodsBeanBO.getGoodsBean(GoodsBeanBO.java:24)
at lwl.servlet.ShowGoodsClServlet.doGet(ShowGoodsClServlet.java:43)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:619)
ps = ct.prepareStatement('select * from goods where goodsId=?')执行失败
java.lang.NullPointerException
at lwl.model.GoodsBeanBO.getGoodsBean(GoodsBeanBO.java:33)
at lwl.servlet.ShowGoodsClServlet.doGet(ShowGoodsClServlet.java:43)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:619)
ps.setString(1, id);执行失败
配置tomcat用的myeclipse自带jdk1.6
[解决办法]
一行代码一个try，然后finally,谁教你的？
java.lang.NullPointerException
at lwl.model.GoodsBeanBO.getGoodsBean(GoodsBeanBO.java:24)
创建的数据库连接被finally close
