com.hangum.tadpole.commons.sql/src/com/hangum/tadpole/engine/query/sql/TadpoleSystemQuery.java

   1 /*******************************************************************************
   2  * Copyright (c) 2013 hangum.
   3  * All rights reserved. This program and the accompanying materials
   4  * are made available under the terms of the GNU Lesser Public License v2.1
   5  * which accompanies this distribution, and is available at
   6  * http://www.gnu.org/licenses/old-licenses/gpl-2.0.html
   7  *
   8  * Contributors:
   9  *     hangum - initial API and implementation
  10  ******************************************************************************/
  11 package com.hangum.tadpole.engine.query.sql;
  12
  13 import java.sql.SQLException;
  14
  15 import org.apache.log4j.Logger;
  16
  17 import com.hangum.tadpole.commons.exception.TadpoleSQLManagerException;
  18 import com.hangum.tadpole.commons.libs.core.define.SystemDefine;
  19 import com.hangum.tadpole.engine.initialize.TadpoleEngineUserDB;
  20 import com.hangum.tadpole.engine.manager.TadpoleSQLManager;
  21 import com.hangum.tadpole.engine.query.dao.system.TadpoleSystemDAO;
  22 import com.ibatis.sqlmap.client.SqlMapClient;
  23
  24 /**
  25  * Tadpole System query
  26  *
  27  * @author hangum
  28  *
  29  */
  30 public class TadpoleSystemQuery {
  31         /**
  32          * Logger for this class
  33          */
  34         private static final Logger logger = Logger.getLogger(TadpoleSystemQuery.class);
  35
  36         /**
  37          * 운영중인 시스템 정보를 얻습니다.
  38          *
  39          * @return
  40          * @throws TadpoleSQLManagerException, SQLException
  41          */
  42         public static TadpoleSystemDAO getSystemInfo() throws TadpoleSQLManagerException, SQLException {
  43                 SqlMapClient sqlClient = TadpoleSQLManager.getInstance(TadpoleEngineUserDB.getUserDB());
  44                 return (TadpoleSystemDAO)sqlClient.queryForObject("system_information");
  45         }
  46
  47         /**
  48          * update system information
  49          *
  50          * @param useType
  51          * @throws TadpoleSQLManagerException, SQLException
  52          */
  53         public static void updateSystemInformation(String useType) throws TadpoleSQLManagerException, SQLException {
  54                 TadpoleSystemDAO dao = new TadpoleSystemDAO(SystemDefine.getProductName(), SystemDefine.DBHUB_MAJOR_VERSION, SystemDefine.DBHUB_SUB_VERSION, SystemDefine.INFORMATION, useType);
  55
  56                 SqlMapClient sqlClient = TadpoleSQLManager.getInstance(TadpoleEngineUserDB.getUserDB());
  57                 sqlClient.update("update_system", dao);
  58         }
  59
  60 }