jdbc连接字符串.docVIP

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:sql