I am trying that when no record found then page not found should appear but unable to do it plz see my code and advice
Thanks & Kind regards
PreparedStatement ps1=cnn.prepareStatement(sql);
ps1.setString(1, product);
ps1.setString(2, startDate);
ps1.setString(3, endDate);
rs=ps1.executeQuery();
while(rs.next()){
id=rs.getInt(1);
if(id<1){
out.println("No Record Found");
}else{
out.println("Record found");
}