KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > h2 > test > cases > TestDate


1 /*
2  * Copyright 2004-2006 H2 Group. Licensed under the H2 License, Version 1.0 (http://h2database.com/html/license.html).
3  * Initial Developer: H2 Group
4  */

5 package org.h2.test.cases;
6
7 import java.sql.*;
8 public class TestDate {
9     public static void main(String JavaDoc[] args) throws Exception JavaDoc {
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 JavaDoc driver, String JavaDoc url, String JavaDoc user, String JavaDoc password)
16             throws Exception JavaDoc {
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 JavaDoc(System.currentTimeMillis()));
28         prep.execute();
29         prep.setDate(1, new java.sql.Date JavaDoc(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