一、以下为连接SQL2000数据库:
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); conn = DriverManager.getConnection ("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=database","user","pwd");
二、以下为连接ORACLE数据库:
- Class.forName("oracle.jdbc.driver.OracleDriver");
- conn = DriverManager.getConnection
- ("jdbc:oracle:thin:@127.0.0.1:1521:SID","user","pwd");
三、以下为连接MYSQL数据库:
- Class.forName("org.gjt.mm.mysql.Driver");
- conn = DriverManager.getConnection
- ("jdbc:mysql://127.0.0.1/database:port","user","pwd");
四、以下为连接SYBASE数据库:
java 代码
- Class.forName("com.sybase.jdbc.SybDriver");
- conn = DriverManager.getConnection
- ("jdbc:sybase:Tds:127.0.0.1:4000/databasename","user","pwd");
五、以下为连接DB2数据库:
java 代码
- Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
- conn = DriverManager.getConnection
- ("jdbc:db2://127.0.0.1:8888/databasename","user","pwd");
六、以下为连接ACCESS数据库:
java 代码
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- //注意DBQ的写法 (不要用相对路径)
- String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\myaccess.mdb";
- con = DriverManager.getConnection(url, "", "");
附件中有各种驱动