Práticas de Informática

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Savepoint;
import java.sql.Statement;

public class Main {

    public static void main(String[] args) {
        Connection conn = null;
        Statement stat = null;
        Savepoint savepoint = null;
        try {
            Class.forName("org.hsqldb.jdbcDriver" );
        } catch (Exception e) {
            System.out.println("ERROR: failed to load HSQLDB JDBC driver.");
            e.printStackTrace();
            return;
        }
        try {
            conn = (Connection) DriverManager.getConnection("jdbc:hsqldb:file:testedb", "sa", "");           
        } catch (SQLException e1) {       
            e1.printStackTrace();
        }   
       
        try {
            stat = conn.createStatement();
            //stat.execute("CREATE TABLE pessoas1 (id int, nome varchar(20))");
            //stat.executeUpdate("INSERT INTO pessoas1 VALUES(1, 'neto')");
            //stat.executeUpdate("INSERT INTO pessoas1 VALUES(2, 'mariana')");
            //stat.executeUpdate("INSERT INTO pessoas1 VALUES(3, 'mairom')");           
            ResultSet resultset = stat.executeQuery("SELECT * FROM pessoas1");           
            while(resultset.next()) {
                System.out.println(resultset.getRow());
                System.out.println(resultset.getInt("id"));
                System.out.println(resultset.getString("nome"));
            }       
            //stat.execute("CHECKPOINT");
            stat.close();
            conn.close();
        } catch (SQLException e2) {    }
    }
}