Skip to main content

Q) Develop a java application to represent 2 accounts?




A)
//userdefinedarray.java
import java.util.Scanner;
class Account
{
       static Scanner s = new Scanner(System.in);
       int accno;
       float balance;
       Account()
       {
              System.out.print("Enter account number :");
              accno=s.nextInt();
              System.out.print("Enter initial balance (Rs) :");
              balance=s.nextFloat();                         
       }
    void displayaccount()
       {
              System.out.println("\naccount number :"+accno);
              System.out.println("account balance :"+balance);
       }
}
class userdefinedarray {

       public static void main(String[] args) {
              Account acc[]=new Account[2];
              //array of 10 reference of type account is created
              for(int i=0;i<acc.length;i++)
              {                                                                                                              
                     acc[i]=new Account();
              }
              int count=1;
              for(Account Account : acc)
              {
                     System.out.println("\n\naccount "+count+" details....");
                     Account.displayaccount();
                     count++;
              }
                    
       }

}
Output:

Enter account number :1001
Enter initial balance (Rs) :5000
Enter account number :1002
Enter initial balance (Rs) :60000


account 1 details....

account number :1001
account balance :5000.0


account 2 details....

account number :1002
account balance :60000.0

Comments

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 : " );      ...

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.  

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.