Java Parameters Query for INSERT PreparedStatement (prepareStatement)

   PreparedStatement pstmt = con.prepareStatement("INSERT INTO EMPLOYEES
                                     (ID,SALARY) VALUES (?,?)");
   pstmt.setBigDecimal(1, 153833.00)
   pstmt.setInt(2, 110592)

PreparedStatement pstmt = con.prepareStatement("INSERT INTO EMPLOYEES
	     (ID,SALARY) VALUES (?,?)");

// Query 1
pstmt.setBigDecimal(1, 153833.00)
pstmt.setInt(2, 110592)
pstmt.executeUpdate();

// Query 2
pstmt.setBigDecimal(1, 1234.00)
pstmt.setInt(2, 56789)
pstmt.executeUpdate();

PreparedStatement pre = connect.prepareStatement(sql);

		
String sql = "INSERT INTO customer " +
		"(CustomerID,Name,Email,CountryCode,Budget,Used) " + 
		"VALUES (?,?,?,?,?,?) ";
pre.setString(1, "C005");
pre.setString(2, "Chai Surachai");
pre.setString(3, "[email protected]");
pre.setString(4, "TH");
pre.setFloat(5, 1000000);
pre.setFloat(6, 0);

pre.executeUpdate();

package com.java.myapp;

import java.sql.PreparedStatement;
import java.sql.Connection;
import java.sql.DriverManager;
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 = "INSERT INTO customer " +
					"(CustomerID,Name,Email,CountryCode,Budget,Used) " + 
					"VALUES (?,?,?,?,?,?) ";
			pre = connect.prepareStatement(sql);
			pre.setString(1, "C005");
			pre.setString(2, "Chai Surachai");
			pre.setString(3, "[email protected]");
			pre.setString(4, "TH");
			pre.setFloat(5, 1000000);
			pre.setFloat(6, 0);
			
			pre.executeUpdate();
			
            System.out.println("Record Inserted Successfully");
             
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		// Close
		try {
			if(connect != null){
				pre.close();
				connect.close();
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}	
		
	}
	
}