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; }
protected static void setStmtParams(Rezept r, PreparedStatement stmt, int index) throws SQLException { DbUtil.setString(stmt, index++, r.getName()); DbUtil.setString(stmt, index++, r.getAnleitung()); }