Exemplo n.º 1
0
  public static boolean nameExists(Rezept r, Connection con) throws SQLException {
    String sql = "SELECT * FROM rezept WHERE name = ? AND ID != ?";
    PreparedStatement stmt = con.prepareStatement(sql);
    stmt.setObject(1, r.getName());
    stmt.setObject(2, r.getId());
    ResultSet rs = stmt.executeQuery();

    if (rs.next()) {
      return true;
    } else return false;
  }
Exemplo n.º 2
0
 protected static void setStmtParams(Rezept r, PreparedStatement stmt, int index)
     throws SQLException {
   DbUtil.setString(stmt, index++, r.getName());
   DbUtil.setString(stmt, index++, r.getAnleitung());
 }