Java Parameters Query for SELECT PreparedStatement (prepareStatement)

   PreparedStatement pstmt = con.prepareStatement("SELECT * FROM EMPLOYEES
                                     WHERE ID = ?");
   pstmt.setInt(1, 101)

PreparedStatement pstmt = con.prepareStatement("SELECT * FROM EMPLOYEES
			     WHERE ID = ?");

// Query 1
pstmt.setInt(1, 101)
ResultSet rec1 = pstmt.executeQuery();

// Query 2
pstmt.setInt(1, 102)
ResultSet rec2 = pstmt.executeQuery();

PreparedStatement pre = connect.prepareStatement(sql);

String sql = "SELECT * FROM  customer " +
		"WHERE CountryCode = ? ORDER BY CustomerID ASC";
pre = connect.prepareStatement(sql);
pre.setString(1, "TH");

ResultSet rec = pre.executeQuery();

package com.java.myapp;

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

public class MyClass {

	public static void main(String[] args) {
		
		Connection connect = null;
		PreparedStatement pre = null;
		
		try {
			Class.forName("com.mysql.jdbc.Driver");
			connect =  DriverManager.getConnection("jdbc:mysql://localhost/mydatabase" +
					"?user=root&password=root");
			
			String sql = "SELECT * FROM  customer " +
					"WHERE CountryCode = ? ORDER BY CustomerID ASC";
			
			pre = connect.prepareStatement(sql);
			pre.setString(1, "TH");
			
			ResultSet rec = pre.executeQuery();
			
			while((rec!=null) && (rec.next()))
            {
                System.out.print(rec.getString("CustomerID"));
                System.out.print(" - ");
                System.out.print(rec.getString("Name"));
                System.out.print(" - ");
                System.out.print(rec.getString("Email"));
                System.out.print(" - ");
                System.out.print(rec.getString("CountryCode"));
                System.out.print(" - ");
                System.out.print(rec.getFloat("Budget"));
                System.out.print(" - ");
                System.out.print(rec.getFloat("Used"));
                System.out.println("");
            }
			
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		try {
            pre.close();
            connect.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
	
}