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

class  JDBCExample {

    public static void main(String[] argv) throws Exception

    {
	Class.forName("com.mysql.jdbc.Driver").newInstance();
	Connection conn = DriverManager.getConnection(
                   "jdbc:mysql://amigo/databasename?user=username&password=userpassword");
  
	Statement stmt = conn.createStatement();
	ResultSet rs = stmt.executeQuery(
                  "SELECT model, price FROM PC");

	while (rs.next()) {
	    String m = rs.getString("model");
	    int p = rs.getInt("price");
	    System.out.println("Model " + m + " costs " + p + " USD");
	}

	String getBigCheapPCs = "SELECT model, speed, price " +
	    "FROM PC " +
	    "WHERE speed >= ? AND price <= ?";

	PreparedStatement stmt2 = conn.prepareStatement(getBigCheapPCs);
	stmt2.setInt(1, 1000); 
	stmt2.setInt(2, 2000); 

	ResultSet rs2 = stmt2.executeQuery();

	System.out.println();
	while (rs2.next()) {
	    String m = rs2.getString("model");
	    int s = rs2.getInt("speed");
	    int p = rs2.getInt("price");
	    System.out.println("Model " + m + " with speed " + s + 
			       " costs " + p + " USD");
	}

    }

}