package com.terac.util; import java.sql.Connection; 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(); } } } |
|
来自: 超越郑越超 > 《sqlserver》