String Sql=" SELECT rect.recName,rect.phoneNo,rect.position,rect.DOB,rect.gender,rect.Mstatus,rect.nationality,rect.quali,rect.major,rect.Uni,rect.email,rect.EngCom,rect.AraCom,rect.status,rect.Stage,rect.IntDate,rect.source,rect.interviewer,rect.RecEval,rect.comments,rect.Attach,rect.company,rect.curcomp,rect.sal,rect.expsal,rect.license,rect.notice,rect.DOJ,rect.health,rect.comm  ,education.qulif,education.grade,education.school,education.qulif2,education.grade2,education.school2,education.qulif3,education.grade3,education.school3,education.qulif4,education.grade4,education.school4,education.qulif5,education.grade5,education.school5,addtraining.trainIns,addtraining.trainDur,addtraining.post,addtraining.trainIns2,addtraining.trainDur2,addtraining.post2,addtraining.trainIns3,addtraining.trainDur3,addtraining.post3,addtraining.trainIns4,addtraining.trainDur4,addtraining.post4,addtraining.trainIns5,addtraining.trainDur5,addtraining.post5,addexp.procom,addexp.desg,addexp.produr,addexp.procom2,addexp.desg2,addexp.produr2,addexp.procom3,addexp.desg3,addexp.produr3,addexp.procom4,addexp.desg4,addexp.produr4,addexp.procom5,addexp.desg5,addexp.produr5,addexp.response,ref.name1,ref.position1,ref.details1,ref.name2,ref.position2,ref.details2,ref.name3,ref.position3,ref.details3,ref.langs,ref.comp,ref.commSkill,ref.Mcomm,ref.Mstate n" +
" FROM hr.rect,hr.education,hr.addtraining,addexp,ref  WHERE rect.recName =  ? GROUP BY rect.recName , education.qulif,addtraining.trainIns,addexp.procom,ref.name1" ;
    try {
        Class.forName("com.mysql.jdbc.Driver");
        con = DriverManager.getConnection("jdbc:mysql://localhost:3306/hr?zeroDateTimeBehavior=convertToNull","root","MZaa8891@");
        ps= con.prepareStatement(Sql);
        ps.setString(1, jTextField1.getText());
   while (rs.next()){
           jTextField1.setText(rs.getString("recName"));
          ...
           inter.jTextField1.setText(rs.getString("curcomp"));
          ...
        edu.jTextField1.setText(rs.getString("qulif"));
       ....
        trexp.jTextField1.setText(rs.getString("trainIns"));
       ...
       wrkexp.jTextField1.setText(rs.getString("procom"));
    .....
              skills.jTextArea1 .setText(rs.getString("langs"));
              ....
       ref.jTextField1.setText(rs.getString("name1"));
    .....
       ass.jComboBox1.addItem(rs.getString("Mcomm"));
   ....
 }

         rs.first();
      Document pdfdoc = new  Document(PageSize.A4);
      PdfDocument pdf = new PdfDocument ();
      PdfWriter writer = PdfWriter.getInstance(pdfdoc,new FileOutputStream("C:/Users/TCC/Documents/Recruitment.pdf"));
      pdfdoc.open();
//the strture of pdf
  pdfdoc.close();
         }

    catch (Exception e){
    JOptionPane.showMessageDialog(null, "Data is not exiting");
    JOptionPane.showMessageDialog(null, e);
    }