Q) Develop a JDBC application that allows the end-user to enter account details until the user opts out. End-user entered details should be stored into the DB.

A)

//RepeatingStoring.java

import java.util.Scanner;

importjava.sql.DriverManager;

import java.sql.Connection;

importjava.sql.PreparedStatement;

class RepeatedStroing {

       public static void main(String[] args) {

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

              PreparedStatement ps = con.PreparedStatement("INSERT INTO ACCOUNT VALUES (?,?,?)");

              Scanner s=new Scanner(System.in);

              while(true)

              {

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

                     intano=s.nextInt();

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

                     String nm= s.next();

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

                     Float bal= s.nextFloat();

                     ps.setInt(1, ano);

                     ps.setString(2, nm);

                     ps.setFloat(3, bal);

                     intre = ps.executeUpdate();

                     System.out.println(re+" account created succesfully");

                     System.out.println("one more account ?(yes/no");

                     String choice=s.next();

                     if(choice.equals("no"))

                           break;

              }//infinite loop

              ps.close();

       con.close();

       }//main

}//class