Q)Write a Java program to display the ACCNO and NAME of the accounts whose
balance is less than Rs.70000.
import java.sql.*;
class  AccountDetails
{
	public static void main(String[] args) throws SQLException
	{
		Connection connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/hdfcdb","root","ashokit");
		Statement statement=connection.createStatement();
		ResultSet resultSet=statement.executeQuery("SELECT ACCNO,NAME FROM ACCOUNT WHERE BALANCE<70000");
		if(resultSet.next())
		{
			 System.out.println("ACCNO\tNAME");
		     do
		     {
			     System.out.println(resultSet.getInt(1)+"\t"+resultSet.getString(2));
		     }while(resultSet.next());
		}
                else
		{
			System.out.println("With this balance range no account exists");
		}
		resultSet.close();
		statement.close();
		connection.close();
	}//main
}	
Q)What happens in the background within the DBMS when an SQL statement 
is submitted to it?
=>DBMS does the following things in order.
         1)Query compilation
	 2)Query Plan generation
	 3)Query execution
Q)What is the limitation of Statement object?
  =>Whenever the same SQL statement is required to be submitted to the
  DBMS repeatedly, we should not use Statement object as it compromises
  performance.

Q)How to overcome the limitation of Statement in a JDBC client?
     =>By using java.sql.PreparedStatement which is a child
     of java.sql.Statement.

Note:- Object Oriented representation of already prepared(pre-compiled)
SQL statement is nothing but PreparedStatement object.

Q)How to make use of PreparedStatement in a Java program to perform
CRUD operations with the DBMS?

DIAGRAM