java 连接 oracle, db2, MySQL, sqlserver 等数据库的方式2008/09/21 16:581、Oracle8/8i/9i 数据库(thin 模式)Class.forName(oracle.jdbc.driver.OracleDriver).newInstance();String url=jdbc:oracle:thin:localhost:1521:orcl;/orcl为数据库的SIDString user=test”;String password=test”;Connection conn= DriverManager.getConnection(url,user,password);2、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);3、Sql Server7.0/2000 数据库Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver).newInst ance();Stringurl=jdbc:microsoft:sqlserver:/localhost:1433;DatabaseName=mydb;/mydb为数据库String user=sa;String password=;Connection conn= DriverManager.getConnection(url,user,password);4、Sybase数据库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);Connection conn= DriverManager.getConnection(url, SysProps);5、Informix 数据库Class.forName(com.informix.jdbc.IfxDriver).newInstance();String url =jdbc:informix-sqli:/123.45.67.89:1533/myDB:INFORMIXSERVER=myserver;user=testuser;password=testpassword;/myDB为数据库名Connection conn= DriverManager.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、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);