Skip to main content

Q) Explain about “finally”?




A)
->”finally” keyword is used to create a block of statements.
->nature of finally block is that it gets executed in both exception raised case and non-raised case. Unlike try and catch blocks.
->unlike means catch is not executed exception non-raised cases, try is not executed completely in exception raised case.
->resources releasing code is written in finally block.

Ex:
 file closing, connection closing (JDBC connection closing)..etc.

->”finally” block is used in java application to release the resources allocated to the application.


Ex:

class withhandling
{
       ---
       ---
       try
       {
              System.exit(0);
       }
       catch(--)
       {
             
       }
       finally()
       {
              --
       }
}

->Here with System.exit(0); method the finally block is not executed.
->The finally block ensuring the release the resources. But not handling the exceptions.
 ->So far guaranty execution sake only the finally block is defined.

-> System.exit(0); with this method explicitly terminate the applications normally, whenever this method is executed before finally block then that finally block doesn’t executed.

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.