导入的jar包：ojdbc14.jar
注：如果没有导入ojdbc.jar在运行后会报：java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
代码如下：
package com.test.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBConnection {
private static final String DRIVER="oracle.jdbc.driver.OracleDriver";
private static final String URL="jdbc:oracle:thin:@127.0.0.1:1521:testdb";
private String name="username";//访问数据库的用户名
private String pwd="password";//访问数据库的密码
Connection conn=null;
public DBConnection(){
try {
Class.forName(DRIVER);
conn = DriverManager.getConnection(URL,name,pwd);
System.out.println("连接成功!");
} catch (Exception e) {
e.printStackTrace();
}
}
public Connection getConn(){
return conn;
}
public void closeConn(){
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public static void main(String[] args) {
new DBConnection();
}
}
