Skip to main content

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;
importjava.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();
                           ResultSet rs= st.executeQuery("SELECT ESAL FROM EMPLOYEE WHERE EID :"+eno);
                           if(rs.next()){
                                  float sal= rs.getFloat(1);
                                  System.out.println("Employee salary : Rs."+sal);
                           }
                           else
                                  System.out.println("Employee doesn't exest");
                           rs.close();
                           st.close();
                           con.close();
       }
}

Comments

Popular posts from this blog

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