Skip to main content

Q) Develop a JDBC application that provides repeated deposit operation to the end-user.



A)
//RepeatedUpdation.java
import java.util.Scanner;
import java.sql.*;
class RepeatedUpdate {
       public static void main(String[] args) {
              Connection con= DriverManager.getConnection("jdbc:odbc:prince","scott","tiger");
              PreparedStatement ps = con.PreparedStatement("UPDATE ACCOUNT SET BALANCE=BALANCE+? WHERE ACCNO=?");
              Scanner s=new Scanner(System.in);
              while(true)
              {
                     System.out.println("Enter accno : ");
                     int ano=s.nextInt();
                     System.out.println("Enter amount : ");
                     Float amt=s.nextFloat();
                     ps.setFloat(1, amt);
                     ps.setInt(2, ano);
                     int re = ps.executeUpdate();
                     if(re==0)
                           System.out.println("update not successfull");
                     else
                           System.out.println("deposit successfully");
                     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

Comments

Post a Comment

Popular posts from this blog

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

Q) What is ODBC?

A) ->open database connectivity is a technology from MS that enables any language program (other than java) to communication with database Management System. ->in java program ODBC is directly not allowed for the fallowing reasons 1) OS dependency 2) Procedural oriented approach 3) Security thread
Post a Comment
Read more

Q) Explain about nested classes?

A) ->defining a class with in another class is known as nesting of the class. Ex: class A {        class B        {                      } //nested class, and inner class.because it is not static class. } //enclosing class or outer class. ->static class is declared in inside an another class then it does not become an inner class. Note: non-static nested class is known as “inner class”. In the above example class B is nested but not an inner class. Ex: class D {        static c        {                      } //nested class, but not an inner class , because of static class. } //outer class. ->we have three different kinds of inner classes. 1) Member inner class 2) Meth...
Post a Comment
Read more