Skip to main content

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.
 

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) Develop a JDBC application that prompts the end-user to enter an employee number and displays the salary details.

A) //Retrieval.java import java.util.Scanner; import java.sql.DriverManager; import java.sql.Connection; import java.sql.Statement; import java.sql.ResultSet; class Retrieval {        public static void main(String[] args) {               Scanner s= new Scanner(System. in );System. out .println( "Enter employee number" );               int eno =s.nextInt();               Connection con=DriverManager. getConnection ( "jdbc:odbc:mydsn" , "scott" , "tiger"");" +                            Statement st=con.createStatement();                  ...
Post a Comment
Read more