掌握多数据库连接方法：Oracle, MS SQL Server & MySQL详解

//For Access Driver
         ClassString="sun.jdbc.odbc.JdbcOdbcDriver";
         ConnectionString=("jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=D:/jdk1/tomcat6.0/webapps/officer/data/work.mdb;ImplicitCommitSync=Yes;MaxBufferSize=512;MaxScanRows=128;PageTimeout=5;SafeTransactions=0;Threads=3;UserCommitSync=Yes;");


连接oracle数据库
    Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
    String url="jdbc:oracle:thin:@服务器ip:1521:数据库名称";
    Connection conn=DriverManager.getConnection(url,"用户名","密码");

二.连接mssql数据库
  //2000
     Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
     String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
  //2005
   Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
     String url="jdbc:sqlserver://localhost:1433;DatabaseName=oms";

六、jsp连接MySQL数据库 (com.mysql.jdbc.Driver)
       Class.forName("org.gjt.mm.mysql.Driver").newInstance();
      String url ="jdbc:mysql://localhost/softforum?
      user=soft&password=soft1234&useUnicode=true&characterEncoding=8859_1"
    //testDB为你的数据库名
     Connection conn= DriverManager.getConnection(url);        

   

三.连接DB2数据库
     Class.forName("com.ibm.db2.jdbc.app.DB2Driver ").newInstance();
     String url="jdbc:db2://localhost:5000/数据库名称";