1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 1.2 +++ b/src/main/java/de/uapcore/lightpit/dao/Functions.java Thu May 14 22:48:01 2020 +0200 1.3 @@ -0,0 +1,62 @@ 1.4 +/* 1.5 + * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER. 1.6 + * 1.7 + * Copyright 2018 Mike Becker. All rights reserved. 1.8 + * 1.9 + * Redistribution and use in source and binary forms, with or without 1.10 + * modification, are permitted provided that the following conditions are met: 1.11 + * 1.12 + * 1. Redistributions of source code must retain the above copyright 1.13 + * notice, this list of conditions and the following disclaimer. 1.14 + * 1.15 + * 2. Redistributions in binary form must reproduce the above copyright 1.16 + * notice, this list of conditions and the following disclaimer in the 1.17 + * documentation and/or other materials provided with the distribution. 1.18 + * 1.19 + * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" 1.20 + * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE 1.21 + * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE 1.22 + * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE 1.23 + * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR 1.24 + * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF 1.25 + * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS 1.26 + * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN 1.27 + * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) 1.28 + * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE 1.29 + * POSSIBILITY OF SUCH DAMAGE. 1.30 + * 1.31 + */ 1.32 +package de.uapcore.lightpit.dao; 1.33 + 1.34 +import java.sql.PreparedStatement; 1.35 +import java.sql.SQLException; 1.36 +import java.sql.Types; 1.37 +import java.util.Optional; 1.38 +import java.util.function.Function; 1.39 + 1.40 +/** 1.41 + * Some DAO utilities. 1.42 + */ 1.43 +public final class Functions { 1.44 + 1.45 + public static void setStringOrNull(PreparedStatement stmt, int index, String str) throws SQLException { 1.46 + if (str == null || str.isBlank()) { 1.47 + stmt.setNull(index, Types.VARCHAR); 1.48 + } else { 1.49 + stmt.setString(index, str); 1.50 + } 1.51 + } 1.52 + 1.53 + public static <T> void setForeignKeyOrNull(PreparedStatement stmt, int index, T instance, Function<? super T, Integer> keyGetter) throws SQLException { 1.54 + Integer key = Optional.ofNullable(instance).map(keyGetter).orElse(null); 1.55 + if (key == null) { 1.56 + stmt.setNull(index, Types.INTEGER); 1.57 + } else { 1.58 + stmt.setInt(index, key); 1.59 + } 1.60 + } 1.61 + 1.62 + private Functions() { 1.63 + 1.64 + } 1.65 +}