package base.Test;
import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;
public class TestDBConnect {
public static Connection con; public static TestDBConnect getConnection() throws SQLException{ try{ Class.forName("oracle.jdbc.driver.OracleDriver");//加载驱动类 String url="jdbc:oracle:thin:@127.0.0.1:1521:test";//数据库为test IP:为本地的即可； String user="test";//用户名test String password="******";//登录密码 DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
con=DriverManager.getConnection(url,user,password); System.out.println("connect success!");
}catch(Exception e){ e.printStackTrace(); }finally{ con.close(); } return null; } public static void main(String[] args) throws SQLException { System.out.println("如果能够连上Oracle那么能够输出就是正常:"+TestDBConnect.getConnection()); } }
/------------------------/
要加入相应数据库的驱动包如：ojdbc14.jar orai18n.jar
