如圖,在WEB-INF的lib目錄下,有連接mysql數(shù)據(jù)庫的驅(qū)動(dòng)包,并沒有oracle的驅(qū)動(dòng)包,為什么我能用class.forName()加載oracle驅(qū)動(dòng)連接到oracle數(shù)據(jù)庫,如果說不要驅(qū)動(dòng)包也能訪問的話那這個(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ù)庫驅(qū)動(dòng) Class.forName("oracle.jdbc.driver.OracleDriver"); //連接數(shù)據(jù)庫 Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","admin","As3014"); //執(zhí)行SQL語句 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(); }}
添加回答
舉報(bào)
0/150
提交
取消