title: check if the record exists in database
body: <p>I need to check the box no if exist in the database under the remittance id that I enter if the box no exists then i need to show the message that the box no already exists but if it doesn't the it should insert new box i have written some code but its showing error </p>
  
  <pre><code>private void txtboxnoFocusLost(java.awt.event.FocusEvent evt) {
      DBUtil util = new DBUtil();
  
      try {
          Connection con = util.getConnection();
          PreparedStatement stmt = con.prepareStatement(
              "select box_no from dbo.soil_det where rm_id = ? and box_no = ?");
          stmt.setLong(1, Long.parseLong(tf_rm_id.getText()));
          stmt.setString(1, (txtboxno.getText()));       
          ResultSet rs=stmt.executeQuery();
          while(rs.next()){
              rs.equals().txtboxno.getText());
          }
          JOptionPane.showMessageDialog(rootPane, "hello!S");
      } catch (Exception ex) {
          Logger.getLogger(DATAENTRY.class.getName()).log(Level.SEVERE, null, ex);
      }
  </code></pre>