1 5 package org.h2.test.cases; 6 import java.sql.*; 7 8 public class TestCompatibiliyMySQL { 9 10 public static void main(String [] args) throws Exception { 11 testWith("org.postgresql.Driver", "jdbc:postgresql:jpox2", "sa", "sa"); 12 testWith("com.mysql.jdbc.Driver", "jdbc:mysql://localhost/test", "sa", "sa"); 13 testWith("org.hsqldb.jdbcDriver", "jdbc:hsqldb:test", "sa", ""); 14 testWith("org.h2.Driver", "jdbc:h2:test", "sa", "sa"); 15 } 16 static void testWith(String driver, String url, String user, String password) 17 throws Exception { 18 Class.forName(driver); 19 System.out.println("URL: " + url); 20 Connection connection = DriverManager.getConnection(url, user, password); 21 Statement statement = connection.createStatement(); 24 try { 25 statement.execute("DROP TABLE PEOPLE"); 26 } catch(SQLException e) {} 27 statement.execute("CREATE TABLE PEOPLE (ID BIGINT, NAME VARCHAR(32))"); 28 statement.execute("INSERT INTO PEOPLE (ID, NAME) VALUES (1, 'Adam')"); 29 ResultSet rs = statement.executeQuery("SELECT PEOPLE.NAME FROM PEOPLE"); 30 rs.next(); 31 assertEquals("Adam", rs.getString(1)); 32 assertEquals("Adam", rs.getString("NAME")); 33 rs = statement.executeQuery("SELECT PEOPLE.NAME FROM PEOPLE"); 34 rs.next(); 35 statement.executeQuery("SELECT PEOPLE.NAME FROM PEOPLE"); 37 statement.executeQuery("SELECT PEOPLE.NAME FROM PEOPLE;"); 38 statement.executeQuery("SELECT PEOPLE.NAME FROM PEOPLE /* comment */"); 39 connection.createStatement().executeQuery("SELECT PEOPLE.NAME FROM PEOPLE /* comment */ ;"); 46 } 47 48 private static void assertEquals(String a, String b) { 49 if(!a.equals(b)) { 50 throw new Error ("a=" + a + " b="+b); 51 } 52 } 53 } 54 | Popular Tags |