1 5 package org.h2.test.cases; 6 7 import java.sql.Connection ; 8 import java.sql.DriverManager ; 9 import java.sql.PreparedStatement ; 10 import java.sql.ResultSet ; 11 12 17 public class TestConnect { 18 public static void main(String [] args) throws Exception { 19 Class.forName("org.h2.Driver"); 20 String url = "jdbc:h2:test"; 21 Connection conn = DriverManager.getConnection(url, "sa", "sa"); 22 PreparedStatement prep = conn.prepareStatement("SELECT CURRENT_TIMESTAMP()"); 23 ResultSet 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 |