如圖,在WEB-INF的lib目錄下,有連接mysql數(shù)據(jù)庫(kù)的驅(qū)動(dòng)包,并沒(méi)有oracle的驅(qū)動(dòng)包,為什么我能用class.forName()加載oracle驅(qū)動(dòng)連接到oracle數(shù)據(jù)庫(kù),如果說(shuō)不要驅(qū)動(dòng)包也能訪問(wèn)的話(huà)那這個(gè)mysql的驅(qū)動(dòng)包又是干什么用的?哪位前輩高人幫忙指點(diǎn)一下,感激不盡!下面是Condb.java的代碼內(nèi)容:package cn;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class Condb { public void getLs(){ try { //加載數(shù)據(jù)庫(kù)驅(qū)動(dòng) Class.forName("oracle.jdbc.driver.OracleDriver"); //連接數(shù)據(jù)庫(kù) Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","admin","As3014"); //執(zhí)行SQL語(yǔ)句 String sql="select * from dept"; Statement st=conn.createStatement(); ResultSet rs=st.executeQuery(sql); //處理執(zhí)行結(jié)果 while (rs.next()) { int a=rs.getInt("deptno"); System.out.println(a); } //釋放資源 } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static void main(String[] args) { new Condb().getLs(); }}
1 回答
已采納

程序員大陽(yáng)
TA貢獻(xiàn)43條經(jīng)驗(yàn) 獲得超24個(gè)贊
可能項(xiàng)目的lib庫(kù)或者tomcat lib庫(kù)里面已有oracle驅(qū)動(dòng)
添加回答
舉報(bào)
0/150
提交
取消