123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128 |
- /*
- * This program is free software: you can redistribute it and/or modify it under
- * the terms of the GNU General Public License as published by the Free Software
- * Foundation, either version 3 of the License, or (at your option) any later
- * version.
- *
- * This program 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 GNU General Public License for more
- * details.
- *
- * You should have received a copy of the GNU General Public License along with
- * this program. If not, see <http://www.gnu.org/licenses/>.
- */
- package com.l2jserver.gameserver.instancemanager;
- import java.sql.Connection;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.util.Map;
- import java.util.logging.Logger;
- import javolution.util.FastMap;
- import com.l2jserver.L2DatabaseFactory;
- public class GlobalVariablesManager
- {
- private static final Logger _log = Logger.getLogger(GlobalVariablesManager.class.getName());
-
- private static final String LOAD_VAR = "SELECT var,value FROM global_variables";
- private static final String SAVE_VAR = "INSERT INTO global_variables (var,value) VALUES (?,?) ON DUPLICATE KEY UPDATE value=?";
-
- private final Map<String, String> _variablesMap;
-
- private GlobalVariablesManager()
- {
- _variablesMap = new FastMap<String, String>();
-
- loadVars();
- }
-
- private final void loadVars()
- {
- Connection con = null;
- try
- {
- con = L2DatabaseFactory.getInstance().getConnection();
- PreparedStatement statement = con.prepareStatement(LOAD_VAR);
- ResultSet rset = statement.executeQuery();
-
- String var, value;
- while (rset.next())
- {
- var = rset.getString(1);
- value = rset.getString(2);
-
- _variablesMap.put(var, value);
- }
-
- rset.close();
- statement.close();
- }
- catch (Exception e)
- {
- _log.warning("GlobalVariablesManager: problem while loading variables: " + e);
- }
- finally
- {
- L2DatabaseFactory.close(con);
- }
- }
-
- public final void saveVars()
- {
- Connection con = null;
- PreparedStatement statement = null;
- try
- {
- con = L2DatabaseFactory.getInstance().getConnection();
- statement = con.prepareStatement(SAVE_VAR);
- for(String var : _variablesMap.keySet())
- {
- statement.setString(1, var);
- statement.setString(2, _variablesMap.get(var));
- statement.setString(3, _variablesMap.get(var));
- statement.execute();
- }
- statement.close();
- _log.info("GlobalVariablesManager: Database updated.");
- }
- catch (Exception e)
- {
- _log.warning("GlobalVariablesManager: problem while saving variables: " + e);
- }
- finally
- {
- L2DatabaseFactory.close(con);
- }
- }
-
- public void storeVariable(String var, String value)
- {
- _variablesMap.put(var, value);
- }
-
- public boolean isVariableStored(String var)
- {
- return _variablesMap.containsKey(var);
- }
-
- public String getStoredVariable(String var)
- {
- return _variablesMap.get(var);
- }
-
- public static final GlobalVariablesManager getInstance()
- {
- return SingletonHolder._instance;
- }
-
- @SuppressWarnings("synthetic-access")
- private static class SingletonHolder
- {
- protected static final GlobalVariablesManager _instance = new GlobalVariablesManager();
- }
- }
|