import java.sql.*;
import java.lang.*;
import java.io.*;

class  Ex_8_5_1_a {

    static String promptUser(String prompt) throws Exception 
    {
	BufferedReader kbd = new BufferedReader(
				 new InputStreamReader(System.in));
	System.out.println(prompt);
	return kbd.readLine();
    }

    public static void main(String[] argv) throws Exception
    {
	Class.forName("com.mysql.jdbc.Driver").newInstance();
	Connection conn = DriverManager.getConnection(
                   "jdbc:mysql://amigo/rolf?user=rolf&password=rolf");
	Statement stmt = conn.createStatement();

	int price = Integer.parseInt(promptUser("State desired PC price:"));
	ResultSet rs1 = stmt.executeQuery("SELECT * FROM PC");

	rs1.first();
	int closestPrice = rs1.getInt("price");
	String closestModel = rs1.getString("model");
	int closestSpeed = rs1.getInt("speed");

	while (rs1.next()) {
	    int p = rs1.getInt("price");
	    if (Math.abs(p-price) < Math.abs(closestPrice-price)){
		closestPrice = p;
		closestModel = rs1.getString("model");
		closestSpeed = rs1.getInt("speed");
	    }
	}
	rs1 = stmt.executeQuery("SELECT maker FROM Product WHERE model = "
				+ closestModel);
	rs1.first();
	String closestMaker = rs1.getString("maker");

	System.out.println("Closest match:");
	System.out.println("Maker: " + closestMaker);
	System.out.println("Model: " + closestModel);
	System.out.println("Speed: " + closestSpeed);

    }

}