// DisplayTransactions Example
// Source code file DisplayTransactions.java
// Display data from transactions table
// given the id.
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;
public class DisplayTransactions {
    public static void main(String[] args) {
        // Declare local variables.
        Connection c = null;
        Statement s = null;
        ResultSet rs = null;
        int id = 0;
        double amount = 0.0;
        String sql = null, buyer = null, seller = null,
        timestamp = null;
        Scanner fromKeyboard = new Scanner(System.in);
        try {
            // Define Connection and Statement objects.
            Class.forName("org.sqlite.JDBC");
            c = DriverManager.getConnection(
               "jdbc:sqlite:transactions.db");
            s = c.createStatement();

            while (id != -1) {
                // Read id and display corresponding table row.
                System.out.print("Enter desired id: ");
                id = fromKeyboard.nextInt( );
                sql = "select buyer, seller, amount, timestamp " +
                      "from transactions " +
                      "where id = " + id + ";";
                System.out.println(sql);
                rs = s.executeQuery(sql);
                while (rs.next( )) {
                    buyer = rs.getString("buyer");
                    seller = rs.getString("seller");
                    amount = rs.getFloat("amount");
                    timestamp = rs.getString("timestamp");
                    System.out.println("Buyer: " + buyer);
                    System.out.println("Seller: " + seller);
                    System.out.printf("Amount: $%.2f\n", amount);
                    System.out.println("Timestamp: " + timestamp);
                }
            }
        }
        catch(SQLException e) {
            System.out.println("SQLException.");
            System.err.println( e.getClass().getName() +
                    ": " + e.getMessage() );
        }
        catch (ClassNotFoundException e ) {
            System.err.println( e.getClass().getName() +
                    ": " + e.getMessage() );
        }
        finally {
            fromKeyboard.close( );
        }
    }
}