Q) Develop a JDBC application that provides repeated balance enquiry service to the end-user.

A)

//Repreatedretrieval.java

import java.util.Scanner;

import java.sql.*;

class RepeatedRetrieval {

       public static void main(String[] args) {

              Connection con = DriverManager.getConnection("jdbc:odbc:prince","scott","tiger");

              PreparedStatement ps = con.PreparedSatement("SELECT BALANCE FROM ACCOUNT WHERE ACCNO=?");

              Scanner s= new Scanner(System.in);

              while(true)

              {

                     System.out.println("Enter accno :");

                     int ano=s.nextInt();

                     ps.setInt(1, ano);

                     ResultSet rs=ps.executeQuery();

                     if(rs.next())

                           System.out.println("A/C balance is : Rs. "+rs.getFloat(1));

                     else

                           System.out.println("wrong account number");

                           rs.close();

                           System.out.println("one more Account ? (yes/No)");

                           String choice = s.next();

                           if(choice.equals("no"))

                                  break;

              }

              ps.close();

           con.close();

       }

}