title: How can i find maximum value in java
body: <pre><code>    try {
          ResultSet r = JDBC.getdata("SELECT MAX(TransactionID) from transaction");
          while (r.next()) {
              int l = r.getInt(1);
  
              int inid = l + 1;
              lbNewTransactionID.setText(new Integer(inid).toString());
  
          }
      } catch (Exception e) {
          e.printStackTrace();
      }
  </code></pre>
  
  <p>When I use this can't generate more than 10 numbers</p>