Struts+Spring+Ibtis 2个MySQL5.0数据源配置

最新推荐文章于 2021-02-17 02:37:19 发布
最新推荐文章于 2021-02-17 02:37:19 发布
阅读量515 收藏 1
点赞数
分类专栏： JAVA技术 文章标签： mysql struts spring object string exception
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/hhj039/article/details/3042745
版权

 

/** *******************OptionObjectFactory******************* */

 

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;


import com.finet.bochk.common.distributed.dao.DistributedDBOperationDao;
import com.finet.bochk.common.distributed.dto.OperationResultDto;

/**
 * 保存数据控制类
 */
public class OptionObjectFactory
{
 private static ApplicationContext appContext;
 private static OptionObjectFactory instance;
 private static final String[] paths = {"db.xml"};//Constants.APP_DISTRIBUTED_DAO};
 DistributedDBOperationDao dao;
 private OptionObjectFactory()
    {
        appContext = new ClassPathXmlApplicationContext(paths);
        dao=(DistributedDBOperationDao)getBean("distributedDBOperationDao");
       
    }
 /**
     *
     *
     *
     */
    public static synchronized OptionObjectFactory getInstance()
    {
        if (instance == null)
        {
         instance = new OptionObjectFactory();
        }

        return instance;
    }
   
  
   
    public DistributedDBOperationDao getBean(String name)
    {
        return (DistributedDBOperationDao)appContext.getBean(name);
    }
   
 public OperationResultDto save(String sqlName,Object parameterObject)
 {
  return dao.save(sqlName,parameterObject);
 }
 
 public OperationResultDto update(String sqlName,Object parameterObject)
 {
  return dao.update(sqlName, parameterObject);
 }
 public OperationResultDto delete(String sqlName,Object parameterObject)
 {
  return dao.delete(sqlName, parameterObject);
 }
 public Object queryObject(String sqlName,Object parameterObject) 
 {
  return dao.queryObject(sqlName, parameterObject);
 }
 public OperationResultDto saveList(final String sqlName,final List parameterList)
 {
  return dao.saveList(sqlName, parameterList);
 }
 
 public OperationResultDto updateList(final String sqlName,final List parameterList)
 {
  return dao.updateList(sqlName, parameterList);
 }
}

 

/** *******************OperationResultDto******************* */

public class OperationResultDto implements java.io.Serializable,DataObjectInfo
{
 /**
  *
  */
 private static final long serialVersionUID = 1L;

 private String operationType; //返回类型
 
 private String operationResult; //返回结果
 
 private String resultInfo;   //返回结果信息
 
 private String exceptionInfo;  //异常信息
 
 private Map resultMap;   //返回结果集合
 
 private Object resultObject;  //返回结果对象

 public OperationResultDto(String operationResult)
 {
  this.operationResult=operationResult;
 }
 public OperationResultDto()
 {

 }
 public String getOperationType()
 {
  return operationType;
 }

 
 public void setOperationType(String operationType)
 {
  this.operationType = operationType;
 }

 
 public String getOperationResult()
 {
  return operationResult;
 }

 
 public void setOperationResult(String operationResult)
 {
  this.operationResult = operationResult;
 }

 
 public String getExceptionInfo()
 {
  return exceptionInfo;
 }

 
 public void setExceptionInfo(String exceptionInfo)
 {
  this.exceptionInfo = exceptionInfo;
 }


 
 public String getResultInfo()
 {
  return resultInfo;
 }


 
 public void setResultInfo(String resultInfo)
 {
  this.resultInfo = resultInfo;
 }


 
 public Map getResultMap()
 {
  return resultMap;
 }


 
 public void setResultMap(Map resultMap)
 {
  this.resultMap = resultMap;
 }


 
 public Object getResultObject()
 {
  return resultObject;
 }


 
 public void setResultObject(Object resultObject)
 {
  this.resultObject = resultObject;
 }
}

/** *******************DistributeDBOperationImpl(暂时将同时操作2个数据库的动作屏蔽，不过代码都已测试通过)******************* */

public  class DistributeDBOperationImpl extends GenericSqlMapImpl implements DistributedDBOperationDao
{
  private static JLogger log = LoggerFactory.getLogger(DistributeDBOperationImpl.class);
  private GenericSqlMapSubDao genericSqlMapSubDao;
  
  public OperationResultDto save(final String sqlName,final Object parameterObject)
  {
   
   OperationResultDto subDto=(OperationResultDto) saveInfoOfSubDatabase(sqlName,parameterObject);
//   if(!subDto.getOperationResult().equals(DataObjectInfo.OPERATION_SUB_DB_SUCCESS))
//   {
//    log.error(subDto.getResultInfo());
//    log.error(subDto.getExceptionInfo());
//    return subDto;
//   }
//   OperationResultDto childDto=(OperationResultDto) saveInfoOfChildDatabase(sqlName,parameterObject);
//   if(!childDto.getOperationResult().equals(DataObjectInfo.OPERATION_CHILD_DB_SUCCESS))
//   {
//    log.error(childDto.getResultInfo());
//    log.error(childDto.getExceptionInfo());
//    String deleteSql=sqlName.replace("insert", "delete");
//    this.deleteOfSubDatabase(deleteSql,parameterObject);
//    return childDto;
//   }
//   return childDto;
   return subDto;
  }

  public OperationResultDto update(final String sqlName,final Object parameterObject)
  {
   String querySqlName=sqlName.replace("update", "query");
   Object operationObj=this.queryObject(querySqlName, parameterObject);
   if(operationObj==null)
   {
    return new OperationResultDto(DataObjectInfo.OPERATION_SUB_DB_NULL);
   }
   OperationResultDto subDto=(OperationResultDto) updateInfoOfSubDatabase(sqlName,parameterObject);
//   if(!subDto.getOperationResult().equals(DataObjectInfo.OPERATION_SUB_DB_SUCCESS))
//   {
//    log.error(subDto.getResultInfo());
//    log.error(subDto.getExceptionInfo());
//    return subDto;
//   }
//   OperationResultDto childDto=(OperationResultDto) updateInfoOfChildDatabase(sqlName,parameterObject);
//   if(!childDto.getOperationResult().equals(DataObjectInfo.OPERATION_CHILD_DB_SUCCESS))
//   {
//    log.error(childDto.getResultInfo());
//    log.error(childDto.getExceptionInfo());
//    this.updateInfoOfSubDatabase(sqlName, operationObj);
//    return childDto;
//   }
//   return childDto;
   return subDto;
  }
  
  public OperationResultDto delete(final String sqlName,final Object parameterObject)
  {
   OperationResultDto subDto=(OperationResultDto) deleteOfSubDatabase(sqlName,parameterObject);
   if(!subDto.getOperationResult().equals(DataObjectInfo.OPERATION_SUB_DB_SUCCESS))
   {
//    log.error(subDto.getResultInfo());
//    log.error(subDto.getExceptionInfo());
    return subDto;
   }
//   OperationResultDto childDto=(OperationResultDto) deleteOfChildDatabase(sqlName,parameterObject);
//   if(!childDto.getOperationResult().equals(DataObjectInfo.OPERATION_CHILD_DB_SUCCESS))
//   {
//    log.error(childDto.getResultInfo());
//    log.error(childDto.getExceptionInfo());
//    String querySqlName=sqlName.replace("delete", "query");
//    this.saveInfoOfSubDatabase(sqlName,this.queryObjectOfChildDatabase(querySqlName, parameterObject));
//    return childDto;
//   }
//   return childDto;
   return subDto;
  }
  public Object queryObject(final String sqlName,final Object parameterObject)
  {
   Object subObj=queryObjectOfSubDatabase(sqlName,parameterObject);
   Object childObj=new Object();//queryObjectOfChildDatabase(sqlName,parameterObject);
   if(subObj!=null&&childObj!=null)
   {
    return subObj;
   }
   else
   {
    return null;
   }
  }
  public OperationResultDto deleteOfSubDatabase(String sqlName, Object parameterObject)
  {
   OperationResultDto dto=new OperationResultDto();
   try
   {
     genericSqlMapSubDao.getSqlMapClientTemplateSub().delete(sqlName, parameterObject);
     dto.setOperationResult(DataObjectInfo.OPERATION_SUB_DB_SUCCESS);
   }
   catch (Exception e)
   {
    // TODO Auto-generated catch block
    //e.printStackTrace();
    dto.setOperationResult(DataObjectInfo.OPERATION_SUB_DB_FAILD);
    dto.setExceptionInfo(e.getMessage());
    log.error(e.getMessage(),e);
   }
   
   return dto;
  }
  
  public OperationResultDto deleteOfChildDatabase(String sqlName,Object parameterObject)
  {
   OperationResultDto dto=new OperationResultDto();
   try
   {
    this.smcTemplate.delete(sqlName, parameterObject);
    dto.setOperationResult(DataObjectInfo.OPERATION_CHILD_DB_SUCCESS);
   }
   catch (Exception e)
   {
    // TODO Auto-generated catch block
    //e.printStackTrace();
    dto.setOperationResult(DataObjectInfo.OPERATION_CHILD_DB_FAILD);
    dto.setExceptionInfo(e.getMessage());
    log.error(e.getMessage(),e);
   }
   
   return dto;
  }

  public OperationResultDto saveInfoOfSubDatabase(String sqlName,Object parameterObject)
  {
   OperationResultDto dto=new OperationResultDto();
   try
   {
    genericSqlMapSubDao.getSqlMapClientTemplateSub().insert(sqlName, parameterObject);
       
    dto.setOperationResult(DataObjectInfo.OPERATION_SUB_DB_SUCCESS);
   }
   catch (Exception e)
   {
    // TODO Auto-generated catch block
    e.printStackTrace();
    dto.setOperationResult(DataObjectInfo.OPERATION_SUB_DB_FAILD);
    dto.setExceptionInfo(e.getMessage());
    log.error(e.getMessage(),e);
   }
   
   return dto;
  }
  
  public OperationResultDto saveInfoOfChildDatabase(String sqlName,Object parameterObject)
  {
   OperationResultDto dto=new OperationResultDto();
   try
   {
    this.smcTemplate.insert(sqlName, parameterObject);
    dto.setOperationResult(DataObjectInfo.OPERATION_CHILD_DB_SUCCESS);
   }
   catch (Exception e)
   {
    // TODO Auto-generated catch block
    //e.printStackTrace();
    
    dto.setOperationResult(DataObjectInfo.OPERATION_CHILD_DB_FAILD);
    dto.setExceptionInfo(e.getMessage());
    log.error(e.getMessage(),e);
   }
   
   return dto;
  }
  
  public OperationResultDto updateInfoOfSubDatabase(String sqlName,Object parameterObject)
  {
   OperationResultDto dto=new OperationResultDto();
   try
   {
    genericSqlMapSubDao.getSqlMapClientTemplateSub().update(sqlName, parameterObject);
    dto.setOperationResult(DataObjectInfo.OPERATION_SUB_DB_SUCCESS);
   }
   catch (Exception e)
   {
    // TODO Auto-generated catch block
    dto.setOperationResult(DataObjectInfo.OPERATION_SUB_DB_FAILD);
    dto.setExceptionInfo(e.getMessage());
    log.error(e.getMessage(),e);
   }
   
   return dto;
  }
  
  public OperationResultDto updateInfoOfChildDatabase(String sqlName,Object parameterObject)
  {
   OperationResultDto dto=new OperationResultDto();
   try
   {

    this.smcTemplate.insert(sqlName, parameterObject);

    dto.setOperationResult(DataObjectInfo.OPERATION_CHILD_DB_SUCCESS);
   }
   catch (Exception e)
   {
    // TODO Auto-generated catch block
    //e.printStackTrace();
    dto.setOperationResult(DataObjectInfo.OPERATION_CHILD_DB_FAILD);
    dto.setExceptionInfo(e.getMessage());
    log.error(e.getMessage(),e);
   }
   
   return dto;
  }
  
  public Object queryObjectOfSubDatabase(String sqlName,Object parameterObject)
  {
   try
   {
    return genericSqlMapSubDao.getSqlMapClientTemplateSub().queryForObject(sqlName, parameterObject);
    
   }
   catch (Exception e)
   {
    // TODO Auto-generated catch block
    //e.printStackTrace();
    log.error(e.getMessage());
    return null;
   }
   
  }
  
  public Object queryObjectOfChildDatabase(String sqlName,Object parameterObject)
  {
   try
   {
    return this.smcTemplate.queryForObject(sqlName, parameterObject);

   }
   catch (Exception e)
   {
    // TODO Auto-generated catch block
    //e.printStackTrace();
    log.error(e.getMessage(),e);
    return null;
   }
  }
  
  public GenericSqlMapSubDao getGenericSqlMapSubDao()
  {
   return genericSqlMapSubDao;
  }

  
  public void setGenericSqlMapSubDao(GenericSqlMapSubDao genericSqlMapSubDao)
  {
   this.genericSqlMapSubDao = genericSqlMapSubDao;
  }
  
  public OperationResultDto saveList(final String sqlName,final List parameterList)
  {
   List tempList=new ArrayList();
   OperationResultDto result=null;
   boolean flag=false;
   for (Iterator iter = parameterList.iterator(); iter.hasNext();)
   {
    Object object=iter.next();
    result=this.save(sqlName, object);
    if(result.getResultInfo().equals(DataObjectInfo.OPERATION_CHILD_DB_SUCCESS))
    {
     tempList.add(object);
    }
    else
    {
     flag=true;
     break;
    }
   }
   if(flag&&tempList.size()>0)
   {
    String tempSqlName=sqlName.replace("insert", "delete");
    for (Iterator iters = tempList.iterator(); iters.hasNext();)
    {
     Object tempObject=iters.next();
     this.delete(tempSqlName, tempObject);
    }
   }
   return result;
  }
  
  public OperationResultDto updateList(final String sqlName,final List parameterList)
  {
   List tempList=new ArrayList();
   OperationResultDto result=null;
   boolean flag=false;
   for (Iterator iter = parameterList.iterator(); iter.hasNext();)
   {
    Object object=iter.next();
    result=this.update(sqlName, object);
    if(result.getResultInfo().equals(DataObjectInfo.OPERATION_CHILD_DB_SUCCESS))
    {
     tempList.add(object);
    }
    else
    {
     flag=true;
     break;
    }
   }
   if(flag&&tempList.size()>0)
   {
    for (Iterator iter = tempList.iterator(); iter.hasNext();)
    {
     Object tempObject=iter.next();
     this.update(sqlName, tempObject);
    }
   }
   return result;
  }
}

/** *******************GenericSqlMapSubImpl*********************** */

public class GenericSqlMapSubImpl extends SqlMapClientDaoSupport implements GenericSqlMapSubDao
{
 
 public SqlMapClientTemplate getSqlMapClientTemplateSub()
 {
  return this.getSqlMapClientTemplate();
 }
}

 

/** *******************db.xml*********************** */

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">

 

<beans>

 <bean id="dataSourceChild"

  class="org.apache.commons.dbcp.BasicDataSource"

  destroy-method="close">

  <property name="driverClassName">

   <value>com.mysql.jdbc.Driver</value>

  </property>

  <property name="url">

   <value>jdbc:mysql://192.168.80.201:3306/bochk</value>

  </property>

  <property name="username">

   <value>syncadm</value>

  </property>

  <property name="password">

   <value>Xpu=6MJu</value>

  </property>

 </bean>

 

 <bean id="sqlMapClientChild"

  class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">

  <property name="configLocation">

   <value>classpath:orm/sql-map-config.xml</value>

  </property>

  <property name="dataSource">

   <ref bean="dataSourceChild" />

  </property>

 </bean>

 

 <bean id="dataSourceSub"

  class="org.apache.commons.dbcp.BasicDataSource"

  destroy-method="close">

  <property name="driverClassName">

   <value>com.mysql.jdbc.Driver</value>

  </property>

  <property name="url">

   <value>jdbc:mysql://dbserver.finet.com.hk:3306/boctest</value>

  </property>

  <property name="username">

   <value>finet_boc</value>

  </property>

  <property name="password">

   <value>bochkzaq12wsx</value>

  </property>

 </bean>

 <bean id="sqlMapClientSub"

  class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">

  <property name="configLocation">

   <value>classpath:orm/sql-map-config.xml</value>

  </property>

  <property name="dataSource">

   <ref bean="dataSourceSub" />

  </property>

 </bean>

 <bean id="genericSqlMapSubDao"

  class="com.finet.bochk.common.distributed.dao.impl.GenericSqlMapSubImpl">

  <property name="sqlMapClient">

   <ref bean="sqlMapClientSub" />

  </property> 

 </bean>

 <bean id="distributedDBOperationDao"

  class="com.finet.bochk.common.distributed.dao.impl.DistributeDBOperationImpl">

  <property name="sqlMapClient">

   <ref bean="sqlMapClientChild" />

  </property> 

  <property name="genericSqlMapSubDao">

   <ref bean="genericSqlMapSubDao" />

  </property> 

 </bean>

</beans>

 

关于Ibtis的配置就不拷贝了，不过insert/update/delete/query是各个对应SQL的ID开头

hhj112
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
spring+ibtis框架
11-30
2. **Spring配置** - **上下文配置**：`context-param`标签中的`param-value`值指定了Spring配置文件的路径，例如`web-context-zh-service.xml`和`web-context-zh-dao.xml`，这些文件会定义服务层和数据访问层的...
java开发工具类
07-09
ibtis2中文文档 j2eeAPI Android 中文API合集 css 3.0 fastjson 1.1.26 hibernate3.2 ibatis SqlMaps JDK 1.6 jQuery 选择器 JScript 8.0 Linux 命令大全 OGNL帮助文档 Spring2.5中文参考手册 struts2-tags-API ...
Struts+Ibtis+Spring整合基础案例
ITpengcheng的专栏
05-30 974
此案例是用Java Web创建，是Struts2+Ibatis+Spring的基础案例，是基础的整合。登录页面login.jsp提交后有UserAction控制，调用Service，Service调用DAO层，Dao中会调用Ibtis的Mapper类。 Spring核心配置 applicationContext.xml http://www.springframework.org/sch
flex3+struts 1.3+spring+ibatis 2.x整合代码实例
云淡风轻、仅此一抹
05-12 1967
flex3+struts 1.3+spring+ibatis 2.x整合代码实例,代码下载地址：http://www.zuidaima.com/share/1778657261997056.htm
JAVAWEB 一一框架整合（SSI : Spring+SpringMVC+ ibtis）
weixin_30767921的博客
11-17 51
web.xml applicationContext.xml springmvc-servlet.xml UserController package com.ssi.controller; import org.springframework.beans.factory.annotation.Autowired; import org.springfram...
java if 中ibt_JAVAWEB 一一框架整合（SSI : Spring+SpringMVC+ ibtis）
weixin_28974985的博客
02-17 92
web.xmlapplicationContext.xmlspringmvc-servlet.xmlUserControllerpackage com.ssi.controller;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controlle...
同城活动底层服务层
11-08
同城活动中的服务层，运用ibtis+spring,具有一定的代表性
springmvc与ibatis 完整项目骨架代码生成工具x64 Jar
09-29
基于springmvc与ibatis 整合的swt/jface实现一键化自动生成 model、dao、service代码 以及spring web配置文件，并实现了事务。此工具源码请关注https://gitee.com/00fly/springmvc_ibatis_plus
Apache Mina使用示例
11-09 3586
 1.import mina-core-2.0.0-RC1.jar slf4j-jdk14-1.5.9.RC1.jar slf4j-api-1.5.9.RC1.jar3个包。mina包可以到http://mina.apache.org/downloads.html中去下载，下载完后用mvn package命令编译mina-core目录下的文件就可以得到(必须安装了maven包)。slf4j的包可以
SNMP使用示例
01-20 1358
import java.io.IOException;import java.net.UnknownHostException;import java.util.Vector;import org.snmp4j.CommandResponder;import org.snmp4j.CommandResponderEvent;import org.snmp4j.MessageDispatcherIm
FTP服务器上传下载文件(edtftpj-pro-2.1.2)
12-01 1284
--目录文件处理类--import java.io.FileFilter;import java.io.IOException;import com.enterprisedt.net.ftp.FTPClient;import com.enterprisedt.net.ftp.FTPException;import com.enterprisedt.net.ftp.pro.ProFTPClient;
linux服务器导出MYSQL中指定表中2年前的数据
08-02 1170
linux服务器导出MYSQL中指定表中2年前的数据
ThreadPoolExecutor的使用
04-21 968
public void execute()    {        //获取一个任务编号        Long taskIndex=Constants.getTaskIndex();        DateFormat df=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");        log.warn("[taskName="+taskIndex+"]
关于URLClassLoader的使用
11-11 654
  今天在看了天涯中classLoader的一篇文章后，自己实际应用了一下URLClassLoader,发现项目中如果想实现一些Application级的信息同步，这个类将是一切的基础。就将自己试用的代码保存下来。  现在是假想在BOC项目中有个InitServlet,如果要自己动态加载这个Servlet就需要在初始化的时候创建一个自己的ClassLoader,下面是创建这个ClassLoader
测试HttpsURLConnection使用
11-12 558
public class Test extends Thread{        String URL_STRING="https://www.sun.com";        long timeCount=0;        long timeStart=0;        long timeEnd=0;        public void run()        {            
找出网页中所有超连接的href内容
11-05 361
 public static void main(String[] args)    {        //找出网页中所有超连接的href内容        InputStream is = CommonUtil.getStream("http://cto.csdn.net/");        String regex = "(?        byte[] bytes =
ProcessBuilder示例
10-09 359
 try            {                //创建一个进程示例                ProcessBuilder pb = new ProcessBuilder("cmd.exe");                //获取系统参数并打印显示                Map env = pb.environment();                Ite
iBATIS 持久层框架详解及入门指南
"ibtis学习资料，涵盖了iBATIS的基本信息，包括起源、特点、适用场景以及快速入门步骤。" iBATIS是一个基于Java的持久层框架，起源于2001年，由Clinton Begin发起，最初专注于密码软件的开发。随着时间的发展，它...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值