JDBC驱动大全

来源：互联网发布：淘宝买身份证暗语编辑：程序博客网时间：2024/06/02 00:06

==================================================================================

Microsoft SQL Server for ODBC

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection conn = DriverManager.getConnection("jdbc:odbc:databse","user","password");

==================================================================================

Microsoft SQL Server 2000

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://host:1433;databaseName=databse","user","password");

==================================================================================

Microsoft SQL Server 2005

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

Connection conn = DriverManager.getConnection("jdbc:sqlserver://host:1433;databaseName=databse", "user", "password");

==================================================================================

Microsoft SQL Server for JTDS

Class.forName("net.sourceforge.jtds.jdbc.Driver");

Connection con = DriverManager.getConnection("jdbc:jtds:sqlserver://host:1433/database","user","password");

==================================================================================

Oracle

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@host:1521:databse","user","password");

==================================================================================

MySQL

Class.forName("com.mysql.jdbc.Driver");

Connection conn = DriverManager.getConnection("jdbc:mysql://host:3306/database","user","password");

==================================================================================

HSQL

Class.forName("org.hsqldb.jdbcDriver");

Connection conn = DriverManager.getConnection("jdbc:hsqldb:hsql://host:port/database","user","password");

==================================================================================

备注:(host:主机名/IP地址,本机为127.0.0.1;port:端口号;database:数据库名!)

==================================================================================