JAVA连接各种数据库的代码大全

Java数据库连接大全

注：newInstance()可要可不要。

通用JDBC-ODBC直连方式（无需额外的驱动包）：

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

Connection conn=DriverManager.getConnection("jdbc:odbc:Driver={SQL Server};Server=localhost;uid=sa;pwd=1111;Database=db");

以下方式中Class.forName中的都是需要添加的驱动包。

1Java连接Oralce

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

String url="jdbc:oracle:thin:@localhost:1521:orcl";

Connection conn=DriverManager.getConnection(url,user,password);

2Java连接MySQL

Class.forName("org.gjt.mm.mysql.Driver").newInstance();

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

String URL="jdbc:mysql://localhost/test";

Connection conn=DriverManager.getConnection(url,user,password);

3Java连接SQLServer

连接mssql2000

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); String URL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db"; Connection conn=DriverManager.getConnection(url,user,password);

连接mssql2005+

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance(); String URL="jdbc:sqlserver://localhost:1433;DatabaseName=db";

Connection conn=DriverManager.getConnection(url,user,password);

通用方式：

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

String url="jdbc:jtds:sqlserver://localhost:1433;DatabaseName=db";

Connection conn=DriverManager.getConnection(url,user,password);

4Java连接DB2

Class.forName(“com.ibm.db2.jdbc.app.DB2Driver").newInstance();

String URL=”jdbc:db2://localhost:5000/db";

Connection conn=DriverManager.getConnection(url,user,password);

5Java连接Infomix

Class.forName("rmix.jdbc.IfxDriver").newInstance();

String URL＝"jdbc:informix-sqli://123.45.67.89:1533/db:INFORMIXSERVER=myserver"; Connection conn=DriverManager.getConnection(url,user,password);

6Java连接SyBase

Class.forName("com.sybase.jdbc.SybDriver").newInstance();

Properties sysProps=System.getProperties();

SysProps.put("user","userid");

SysProps.put("password","user_password");

Connection conn=DriverManager.getConnection(url,SysProps);

7Java连接PostgreSQL

Class.forName("org.postgresql.Driver").newInstance();

String url="jdbc:postgresql://localhost/db";

Connection conn=DriverManager.getConnection(url,user,password); 8access数据库使用ODBC直连

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

String url="jdbc:odbc:Driver={MicroSoft Access Driver(*.mdb)}; DBQ="+application.getRealPath("/Data/db.mdb");

Connection conn=DriverManager.getConnection(url,"",""); Statement stmtNew=conn.createStatement();