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.

//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

స్వవిధ