Skip to main content

Q) Develop a java application that creates one account and performs the fallowing operations ?



1)      balance enquiry
2)      deposit
3)      withdraw
4)      view details
A)
Account
accno
name
balance
type
getbalance()
Deposit()
Withdraw()
Viewaccountdetails()
Account is class name
accno , name , balance , type are Properties(general terminology) / attributes (UML terminology)  /  instance variables (java terminology)
Instance methods (java terminology) / operations (UML terminology)   /behavior

// save as ExecuteAccount.java

//Execute account
class account {
       int accno;
       String name;
       float balance;
       String type;
       void storeaccountdetails()
       {
              accno=1001;
              name="krishna";
              balance=8000;
              type="savings";
       }
       float getbalance()
       {
       return balance;
       }
       void viewaccountdetails()
       {
              System.out.println("account :"+accno);
              System.out.println("A/c holder name :"+name);
              System.out.println("Balance (Rs) :"+balance);
              System.out.println("A/c type :"+type);
       }
       void deposit(float amt)
       {
              balance = balance+amt;
       }
       void withdraw(float amt)
       {
              if(balance>amt)
              {
                     balance= balance-amt;
                     System.out.println("please collect Rs :"+amt);
              }
              else
                     System.out.println("can't withdraw. Insufficient funds");
       }
}

class ExecuteAccount
{
       public static void main(String[] args) {
       account acc= new account();
       acc.storeaccountdetails();
       acc.viewaccountdetails();
       acc.deposit(40000);
       acc.withdraw(15000);
       float bal = acc.getbalance();
       System.out.println("A/c balance is (Rs) :"+bal);
       acc.withdraw(12000);

       }

}

Output :
account :1001
A/c holder name :krishna
Balance (Rs) :8000.0
A/c type :savings
please collect Rs :15000.0
A/c balance is (Rs) :33000.0
please collect Rs :12000.0

Comments

Post a Comment

Popular posts from this blog

Q) Retrieving data from database?

A)   ->to retrieve the data from database we need to submit SELECT statement from JDBC application. -> executeQuery() method of statement object is used for this purpose. This method has the fallowing ResultSet executeQuery(String sql) throws SQLException Ex: ResultSet rs = st.executeQuery(“SELECT * FROM ACCOUNT”); ->objectoriented representation of tables formate data is called ResultSet object. Ao the driver created one object i.e. ResultSet object. ->object orientation representation of a table of records returned from db is nothing but “ ResultSet ” object.  
Post a Comment
Read more

Q) Explain repeated deletion of records.

A) //RepeatedDeletion.java import java.util.Scanner; import java.sql.*; class RepeatedDeletion {        public static void main(String[] args) {               Connection con= DriverManager. getConnection ( "jdbc:odbc:prince" , "scott" , "tiger" );               PreparedStatement ps=con.PreparedStatement( "DELETE FROM ACCOUNT WHERE ACCNO=?" );               Scanner s= new Scanner(System. in );               while ( true )               {                      System. out .println( "Enter accno : " );      ...
Post a Comment
Read more

Q) What is JDBC driver? What is its role in java database connection?

A) ->A translation software written in java according o JDBC specification is nothing but “JDBC driver”. -> JDBC driver implements JDBC API. Use single API. JDBC driver role: They are 4 roles   1)       Establishing connection between JDBC client and database server. 2)       Receiving JDBC method calls made by JDBC client while performing database (CRUD) operations. 3)       Translating java method calls into DBMS understandable calls and forwarding them to database server. 4)       Receiving the results from database server. Translating them into java format and handling over the same to the JDBC client.
Post a Comment
Read more