spring和mybatis集成时总报错 麻烦帮忙看下什么原因

问题描述

spring和mybatis集成时总报错 麻烦帮忙看下什么原因
项目请求数据的时候报
Request processing failed; nested exception is org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.business.dao.system.AdminMapper.selectByPrimaryKey
麻烦大神帮忙看下这是啥原因，找了好久不知道哪里弄错了

spring-mybatis.xml文件配置

<bean id=""sqlSessionFactory"" class=""org.mybatis.spring.SqlSessionFactoryBean"">    <property name=""dataSource"" ref=""dataSource"" />    <!-- 自动扫描entity目录 省掉Configuration.xml里的手工配置 -->    <property name=""mapperLocations"" value=""*Mapper.xml"" /></bean>

dao/mapper/model的目录

AdminMapper.java的内容

package com.business.dao.system;

import com.business.models.system.Admin;
import org.springframework.stereotype.Repository;

@Repository(value=""adminMapper"")
public interface AdminMapper {
int deleteByPrimaryKey(Long adminOid);

int insert(Admin record);int insertSelective(Admin record);Admin selectByPrimaryKey(Long adminOid);int updateByPrimaryKeySelective(Admin record);int updateByPrimaryKey(Admin record);

}

AdminMapper.xm的内容

 <?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"" ><mapper namespace=""com.business.dao.system.AdminMapper"" >  <resultMap id=""BaseResultMap"" type=""com.business.models.system.Admin"" >    <id column=""admin_oid"" property=""adminOid"" jdbcType=""BIGINT"" />    <result column=""user_name"" property=""userName"" jdbcType=""VARCHAR"" />    <result column=""password"" property=""password"" jdbcType=""VARCHAR"" />  </resultMap>  <sql id=""Base_Column_List"" >    admin_oid user_name password  </sql>  <select id=""selectByPrimaryKey"" resultMap=""BaseResultMap"" parameterType=""java.lang.Long"" >    select     <include refid=""Base_Column_List"" />    from admin    where admin_oid = #{adminOidjdbcType=BIGINT}  </select>  <delete id=""deleteByPrimaryKey"" parameterType=""java.lang.Long"" >    delete from admin    where admin_oid = #{adminOidjdbcType=BIGINT}  </delete>  <insert id=""insert"" parameterType=""com.business.models.system.Admin"" >    insert into admin (admin_oid user_name password      )    values (#{adminOidjdbcType=BIGINT} #{userNamejdbcType=VARCHAR} #{passwordjdbcType=VARCHAR}      )  </insert>  <insert id=""insertSelective"" parameterType=""com.business.models.system.Admin"" >    insert into admin    <trim prefix=""("" suffix="")"" suffixOverrides="" >      <if test=""adminOid != null"" >        admin_oid      </if>      <if test=""userName != null"" >        user_name      </if>      <if test=""password != null"" >        password      </if>    </trim>    <trim prefix=""values ("" suffix="")"" suffixOverrides="" >      <if test=""adminOid != null"" >        #{adminOidjdbcType=BIGINT}      </if>      <if test=""userName != null"" >        #{userNamejdbcType=VARCHAR}      </if>      <if test=""password != null"" >        #{passwordjdbcType=VARCHAR}      </if>    </trim>  </insert>  <update id=""updateByPrimaryKeySelective"" parameterType=""com.business.models.system.Admin"" >    update admin    <set >      <if test=""userName != null"" >        user_name = #{userNamejdbcType=VARCHAR}      </if>      <if test=""password != null"" >        password = #{passwordjdbcType=VARCHAR}      </if>    </set>    where admin_oid = #{adminOidjdbcType=BIGINT}  </update>  <update id=""updateByPrimaryKey"" parameterType=""com.business.models.system.Admin"" >    update admin    set user_name = #{userNamejdbcType=VARCHAR}      password = #{passwordjdbcType=VARCHAR}    where admin_oid = #{adminOidjdbcType=BIGINT}  </update></mapper>

现在启动时没有问题 但是一访问请求数据的时候就报错
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.business.dao.system.AdminMapper.selectByPrimaryKey
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:978)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:857)
javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

root cause
org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.business.dao.system.AdminMapper.selectByPrimaryKey
org.apache.ibatis.binding.MapperMethod$SqlCommand.(MapperMethod.java:189)
org.apache.ibatis.binding.MapperMethod.(MapperMethod.java:43)
org.apache.ibatis.binding.MapperProxy.cachedMapperMethod(MapperProxy.java:58)
org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:51)
com.sun.proxy.$Proxy12.selectByPrimaryKey(Unknown Source)
com.business.service.system.Impl.SystemServiceImpl.findAdminByAdminOid(SystemServiceImpl.java:21)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:606)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
com.sun.proxy.$Proxy15.findAdminByAdminOid(Unknown Source)
controller.system.SystemController.findAdmin(SystemController.java:27)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:606)
org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:177)
org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:446)
org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:434)
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:857)
javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

解决方案

@Repository(value=""adminMapper"")这里这样写感觉有问题啊，
看看我写的http://blog.csdn.net/evankaka/article/details/48785513

解决方案二：
我把@Repository(value=""adminMapper"")还是一样的 我这个mybatis的model mapper.java mapper.xml是用generator自动生成的，可是一直报那个错误，
怎么弄都不行。。。。。

解决方案三：
mapper.xml中的selectByPrimaryKey方法有问题！

解决方案四：
接口的定义没有和对应的xml文件对应，检查配置。

时间： 2025-01-18 15:52:32

spring和mybatis集成时总报错 麻烦帮忙看下什么原因的相关文章

json校验格式报错，帮忙看下。

问题描述 json校验格式报错,帮忙看下. { "deplist": [ { bumen: 95, bound_id: "餐饮部", pad_sbound: "甜品类", pad_tab: 1 }, { bumen: 96, bound_id: "餐饮部", pad_sbound: "饮料类", pad_tab: 2 } ] } err info: bumen: 95, ------------------

gulp-新手第一次整nodejs 遇到问题 npm install报错，帮忙看下吧

问题描述 新手第一次整nodejs 遇到问题 npm install报错,帮忙看下吧 npm ERR! Windows_NT 6.1.7601 npm ERR! argv "d:Program Filesnodejsnode.exe" "d:Program Filesnodejs node_modulesnpmbinnpm-cli.js" "install" npm ERR! node v0.12.4 npm ERR! npm v2.11.1 n

javaee hibernate-求助avaee hibernate 项目控制台报错 求帮忙分析下，万分感谢！！

问题描述 求助avaee hibernate 项目控制台报错 求帮忙分析下,万分感谢!! 出现异常时间: [2013年8月9日 15:15:32] org.hibernate.HibernateException: Already disconnectedat com.hiaward.common.util.HibernateUtil.rollbackTransaction(HibernateUtil.java:175) at com.hiaward.common.util.HibernateU

不知道具体少什么包-第一次用springmvc+myBatis框架，求大神进来帮忙看下缺什么包

问题描述 第一次用springmvc+myBatis框架,求大神进来帮忙看下缺什么包 java.lang.ArrayStoreException: sun.reflect.annotation.TypeNotPresentExceptionProxy at sun.reflect.annotation.AnnotationParser.parseClassArray(AnnotationParser.java:653) at sun.reflect.annotation.AnnotationPa

菜鸟调错（四） Spring与DWR集成，配置文件报错

背景简介: 该项目是市信用办的一个系统,之前好像是一个石家庄的公司负责的.我属于是半路接手.拿到源码后,根据他们给的简(shao)单(de)明(ke)了(lian)的说明把项目搭起来.结果可想而知,项目文件一片红.于是就开始解决这些错误,好在很多错误都是类似的.经过一番捣鼓,大部分的错误都解决了,有一个Spring跟DWR集成配置的错误,错误信息如下: Multiple annotations found at this line: - schema_reference.4: Failed to

麻烦帮忙看下这个程序出现什么问题了呢？运行是报“出错啦！”

问题描述 importjava.io.*;publicclassfile1{publicstaticvoidmain(String[]args)throwsException{Filef1=newFile("E:\abc\汇编\abc.txt");FileInputStreamfis=newFileInputStream(f1);DataInputStreamdis=newDataInputStream(fis);try{System.out.println(dis.readUTF()

xplanner部署tomcat启动报错，麻烦帮忙看下，错误信息贴出来如下

问题描述 [1235]ERROR-work.web.context.ContextLoader-Contextinitializationfailedorg.springframework.beans.factory.BeanCreationException:Errorcreatingbeanwithname'metaRepository'definedinclasspathresource[spring-beans.xml]:Errorsettingpropertyvalues;nested

接口-在上传图文消息素材时，总报错说是不合法的媒体文件id，不知道什么才是正确的id呢

问题描述 在上传图文消息素材时,总报错说是不合法的媒体文件id,不知道什么才是正确的id呢 package main;import java.util.ArrayList;import java.util.List;import org.slf4j.Logger;import org.slf4j.LoggerFactory;import pojo.AccessToken;import pojo.Article;import pojo.Articles;import util.WeixinUtil

maven问题,在pom.xml配置ssh时spring有两个依赖包报错

问题描述 maven问题,在pom.xml配置ssh时spring有两个依赖包报错 //一条红线划着<>org.springframeworkspring-orm3.1.1.RELEASE <dependency>//一条红线划着<<dependency>> <groupId>org.springframework</groupId> <artifactId>spring-web</artifactId> &l