com.aspire.nm.component.common.mobile.Strategy.Impl.MySqlLoader Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of commonUtil Show documentation
Show all versions of commonUtil Show documentation
commonUtil is a dajiangnan's java utils
package com.aspire.nm.component.common.mobile.Strategy.Impl;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import org.apache.log4j.Logger;
import com.aspire.nm.component.common.mobile.MobileUtil;
import com.aspire.nm.component.common.mobile.Strategy.LoadStrategy;
import com.aspire.nm.component.common.mobile.Strategy.Impl.db.black.Black;
import com.aspire.nm.component.common.mobile.Strategy.Impl.db.legalPerfix.LegalPerfix;
import com.aspire.nm.component.common.mobile.Strategy.Impl.db.segment.SegMent;
import com.aspire.nm.component.common.mobile.Strategy.Impl.db.switchs.Swithchs;
import com.aspire.nm.component.common.mobile.Strategy.Impl.db.update.UpdateTimes;
import com.aspire.nm.component.commonUtil.constants.ConstantConfig;
import com.aspire.nm.component.commonUtil.date.DateUtil;
import com.aspire.nm.component.commonUtil.db.DBConnectionManager;
import com.aspire.nm.component.commonUtil.db.Db;
import com.aspire.nm.component.commonUtil.log.BootLogger;
public class MySqlLoader implements LoadStrategy{
private static DBConnectionManager dBConnectionManager = null;
private static Db db = new Db();
private static Logger logger = Logger.getLogger(MobileUtil.class);
private static Logger bootLogger = Logger.getLogger(BootLogger.class);
public MySqlLoader(String jdbcConfigPath){
dBConnectionManager = new DBConnectionManager(jdbcConfigPath);
Connection con = dBConnectionManager.getConnection("mysql");
try{
db.saveOrUpdateOrDelete(ConstantConfig.getContentValue("config/sql/create/updateMobile.sql"), null, con);
bootLogger.debug("create updateMobile");
db.saveOrUpdateOrDelete("insert common_update_mobile(table_name,update_time) values ('"+UpdateTimes.TABLE_NAME_BLACK+"',?)", new Object[]{DateUtil.getCurDateTime()}, con);
db.saveOrUpdateOrDelete("insert common_update_mobile(table_name,update_time) values ('"+UpdateTimes.TABLE_NAME_LEGALPERFIX+"',?)", new Object[]{DateUtil.getCurDateTime()}, con);
db.saveOrUpdateOrDelete("insert common_update_mobile(table_name,update_time) values ('"+UpdateTimes.TABLE_NAME_SEGMENT+"',?)", new Object[]{DateUtil.getCurDateTime()}, con);
db.saveOrUpdateOrDelete("insert common_update_mobile(table_name,update_time) values ('"+UpdateTimes.TABLE_NAME_SWITCH+"',?)", new Object[]{DateUtil.getCurDateTime()}, con);
bootLogger.debug("init updateMobile");
}catch(Exception e){
if(e.toString().indexOf("already exists") != -1){
bootLogger.debug("exist update");
}else{
bootLogger.error(e);
e.printStackTrace();
}
}
try{
db.saveOrUpdateOrDelete(ConstantConfig.getContentValue("config/sql/create/legalperfix.sql"), null, con);
bootLogger.debug("create legalperfix");
db.saveOrUpdateOrDelete("insert common_mobile_legalperfix(mobile,cmcc_mobile,ctcc_mobile,cucc_mobile) values (?,?,?,?)",
new Object[]{"13,14,15,18","134,135,136,137,138,139,147,150,151,152,157,158,159,178,182,183,187,188","133,153,177,180,189,181","130,131,132,145,155,156,176,185,186"}, con);
bootLogger.debug("init legalperfix");
}catch(Exception e){
if(e.toString().indexOf("already exists") != -1){
bootLogger.debug("exist legalperfix");
}else{
bootLogger.error(e);
e.printStackTrace();
}
}
try{
db.saveOrUpdateOrDelete(ConstantConfig.getContentValue("config/sql/create/segment.sql"), null, con);
bootLogger.debug("create segment");
}catch(Exception e){
if(e.toString().indexOf("already exists") != -1){
bootLogger.debug("exist segment");
}else{
bootLogger.error(e);
e.printStackTrace();
}
}
try{
db.saveOrUpdateOrDelete(ConstantConfig.getContentValue("config/sql/create/black.sql"), null, con);
bootLogger.debug("create black");
}catch(Exception e){
if(e.toString().indexOf("already exists") != -1){
bootLogger.debug("exist black");
}else{
bootLogger.error(e);
e.printStackTrace();
}
}
try{
db.saveOrUpdateOrDelete(ConstantConfig.getContentValue("config/sql/create/switch.sql"), null, con);
bootLogger.debug("create switch");
}catch(Exception e){
if(e.toString().indexOf("already exists") != -1){
bootLogger.debug("exist switch");
}else{
logger.error(e);
e.printStackTrace();
}
}
dBConnectionManager.freeConnection("mysql", con);
}
@Override
public UpdateTimes getUpdateTimes() {
UpdateTimes updateTimes = new UpdateTimes();
Connection con = dBConnectionManager.getConnection("mysql");
List> result;
try {
result = db.query(ConstantConfig.getContentValue("config/sql/query/updateMobile.sql"), null, con);
} catch (SQLException e) {
e.printStackTrace();
return null;
}
for(Map map : result){
if(((String)map.get("table_name")).equals(UpdateTimes.TABLE_NAME_BLACK)){
updateTimes.setUpdateBlackTime((String)map.get("update_time"));
}
if(((String)map.get("table_name")).equals(UpdateTimes.TABLE_NAME_LEGALPERFIX)){
updateTimes.setUpdateLegalPerfixTime((String)map.get("update_time"));
}
if(((String)map.get("table_name")).equals(UpdateTimes.TABLE_NAME_SEGMENT)){
updateTimes.setUpdateSegmentTime((String)map.get("update_time"));
}
if(((String)map.get("table_name")).equals(UpdateTimes.TABLE_NAME_SWITCH)){
updateTimes.setUpdateSwitchTime((String)map.get("update_time"));
}
}
dBConnectionManager.freeConnection("mysql", con);
return updateTimes;
}
@Override
public List loadSegMents() {
List list = new ArrayList();
Connection con = dBConnectionManager.getConnection("mysql");
List> result;
try {
result = db.query(ConstantConfig.getContentValue("config/sql/query/segment.sql"), null, con);
} catch (SQLException e) {
logger.error(e);
e.printStackTrace();
return null;
}
for(Map map : result){
SegMent segMent = new SegMent(
(String)map.get("segment"),
(String)map.get("province"),
(String)map.get("province_code"),
(String)map.get("city"),
(String)map.get("city_code"),
(String)map.get("mmsc_id"));
list.add(segMent);
}
dBConnectionManager.freeConnection("mysql", con);
return list;
}
@Override
public List loadBlacks() {
List list = new ArrayList();
Connection con = dBConnectionManager.getConnection("mysql");
List> result;
try {
result = db.query(ConstantConfig.getContentValue("config/sql/query/black.sql"), null, con);
} catch (SQLException e) {
logger.error(e);
e.printStackTrace();
return null;
}
for(Map map : result){
Black black = new Black((String)map.get("terminal"),(String)map.get("desc"));
list.add(black);
}
dBConnectionManager.freeConnection("mysql", con);
return list;
}
@Override
public List loadSwithchs() {
List list = new ArrayList();
Connection con = dBConnectionManager.getConnection("mysql");
List> result;
try {
result = db.query(ConstantConfig.getContentValue("config/sql/query/switch.sql"), null, con);
} catch (SQLException e) {
logger.error(e);
e.printStackTrace();
return null;
}
for(Map map : result){
Swithchs swithchs = new Swithchs((String)map.get("terminal"),(Integer)map.get("type"));
list.add(swithchs);
}
dBConnectionManager.freeConnection("mysql", con);
return list;
}
@Override
public LegalPerfix loadLegalPerfix() {
LegalPerfix legalPerfix = new LegalPerfix();
Connection con = dBConnectionManager.getConnection("mysql");
List> result;
try {
result = db.query(ConstantConfig.getContentValue("config/sql/query/legalperfix.sql"), null, con);
} catch (SQLException e) {
logger.error(e);
e.printStackTrace();
return null;
}
for(Map map : result){
legalPerfix.setPerfix_legal_mobile(((String)map.get("mobile")).split(","));
legalPerfix.setPerfix_legal_cmcc_mobile(((String)map.get("cmcc_mobile")).split(","));
legalPerfix.setPerfix_legal_ctcc_mobile(((String)map.get("ctcc_mobile")).split(","));
legalPerfix.setPerfix_legal_cucc_mobile(((String)map.get("cucc_mobile")).split(","));
}
dBConnectionManager.freeConnection("mysql", con);
return legalPerfix;
}
}