KickJava   Java API By Example, From Geeks To Geeks.

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


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.Connection JavaDoc;
8 import java.sql.DriverManager JavaDoc;
9 import java.sql.PreparedStatement JavaDoc;
10 import java.sql.ResultSet JavaDoc;
11
12 /*
13 del *.db
14 java -Xrunhprof:cpu=samples org.h2.test.cases.TestConnect
15 java org.h2.test.cases.TestConnect
16  */

17 public class TestConnect {
18     public static void main(String JavaDoc[] args) throws Exception JavaDoc {
19         Class.forName("org.h2.Driver");
20         String JavaDoc url = "jdbc:h2:test";
21         Connection JavaDoc conn = DriverManager.getConnection(url, "sa", "sa");
22         PreparedStatement JavaDoc prep = conn.prepareStatement("SELECT CURRENT_TIMESTAMP()");
23         ResultSet JavaDoc rs = prep.executeQuery();
24         rs.next();
25         System.out.println(rs.getString(1));
26         Thread.sleep(50);
27         rs = prep.executeQuery();
28         rs.next();
29         System.out.println(rs.getString(1));
30         conn.close();
31     }
32     
33 }
34
Popular Tags