/*
 * Main.java
 *
 * Created on: 17-Mar-2010
 *
 */

package netukar.animalia.jdbc;

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

/**
 *
 * @author Radovan Netuka
 */
public class Main {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        try {
            Class.forName("org.apache.derby.jdbc.ClientDriver");

            String url = "jdbc:derby://db.animalia.com";
            String username = "admin";
            String password = "adminadmin";

            Connection connection = DriverManager.getConnection(url, username, password);
            Statement statement = connection.createStatement();
            statement.executeUpdate("CREATE TABLE Animals(" +
                    "id INTEGER, " +
                    "genus VARCHAR(30), " +
                    "species VARCHAR(30)");

            statement.executeUpdate("INSERT INTO Animals VALUES (1, 'Panthera', 'Tigris')");
            statement.executeUpdate("UPDATE TABLE Animals SET species = 'Leo' WHERE id = 1");
            statement.executeUpdate("DELETE FROM Animals WHERE genus = 'Panthera'");

            ResultSet result = statement.executeQuery(
                    "SELECT id, genus, species " +
                    "FROM Animals " +
                    "WHERE genus = 'Panthera'");

            while (result.next()) {
                System.out.println(result.getInt("id"));
                System.out.println(result.getString("genus"));
                System.out.println(result.getString("species"));
                System.out.println("---");
            }

            PreparedStatement statement2 = connection.prepareStatement(
                    "SELECT id, genus, species " +
                    "FROM Animals " +
                    "WHERE genus = ?");

            statement2.setString(0, "Panthera");
            result = statement2.executeQuery();

            while (result.next()) {
                System.out.println(result.getInt("id"));
                System.out.println(result.getString("genus"));
                System.out.println(result.getString("species"));
                System.out.println("---");
            }
        
        }
        catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        }
        catch (SQLException ex) {
            ex.printStackTrace();
        }

    }
    
}