import java.sql.*;

public class FindTheBerries {
    public static void main(String[] args) {
        if (args.length != 4) {
            System.err.println("Skriv: java FindTheBerries MIN-LAT MAX-LAT MIN-LONG MAX-LONG");
            return;
        }
        try {
            Class.forName("com.mimer.jdbc.Driver");
            String url = "jdbc:mimer://dbtek0:gazonk@basen.oru.se/dbk";
            Connection con = DriverManager.getConnection(url);
            System.out.println("Blåbär:");
            // Det här ger goda möjligheter till SQL Injection!
            String query = "select latitud, longitud from Buskar"  
                + " where latitud >= " + args[0]
                + " and latitud <= " + args[1]
                + " and longitud >= " + args[2]
                + " and longitud <= " + args[3];
            Statement stmt = con.createStatement();
            ResultSet rs = stmt.executeQuery(query);
            int antal = 0;
            while (rs.next()) {
                System.out.println(++antal + ": " + rs.getDouble("latitud") + " " + rs.getDouble("longitud"));
            }
            rs.close();
            stmt.close();
            con.close();
        }
        catch (java.lang.ClassNotFoundException cnf) {
            System.err.println("Hittade inte JDBC-drivrutinen.");
        }
        catch (java.sql.SQLException e) {
            // Normalt skulle vi inte hantera alla fel i klump så här
            System.err.println("Något databasrelaterat fel uppstod: " + e.toString());
        }
    } // main
} // class FindTheBerries