【求助】spring mvc +iBATIS 如何实现数据和页面的连接？？

Question

系统执行发生错误，信息描述如下：错误状态代码是：200错误发生页面是：/WeiXin/adminuser_search.do错误信息：com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in com/hnsd/sqlmap/t_adminuser_SqlMap.xml. --- The error occurred while preparing the mapped statement for execution. --- Check the t_adminuser.selectByName. --- Cause: java.sql.SQLException: Invalid parameter object type. Expected 'java.lang.String' but found 'com.hnsd.vo.AdminuserVo'.错误堆栈信息：
com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201) 
com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139) 
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567) 
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541) 
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118) 
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:94) 
com.hnsd.dao.BasicDao.Page(BasicDao.java:175) 
com.hnsd.dao.BasicDao.queryForPage(BasicDao.java:140) 
com.hnsd.service.AdminuserService.selectAdminUserList(AdminuserService.java:120) 
com.hnsd.controller.AdminuserController.adminUserQueryByadName(AdminuserController.java:132) 
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:601) 
org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:213) 
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126) 
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96) 
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617) 
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578) 
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80) 
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923) 
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852) 
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882) 
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789) 
javax.servlet.http.HttpServlet.service(HttpServlet.java:643) 
javax.servlet.http.HttpServlet.service(HttpServlet.java:723) 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) 
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) 
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861) 
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606) 
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) 
java.lang.Thread.run(Thread.java:722) 我在sqlmap.xml中改了java.lang.String类型，可是还出现错误
【代码如下】/**
 * 
 * 按姓名查询管理员信息
 */

@RequestMapping(value="/adminuser_search")
@Scope(value="prototype")
public ModelAndView adminUserQueryByadName(HttpServletRequest request, HttpServletResponse response, ModelMap model,String adName) throws SQLException{
ModelAndView mav = null;

AdminuserVo vo= (AdminuserVo)AdminuserService.getAdminUserByadName(adName);


Pagination page = new Pagination();
AdminuserService.selectAdminUserList(page, vo);
mav.addObject("pagination", vo);

mav= new ModelAndView("adminuser_list");

return mav;
}
【sqlmap.xml如下：】  <select id="selectByName" resultMap="adminuserResult" parameterClass="java.lang.String" >
    <!--
      WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
      This element was generated on Tue Jul 16 14:18:53 CST 2013.
    -->
    select id, loginName, password,adName, type,createTime
    from t_adminuser
    where adName = #adName:VARCHAR#
  </select>
 iBATISSpring MVC

Answer 1

有没有人在啊，帮助一下呗，没学过spring,老师让做一个项目用spring mvc+iBATIS

Answer 2

你传入的值是AdminuserVo ，而你parameterClass是java.lang.String，这怎么行呢？
<select id="selectByName" resultType="adminuserResult" parmeterType="AdminuserVo" >
    <!--
      WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
      This element was generated on Tue Jul 16 14:18:53 CST 2013.
    -->
    select id, loginName, password,adName, type,createTime
    from t_adminuser
    where adName = #{adName}
  </select>
resultType和parmeterType用类的全限定名，我也不知道你类是怎么定义的，你自己修改下！