java连接几种数据库的代码

//JDBC_ORACLE

    private final String driver = "oracle.jdbc.driver.OracleDriver";
    private final String url = "jdbc:oracle:thin:@localhost:1521:SIDTB";
    private final String username = "scott";
    private final String passwrod = "tiger";

 

    //JDBC_SQL

    private String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
    private String url = "jdbc:microsoft:sqlserver://localhost:1433;databasename=pubs";
    private String username = "sa";
    private String password = "sa";

    
    //ODBC_ORACLE

    private final String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
    private final String url = "jdbc:odbc:oracle";
    private final String username = "scott";
    private final String password = "tiger";

 

    //ODBC_SQL

    private final String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
    private final String url = "jdbc:odbc:trukey";
    private final String username = "sa";
    private final String password = "sa";

    
    //Access //此为NO-DSN方式

    private String driver = "sun.jdbc.odbc.JdbcOdbcDriver"; 
    private final String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=Mobile.mdb";

 

    //Access //此为ODBC连接方式

    private String driver = "sun.jdbc.odbc.JdbcOdbcDriver"; 
    private final String url = "jdbc:odbc:odbcName"; //odbcName数据源的名字