Connect various database code __ database

JDBC Connection URL 1, oracle8/8i/9i database (thin mode) Class.forName ("Oracle.jdbc.driver.OracleDriver"). newinstance (); String url= "Jdbc:oracle:thin: @localhost: 1521:ORCL"; ORCL is the SID of the database String user= "Test"; String password= "Test"; Connection conn= drivermanager.getconnection (Url,user,password); 2. DB2 Database Class.forName ("Com.ibm.db2.jdbc.app.DB2Driver"). newinstance (); String url= "Jdbc:db2://localhost:5000/sample"; Sample for your database name String user= "admin"; String password= ""; Connection conn= drivermanager.getconnection (Url,user,password); 3. SQL server7.0/2000 Database Class.forName ("Com.microsoft.jdbc.sqlserver.SQLServerDriver"). newinstance (); String url= "Jdbc:microsoft:sqlserver://localhost:1433;databasename=mydb"; MyDB as a database String user= "SA"; String password= ""; Connection conn= drivermanager.getconnection (Url,user,password); 4. Sybase database Class.forName ("Com.sybase.jdbc.SybDriver"). newinstance (); String url = "Jdbc:sybase:tds:localhost:5007/mydb"; MyDB for your database name Properties sysprops = System.getproperties (); Sysprops.put ("User", "userid"); Sysprops.put ("Password", "User_password"); Connection conn= drivermanager.getconnection (URL, sysprops); 5. Informix Database 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 for Database name Connection conn= drivermanager.getconnection (URL); 6. mysql Database Class.forName ("Org.gjt.mm.mysql.Driver"). newinstance (); String url = "Jdbc:mysql://localhost/mydb?user=soft&password=soft1234&useunicod E=true&characterencoding=8859_1 " MyDB for Database name Connection conn= drivermanager.getconnection (URL); 7. PostgreSQL Database Class.forName ("Org.postgresql.Driver"). newinstance (); String url = "Jdbc:postgresql://localhost/mydb" MyDB for Database name String user= "MyUser"; String password= "MyPassword"; Connection conn= drivermanager.getconnection (url,user JDBC Configuration: 1. Old JDBC (2000): Driverclass is "Com.microsoft.jdbc.sqlserver.SQLServerDriver"; Jdbcurl is "jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=test;characterencoding=gb2312". 2. New jdbc:     driverclass is "com.microsoft.sqlserver.jdbc.SQLServerDriver";     Jdbcurl is "jdbc:sqlserver://127.0.0.1:1433;database=test;characterencoding=gb2312"