Java JDBC连接MySQL、Oracle、SQLServer数据库
JDBC链接MySQL
@Test public void mySqlTest() { String driverName = "com.mysql.jdbc.Driver"; String dbUrl = "jdbc:mysql://localhost:3306/dbName"; String username = "root"; String password = "root"; Connection con = null; try { Class.forName(driverName); } catch (ClassNotFoundException e) { e.printStackTrace(); } try { con = DriverManager.getConnection(dbUrl, username, password); } catch (SQLException e) { e.printStackTrace(); } System.out.println(con.toString()); }
JDBC链接Oracle
@Test public void oracleTest() { String driverName = "oracle.jdbc.driver.OracleDriver"; String dbUrl = "jdbc:oracle:thin:@127.0.0.1:1521:服务名"; String username = "root"; String password = "root"; Connection con = null; try { Class.forName(driverName); } catch (ClassNotFoundException e) { e.printStackTrace(); } try { con = DriverManager.getConnection(dbUrl, username, password); } catch (SQLException e) { e.printStackTrace(); } System.out.println(con.toString()); }
JDBC链接SQLServer
@Test public void sqlServerTest() { String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; String dbUrl = "jdbc:sqlserver://localhost:1433;databaseName=master;"; String username = "root"; String password = "root"; Connection con = null; try { Class.forName(driverName); } catch (ClassNotFoundException e) { e.printStackTrace(); } try { con = DriverManager.getConnection(dbUrl, username, password); } catch (SQLException e) { e.printStackTrace(); } System.out.println(con.toString()); }
记得下载数据库驱动jar,SQLServer和Oracle jar包maven私服是没有的,自己去网上找。