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 import java.sql.Types ; 12 13 public class TestOther { 14 public static void main(String [] args) { 15 Object [] tos = { 16 new String [] {"hello", "world"}, }; 21 22 try { 23 Class.forName("org.h2.Driver"); 24 Connection con = DriverManager.getConnection("jdbc:h2:mem:", "sa", ""); 25 con.setAutoCommit(true); 26 27 con.createStatement().executeUpdate("CREATE TABLE TestOtherJDBC (tstData OTHER)"); 28 System.out.println("table created"); 29 30 PreparedStatement stmt = con.prepareStatement("INSERT INTO TestOtherJDBC (tstData) VALUES (?)"); 31 32 for (int i = 0; i < tos.length; i++) { 33 System.out.println(tos[i].getClass().getName() + "\t" + tos[i]); 34 stmt.setObject(1, tos[i], Types.OTHER); 35 stmt.executeUpdate(); 36 } 37 System.out.println("inserted"); 38 39 ResultSet rs = con.createStatement().executeQuery("SELECT tstData FROM TestOtherJDBC"); 40 41 while(rs.next()) { 42 Object obj = rs.getObject(1); 43 System.out.println(obj.getClass().getName() + "\t" + obj); 44 } 45 rs.close(); 46 } catch (Throwable e) { 47 e.printStackTrace(); 48 } 49 50 } 51 } 52 | Popular Tags |