1 5 package org.h2.test.cases; 6 7 import java.sql.*; 8 public class TestDate { 9 public static void main(String [] args) throws Exception { 10 testWith("org.postgresql.Driver", "jdbc:postgresql:jpox2", "sa", "sa"); 11 testWith("com.mysql.jdbc.Driver", "jdbc:mysql://localhost/test", "sa", "sa"); 12 testWith("org.h2.Driver", "jdbc:h2:test", "sa", "sa"); 13 testWith("org.hsqldb.jdbcDriver", "jdbc:hsqldb:test", "sa", ""); 14 } 15 static void testWith(String driver, String url, String user, String password) 16 throws Exception { 17 Class.forName(driver); 18 System.out.println("URL: " + url); 19 Connection conn = DriverManager.getConnection(url, user, password); 20 Statement stat = conn.createStatement(); 21 try { 22 stat.execute("DROP TABLE ts_trial"); 23 } catch (SQLException e) { } 24 stat.execute("CREATE TABLE ts_trial(myts TIMESTAMP)"); 25 PreparedStatement prep = conn.prepareStatement( 26 "INSERT INTO ts_trial(myts) VALUES (?)"); 27 prep.setTimestamp(1, new java.sql.Timestamp (System.currentTimeMillis())); 28 prep.execute(); 29 prep.setDate(1, new java.sql.Date (System.currentTimeMillis())); 30 prep.execute(); 31 ResultSet rs = stat.executeQuery("SELECT myts FROM ts_trial"); 32 rs.next(); 33 System.out.println("Timestamp: " + rs.getTimestamp("myts")); 34 rs.next(); 35 System.out.println("Date: " + rs.getTimestamp("myts")); 36 System.out.println(); 37 } 38 } 39 | Popular Tags |