// Write Connectivity Code here properly/globally.
private void jBtnRegSearchActionPerformed(java.awt.event.ActionEvent evt)
{
String gender = "";
String ChkMatric = "";
String ChkInter = "";
String ChkGrad = "";
String ChkPg = "";
try
{
pst=conn.prepareStatement("select * from REGISTRATION where REGUNAME='"+
jTxtRegUname.getText().trim()+"'");
rs= pst.executeQuery();
while (rs.next())
{
jTxtRegSlno.setText(rs.getString("REGSLNO"));
jTxtRegName.setText(rs.getString("REGNAME"));
jTxtRegFname.setText(rs.getString("REGFNAME"));
//Date pp = new SimpleDateFormat("dd-MMM-yyyy").parse(rs.getString("REGDOB"));
jDtRegDob.setDate(new SimpleDateFormat("dd-MMM-yyyy").parse(rs.getString("REGDOB")));
gender = rs.getString("REGGENDER");
if(gender.equals("Male"))
{
jRdbRegMale.setSelected(true);
}
else if (gender.equals("Female"))
{
jRdbRegFemale.setSelected(true);
}
else if (gender.equals("Other"))
{
jRdbRegMale.setSelected(true);
}
else
{
jRdbRegMale.setSelected(false);
jRdbRegFemale.setSelected(false);
jRdbRegOther.setSelected(false);
}
ChkMatric = rs.getString("REGMATRIC");
if (ChkMatric.equals("Matric"))
{
jChkRegMatric.setSelected(true);
}
else
{
jChkRegMatric.setSelected(false);
}
ChkInter = rs.getString("REGINTER");
if (ChkInter.equals("Inter"))
{
jChkRegInter.setSelected(true);
}
else
{
jChkRegInter.setSelected(false);
}
ChkGrad = rs.getString("REGGRAD");
if (ChkGrad.equals("Graduation"))
{
jChkRegGrad.setSelected(true);
}
else
{
jChkRegGrad.setSelected(false);
}
ChkPg = rs.getString("REGPG");
if (ChkPg.equals("PG"))
{
jChkRegPg.setSelected(true);
}
else
{
jChkRegPg.setSelected(false);
}
jTxtRegMobile.setText(rs.getString("REGMOBILE"));
jTxtRegEmail.setText(rs.getString("REGEMAIL"));
jCmbRegState.setSelectedItem(rs.getString("REGSTATE"));
jRtbRegAddress.setText(rs.getString("REGADDRESS"));
jTxtRegUname.setText(rs.getString("REGUNAME"));
jPdRegPsd.setText(rs.getString("REGPSD"));
}
}
catch(Exception e)
{
System.out.println(e)
}
}
0 Comments