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.