常用数据库连接测试程序

Oracle:

  Class.forName("oracle.jdbc.driver.OracleDriver");
  Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","zhaozy");
  System.out.println(conn);

 

Mysql:

  Class.forName("com.mysql.jdbc.Driver");
  Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/drp?user=root&password=zhaozy");
  System.out.println(conn);

 

Sybase(ASE):

   Class.forName("com.sybase.jdbc3.jdbc.SybDriver");
   Connection conn=DriverManager.getConnection("jdbc:sybase:Tds:10.32.17.154:5000/master","sa","");
   System.out.println(conn);