spring+mybati配置问题，查询时就报错找不到方法

Question

我的map路径：D:\项目\gwbm\src\com\Project\login\mapper\UserMapper.java
mapper中的文件配置：<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<resultMap type="com.Project.login.bean.UserBean" id="user">
    <result column="id" jdbcType="INTEGER" property="id" javaType="int"/>
    <result column="name" jdbcType="VARCHAR" property="name" javaType="java.lang.String"/>
</resultMap>



<!-- 登录信息-->
<select id="getsysbean" parameterType="com.Project.login.bean.UserBean" resultMap="user">
    select * from TESTTABLE where id='${id}'
</select>
<select id="getsysbeanmap" parameterType="com.Project.login.bean.UserBean" resultType="hashmap">
    select * from TESTTABLE where id='${id}'
</select>

dispatcher-servlet.xml里面的配置：
<?xml version="1.0" encoding="UTF-8"?>
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd">
<!-- 配置SpringMVC @ResponseBody和@RequestBody注解 -->
class="org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter">




text/html;charset=UTF-8

<!-- 扫描指定package下所有带有如@controller,@services,@resource,并把所注释的注册为Spring Beans -->
<mvc:annotation-driven/>
<context:component-scan base-package="com.Project.*.controller,com.Project.controller"></context:component-scan>

<!-- 扫描包下的myBatis数据接口 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">  
    <property name="basePackage"  value="com.Project.*.mapper,com.Project.mapper"/>
</bean>  

<!-- 配置rest-->
<bean id="contentNegotiatingViewResolver" class="org.springframework.web.servlet.view.ContentNegotiatingViewResolver">
    <!-- 视图解析器的执行顺序 -->
    <property name="order" value="1"></property>
    <!-- 设置为true以忽略对Accept Header的支持 -->
    <property name="ignoreAcceptHeader" value="true"/>
    <!-- 在没有扩展名时即: "/user/1" 时的默认展现形式 -->
    <property name="defaultContentType" value="text/html" />

    <property name="mediaTypes">
        <map>
            <entry key="json" value="application/json" />
            <entry key="xml" value="application/xml" />
        </map>
    </property>

    <property name="defaultViews">
        <list>
            <bean class="org.springframework.web.servlet.view.json.MappingJacksonJsonView" />
            <bean class="org.springframework.web.servlet.view.xml.MarshallingView" >
                <constructor-arg>
                    <bean class="org.springframework.oxm.xstream.XStreamMarshaller"/>
                </constructor-arg>
            </bean>
        </list>
    </property>
</bean>

<!-- 配置jsp视图解析 -->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    <property name="order" value="2"></property>
    <property name="contentType" value="text/html;charset=UTF-8" />
    <property name="requestContextAttribute" value="request" />
    <property name="prefix" value="/view/"></property>
    <property name="suffix" value=".jsp"></property>
</bean>

<!-- 文件上传配置 -->
<bean id="multipartResolver" 
    class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
    <property name="maxUploadSize">
        <value>1073741824</value>
    </property>
    <property name="maxInMemorySize">
        <value>4096</value>
    </property>
    <property name="resolveLazily" value="true" />
    <property name="uploadTempDir">
        <value>/load/temp</value>
    </property>
</bean>
<!-- 静态资源 -->
<mvc:resources mapping="/css/**" location="/css/" />
<mvc:resources mapping="/js/**" location="/js/" />
<mvc:resources mapping="/images/**" location="/images/" />

现在已到查询数据库的地方就报DEBUG - Resolving exception from handler [public java.lang.String com.Project.login.controller.UserLoginController.userLogin(com.Project.login.bean.UserBean,javax.servlet.http.HttpServletRequest,org.springframework.ui.Model)]: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.Project.login.mapper.UserMapper.getsysbean

纠结了一天了，求大神帮忙

Answer 1

建议包名按驼峰命名法写

select * from TESTTABLE where id='${id}'

这句话出的问题，也许是返回的字段，实体内有不对应的字段，也许是类型不对。