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

class  Ex_8_5_1_e {

    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();

	String maker = promptUser("Manufacturer:");
	int model = Integer.parseInt(promptUser("Model number:"));
	int speed = Integer.parseInt(promptUser("Speed:"));
	int ram = Integer.parseInt(promptUser("RAM size:"));
	int hd = Integer.parseInt(promptUser("Harddisk size:"));
	String rd = promptUser("Removable disk specs:");
	int price = Integer.parseInt(promptUser("Price:"));

	ResultSet rs1 = stmt.executeQuery("SELECT * FROM PC WHERE model = " 
					  + model);

	if (rs1.next())
	    System.out.println("Error: model number exists!");
	else {
	    String s = "('" + model + "','" + speed + "','" + ram +
			"','" + hd +  "','" + rd + "','" + price + "')";
	    stmt.executeUpdate("INSERT INTO PC VALUES " + s);
	}
    }

}