JDBC and JSP to display

QuestionsJDBC and JSP to display
akankshat.ngPublished on: 10/18/2018 5:22:56 PM

  Write a program using JDBC and JSP to display the current balance from a saving bank account. The program should take account number or registered mobile number as input. 


1 Answers
Best Answer 0
admin 10/16/2018 1:29:00 AM

<pre><html>import java.io.*;class Curr_acct //CURRENT ACCOUNT CLASS{ final int max_limit=20; final int min_limit=1; final double min_bal=500; private String name[]=new String[20]; privateint accNo[]=newint[20]; private String accType[]=new String[20]; privatedouble balAmt[]=newdouble[20]; staticint totRec=0; //Intializing Methodpublicvoid initialize() { for(int i=0;i<max_limit;i ) { name[i]=""; accNo[i]=0; accType[i]=""; balAmt[i]=0.0; } } //TO ADD NEW RECORDpublicvoid newEntry() { String str; int acno; double amt; boolean permit; permit=true; if (totRec>max_limit) { System.out.println("\n\n\nSorry we cannot admit you in our bank...\n\n\n"); permit=false; } if(permit = true) //Allows to create new entry { totRec ; // Incrementing Total Record System.out.println("\n\n\n=====RECORDING NEW ENTRY====="); try{ accNo[totRec]=totRec; //Created AutoNumber to accNo so no invalid id occurs System.out.println("Account Number : " accNo[totRec]); BufferedReader obj = new BufferedReader(new InputStreamReader(System.in)); System.out.print("Enter Name : "); System.out.flush(); name[totRec]=obj.readLine(); accType[totRec]="Current Account"; System.out.println("Account Type : " accType[totRec]); do{ System.out.print("Enter Initial Amount to be deposited : "); System.out.flush(); str=obj.readLine(); balAmt[totRec]=Double.parseDouble(str); }while(balAmt[totRec]<min_bal); //Validation that minimun amount must be 500 System.out.println("\n\n\n"); } catch(Exception e) {} } } //TO DISPLAY DETAILS OF RECORDpublicvoid display() { String str; int acno=0; boolean valid=true; System.out.println("\n\n=====DISPLAYING DETAILS OF CUSTOMER=====\n"); try{ BufferedReader obj = new BufferedReader(new InputStreamReader(System.in)); System.out.print("Enter Account number : "); System.out.flush(); str=obj.readLine(); acno=Integer.parseInt(str); if (acno<min_limit || acno>totRec) //To check whether accNo is valid or Not { System.out.println("\n\n\nInvalid Account Number \n\n"); valid=false; } if (valid==true) { System.out.println("\n\nAccount Number : " accNo[acno]); System.out.println("Name : " name[acno]); System.out.println("Account Type : " accType[acno]); System.out.println("Balance Amount : " balAmt[acno] "\n\n\n"); } } catch(Exception e) {} } //TO DEPOSIT AN AMOUNTpublicvoid deposit() { String str; double amt; int acno; boolean valid=true; System.out.println("\n\n\n=====DEPOSIT AMOUNT====="); try{ //Reading deposit value BufferedReader obj = new BufferedReader(new InputStreamReader(System.in)); System.out.print("Enter Account No : "); System.out.flush(); str=obj.readLine(); acno=Integer.parseInt(str); if (acno<min_limit || acno>totRec) //To check whether accNo is valid or Not { System.out.println("\n\n\nInvalid Account Number \n\n"); valid=false; } if (valid==true) { System.out.print("Enter Amount you want to Deposit : "); System.out.flush(); str=obj.readLine(); amt=Double.parseDouble(str); balAmt[acno]=balAmt[acno] amt; //Displaying Depsit Details System.out.println("\nAfter Updation..."); System.out.println("Account Number : " acno); System.out.println("Balance Amount : " balAmt[acno] "\n\n\n"); } } catch(Exception e) {} } //TO WITHDRAW BALANCEpublicvoid withdraw() { String str; double amt,checkamt,penalty; int acno; boolean valid=true; System.out.println("\n\n\n=====WITHDRAW AMOUNT====="); try{ //Reading deposit value BufferedReader obj = new BufferedReader(new InputStreamReader(System.in)); System.out.print("Enter Account No : "); System.out.flush(); str=obj.readLine(); acno=Integer.parseInt(str); if (acno<min_limit || acno>totRec) //To check whether accNo is valid or Not { System.out.println("\n\n\nInvalid Account Number \n\n"); valid=false; } if (valid==true) { System.out.println("Balance is : " balAmt[acno]); System.out.print("Enter Amount you want to withdraw : "); System.out.flush(); str=obj.readLine(); amt=Double.parseDouble(str); checkamt=balAmt[acno]-amt; if(checkamt >= min_bal) { balAmt[acno]=checkamt; //Displaying Depsit Details System.out.println("\nAfter Updation..."); System.out.println("Account Number : " acno); System.out.println("Balance Amount : " balAmt[acno] "\n\n\n"); } else { System.out.println("\n\nYour Balance has gone down and so penalty is calculated"); //Bank policy is to charge 20% on total difference of balAmt and min_bal to be maintain penalty=((min_bal - checkamt)*20)/100; balAmt[acno]=balAmt[acno]-(amt penalty); System.out.println("Now your balance revels : " balAmt[acno] "\n\n\n"); } } } catch(Exception e) {} }}class Sav_acct //SAVING ACCOUNT CLASS{ final int max_limit=20; final int min_limit=1; final double min_bal=500; private String name[]=new String[20]; privateint accNo[]=newint[20]; private String accType[]=new String[20]; privatedouble balAmt[]=newdouble[20]; staticint totRec=0; //Intializing Methodpublicvoid initialize() { for(int i=0;i<max_limit;i ) { name[i]=""; accNo[i]=0; accType[i]=""; balAmt[i]=0.0; } } //TO ADD NEW RECORDpublicvoid newEntry() { String str; int acno; double amt; boolean permit; permit=true; if (totRec>max_limit) { System.out.println("\n\n\nSorry we cannot admit you in our bank...\n\n\n"); permit=false; } if(permit = true) //Allows to create new entry { totRec ; // Incrementing Total Record System.out.println("\n\n\n=====RECORDING NEW ENTRY====="); try{ accNo[totRec]=totRec; //Created AutoNumber to accNo so no invalid id occurs System.out.println("Account Number : " accNo[totRec]); BufferedReader obj = new BufferedReader(new InputStreamReader(System.in)); System.out.print("Enter Name : "); System.out.flush(); name[totRec]=obj.readLine(); accType[totRec]="Saving Account"; System.out.println("Account Type : " accType[totRec]); do{ System.out.print("Enter Initial Amount to be deposited : "); System.out.flush(); str=obj.readLine(); balAmt[totRec]=Double.parseDouble(str); }while(balAmt[totRec]<min_bal); //Validation that minimun amount must be 500 System.out.println("\n\n\n"); } catch(Exception e) {} } } //TO DISPLAY DETAILS OF RECORDpublicvoid display() { String str; int acno=0; boolean valid=true; System.out.println("\n\n=====DISPLAYING DETAILS OF CUSTOMER=====\n"); try{ BufferedReader obj = new BufferedReader(new InputStreamReader(System.in)); System.out.print("Enter Account number : "); System.out.flush(); str=obj.readLine(); acno=Integer.parseInt(str); if (acno<min_limit || acno>totRec) //To check whether accNo is valid or Not { System.out.println("\n\n\nInvalid Account Number \n\n"); valid=false; } if (valid==true) { System.out.println("\n\nAccount Number : " accNo[acno]); System.out.println("Name : " name[acno]); System.out.println("Account Type : " accType[acno]); //Bank policy is to give 10% interest on Net balance amt balAmt[acno]=balAmt[acno] (balAmt[acno]/10); System.out.println("Balance Amount : " balAmt[acno] "\n\n\n"); } } catch(Exception e) {} } //TO DEPOSIT AN AMOUNTpublicvoid deposit() { String str; double amt; int acno; boolean valid=true; System.out.println("\n\n\n=====DEPOSIT AMOUNT====="); try{ //Reading deposit value BufferedReader obj = new BufferedReader(new InputStreamReader(System.in)); System.out.print("Enter Account No : "); System.out.flush(); str=obj.readLine(); acno=Integer.parseInt(str); if (acno<min_limit || acno>totRec) //To check whether accNo is valid or Not { System.out.println("\n\n\nInvalid Account Number \n\n"); valid=false; } if (valid==true) { System.out.print("Enter Amount you want to Deposit : "); System.out.flush(); str=obj.readLine(); amt=Double.parseDouble(str); balAmt[acno]=balAmt[acno] amt; //Displaying Depsit Details System.out.println("\nAfter Updation..."); System.out.println("Account Number : " acno); System.out.println("Balance Amount : " balAmt[acno] "\n\n\n"); } } catch(Exception e) {} } //TO WITHDRAW BALANCEpublicvoid withdraw() { String str; double amt,checkamt; int acno; boolean valid=true; System.out.println("\n\n\n=====WITHDRAW AMOUNT====="); try{ //Reading deposit value BufferedReader obj = new BufferedReader(new InputStreamReader(System.in)); System.out.print("Enter Account No : "); System.out.flush(); str=obj.readLine(); acno=Integer.parseInt(str); if (acno<min_limit || acno>totRec) //To check whether accNo is valid or Not { System.out.println("\n\n\nInvalid Account Number \n\n"); valid=false; } if (valid==true) { System.out.println("Balance is : " balAmt[acno]); System.out.print("Enter Amount you want to withdraw : "); System.out.flush(); str=obj.readLine(); amt=Double.parseDouble(str); checkamt=balAmt[acno]-amt; if(checkamt >= min_bal) { balAmt[acno]=checkamt; //Displaying Depsit Details System.out.println("\nAfter Updation..."); System.out.println("Account Number : " acno); System.out.println("Balance Amount : " balAmt[acno] "\n\n\n"); } else { System.out.println("\n\nAs per Bank Rule you should maintain minimum balance of Rs 500\n\n\n"); } } } catch(Exception e) {} }}class Bank_improved{ publicstaticvoid main(String args[]) { String str; int choice,check_acct=1,quit=0; choice=0; Curr_acct curr_obj = new Curr_acct(); Sav_acct sav_obj = new Sav_acct(); System.out.println("\n=====WELLCOME TO BANK DEMO PROJECT=====\n");while( quit!=1){ try{ BufferedReader obj = new BufferedReader(new InputStreamReader(System.in)); System.out.print("Type 1 for Current Account and Any no for Saving Account : "); System.out.flush(); str=obj.readLine(); check_acct=Integer.parseInt(str); } catch(Exception e) {} if(check_acct==1) { do//For Current Account { System.out.println("\n\nChoose Your Choices ..."); System.out.println("1) New Record Entry "); System.out.println("2) Display Record Details "); System.out.println("3) Deposit..."); System.out.println("4) Withdraw..."); System.out.println("5) Quit"); System.out.print("Enter your choice : "); System.out.flush(); try{ BufferedReader obj = new BufferedReader(new InputStreamReader(System.in)); str=obj.readLine(); choice=Integer.parseInt(str); switch(choice) { case 1 : //New Record Entry curr_obj.newEntry(); break; case 2 : //Displaying Record Details curr_obj.display(); break; case 3 : //Deposit... curr_obj.deposit(); break; case 4 : //Withdraw... curr_obj.withdraw(); break; case 5 : System.out.println("\n\n.....Closing Current Account....."); break; default : System.out.println("\nInvalid Choice \n\n"); } } catch(Exception e) {} }while(choice!=5); }else { do//For Saving Account { System.out.println("Choose Your Choices ..."); System.out.println("1) New Record Entry "); System.out.println("2) Display Record Details "); System.out.println("3) Deposit..."); System.out.println("4) Withdraw..."); System.out.println("5) Quit"); System.out.print("Enter your choice : "); System.out.flush(); try{ BufferedReader obj = new BufferedReader(new InputStreamReader(System.in)); str=obj.readLine(); choice=Integer.parseInt(str); switch(choice) { case 1 : //New Record Entry sav_obj.newEntry(); break; case 2 : //Displaying Record Details sav_obj.display(); break; case 3 : //Deposit... sav_obj.deposit(); break; case 4 : //Withdraw... sav_obj.withdraw(); break; case 5 : System.out.println("\n\n.....Closing Saving Account....."); break; default : System.out.println("\nInvalid Choice \n\n"); } } catch(Exception e) {} }while(choice!=5); }try{BufferedReader obj = new BufferedReader(new InputStreamReader(System.in));System.out.print("\nEnter 1 for Exit : ");System.out.flush();str=obj.readLine();quit=Integer.parseInt(str);}catch (Exception e){}} }}</html></pre>

Edit