美文网首页
mybatis多参数传递到Mapper.xml中

mybatis多参数传递到Mapper.xml中

作者: 墨色尘埃 | 来源:发表于2017-12-08 16:15 被阅读0次

MyBatis多参数传递的四种方式

MyBatis3-传递多个参数（Multiple Parameters）

Mybatis传多个参数（四种解决方案）
据我目前接触到的传多个参数的方案有三种。
第一种方案：一个一个参数传递
DAO层的函数方法

User  selectUser(String name,String area);

对应的Mapper.xml

    <select id="selectUser" resultMap="BaseResultMap">
        SELECT
            *
        FROM
            user_user_t
        WHERE
            user_name = #{0} and
            user_area = #{1}
    </select>

其中，#{0}代表接收的是dao层中的第一个参数，#{1}代表dao层中第二参数，更多参数一致往后加即可。

第二种方案：采用Map传多参数
Dao层的函数方法

User  selectUser(Map paramMap);

对应的Mapper.xml

    <select id=" selectUser" resultMap="BaseResultMap">
        SELECT
            *
        FROM
            user_user_t
        WHERE
            user_name = #{userName，jdbcType=VARCHAR} 
        AND user_area = #{userArea,jdbcType=VARCHAR}
    </select>

Service层调用

    private User xxxSelectUser(){
        Map paramMap=new hashMap();
        paramMap.put(“userName”,”对应具体的参数值”);
        paramMap.put(“userArea”,”对应具体的参数值”);

        User user=xxx. selectUser(paramMap);
    }

个人认为此方法不够直观，见到接口方法不能直接的知道要传的参数是什么。

第三种方案：直接传递对象
Dao层的函数方法

int insert(WaterEle record);

对应的Mapper.xml

<!--测试-->
    <insert id="insert" parameterType="com.jsptpd.gayg.modules.cloud.model.WaterEle">
    insert into t_enterprise_water_ele (WATER_ELE_ID, ENTERPRISE_ID, ENTERPRISE_NAME, 
      YEARMONTH, WATER_SIZE, WATER_AMOUNT, 
      ELE_SIZE, ELE_AMOUNT, STATUS, 
      OPERATOR, OPERATE_TIME)
    values (#{waterEleId,jdbcType=VARCHAR}, #{enterpriseId,jdbcType=VARCHAR}, #{enterpriseName,jdbcType=VARCHAR},
      #{yearmonth,jdbcType=VARCHAR}, #{waterSize,jdbcType=DECIMAL}, #{waterAmount,jdbcType=VARCHAR}, 
      #{eleSize,jdbcType=DOUBLE}, #{eleAmount,jdbcType=VARCHAR}, #{status,jdbcType=INTEGER}, 
      #{operator,jdbcType=VARCHAR}, #{operateTime,jdbcType=TIMESTAMP})
  </insert>

Service层调用

    @RequestMapping(value = "", method = RequestMethod.POST)
    public ResponseObj<Boolean> insert(@RequestBody WaterEle waterEle) {

        //先查询是否有这条数据，没有进行插入操作
        WaterEle enterpriseBase1 = waterEleMapper.selectByPrimaryKey(waterEle.getWaterEleId());
        if (enterpriseBase1 == null) {

            waterEle.setWaterEleId(CommonUtil.getSysRef());
            waterEle.setEnterpriseId(CommonUtil.getSysRef());
            waterEle.setStatus(SysData.STATUS_NORMAL);
            waterEle.setOperateTime(DateUtil.getDateTime());

            int i = waterEleMapper.insertSelective(waterEle);
            if (i == 1)
                return new ResponseObj<Boolean>(true, RetCode.SUCCESS);
            return new ResponseObj<>(false, RetCode.FAIL);
        }
        return new ResponseObj<>(false, RetCode.FAIL);

    }

第四种方案：使用@Param标注
Dao层的函数方法

User selectUser(@Param(“userName”)String name,@Param(“userArea”)String area);

对应的Mapper.xml

    <select id=" selectUser" resultMap="BaseResultMap">
        SELECT
            *
        FROM
            user_user_t
        WHERE
            user_name = #{userName，jdbcType=VARCHAR} 
        AND user_area = #{userArea,jdbcType=VARCHAR}
    </select>

个人觉得这种方法比较好，能让开发者看到dao层方法就知道该传什么样的参数，比较直观，个人推荐用此种方案。

完整示例的Dao层接口

@Mapper
public interface OverViewMapper {

    int deleteByPrimaryKey(String enterpriseId);

    int insert(OverView record);

    int insertSelective(OverView record);

    OverView selectByPrimaryKey(String enterpriseId);

    int updateByPrimaryKeySelective(OverView record);

    int updateByPrimaryKey(OverView record);

    //
    List<Map<String, Object>> list(@Param("extraSql") String extraSql);

    List<Map<String, Object>> detail(@Param("enterpriseId") String enterpriseId);

    List<DynaTableField> tableName(@Param("dynaKey") String dynaKey);

    List<LinkedHashMap<String, Object>> overViewDetail(@Param("startTime") String startTime,
                                                       @Param("endTime") String endTime,
                                                       @Param("dynaKey") String dynaKey,
                                                       @Param("tableName") String tableName);


}

2018.7.2改
对于第四种方案，不管参数name/area是不是对象中的属性，都要加@Param("xx")才能有用！！否则报错。是对象中的属性，那么对于传入参数Map<>和Object是有用的。

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter 'userId' not found. Available parameters are [0, 1, param1, param2]
    at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:79)
    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:447)
    at com.sun.proxy.$Proxy67.delete(Unknown Source)
    at org.mybatis.spring.SqlSessionTemplate.delete(SqlSessionTemplate.java:311)
    at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)
    at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
    at com.sun.proxy.$Proxy106.deleteByUserId1(Unknown Source)
    at com.jsptpd.weixinserver.restcontrol.WeixinControl.getUserInfo(WeixinControl.java:102)
    at com.jsptpd.weixinserver.restcontrol.WeixinControl$$FastClassBySpringCGLIB$$120892ed.invoke(<generated>)
    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:721)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
    at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)
    at com.jsptpd.weixinserver.config.aop.LogConfig.print(LogConfig.java:103)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:483)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629)
    at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618)
    at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:656)
    at com.jsptpd.weixinserver.restcontrol.WeixinControl$$EnhancerBySpringCGLIB$$87781780.getUserInfo(<generated>)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:483)
    at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
    at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
    at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:116)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
    at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
    at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
    at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
    at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
    at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:105)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
    at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
    at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)
    at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:783)
    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:798)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1434)
    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.ibatis.binding.BindingException: Parameter 'userId' not found. Available parameters are [0, 1, param1, param2]
    at org.apache.ibatis.binding.MapperMethod$ParamMap.get(MapperMethod.java:186)
    at org.apache.ibatis.reflection.wrapper.MapWrapper.get(MapWrapper.java:45)
    at org.apache.ibatis.reflection.MetaObject.getValue(MetaObject.java:122)
    at org.apache.ibatis.scripting.defaults.DefaultParameterHandler.setParameters(DefaultParameterHandler.java:79)
    at org.apache.ibatis.executor.statement.PreparedStatementHandler.parameterize(PreparedStatementHandler.java:93)
    at org.apache.ibatis.executor.statement.RoutingStatementHandler.parameterize(RoutingStatementHandler.java:64)
    at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86)
    at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:49)
    at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
    at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.delete(DefaultSqlSession.java:213)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:483)
    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:434)
    ... 78 common frames omitted

相关文章

网友评论

      本文标题：mybatis多参数传递到Mapper.xml中

      本文链接：https://www.haomeiwen.com/subject/yoweixtx.html

      延伸阅读

      深度阅读

      • 您也可以注册成为美文阅读网的作者，发表您的原创作品、分享您的心情！

      栏目导航

      热点阅读

      关于我们|服务条款|联系我们|mybatis多参数传递到Mapper.xml中|投稿指南|网站地图|RSS订阅|排版工具|手机版

      提供经典美文摘抄,优美散文欣赏,现代诗歌精选,短篇小说,心情随笔,表白情书范文,故事会在线阅读欣赏

      Copyright © 2014-2023 Haomeiwen.com All Rights Reserved. 好美文阅读网 版权所有

      备案信息：桂公网安备 45052102000051号 · 桂ICP备13007215号-3

      本站所收录作品、热点评论等信息部分来源互联网，目的只是为了系统归纳学习和传递资讯

      所有作品版权归原创作者所有，与本站立场无关，如不慎侵犯了你的权益，请联系我们告知，我们将做删除处理！