/*
 * Copyright (C) 2006 Markus KARG (markus-karg@users.sourceforge.net)
 */

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public final class Foo {

    public static final void main(final String[] args) throws Exception {
        Class.forName("com.sap.dbtech.jdbc.DriverSapDB");
        final Connection c = DriverManager.getConnection("jdbc:sapdb://localhost/SCRUM", "DBA", "SQL");
        c.setAutoCommit(false);
        
        c.createStatement().execute("CREATE TABLE A (X INTEGER, PRIMARY KEY (X))");
        c.createStatement().execute("INSERT INTO A (X) VALUES (1)");
        select("SELECT X FROM A", c);
        c.createStatement().execute("CREATE TABLE TEMP.B LIKE A");
        c.createStatement().execute("INSERT INTO TEMP.B (X) SELECT X FROM A");
        select("SELECT X FROM TEMP.B", c);
        c.createStatement().execute("DELETE FROM A WHERE EXISTS(SELECT X FROM TEMP.B WHERE TEMP.B.X - A.X = 0)");
        select("SELECT X FROM A", c);
        c.createStatement().execute("DROP TABLE A");
        c.commit();
    }
    
    private static final void select(final String sql, final Connection c) throws SQLException {
        System.out.print(sql + ": ");
        final ResultSet r = c.createStatement().executeQuery(sql);
        while (r.next()) {
            for (int i = 1, j = r.getMetaData().getColumnCount() + 1; i < j; i++)
                System.out.print(r.getString(i) + "\t");
            System.out.println();
        }
    }

}