Cnfan.net中国网络
IT网络技术专家
数据库
 最新专题: 专题 | 分类 | 投稿 | 搜索
 数据库首页 | mysql | Oracle | Sybase | IBMDB2 | PostgreSQL | Informix

JDBC连接DB2、Oracle、MySQL、PostgreSQL

  • 2008-01-07 16:08:22  作者:  来源:赛迪网  浏览次数:0  文字大小:【】【】【
简介: JDBC连接DB2、Oracle、MySQL、PostgreSQL,并取得当前时间得实用代码: package com.terac.util; import java.sql.Connection; ...

关键字: JDBC 连接 DB2 Oracle MySQL PostgreSQL

 

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();   
  }   
  }   
  }

  <欢迎投稿>  <论坛讨论>
 »相关文章  »论坛新贴
精彩文章 活动资讯 今日头条