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中的都是需要添加的驱动包。
1 Java 连接 Oralce
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@localhost:1521:orcl";
Connection conn= DriverManager.getConnection(url,user,password);
2 Java 连接 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);
3 Java 连接SQLServer
连接mssql 2005 +
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);
4 Java 连接DB2
Class.forName(“com.ibm.db2.jdbc.app.DB2Driver").newInstance();
String URL =”jdbc:db2://localhost:5000/db";
Connection conn= DriverManager.getConnection(url,user,password);
5 Java 连接 Infomix
Class.forName("com.informix.jdbc.IfxDriver").newInstance();
String URL ="jdbc:informix-sqli://123.45.67.89:1533/db:INFORMIXSERVER=myserver";
Connection conn= DriverManager.getConnection(url,user,password);
6 Java 连接 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);
7 Java连接 PostgreSQL
Class.forName("org.postgresql.Driver").newInstance();
String url ="jdbc:postgresql://localhost/db";
Connection conn= DriverManager.getConnection(url,user,password);
8 access数据库使用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() ;