常用连数据库的几种方法:
//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数据源的名字 |