麻烦帮我看下这个报错是哪里的问题
求大神解答。。。。。报错信息：java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@172.17.11.60:1521:HDQTLS at java.sql.DriverManager.getConnection(DriverManager.java:596) at java.sql.DriverManager.getConnection(DriverManager.java:215) at util.DBHelper.getConnection(DBHelper.java:34) at dao.ItemsDAO.getAllItems(ItemsDAO.java:22) at org.apache.jsp.index_jsp._jspService(index_jsp.java:173) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:438) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:522) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1095) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2500) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2489) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)代码如下：import java.sql.Cimport java.sql.DriverMpublic class DBHelper {
private static final String driver = "oracle.jdbc.driver.OracleDriver"; //数据库驱动 //连接数据库的URL地址 private static final String url="jdbc:oracle:thin:@172.17.11.60:1521:HDQTLS";
private static final String username="dbusrmkt";//数据库的用户名 private static final String password="futuremkt";//数据库的密码
private static Connection conn=
//静态代码块负责加载驱动 static
Class.forName(driver);
catch(Exception ex)
ex.printStackTrace();
//单例模式返回数据库连接对象 public static Connection getConnection() throws Exception {
if(conn==null)
conn = DriverManager.getConnection(url, username, password);
public static void main(String[] args) {
Connection conn = DBHelper.getConnection();
if(conn!=null)
System.out.println("数据库连接正常！");
System.out.println("数据库连接异常！");
catch(Exception ex)
ex.printStackTrace();
}}PS：以上我run了一遍能返回---数据库连接正常！
这个提示import java.sql.Cimport java.sql.PreparedSimport java.sql.ResultSimport java.util.ArrayLimport util.DBHimport entity.I//商品的业务逻辑类public class ItemsDAO { // 获得所有的商品信息 public ArrayList&Items& getAllItems() {
Connection conn =
PreparedStatement stmt =
ResultSet rs =
ArrayList&Items& list = new ArrayList&Items&(); // 商品集合
conn = DBHelper.getConnection();
String sql = "select *"; // SQL语句
stmt = conn.prepareStatement(sql);
rs = stmt.executeQuery();
while (rs.next()) {
Items item = new Items();
item.setId(rs.getInt("id"));
item.setName(rs.getString("name"));
item.setCity(rs.getString("city"));
item.setNumber(rs.getInt("number"));
item.setPrice(rs.getInt("price"));
item.setPicture(rs.getString("picture"));
list.add(item);// 把一个商品加入集合
// 返回集合。
} catch (Exception ex) {
ex.printStackTrace();
} finally {
// 释放数据集对象
if (rs != null) {
rs.close();
} catch (Exception ex) {
ex.printStackTrace();
// 释放语句对象
if (stmt != null) {
stmt.close();
} catch (Exception ex) {
ex.printStackTrace();
} } // 根据商品编号获得商品资料 public Items getItemsById(int id) {
Connection conn =
PreparedStatement stmt =
ResultSet rs =
conn = DBHelper.getConnection();
String sql = "select * from items where id=?;"; // SQL语句
stmt = conn.prepareStatement(sql);
stmt.setInt(1, id);
rs = stmt.executeQuery();
if (rs.next()) {
Items item = new Items();
item.setId(rs.getInt("id"));
item.setName(rs.getString("name"));
item.setCity(rs.getString("city"));
item.setNumber(rs.getInt("number"));
item.setPrice(rs.getInt("price"));
item.setPicture(rs.getString("picture"));
} catch (Exception ex) {
ex.printStackTrace();
} finally {
// 释放数据集对象
if (rs != null) {
rs.close();
} catch (Exception ex) {
ex.printStackTrace();
// 释放语句对象
if (stmt != null) {
stmt.close();
} catch (Exception ex) {
ex.printStackTrace();
} } //获取最近浏览的前五条商品信息 public ArrayList&Items& getViewList(String list) {
System.out.println("list:"+list);
ArrayList&Items& itemlist = new ArrayList&Items&();
int iCount=5; //每次返回前五条记录
if(list!=null&&list.length()&0)
String[] arr = list.split(",");
System.out.println("arr.length="+arr.length);
//如果商品记录大于等于5条
if(arr.length&=5)
for(int i=arr.length-1;i&=arr.length-iCi--)
itemlist.add(getItemsById(Integer.parseInt(arr[i])));
for(int i=arr.length-1;i&=0;i--)
itemlist.add(getItemsById(Integer.parseInt(arr[i])));
}}=======jsp如下==============================&%@ page language="java" import="java.util.*" contentType="text/ charset=utf-8"%&&%@ page import="entity.Items"%&&%@ page import="dao.ItemsDAO"%&&%String path = request.getContextPath();String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%&&!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"&&html&
&base href="&%=basePath%&"&
&title&My JSP 'index.jsp' starting page&/title& &meta http-equiv="pragma" content="no-cache"& &meta http-equiv="cache-control" content="no-cache"& &meta http-equiv="expires" content="0"&
&meta http-equiv="keywords" content="keyword1,keyword2,keyword3"& &meta http-equiv="description" content="This is my page"& &!-- &link rel="stylesheet" type="text/css" href="styles.css"& --& &style type="text/css"&
margin: 10
font-size:10
div dd.dd_name
div dd.dd_city
color:#000;
} &/style&
&h1&商品展示&/h1&
&table width="750" height="60" cellpadding="0" cellspacing="0" border="0"&
&!-- 商品循环开始 --&
ItemsDAO itemsDao = new ItemsDAO();
ArrayList&Items& list = itemsDao.getAllItems();
if(list!=null&&list.size()&0)
for(int i=0;i&list.size();i++)
Items item = list.get(i);
&a href="details.jsp?id=&%=item.getId()%&"&&img src="images/&%=item.getPicture()%&" width="120" height="90" border="1"/&&/a&
&dd class="dd_name"&&%=item.getName() %&&/dd&
&dd class="dd_city"&产地:&%=item.getCity() %&&&价格:￥ &%=item.getPrice() %&&/dd&
&!-- 商品循环结束 --&
&/body&&/html&
我发生了和你一样的错误，什么叫驱动包没添加上
写下你的评论...
写下你的评论...
Copyright (C)
All Rights Reserved | 京ICP备 号-2其他回答(1)
WHERE 子句不用接括号吧，还有看错误好像说你的数据源配置是不是有问题
收获园豆：10
&&&您需要以后才能回答，未注册用户请先。