java.sql.SQLException: No suitable driver我在执行插入操作的时候不会出现错误, 执行删除的时候就会出现这个异常
解决方案 »
- 我是个新手 请教下form提交上去怎么不显示结果,各位大侠帮我看看哪错了
- spring中 jdbcTemplate nullpointerexception的问题
- spring事务隔离级别
- php连接mysql
- jsp:如何屏蔽跳转后的jsp(如:地址栏,菜单栏等)
- 从JSP中用超连接到servlet
- eclipse安装了aptana插件,不知道怎么调整字体大小!
- 国内使用开源为何如此之少?深入了解和使用OFBIZ看这里!
- 请问该如何在一个字符串后面插入一个字符串?
- tomcat+windows2000 的配置问题
- 如何获取文件的路径
- 请问谁有ajax实现无刷新二级联动源代码啊或小项目!急急急
OrderDao od=new OrderDao();
od.delAdmin(1);
%>
实际页面就是这两句JSP , 用的是mysql的数据库,完整错误
信息: Server startup in 16375 ms
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at com.logistics.order.dao.OrderDao.delAdmin(OrderDao.java:114)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:73)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:595)
还不行的话,建议重新加载一个驱动包!
{
PreparedStatement stmt = null;
Connection conn=null;
ResultSet rs=null;
try{
conn = DriverManager.getConnection(url);
stmt = conn.prepareStatement("delete from orders where o_id=?");
stmt.setInt(1,id);
stmt.executeUpdate();
} catch(SQLException e){
e.printStackTrace();//del="您要删除的数据不存在";
}
finally{
try{
if(stmt!=null)
stmt.close();
if(conn!=null)
conn.close();
if(rs!=null)
rs.close(); }catch(SQLException e)
{
e.printStackTrace();
} }
}