Mon, 11 May 2020 19:09:06 +0200
adds DAO for Project entity and save/update methods
1 /*
2 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
3 *
4 * Copyright 2018 Mike Becker. All rights reserved.
5 *
6 * Redistribution and use in source and binary forms, with or without
7 * modification, are permitted provided that the following conditions are met:
8 *
9 * 1. Redistributions of source code must retain the above copyright
10 * notice, this list of conditions and the following disclaimer.
11 *
12 * 2. Redistributions in binary form must reproduce the above copyright
13 * notice, this list of conditions and the following disclaimer in the
14 * documentation and/or other materials provided with the distribution.
15 *
16 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
17 * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
18 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
19 * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE
20 * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
21 * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
22 * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
23 * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
24 * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
25 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
26 * POSSIBILITY OF SUCH DAMAGE.
27 *
28 */
29 package de.uapcore.lightpit.dao.postgres;
31 import de.uapcore.lightpit.dao.AbstractDao;
32 import de.uapcore.lightpit.dao.UserDao;
33 import de.uapcore.lightpit.entities.User;
35 import java.sql.Connection;
36 import java.sql.PreparedStatement;
37 import java.sql.ResultSet;
38 import java.sql.SQLException;
39 import java.util.Objects;
41 public final class PGUserDao extends AbstractDao<User> implements UserDao {
43 private final PreparedStatement insert;
44 private final PreparedStatement update;
46 public PGUserDao(Connection connection) throws SQLException {
47 super(connection.prepareStatement("select * from lpit_user where userid >= 0 order by username"));
49 insert = connection.prepareStatement("insert into lpit_user (username, lastname, givenname, mail) values (?, ?, ?, ?)");
50 update = connection.prepareStatement("update lpit_user set lastname = ?, givenname = ?, mail = ? where userid = ?");
51 }
53 @Override
54 public User mapColumns(ResultSet result, String q) throws SQLException {
55 final var user = new User(result.getInt(qual(q, "userid")));
56 user.setUsername(result.getString(qual(q, "username")));
57 user.setGivenname(result.getString(qual(q, "givenname")));
58 user.setLastname(result.getString(qual(q, "lastname")));
59 return user;
60 }
62 @Override
63 public void save(User instance) throws SQLException {
64 Objects.requireNonNull(instance.getUsername());
65 insert.setString(1, instance.getUsername());
66 setStringOrNull(insert, 2, instance.getLastname());
67 setStringOrNull(insert, 3, instance.getGivenname());
68 setStringOrNull(insert, 4, instance.getMail());
69 insert.executeUpdate();
70 }
72 @Override
73 public boolean update(User instance) throws SQLException {
74 setStringOrNull(update, 1, instance.getLastname());
75 setStringOrNull(update, 2, instance.getGivenname());
76 setStringOrNull(update, 3, instance.getMail());
77 update.setInt(4, instance.getUserID());
78 return update.executeUpdate() > 0;
79 }
80 }