--- /dev/null
+/*******************************************************************************
+ * Copyright � Igor Barma, Alexandre Desoubeaux, Christian Martel, Eric Brun, Mathieu Amblard, Gwenael Gevet, Pierre Guillot, 2012
+ * Copyright Alexandre Desoubeaux, Christian Martel, Cedric Lecarpentier, Alexandre Lefevre, Marc Salvat 2014-2016
+ * Copyright Alexandre Desoubeaux, Christian Martel, Cedric Lecarpentier, Marc Salvat, Marc Suarez, Harifetra Ramamonjy 2017
+ *
+ * This file is part of the work and learning management system Pentila Nero.
+ *
+ * Pentila Nero is free software. You can redistribute it and/or modify since
+ * you respect the terms of either (at least one of the both license) :
+ * - under the terms of the GNU Affero General Public License as
+ * published by the Free Software Foundation, either version 3 of the
+ * License, or (at your option) any later version.
+ * - the CeCILL-C as published by CeCILL-C; either version 1 of the
+ * License, or any later version
+ * - the GNU Lesser General Public License as published by the
+ * Free Software Foundation, either version 3 of the license,
+ * or (at your option) any later version.
+ *
+ * There are special exceptions to the terms and conditions of the
+ * licenses as they are applied to this software. View the full text of
+ * the exception in file LICENSE-PROJECT.txt in the directory of this software
+ * distribution.
+ *
+ * Pentila Nero is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * Licenses for more details.
+ *
+ * You should have received a copy of the GNU Affero General Public License
+ * and the CeCILL-C and the GNU Lesser General Public License along with
+ * Pentila Nero. If not, see :
+ * <http://www.gnu.org/licenses/> and
+ * <http://www.cecill.info/licences.fr.html>.
+ ******************************************************************************/
+package com.pentila.entSavoie.portlets.gestionUtilisateurs;
+
+import java.sql.Connection;
+import java.sql.DriverManager;
+import java.sql.ResultSet;
+import java.sql.ResultSetMetaData;
+import java.sql.SQLException;
+import java.sql.Statement;
+
+import javax.naming.Context;
+import javax.naming.InitialContext;
+import javax.sql.DataSource;
+
+import com.pentila.entSavoie.utils.ENTMainUtilsLocalServiceUtil;
+
+
+
+public class UserManagementUtil {
+
+ public static Connection getDBConnection() throws SQLException {
+
+ try {
+ Class.forName("com.mysql.jdbc.Driver");
+ } catch (ClassNotFoundException e) {
+ e.printStackTrace();
+ }
+
+ // Get entlog database url + user + password (read in portal-ext.properties)
+ String entlogUrl = ENTMainUtilsLocalServiceUtil.getJdbcEntlogUrl();
+ String entlogUser = ENTMainUtilsLocalServiceUtil.getJdbcEntlogUser();
+ String entlogPasswd = ENTMainUtilsLocalServiceUtil.getJdbcEntlogPasswd();
+
+ // Setup the connection with the DB
+ Connection connect = DriverManager.getConnection(entlogUrl + "?user=" + entlogUser + "&password=" + entlogPasswd);
+
+ return connect;
+ }
+
+ public static void closeDBConnection(Connection conn) throws SQLException {
+ conn.close();
+ }
+
+ public static String getPassword(String login, Connection conn){
+ try {
+
+ boolean needClose = false;
+ if (conn == null) {
+ conn = getDBConnection();
+ needClose = true;
+ }
+
+ Statement request = conn.createStatement();
+
+ String sql = "SELECT * FROM operation o WHERE o.login='" + login + "' AND o.type=0";
+
+ ResultSet result = request.executeQuery(sql);
+ ResultSetMetaData resmd = result.getMetaData();
+
+ String password = "Aucun";
+
+ while(result.next()){
+ password = result.getString(resmd.getColumnLabel(10));
+ }
+
+ request.close();
+
+ if (needClose) {
+ conn.close();
+ }
+
+
+ return password;
+
+ } catch (SQLException e) {
+ // TODO Auto-generated catch block
+ e.printStackTrace();
+ }
+ return "";
+ }
+
+
+}