code: public KamInfo getKamInfoById(final int id) throws SQLException {
          KamInfo kamInfo = null;
          ResultSet rset = null;
  
          try {
              PreparedStatement ps = getPreparedStatement(SELECT_KAM_BY_ID_SQL);
              ps.setInt(1, id);
  
              rset = ps.executeQuery();
  
              if (rset.next()) {
                  kamInfo = getKamInfo(rset);
              }
          } catch (SQLException ex) {
              throw ex;
          } finally {
              close(rset);
          }
  
          return kamInfo;
      }
docs: Retrieves a {@link KamInfo} object, from the KAM catalog database,
  using the KAM's id.
  
  @param id, the KAM id
  @return {@link KamInfo}, the queried KAM or null if no KAM is found by
  that <tt>id</tt>
  @throws SQLException Thrown if a SQL error occurred while retrieving
  the {@link KamInfo} object by kam id.