import java.sql.*;
import java.util.*;

class RetrieveData 
{
    public static void main(String[] args) throws Exception
    {
        Scanner input=new Scanner(System.in);
        System.out.print("Enter id: ");
        int id=input.nextInt();

        System.out.print("Enter Name: ");
        String name=input.next();

        Class.forName("com.mysql.jdbc.Driver").newInstance();
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root" );
        Statement st=conn.createStatement();
        ResultSet rs=st.executeQuery("select * from data where id="+id+" and name='"+name+"'");

        if(rs.next()){
            String fname=rs.getString("fatherName");
            String date=rs.getString("dateOfJoining");
            String address=rs.getString("address");
            String mobile=rs.getString("mobile");
            System.out.println("Father's Name: "+fname); 
            System.out.println("Date of joining: "+date);
            System.out.println("Address: "+address);
            System.out.println("Mobile No: "+mobile);
        }
    }
}