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) 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) 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) What is the purpose of JDBC?

A) -> Java application can do any task by making a method (function) call. ->java method calls are not understandable to database management system. They can understand only SQL statements. ->SQL statements can’t be directly used in a java application. Java compiler complains. ->therefore, we say that java environment and database environment are heterogeneous to each other. Purpose of JDBC: ->for any kind of java application to communicate with any kind of database (management system) in a standard manner, JDBC is used.
Post a Comment
Read more