JDBC链接MySQL和Oracle

  • import java.sql.*;
        JDBC中所要用的包几乎都在import?java.sql.*;中;
  • 在项目中导入Oracel或者是MySQL包和装载驱动:
    项目的ClassPath和系统的ClassPath建议放在ClassPath,如果放在系统的ClassPath中如果版本不同,可能干扰系统中的不同的项目,放在项目下,降低项目之间的耦合性;
装载Oracle驱动:
Class.forName("oracle.jdbc.driver.OracleDriver");

装载MySQL驱动:

Class.forName("com.mysql.jdbc.Driver");

  • 建立连接:
    1.1、建立Oracle连接:
Connection conn = DriverManager.getConnection("jdbc:mysql://host:port/datebase","user","password");

    2.1、建立MySQL连接:
Connection conn = DriverManager.getConnection("jdbc:mysql://host:port/datebase","user","password");
JDBC链接MySQL和Oracle
import java.sql.*;
public class TestJDBC {
public static void main(String[] args) throws Exception { //Class.forName("com.mysql.jdbc.Driver"); long start = System.currentTimeMillis(); new com.mysql.jdbc.Driver(); //Connection conn = DriverManager.getConnection("jdbc:mysql://host:port/datebase","user","password");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/martin","root","admin");
//Connection conn = DriverManager.getConnection("jdbc:oracle:thin@host:port:datebase","user","password"); //System.out.println(conn); System.out.println(conn);
long end = System.currentTimeMillis();
System.out.println("建立连接耗时: "+(end - start));
}
}
JDBC链接MySQL和Oracle
上一篇:loj 1429(可相交的最小路径覆盖)


下一篇:洛谷P1087 FBI树