src/main/java/de/uapcore/lightpit/dao/postgres/PGDataAccessObjects.java

Thu, 14 May 2020 22:48:01 +0200

author
Mike Becker <universe@uap-core.de>
date
Thu, 14 May 2020 22:48:01 +0200
changeset 47
57cfb94ab99f
parent 38
cf85ef18f231
child 59
c759c60507a2
permissions
-rw-r--r--

projects can now be added and updated

34
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
1 /*
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
2 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
3 *
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
4 * Copyright 2018 Mike Becker. All rights reserved.
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
5 *
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
6 * Redistribution and use in source and binary forms, with or without
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
7 * modification, are permitted provided that the following conditions are met:
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
8 *
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
9 * 1. Redistributions of source code must retain the above copyright
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
10 * notice, this list of conditions and the following disclaimer.
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
11 *
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
12 * 2. Redistributions in binary form must reproduce the above copyright
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
13 * notice, this list of conditions and the following disclaimer in the
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
14 * documentation and/or other materials provided with the distribution.
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
15 *
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
16 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
17 * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
18 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
19 * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
20 * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
21 * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
22 * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
23 * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
24 * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
25 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
26 * POSSIBILITY OF SUCH DAMAGE.
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
27 *
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
28 */
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
29 package de.uapcore.lightpit.dao.postgres;
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
30
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
31 import de.uapcore.lightpit.dao.DataAccessObjects;
38
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
32 import de.uapcore.lightpit.dao.ProjectDao;
34
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
33 import de.uapcore.lightpit.dao.UserDao;
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
34
38
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
35 import java.sql.Connection;
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
36 import java.sql.SQLException;
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
37
34
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
38 public class PGDataAccessObjects implements DataAccessObjects {
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
39
38
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
40 private final UserDao userDao;
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
41 private final ProjectDao projectDao;
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
42
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
43 public PGDataAccessObjects(Connection connection) throws SQLException {
47
57cfb94ab99f projects can now be added and updated
Mike Becker <universe@uap-core.de>
parents: 38
diff changeset
44 userDao = new PGUserDao(connection);
57cfb94ab99f projects can now be added and updated
Mike Becker <universe@uap-core.de>
parents: 38
diff changeset
45 projectDao = new PGProjectDao(connection);
38
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
46 }
34
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
47
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
48 @Override
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
49 public UserDao getUserDao() {
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
50 return userDao;
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
51 }
38
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
52
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
53 @Override
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
54 public ProjectDao getProjectDao() {
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
55 return projectDao;
cf85ef18f231 adds DAO for Project entity and save/update methods
Mike Becker <universe@uap-core.de>
parents: 36
diff changeset
56 }
34
824d4042c857 cleanup and simplification of database access layer
Mike Becker <universe@uap-core.de>
parents:
diff changeset
57 }

mercurial