首页 新闻 搜索 专区 学院

mybatis java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for

0
[待解决问题]

 

DAO

 1 package com.cmbc.dao;
 2 
 3 import com.cmbc.po.Shopcart;
 4 import org.springframework.stereotype.Repository;
 5 
 6 import java.util.List;
 7 
 8 @Repository("shopcartDao")
 9 public interface ShopcartMapper {
10     int deleteByPrimaryKey(Integer shopcardId);
11 
12     int insert(Shopcart record);
13 
14     int insertSelective(Shopcart record);
15 
16     Shopcart selectByPrimaryKey(Integer shopcardId);
17 
18     int updateByPrimaryKeySelective(Shopcart record);
19 
20     int updateByPrimaryKey(Shopcart record);
21 
22     List<Shopcart> getShopcartsByUserId(int userId);
23 }

mapper.xml

  1 <?xml version="1.0" encoding="UTF-8" ?>
  2 <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
  3 <mapper namespace="com.cmbc.dao.ShopcartMapper" >
  4   <resultMap id="BaseResultMap" type="com.cmbc.po.Shopcart" >
  5     <id column="shopcard_id" property="shopcardId" jdbcType="INTEGER" />
  6     <result column="food_id" property="foodId" jdbcType="INTEGER" />
  7     <result column="shopcard_count" property="shopcardCount" jdbcType="INTEGER" />
  8     <result column="shopcard_sum" property="shopcardSum" jdbcType="DOUBLE" />
  9     <result column="user_id" property="userId" jdbcType="INTEGER" />
 10   </resultMap>
 11   <sql id="Base_Column_List" >
 12     shopcard_id, food_id, shopcard_count, shopcard_sum, user_id
 13   </sql>
 14   <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
 15     select 
 16     <include refid="Base_Column_List" />
 17     from shopcart
 18     where shopcard_id = #{shopcardId,jdbcType=INTEGER}
 19   </select>
 20 
 21   <select id="getShopcartsByUserId" resultMap="BaseResultMap"  parameterType="java.lang.Integer" >
 22     select
 23     <include refid="Base_Column_List" />
 24     from shopcart
 25     where user_id = #{userId,jdbcType=INTEGER}
 26   </select>
 27 
 28 
 29 
 30   <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" >
 31     delete from shopcart
 32     where shopcard_id = #{shopcardId,jdbcType=INTEGER}
 33   </delete>
 34   <insert id="insert" parameterType="com.cmbc.po.Shopcart" >
 35     insert into shopcart (shopcard_id, food_id, shopcard_count, 
 36       shopcard_sum, user_id)
 37     values (#{shopcardId,jdbcType=INTEGER}, #{foodId,jdbcType=INTEGER}, #{shopcardCount,jdbcType=INTEGER}, 
 38       #{shopcardSum,jdbcType=DOUBLE}, #{userId,jdbcType=INTEGER})
 39   </insert>
 40   <insert id="insertSelective" parameterType="com.cmbc.po.Shopcart" >
 41     insert into shopcart
 42     <trim prefix="(" suffix=")" suffixOverrides="," >
 43       <if test="shopcardId != null" >
 44         shopcard_id,
 45       </if>
 46       <if test="foodId != null" >
 47         food_id,
 48       </if>
 49       <if test="shopcardCount != null" >
 50         shopcard_count,
 51       </if>
 52       <if test="shopcardSum != null" >
 53         shopcard_sum,
 54       </if>
 55       <if test="userId != null" >
 56         user_id,
 57       </if>
 58     </trim>
 59     <trim prefix="values (" suffix=")" suffixOverrides="," >
 60       <if test="shopcardId != null" >
 61         #{shopcardId,jdbcType=INTEGER},
 62       </if>
 63       <if test="foodId != null" >
 64         #{foodId,jdbcType=INTEGER},
 65       </if>
 66       <if test="shopcardCount != null" >
 67         #{shopcardCount,jdbcType=INTEGER},
 68       </if>
 69       <if test="shopcardSum != null" >
 70         #{shopcardSum,jdbcType=DOUBLE},
 71       </if>
 72       <if test="userId != null" >
 73         #{userId,jdbcType=INTEGER},
 74       </if>
 75     </trim>
 76   </insert>
 77   <update id="updateByPrimaryKeySelective" parameterType="com.cmbc.po.Shopcart" >
 78     update shopcart
 79     <set >
 80       <if test="foodId != null" >
 81         food_id = #{foodId,jdbcType=INTEGER},
 82       </if>
 83       <if test="shopcardCount != null" >
 84         shopcard_count = #{shopcardCount,jdbcType=INTEGER},
 85       </if>
 86       <if test="shopcardSum != null" >
 87         shopcard_sum = #{shopcardSum,jdbcType=DOUBLE},
 88       </if>
 89       <if test="userId != null" >
 90         user_id = #{userId,jdbcType=INTEGER},
 91       </if>
 92     </set>
 93     where shopcard_id = #{shopcardId,jdbcType=INTEGER}
 94   </update>
 95   <update id="updateByPrimaryKey" parameterType="com.cmbc.po.Shopcart" >
 96     update shopcart
 97     set food_id = #{foodId,jdbcType=INTEGER},
 98       shopcard_count = #{shopcardCount,jdbcType=INTEGER},
 99       shopcard_sum = #{shopcardSum,jdbcType=DOUBLE},
100       user_id = #{userId,jdbcType=INTEGER}
101     where shopcard_id = #{shopcardId,jdbcType=INTEGER}
102   </update>
103 </mapper>

spring-mybatis.xml

  1 <?xml version="1.0" encoding="UTF-8"?>
  2 <beans xmlns="http://www.springframework.org/schema/beans"
  3     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tx="http://www.springframework.org/schema/tx"
  4     xmlns:aop="http://www.springframework.org/schema/aop"
  5     xsi:schemaLocation="
  6 http://www.springframework.org/schema/beans 
  7 http://www.springframework.org/schema/beans/spring-beans-3.0.xsd 
  8 http://www.springframework.org/schema/tx 
  9 http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
 10 http://www.springframework.org/schema/aop 
 11 http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
 12 ">
 13 
 14     <!-- JNDI方式配置数据源 -->
 15     <!-- <bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean"> 
 16         <property name="jndiName" value="${jndiName}"></property> </bean> -->
 17 
 18     <!-- 配置数据源 -->
 19     <bean name="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
 20         init-method="init" destroy-method="close">
 21         <property name="url" value="${jdbc_url}" />
 22         <property name="username" value="${jdbc_username}" />
 23         <property name="password" value="${jdbc_password}" />
 24 
 25         <!-- 初始化连接大小 -->
 26         <property name="initialSize" value="0" />
 27         <!-- 连接池最大使用连接数量 -->
 28         <property name="maxActive" value="20" />
 29         <!-- 连接池最大空闲 -->
 30         <property name="maxIdle" value="20" />
 31         <!-- 连接池最小空闲 -->
 32         <property name="minIdle" value="0" />
 33         <!-- 获取连接最大等待时间 -->
 34         <property name="maxWait" value="60000" />
 35 
 36         <!-- <property name="poolPreparedStatements" value="true" /> <property 
 37             name="maxPoolPreparedStatementPerConnectionSize" value="33" /> -->
 38 
 39         <property name="validationQuery" value="${validationQuery}" />
 40         <property name="testOnBorrow" value="false" />
 41         <property name="testOnReturn" value="false" />
 42         <property name="testWhileIdle" value="true" />
 43 
 44         <!-- 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 -->
 45         <property name="timeBetweenEvictionRunsMillis" value="60000" />
 46         <!-- 配置一个连接在池中最小生存的时间,单位是毫秒 -->
 47         <property name="minEvictableIdleTimeMillis" value="25200000" />
 48 
 49         <!-- 打开removeAbandoned功能 -->
 50         <property name="removeAbandoned" value="true" />
 51         <!-- 1800秒,也就是30分钟 -->
 52         <property name="removeAbandonedTimeout" value="1800" />
 53         <!-- 关闭abanded连接时输出错误日志 -->
 54         <property name="logAbandoned" value="true" />
 55 
 56         <!-- 监控数据库 -->
 57         <!-- <property name="filters" value="stat" /> -->
 58         <property name="filters" value="mergeStat" />
 59     </bean>
 60 
 61     <!-- myBatis文件 -->
 62     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
 63         <property name="dataSource" ref="dataSource" />
 64         <!-- 自动扫描entity目录, 省掉Configuration.xml里的手工配置 -->
 65         <property name="mapperLocations" value="classpath:com/cmbc/mapper/*.xml" />
 66         <!-- 加载mybatis分页插件 -->
 67         <property name="plugins">
 68             <list>
 69                 <bean class="com.cmbc.paginator.OffsetLimitInterceptor">
 70                     <property name="dialectClass" value="com.cmbc.dialect.MySQLDialect"></property>
 71                 </bean>
 72             </list>
 73 
 74         </property>
 75     </bean>
 76 
 77     <!-- sqlSession -->
 78     <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
 79         <constructor-arg index="0" ref="sqlSessionFactory" />
 80     </bean>
 81 
 82     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
 83         <property name="basePackage" value="com.cmbc.dao" />
 84         <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
 85     </bean>
 86 
 87     <!-- 配置事务管理器 -->
 88     <bean id="transactionManager"
 89         class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
 90         <property name="dataSource" ref="dataSource" />
 91     </bean>
 92 
 93     <!-- 注解方式配置事物 -->
 94     <!-- <tx:annotation-driven transaction-manager="transactionManager" /> -->
 95 
 96     <!-- 拦截器方式配置事物 -->
 97     <tx:advice id="transactionAdvice" transaction-manager="transactionManager">
 98         <tx:attributes>
 99             <tx:method name="add*" propagation="REQUIRED" />
100             <tx:method name="append*" propagation="REQUIRED" />
101             <tx:method name="insert*" propagation="REQUIRED" />
102             <tx:method name="save*" propagation="REQUIRED" />
103             <tx:method name="update*" propagation="REQUIRED" />
104             <tx:method name="modify*" propagation="REQUIRED" />
105             <tx:method name="edit*" propagation="REQUIRED" />
106             <tx:method name="delete*" propagation="REQUIRED" />
107             <tx:method name="remove*" propagation="REQUIRED" />
108             <tx:method name="repair" propagation="REQUIRED" />
109             <tx:method name="delAndRepair" propagation="REQUIRED" />
110 
111             <tx:method name="get*" propagation="SUPPORTS" />
112             <tx:method name="find*" propagation="SUPPORTS" />
113             <tx:method name="load*" propagation="SUPPORTS" />
114             <tx:method name="search*" propagation="SUPPORTS" />
115             <tx:method name="datagrid*" propagation="SUPPORTS" />
116 
117             <tx:method name="*" propagation="SUPPORTS" />
118         </tx:attributes>
119     </tx:advice>
120     <aop:config>
121         <aop:pointcut id="transactionPointcut"
122             expression="execution(* com.cmbc.service..*Impl.*(..))" />
123         <aop:advisor pointcut-ref="transactionPointcut"
124             advice-ref="transactionAdvice" />
125     </aop:config>
126 
127 
128     <!-- 配置druid监控spring jdbc -->
129     <bean id="druid-stat-interceptor"
130         class="com.alibaba.druid.support.spring.stat.DruidStatInterceptor">
131     </bean>
132     <bean id="druid-stat-pointcut" class="org.springframework.aop.support.JdkRegexpMethodPointcut"
133         scope="prototype">
134         <property name="patterns">
135             <list>
136                 <value>com.cmbc.service.*</value>
137             </list>
138         </property>
139     </bean>
140     <aop:config>
141         <aop:advisor advice-ref="druid-stat-interceptor"
142             pointcut-ref="druid-stat-pointcut" />
143     </aop:config>
144 
145 </beans>

测试类

 1 package com.cmbc.test;
 2 
 3 import com.alibaba.fastjson.JSON;
 4 import com.cmbc.dao.ShopcartMapper;
 5 import com.cmbc.po.Shopcart;
 6 import org.junit.Test;
 7 import org.junit.runner.RunWith;
 8 import org.springframework.test.context.ContextConfiguration;
 9 import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
10 
11 import javax.annotation.Resource;
12 import java.util.List;
13 
14 /**
15  * Created by admin on 2016/6/25.
16  */
17 @RunWith(SpringJUnit4ClassRunner.class)
18 @ContextConfiguration(locations = {"classpath:spring.xml", "classpath:spring-mybatis.xml"})
19 public class TestShopcartMapper {
20 
21     private ShopcartMapper shopcartMapper;
22 
23     @Test
24     public void test1() {
25 
26         Shopcart shopcart = shopcartMapper.selectByPrimaryKey(1);
27         System.out.println(JSON.toJSONString(shopcart));
28     }
29 
30 
31     @Test
32     public void test2() {
33         List<Shopcart> shopcarts = shopcartMapper.getShopcartsByUserId(1);
34         System.out.println(JSON.toJSONString(shopcarts));
35     }
36 
37     @Resource(name = "shopcartDao")
38     public void setShopcartMapper(ShopcartMapper shopcartMapper) {
39         this.shopcartMapper = shopcartMapper;
40     }
41 }

 

 

 

报错

 1 [DEBUG] 2016-06-26 10:08:27,167 method:org.springframework.test.context.web.ServletTestExecutionListener.afterTestMethod(ServletTestExecutionListener.java:96)
 2 Resetting RequestContextHolder for test context [TestContext@4958b2cc testClass = TestShopcartMapper, testInstance = com.cmbc.test.TestShopcartMapper@5e4294b2, testMethod = test2@TestShopcartMapper, testException = java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.cmbc.dao.ShopcartMapper.getShopcartsByUserId, mergedContextConfiguration = [MergedContextConfiguration@1632dfd4 testClass = TestShopcartMapper, locations = '{classpath:spring.xml, classpath:spring-mybatis.xml}', classes = '{}', contextInitializerClasses = '[]', activeProfiles = '{}', contextLoader = 'org.springframework.test.context.support.DelegatingSmartContextLoader']].
 3 
 4 java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.cmbc.dao.ShopcartMapper.getShopcartsByUserId
 5 
 6     at org.apache.ibatis.session.Configuration$StrictMap.get(Configuration.java:672)
 7     at org.apache.ibatis.session.Configuration.getMappedStatement(Configuration.java:507)
 8     at org.apache.ibatis.session.Configuration.getMappedStatement(Configuration.java:500)
 9     at org.apache.ibatis.binding.MapperMethod.setupCommandType(MapperMethod.java:240)
10     at org.apache.ibatis.binding.MapperMethod.<init>(MapperMethod.java:71)
11     at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:39)
12     at com.sun.proxy.$Proxy15.getShopcartsByUserId(Unknown Source)
13     at com.cmbc.test.TestShopcartMapper.test2(TestShopcartMapper.java:32)
14     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
15     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
16     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
17     at java.lang.reflect.Method.invoke(Method.java:606)
18     at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47)
19     at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
20     at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44)
21     at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
22     at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:74)
23     at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:83)
24     at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:72)
25     at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:231)
26     at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:88)
27     at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)
28     at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)
29     at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)
30     at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)
31     at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)
32     at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
33     at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:71)
34     at org.junit.runners.ParentRunner.run(ParentRunner.java:309)
35     at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:174)
36     at org.junit.runner.JUnitCore.run(JUnitCore.java:160)
37     at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:119)
38     at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:42)
39     at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:234)
40     at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:74)
41     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
42     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
43     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
44     at java.lang.reflect.Method.invoke(Method.java:606)
45     at com.intellij.rt.execution.application.AppMain.main(AppMain.java:144)
46 
47 [DEBUG] 2016-06-26 10:08:27,180 method:org.springframework.test.context.support.DirtiesContextTestExecutionListener.afterTestClass(DirtiesContextTestExecutionListener.java:112)
48 After test class: context [[TestContext@4958b2cc testClass = TestShopcartMapper, testInstance = [null], testMethod = [null], testException = [null], mergedContextConfiguration = [MergedContextConfiguration@1632dfd4 testClass = TestShopcartMapper, locations = '{classpath:spring.xml, classpath:spring-mybatis.xml}', classes = '{}', contextInitializerClasses = '[]', activeProfiles = '{}', contextLoader = 'org.springframework.test.context.support.DelegatingSmartContextLoader']]], dirtiesContext [false].
49 [INFO ] 2016-06-26 10:08:27,183 method:org.springframework.context.support.AbstractApplicationContext.doClose(AbstractApplicationContext.java:1042)
50 Closing org.springframework.context.support.GenericApplicationContext@7305830a: startup date [Sun Jun 26 10:08:23 CST 2016]; root of context hierarchy
51 [DEBUG] 2016-06-26 10:08:27,184 method:org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:246)
52 Returning cached instance of singleton bean 'sqlSessionFactory'
53 [DEBUG] 2016-06-26 10:08:27,185 method:org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:246)
54 Returning cached instance of singleton bean 'lifecycleProcessor'
55 [INFO ] 2016-06-26 10:08:27,186 method:org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroySingletons(DefaultSingletonBeanRegistry.java:444)
56 Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@28741848: defining beans [org.springframework.beans.factory.config.PropertyPlaceholderConfigurer#0,shopcartService,userService,org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,dataSource,sqlSessionFactory,sqlSession,org.mybatis.spring.mapper.MapperScannerConfigurer#0,transactionManager,transactionAdvice,org.springframework.aop.config.internalAutoProxyCreator,transactionPointcut,org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor#0,druid-stat-interceptor,druid-stat-pointcut,org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor#1,org.springframework.context.annotation.ConfigurationClassPostProcessor.importAwareProcessor,foodMapper,informationMapper,menuMapper,merchantMapper,msgnoteMapper,orderMapper,shopcartDao,userDao]; root of factory hierarchy
57 [DEBUG] 2016-06-26 10:08:27,186 method:org.springframework.beans.factory.support.DisposableBeanAdapter.destroy(DisposableBeanAdapter.java:219)
58 Invoking destroy() on bean with name 'druid-stat-interceptor'
59 [DEBUG] 2016-06-26 10:08:27,186 method:org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroyBean(DefaultSingletonBeanRegistry.java:500)
60 Retrieved dependent beans for bean '(inner bean)': [transactionAdvice]
61 [DEBUG] 2016-06-26 10:08:27,187 method:org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroyBean(DefaultSingletonBeanRegistry.java:500)
62 Retrieved dependent beans for bean 'shopcartDao': [com.cmbc.test.TestShopcartMapper]
63 [DEBUG] 2016-06-26 10:08:27,187 method:org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroyBean(DefaultSingletonBeanRegistry.java:500)
64 Retrieved dependent beans for bean 'com.cmbc.paginator.OffsetLimitInterceptor#4485af5c': [sqlSessionFactory]
65 [DEBUG] 2016-06-26 10:08:27,187 method:org.springframework.beans.factory.support.DisposableBeanAdapter.invokeCustomDestroyMethod(DisposableBeanAdapter.java:295)
66 Invoking destroy method 'close' on bean with name 'dataSource'
67 [INFO ] 2016-06-26 10:08:27,192 method:com.alibaba.druid.pool.DruidDataSource.close(DruidDataSource.java:982)
68 {dataSource-1} closed
69 
70 Process finished with exit code -1

 

 

远歌的主页 远歌 | 菜鸟二级 | 园豆:210
提问于:2016-06-26 10:24
< >
分享
所有回答(1)
0
dudu | 园豆:37791 (高人七级) | 2016-06-26 10:40
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册