diff -r 30b840ed8c0e -r 822b7e3d064d src/main/java/de/uapcore/lightpit/dao/Functions.java --- a/src/main/java/de/uapcore/lightpit/dao/Functions.java Fri Oct 23 18:40:50 2020 +0200 +++ b/src/main/java/de/uapcore/lightpit/dao/Functions.java Fri Oct 23 20:34:57 2020 +0200 @@ -39,6 +39,10 @@ */ public final class Functions { + public static String getSafeString(ResultSet rs, String column) throws SQLException { + return Optional.ofNullable(rs.getString(column)).orElse(""); + } + public static void setStringOrNull(PreparedStatement stmt, int index, String str) throws SQLException { if (str == null || str.isBlank()) { stmt.setNull(index, Types.VARCHAR);