!7

lib 1011900 // h2

static Connection conn;

import java.sql.*;

import java.lang.reflect.Array;

p {

  Class.forName("org.h2.Driver");

  conn = DriverManager.getConnection("jdbc:h2:tcp://localhost/~/test", "sa", "");

  print(symbolToID(print("hello"));

  print(symbolToID(print("world"));

  conn.close();

}

static int symbolToID(S symbol) ctex {

  PreparedStatement statement = conn.prepareStatement("select id from symbol where name=?");

  statement.setString(1, symbol);

  ResultSet rs = statement.executeQuery();

  try {

    if (rs.next())

      ret rs.getInt("id");

  } finally {

    rs.close();

  }

  statement = conn.prepareStatement("insert into symbol set name=?",

    statement.RETURN_GENERATED_KEYS);

  statement.setString(1, symbol);

  statement.executeUpdate();

  ResultSet generatedKeys = statement.getGeneratedKeys();

  try {

    assertTrue(generatedKeys.next());

    ret generatedKeys.getInt(1);

  } finally {

    generatedKeys.close();

  }

}