Java tutorial
/******************************************************************************* * Copyright 2014 Federal Chancellery Austria * MOA-ID has been developed in a cooperation between BRZ, the Federal * Chancellery Austria - ICT staff unit, and Graz University of Technology. * * Licensed under the EUPL, Version 1.1 or - as soon they will be approved by * the European Commission - subsequent versions of the EUPL (the "Licence"); * You may not use this work except in compliance with the Licence. * You may obtain a copy of the Licence at: * http://www.osor.eu/eupl/ * * Unless required by applicable law or agreed to in writing, software * distributed under the Licence is distributed on an "AS IS" basis, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the Licence for the specific language governing permissions and * limitations under the Licence. * * This product combines work with different licenses. See the "NOTICE" text * file for details on the various modules and licenses. * The "NOTICE" text file is part of the distribution. Any derivative works * that you distribute must include a readable copy of the "NOTICE" text file. *******************************************************************************/ package at.gv.egovernment.moa.id.commons.db; import at.gv.egovernment.moa.id.commons.db.dao.config.MOAIDConfiguration; import at.gv.egovernment.moa.id.commons.db.dao.config.OnlineApplication; import at.gv.egovernment.moa.id.commons.db.dao.config.UserDatabase; import at.gv.egovernment.moa.logging.Logger; import at.gv.egovernment.moa.util.MiscUtil; //import org.apache.commons.lang.StringEscapeUtils; import javax.persistence.EntityManager; import javax.persistence.PersistenceException; import org.apache.commons.lang3.StringEscapeUtils; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; @SuppressWarnings("rawtypes") public class ConfigurationDBRead { private static Map<String, String> QUERIES = new HashMap<String, String>(); static { QUERIES.put("getActiveOnlineApplicationWithID", "select onlineapplication from OnlineApplication onlineapplication where onlineapplication.publicURLPrefix = SUBSTRING(:id, 1, LENGTH(onlineapplication.publicURLPrefix)) and onlineapplication.isActive = '1'"); QUERIES.put("getOnlineApplicationWithID", "select onlineapplication from OnlineApplication onlineapplication where onlineapplication.publicURLPrefix = SUBSTRING(:id, 1, LENGTH(onlineapplication.publicURLPrefix))"); QUERIES.put("getOnlineApplicationWithDBID", "select onlineapplication from OnlineApplication onlineapplication where onlineapplication.hjid = :id"); QUERIES.put("getAllOnlineApplications", "select onlineapplication from OnlineApplication onlineapplication"); QUERIES.put("getAllActiveOnlineApplications", "select onlineapplication from OnlineApplication onlineapplication where onlineapplication.isActive = '1'"); QUERIES.put("getAllNewOnlineApplications", "select onlineapplication from OnlineApplication onlineapplication where onlineapplication.isActive = '0' and onlineapplication.isAdminRequired = '1'"); QUERIES.put("getMOAIDConfiguration", "select moaidconfiguration from MOAIDConfiguration moaidconfiguration"); QUERIES.put("getUserWithUserID", "select userdatabase from UserDatabase userdatabase where userdatabase.hjid = :id"); QUERIES.put("getNewUserWithUserTokken", "select userdatabase from UserDatabase userdatabase where userdatabase.userRequestTokken = :tokken"); QUERIES.put("getAllNewUsers", "select userdatabase from UserDatabase userdatabase where userdatabase.userRequestTokken is null and userdatabase.isAdminRequest = '1' and userdatabase.isMailAddressVerified = '1'"); QUERIES.put("getAllOpenUsersRequests", "select userdatabase from UserDatabase userdatabase where userdatabase.userRequestTokken is not null and userdatabase.isAdminRequest = '1' and userdatabase.isMailAddressVerified = '0'"); QUERIES.put("getUserWithUserBPKWBPK", "select userdatabase from UserDatabase userdatabase where userdatabase.bpk = :bpk"); QUERIES.put("getUserWithUserUsername", "select userdatabase from UserDatabase userdatabase where userdatabase.username = :username"); QUERIES.put("getAllUsers", "select userdatabase from UserDatabase userdatabase"); QUERIES.put("getUsersWithOADBID", "select userdatabase from UserDatabase userdatabase inner join userdatabase.onlineApplication oa where oa.hjid = :id"); QUERIES.put("searchOnlineApplicationsWithID", "select onlineapplication from OnlineApplication onlineapplication where onlineapplication.friendlyName like :id"); } public static OnlineApplication getActiveOnlineApplication(String id) { MiscUtil.assertNotNull(id, "OnlineApplictionID"); Logger.trace("Getting OnlineApplication with ID " + id + " from database."); List result; EntityManager session = ConfigurationDBUtils.getCurrentSession(); javax.persistence.Query query = session.createQuery(QUERIES.get("getActiveOnlineApplicationWithID")); //query.setParameter("id", id+"%"); query.setParameter("id", StringEscapeUtils.escapeHtml4(id)); result = query.getResultList(); Logger.trace("Found entries: " + result.size()); if (result.size() == 0) { Logger.debug("No entries found."); return null; } if (result.size() > 1) { Logger.warn("OAIdentifier match to more then one DB-entry!"); return null; } return (OnlineApplication) result.get(0); } public static OnlineApplication getOnlineApplication(String id) { MiscUtil.assertNotNull(id, "OnlineApplictionID"); Logger.trace("Getting OnlineApplication with ID " + id + " from database."); List result; EntityManager session = ConfigurationDBUtils.getCurrentSession(); javax.persistence.Query query = session.createQuery(QUERIES.get("getOnlineApplicationWithID")); //query.setParameter("id", id+"%"); query.setParameter("id", id); result = query.getResultList(); Logger.trace("Found entries: " + result.size()); if (result.size() == 0) { Logger.trace("No entries found."); return null; } if (result.size() > 1) { Logger.warn("OAIdentifier match to more then one DB-entry!"); return null; } return (OnlineApplication) result.get(0); } public static OnlineApplication getOnlineApplication(long dbid) { MiscUtil.assertNotNull(dbid, "OnlineApplictionID"); Logger.trace("Getting OnlineApplication with DBID " + dbid + " from database."); List result; EntityManager session = ConfigurationDBUtils.getCurrentSession(); javax.persistence.Query query = session.createQuery(QUERIES.get("getOnlineApplicationWithDBID")); //query.setParameter("id", id+"%"); query.setParameter("id", dbid); result = query.getResultList(); Logger.trace("Found entries: " + result.size()); if (result.size() == 0) { Logger.trace("No entries found."); return null; } return (OnlineApplication) result.get(0); } public static MOAIDConfiguration getMOAIDConfiguration() { Logger.trace("Load MOAID Configuration from database."); List<MOAIDConfiguration> result; EntityManager session = ConfigurationDBUtils.getCurrentSession(); javax.persistence.Query query = session.createQuery(QUERIES.get("getMOAIDConfiguration")); result = query.getResultList(); Logger.trace("Found entries: " + result.size()); if (result.size() == 0) { Logger.trace("No entries found. Create fresh instance."); return null; } return (MOAIDConfiguration) result.get(0); } public static List<OnlineApplication> getAllOnlineApplications() { Logger.trace("Get All OnlineApplications from database."); List<OnlineApplication> result = null; EntityManager session = ConfigurationDBUtils.getCurrentSession(); javax.persistence.Query query = session.createQuery(QUERIES.get("getAllOnlineApplications")); result = query.getResultList(); Logger.trace("Found entries: " + result.size()); if (result.size() == 0) { Logger.trace("No entries found."); return null; } return result; } public static List<OnlineApplication> getAllNewOnlineApplications() { Logger.trace("Get All OnlineApplications from database."); List<OnlineApplication> result; EntityManager session = ConfigurationDBUtils.getCurrentSession(); javax.persistence.Query query = session.createQuery(QUERIES.get("getAllNewOnlineApplications")); result = query.getResultList(); Logger.trace("Found entries: " + result.size()); if (result.size() == 0) { Logger.trace("No entries found."); return null; } return result; } public static List<UserDatabase> getAllUsers() { Logger.trace("Get All OnlineApplications from database."); List<UserDatabase> result; EntityManager session = ConfigurationDBUtils.getCurrentSession(); javax.persistence.Query query = session.createQuery(QUERIES.get("getAllUsers")); result = query.getResultList(); Logger.trace("Found entries: " + result.size()); if (result.size() == 0) { Logger.trace("No entries found."); return null; } return result; } public static List<OnlineApplication> getAllActiveOnlineApplications() { Logger.trace("Get All active OnlineApplications from database."); List<OnlineApplication> result; EntityManager session = ConfigurationDBUtils.getCurrentSession(); javax.persistence.Query query = session.createQuery(QUERIES.get("getAllActiveOnlineApplications")); result = query.getResultList(); Logger.trace("Found entries: " + result.size()); if (result.size() == 0) { Logger.trace("No entries found."); result = new ArrayList<OnlineApplication>(); } return result; } @SuppressWarnings("rawtypes") public static List<OnlineApplication> searchOnlineApplications(String id) { MiscUtil.assertNotNull(id, "OnlineApplictionID"); Logger.trace("Getting OnlineApplication with ID " + id + " from database."); List<OnlineApplication> result; EntityManager session = ConfigurationDBUtils.getCurrentSession(); javax.persistence.Query query = session.createQuery(QUERIES.get("searchOnlineApplicationsWithID")); query.setParameter("id", "%" + id + "%"); result = query.getResultList(); Logger.trace("Found entries: " + result.size()); if (result.size() == 0) { Logger.trace("No entries found."); return null; } return result; } public static UserDatabase getUserWithID(long id) { MiscUtil.assertNotNull(id, "UserID"); Logger.trace("Getting Userinformation with ID " + id + " from database."); List<UserDatabase> result; EntityManager session = ConfigurationDBUtils.getCurrentSession(); javax.persistence.Query query = session.createQuery(QUERIES.get("getUserWithUserID")); query.setParameter("id", id); result = query.getResultList(); Logger.trace("Found entries: " + result.size()); if (result.size() == 0) { Logger.trace("No entries found."); return null; } return (UserDatabase) result.get(0); } public static UserDatabase getUsersWithOADBID(long id) { MiscUtil.assertNotNull(id, "OADBID"); Logger.trace("Getting Userinformation with OADBID " + id + " from database."); List<UserDatabase> result; EntityManager session = ConfigurationDBUtils.getCurrentSession(); javax.persistence.Query query = session.createQuery(QUERIES.get("getUsersWithOADBID")); query.setParameter("id", id); result = query.getResultList(); Logger.trace("Found entries: " + result.size()); if (result.size() == 0) { Logger.trace("No entries found."); return null; } return (UserDatabase) result.get(0); } public static UserDatabase getUserWithUserName(String username) { MiscUtil.assertNotNull(username, "UserName"); Logger.trace("Getting Userinformation with ID " + username + " from database."); List<UserDatabase> result; EntityManager session = ConfigurationDBUtils.getCurrentSession(); javax.persistence.Query query = session.createQuery(QUERIES.get("getUserWithUserUsername")); query.setParameter("username", username); result = query.getResultList(); Logger.trace("Found entries: " + result.size()); if (result.size() == 0) { Logger.trace("No entries found."); return null; } return (UserDatabase) result.get(0); } public static UserDatabase getUserWithUserBPKWBPK(String bpkwbpk) { MiscUtil.assertNotNull(bpkwbpk, "bpk/wbpk"); Logger.trace("Getting Userinformation with ID " + bpkwbpk + " from database."); List<UserDatabase> result; EntityManager session = ConfigurationDBUtils.getCurrentSession(); javax.persistence.Query query = session.createQuery(QUERIES.get("getUserWithUserBPKWBPK")); query.setParameter("bpk", bpkwbpk); result = query.getResultList(); Logger.trace("Found entries: " + result.size()); if (result.size() == 0) { Logger.trace("No entries found."); return null; } return (UserDatabase) result.get(0); } public static UserDatabase getNewUserWithTokken(String tokken) { MiscUtil.assertNotNull(tokken, "bpk/wbpk"); Logger.trace("Getting Userinformation with Tokken " + tokken + " from database."); List<UserDatabase> result; EntityManager session = ConfigurationDBUtils.getCurrentSession(); javax.persistence.Query query = session.createQuery(QUERIES.get("getNewUserWithUserTokken")); query.setParameter("tokken", tokken); result = query.getResultList(); Logger.trace("Found entries: " + result.size()); if (result.size() == 0) { Logger.trace("No entries found."); return null; } return (UserDatabase) result.get(0); } public static List<UserDatabase> getAllNewUsers() { Logger.trace("Get all new Users from Database"); List<UserDatabase> result; EntityManager session = ConfigurationDBUtils.getCurrentSession(); javax.persistence.Query query = session.createQuery(QUERIES.get("getAllNewUsers")); result = query.getResultList(); Logger.trace("Found entries: " + result.size()); if (result.size() == 0) { Logger.trace("No entries found."); return null; } return result; } public static List<UserDatabase> getAllOpenUsersRequests() { Logger.trace("Get all new Users from Database"); List<UserDatabase> result; EntityManager session = ConfigurationDBUtils.getCurrentSession(); javax.persistence.Query query = session.createQuery(QUERIES.get("getAllOpenUsersRequests")); result = query.getResultList(); Logger.trace("Found entries: " + result.size()); if (result.size() == 0) { Logger.trace("No entries found."); return null; } return result; } }