java mapper control_mybatis多参数传递到Mapper.xml中

最新推荐文章于 2023-01-26 20:42:22 发布

weixin_39627481

最新推荐文章于 2023-01-26 20:42:22 发布

阅读量451

点赞数

文章标签： java mapper control

本文链接：https://blog.csdn.net/weixin_39627481/article/details/115071328

版权

Mybatis传多个参数(四种解决方案)

据我目前接触到的传多个参数的方案有三种。

第一种方案：一个一个参数传递

DAO层的函数方法

User selectUser(String name,String area);

对应的Mapper.xml

SELECT

FROM

user_user_t

WHERE

user_name = #{0} and

user_area = #{1}

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

第二种方案：采用Map传多参数

Dao层的函数方法

User selectUser(Map paramMap);

对应的Mapper.xml

SELECT

FROM

user_user_t

WHERE

user_name = #{userName，jdbcType=VARCHAR}

AND user_area = #{userArea,jdbcType=VARCHAR}

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 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})

Service层调用

@RequestMapping(value = "", method = RequestMethod.POST)

public ResponseObj 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(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

FROM

user_user_t

WHERE

user_name = #{userName，jdbcType=VARCHAR}

AND user_area = #{userArea,jdbcType=VARCHAR}

个人觉得这种方法比较好，能让开发者看到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> list(@Param("extraSql") String extraSql);

List> detail(@Param("enterpriseId") String enterpriseId);

List tableName(@Param("dynaKey") String dynaKey);

List> 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()

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()

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)