java- JDBC连接各种数据库小结

JDBC连接--Mysql

 private static final String driver = "com.mysql.jdbc.Driver";
 private static final String dbURL = "jdbc:mysql://localhost:3306/studb";
 private static final String user = "root";
 private static final String password = "123456";

JDBC连接--Orcal

 private static final String driver = "oracle.jdbc.driver.OracleDriver";
 private static final String dbURL = "jdbc:oracle:thin:@localhost:1521:ORCL";
 private static final String user = "newuser";
 private static final String password = "newuser";

JDBC连接--Access

 private static final String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
 private static final String dbURL="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=access数据库文件位置";

JDBC连接--Sqlserver
 private static final String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
 private static final String dbURL = "jdbc:microsoft:sqlserver://localhost:1433;databaseName";
 private static final String user = "newuser";
 private static final String password = "newuser";