java 连接各种数据库源代码

1、1、Oracle8/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; 2

2、、Sql 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

3、(url,user,password; 3、DB2数据库 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; 4、Syba

4、se数据库 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"

5、Connection conn= DriverManager.getConnection(url, SysProps; 5、Informix数据库 Class.forName("rmix.jdbc.IfxDriver".newInstance(; String url = "jdbc:informix-sqli:/9:1533/myDB:INFORMIXSERVER=myserver; user=testuser;password=testpassword" /myDB为数据库名 Connection conn= D

6、riverManager.getConnection(url; 6、MySQL数据库 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;

7、7、PostgreSQL数据库 Class.forName("org.postgresql.Driver".newInstance(; String url ="jdbc:postgresql:/localhost/myDB" /myDB为数据库名 String user="myuser" String password="mypassword" Connection conn= DriverManager.getConnection(url,user,password; 8、JDBC-ODBC桥 Class.fo

8、rName("sun.jdbc.odbc.JdbcOdbcDriver" Connection con=DriverManager.getConnection("jdbc:odbc:jsp" jsp为建立的odbc数据源名，事先要先将SQL server的表设置为数据源。在“管理工具”-“数据源odbc”里用系统DNS添加。 8.Oracle8/8i/9i数据库（thin模式） /import java.sql.*; Class.forName("oracle.jdbc.driver.OracleDriver".newInstance

9、(; String url="jdbc:oracle:thin:localhost:1521:orcl" /orcl为数据库的SID String user="test" String password="test" Connection conn= DriverManager.getConnection(url,user,password; Statement stmtNew=conn.createStatement(; 9.DB2数据库 /import java.sql.*; Class.forName("com.ibm

10、.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; Statement stmtNew=conn.createStatement(; 10.Sql Server7.0/200

11、0数据库 /import java.sql.*; Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver".newInstance(; /String url="jdbc:microsoft:sqlserver:/localhost:1433;DatabaseName=db2" /7.0、2000 String url="jdbc:sqlserver:/localhost:1433;DatabaseName=db2" /2005 /db2为数据库名 String user

12、="sa" String password="" Connection conn= DriverManager.getConnection(url,user,password; Statement stmtNew=conn.createStatement(; 11.Sybase数据库 /import java.sql.*; Class.forName("com.sybase.jdbc.SybDriver".newInstance(; String url =" jdbc:sybase:Tds:localhost:5007/m

13、yDB"/myDB为你的数据库名 Properties sysProps = System.getProperties(; SysProps.put("user","userid" SysProps.put("password","user_password" Connection conn= DriverManager.getConnection(url, SysProps; Statement stmtNew=conn.createStatement(; 12.Informix数据库 /import

14、java.sql.*; 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; Statement stmtNew=conn.createS

15、tatement(; 13.MySQL数据库 /import java.sql.*; /Class.forName("org.gjt.mm.mysql.Driver".newInstance(; Class.forName("com.mysql.jdbc.Driver" /String url ="jdbc:mysql:/localhost/myDB?user=soft&password=soft1234&useUnicode=true&characterEncoding=8859_1" String url

16、="jdbc:mysql:/localhost:3306/myDB" /myDB为数据库名 Connection conn= DriverManager.getConnection(url,"root","root" Statement stmtNew=conn.createStatement(; 14.PostgreSQL数据库 /import java.sql.*; Class.forName("org.postgresql.Driver".newInstance(; String url ="jdb

17、c:postgresql:/localhost/myDB" /myDB为数据库名 String user="myuser" String password="mypassword" Connection conn= DriverManager.getConnection(url,user,password; Statement stmtNew=conn.createStatement(; 15.access数据库直连用ODBC的 /import java.sql.*; Class.forName("sun.jdbc.odbc.Jdbc

18、OdbcDriver" ; String url="jdbc:odbc:Driver=MicroSoft Access Driver (*.mdb;DBQ="+application.getRealPath("/Data/ReportDemo.mdb" Connection conn = DriverManager.getConnection(url,"sa","" Statement stmtNew=conn.createStatement(; 16.程序计时 long time1=System.currentTimeMillis(; long time2=System.currentTimeMillis(; long interval=time2-time1; 17.延时 try Thread.sleep(Integer.Parse(%1; catch(InterruptedException e e.printStackTrace(; 18.连接Excel文件 /import java.sql.*; Class.forName("sun.jdbc.o