java中jdbc连接Oracle，Sql Server2000，MySql数据库的方法

1.Java使用thin方式连接Oracle数据库的代码：


public Connection getDBConnection() throws Exception {
    Connection conn=null;
    String url="jdbc:oracle:@thin://192.168.1.10:1521:orcl";
    String username="sysdba";
    String password="root";
    try{
          Class.forName("com.oracle.driver.OracleDriver");
          conn=DriverManager.getConnection(ur,username,password);
       }
   catch(ClassNotFoundException classNotFound){
         throw classNotFound
       }
   catch(SQLException sqlExc){
        throw sqlExc; 
     }
    return conn;
}


2.Java连接Sql Server2000数据库的代码：


public Connection getDBConnection() throws Exception{
   Connection conn=null;
   String url="jdbc:microsoft:sqlserver://192.168.1.10:1433;DatabaseName=tdb";
   String username="sa";
   String password="12345678"
  try{
      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
      conn=DriverManager.getConnection(url,username,password);
      }
   catch(ClassNotFoundException classNotFound){
         throw classNotFound;
      }
   catch(SQLException sqlException){
       throw sqlException;
     }
   return conn;
}


3.Java连接MySql数据库的代码：


public Connection getDBConnection() throws ClassNotFoundException,SQLException{
   Connection conn=null;
   String url="jdbc:mysql://localhost:3306/tdb";
   String username="test";
   String password="123456";
   Class.forName("com.mysql.jdbc.Driver");
   conn=DriverManager.getConnection(url,username,password);
   return conn;
}