下面这个代码的运行环境是netbeans 用来检测在jsp中能否连接上oracle oracle数据库和netbeans都安装在一台计算机上 并且安装成功 但是jsp 页面总是出现下面异常:java.sql.SQLException: No suitable driver found for jdbc:orcl:thin@f38d48ed599144f:1521:orcl 连接oracle数据库除了有一个oracle 11g 11.1.0.6.0 JDBC_ojdbc6.jar是不是还应该有另外两个驱动 ?另外两个驱动是什么? 这三个驱动分别放在什么目录下?请大家帮忙解决下 谢谢
<%@page import="java.sql.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>JSP Page</title>
</head>
<body>
<% Connection con=null;
Statement sql=null;
ResultSet rs=null;
try{ Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();}
catch(ClassNotFoundException e){}
try{con=DriverManager.getConnection("jdbc:orcl:thin@f38d48ed599144f:1521:orcl","system","sa");
sql=con.createStatement();
rs=sql.executeQuery("select * from emp");
out.print("<Table Border>");
out.print("<TR>");
out.print("<TH width=100>"+"EMPNO");
out.print("<TH width=50>"+"Ename");
out.print("</TR>");
while(rs.next()){
out.print("<TR>");
int n=rs.getInt(1);
out.print("<TD>"+n+"</TD>");
String e=rs.getString(2);
out.print("<TD>"+e+"</TD>");
out.print("</TR>");
}
out.print("</table>");
con.close();}
catch(SQLException e1){out.print(""+e1);}
%> </body>
</html>
<%@page import="java.sql.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>JSP Page</title>
</head>
<body>
<% Connection con=null;
Statement sql=null;
ResultSet rs=null;
try{ Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();}
catch(ClassNotFoundException e){}
try{con=DriverManager.getConnection("jdbc:orcl:thin@f38d48ed599144f:1521:orcl","system","sa");
sql=con.createStatement();
rs=sql.executeQuery("select * from emp");
out.print("<Table Border>");
out.print("<TR>");
out.print("<TH width=100>"+"EMPNO");
out.print("<TH width=50>"+"Ename");
out.print("</TR>");
while(rs.next()){
out.print("<TR>");
int n=rs.getInt(1);
out.print("<TD>"+n+"</TD>");
String e=rs.getString(2);
out.print("<TD>"+e+"</TD>");
out.print("</TR>");
}
out.print("</table>");
con.close();}
catch(SQLException e1){out.print(""+e1);}
%> </body>
</html>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货