各种数据库连接综合（Various database connection synthesis）.docVIP

各种数据库连接综合（Various database connection synthesis） JDBC connect to the database of experience One way to connect a variety of database lookup tables (URL) Heres a list of the ways all databases use JDBC connections, which can be used as a manual. 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 is 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 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 is 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 is the 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=softpassword=soft1234useUnicode=truecharacterEncoding=8859_1? //myDB is the database name Connection conn= DriverManager.getConnection (URL); 7, P