jdbc连接字符串.doc

JDBC连接字符串大全(2009-06-13 07:54:07)转载标签：jdbc杂谈分类：Java各种数据库的JDBC连接大全 Microsoft SQL Server series (6.5, 7.x and 2000) and Sybase 10 JDBC Name: jTDS URL: / Version: 0.5.1 Download URL: /project/showfiles.php?group_id=33291 语法: Class.forName(net.sourceforge.jtds.jdbc.Driver ); Connection con = DriverManager.getConnection(jdbc:jtds:sqlserver:/host:port/database,user,password); or Connection con = DriverManager.getConnection(jdbc:jtds:sybase:/host:port/database,user,password); MySQL JDBC Name: Connector/J 3.0 URL: / Version: 3.0.8-stable Download URL: /downloads/api-jdbc-stable.html 语法: Download URL: /downloads/api-jdbc-stable.html 语法: Class.forName(com.mysql.jdbc.Driver); Connection con = DriverManager.getConnection(jdbc:mysql:/host:port/database,user,password); Oracle JDBC Name: Connector/J 3.0 URL: / Version: 3.0.8-stable Download URL: /software/tech/java/sqlj_jdbc/content.html 语法: Download URL: /software/tech/java/sqlj_jdbc/content.html 语法: Class.forName(oracle.jdbc.driver.OracleDriver); Connection con = DriverManager.getConnection(jdbc:oracle:thin:host:port:databse,user,password); Sybase Driver: jConnect 4.5/5.5 (JDBC 2.0 请使用5.5) 语法: Class.forName(com.sybase.jdbc2.jdbc.SybDriver).newInstance(); DriverManager.getConnection(jdbc:sybase:Tds:IP地址:2638?ServiceName=+数据库名称,账号,密码); Postgresql JDBC Name: PostgreSQL JDBC URL: / Version: 7.3.3 build 110 Download URL: /download.html 语法: Download URL: /download.html 语法: Class.forName(org.postgresql.Driver); Connection con=DriverManager.getConnection(jdbc:postgresql:/host:port/database,user,password); IBM AS400主机在用的JDBC语法 有装V4R4以上版本的Client Access Express 可以在C:Program FilesIBMClient Accessjt400lib 找到 driver 档案 jt400.zip，并更改扩展名成为 jt400.jar 语法语法: Class.forName(net.sourceforge.jtds.jdbc.Driver ); Connection con = DriverManager.getConnection(jdbc:jtds:sqlserver:/host:port/database,user,password); or Connection con = DriverManager.getConnection(jdbc:jtds:sybase:/host:port/database,user,password); MySQL JDBC Name: Connector/J 3.0 URL: / Version: 3.0.8-stable Download URL: /downloads/api-jdbc-stable.html 语法: Download URL: /downloads/api-jdbc-stable.html 语法: Class.forName(com.mysql.jdbc.Driver); Connection con = DriverManager.getConnection(jdbc:mysql:/host:port/database,user,password); Oracle JDBC Name: Connector/J 3.0 URL: / Version: 3.0.8-stable Download URL: /software/tech/java/sqlj_jdbc/content.html 语法: Download URL: /software/tech/java/sqlj_jdbc/content.html 语法: Class.forName(oracle.jdbc.driver.OracleDriver); Connection con = DriverManager.getConnection(jdbc:oracle:thin:host:port:databse,user,password); Sybase Driver: jConnect 4.5/5.5 (JDBC 2.0 请使用5.5) 语法: Class.forName(com.sybase.jdbc2.jdbc.SybDriver).newInstance(); DriverManager.getConnection(jdbc:sybase:Tds:IP地址:2638?ServiceName=+数据库名称,账号,密码); Postgresql JDBC Name: PostgreSQL JDBC URL: / Version: 7.3.3 build 110 Download URL: /download.html 语法: Download URL: /download.html 语法: Class.forName(org.postgresql.Driver); Connection con=DriverManager.getConnection(jdbc:postgresql:/host:port/database,user,password); IBM AS400主机在用的JDBC语法 有装V4R4以上版本的Client Access Express 可以在C:Program FilesIBMClient Accessjt400lib 找到 driver 档案 jt400.zip，并更改扩展名成为 jt400.jar 语法 java.sql.DriverManager.registerDriver (new com.ibm.as400.access.AS400JDBCDriver (); Class.forName(com.ibm.as400.access.AS400JDBCConnection); con = DriverManager.getConnection(jdbc:as400:/IP,user,passwor); 1Oracle8/8i/9i数据库（thin模式） Class.forName(oracle.jdbc.driver.OracleDriver).newInstance(); String url=jdbc:oracle:thin:localhost:1521:orcl; /orcl为数据库的SID String user=test; String password=test; Connection conn= DriverManager.getConnection(url,user,password); 2DB2数据库 Class.forName(com.ibm.db2.jdbc.app.DB2Driver ).newInstance(); String url=jdbc:db2:/localhost:5000/sample; /sample为你的数据库名 String user=admin; String password=; Connection conn= DriverManager.getConnection(url,user,password); 3Sql Server7.0/2000数据库 Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver).newInstance(); String url=jdbc:microsoft:sqlserver:/localhost:1433;DatabaseName=mydb; /mydb为数据库 String user=sa; String password=; Connection conn= DriverManager.getConnection(url,user,password); 4Sybase数据库 Class.forName(com.sybase.jdbc.SybDriver).newInstance(); String url = jdbc:sybase:Tds:localhost:5007/myDB;/myDB为你的数据库名 Properties sysProps = System.getProperties(); SysProps.put(user,userid); SysProps.put(password,user_password); Connection conn= DriverManager.getConnection(url, SysProps); 5Informix数据库 Class.forName(rmix.jdbc.IfxDriver).newInstance(); String url = jdbc:informix-sqli:/9:1533/myDB:INFORMIXSERVER=myserver; user=testuser;password=testpassword; /myDB为数据库名 Connection conn= DriverManager.getConnection(url); 6MySQL数据库 Class.forName(org.gjt.mm.mysql.Driver).newInstance(); String url =jdbc:mysql:/localhost/myDB?user=soft&password=soft1234&useUnicode=true&characterEncoding=8859_1 /myDB为数据库名 Connection conn= DriverManager.getConnection(url); 7PostgreSQL数据库 Class.forName(org.postgresql.Driver).newInstance(); String url =jdbc:postgresql:/localhost/myDB /myDB为数据库名 String user=myuser; String password=mypassword; Connection conn= DriverManager.getConnecti