如图,在WEB-INF的lib目录下,有连接mysql数据库的驱动包,并没有oracle的驱动包,为什么我能用class.forName()加载oracle驱动连接到oracle数据库,如果说不要驱动包也能访问的话那这个mysql的驱动包又是干什么用的?
哪位前辈高人帮忙指点一下,感激不尽!下面是Condb.java的代码内容:
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 {
//加载数据库驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//连接数据库
Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","admin","As3014");
//执行SQL语句
String sql="select * from dept";
Statement st=conn.createStatement();
ResultSet rs=st.executeQuery(sql);
//处理执行结果
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();
}
}
程序员大阳