Q) Develop a JDBC application that displays a specified account details

A)

import java.sql.*;

class RealAccount {

       public static void main(String[] args) {

       Connection con = DriverManager.getConnection("jdbc:odbc:mydsn","scott","tiger");

       Statement st= con.createStatement();

       ResultSet rs=st.executeQuery("SELECT * FROM ACCOUNT WHERE ACCNO=101");

       if(rs.next())

       {

              System.out.println("Accno :"+rs.getInt(1));

              System.out.println("A/C holdername :"+rs.getString(2));

       }

       else

              System.out.println("Account doesn't exist");

       rs.close();

       st.close();

       con.close();

       }

}