您的位置:首页 >> 数据库 >> 数据库其它 >> 正文
数据库其它 RSS
 

JDBC连接DB2OracleMySQLPostgreSQL

http://www.rdxx.com 08年01月09日 09:16 赛迪网 30961 我要投稿

关键词: PostgreSQL , Oracle , MySQL , JDBC , 连接 , DB2 , SQL , JDB , POST

JDBC连接DB2、Oracle、MySQL、PostgreSQL,并取得当前时间得实用代码:

package   com.terac.util;   
    
  import   java.sql.Connection;   
  import   java.sql.DriverManager;   
  import   java.sql.ResultSet;   
  import   java.sql.Statement;   
    
  public   class   DBTest   {   
  public   static   void   main(String[]   args)   {   
  try   {   
  String   user   =   "user";   
  String   password   =   "password";   
  String   driver   =   "COM.ibm.db2.jdbc.net.DB2Driver";   
  //"oracle.jdbc.driver.OracleDriver";   
  //"com.mysql.jdbc.Driver";   
  //"org.postgresql.Driver";   
  String   url   =   "jdbc:db2://localhost/a";   
  //"jdbc:oracle:thin:@localhost:1521:a";   
  //"jdbc:mysql://localhost/a";   
  //"jdbc:postgresql://localhost:5740/a";   
  String   sql   =   "SELECT   current   timestamp   FROM   sysibm.sysdummy1";   
  //"SELECT   sysdate   FROM   dual";   
  //"SELECT   now()";   
  //"SELECT   current_timestamp";   
  Class.forName(driver).newInstance();   
  Connection   c   =   DriverManager.getConnection(url,   user,   password);   
  Statement   stmt   =   c.createStatement();   
  ResultSet   rs   =   stmt.executeQuery(sql);   
  while   (rs.next())   {   
  System.out.println(rs.getString(1));   
  }   
  }   catch   (Exception   e)   {   
  e.printStackTrace();   
  }   
  }   
  }


 
 
标签: PostgreSQL , Oracle , MySQL , JDBC , 连接 , DB2 , SQL , JDB , POST 打印本文
 
 
  热点搜索
 
 
 



Valid XHTML 1.0 Transitional
Copyright ©2005 - 2008 Rdxx.Com,All Rights Reserved
收藏本页
收藏本站