mybatis返回int类型报错

最新推荐文章于 2024-09-28 23:45:00 发布

taoyuanforrest

最新推荐文章于 2024-09-28 23:45:00 发布

阅读量4.8w

点赞数 7

分类专栏：数据库

本文链接：https://blog.csdn.net/just_lion/article/details/9700793

版权

数据库专栏收录该内容

6 篇文章 0 订阅

订阅专栏

当配置mybatis返回int类型时

select id="getUserIdByName" parameterType="string" resultType="int">
    SELECT
    	  id
    FROM user
    WHERE userName = #{userName}
  </select>

会报错如下：

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.apache.ibatis.binding.BindingException: Mapper method 'com.bill.springMybatis.dao.UserDao.getUserIdByName attempted to return null from a method with a primitive return type (int).
   org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:894)
   org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:734)
   javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
   org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
   org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

解决方案，返回类型设置为封装类型Integer而不是基本类型int

<?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.bill.springMybatis.dao.UserDao">

  <cache />
  <select id="getUserIdByName" parameterType="string" resultType="Integer">
    SELECT
    	  id
    FROM user
    WHERE userName = #{userName}
  </select>
  
</mapper>

service层如果需要int数据类型，可以自动从Integer进行转换，当然有可能加入一些判断，比如Integer为Null，赋给int可以先转成0

工程源码：

http://download.csdn.net/detail/sundongsdu/5851343