【使用SSM时，在Mapper.xml中添加了SQL语句，但运行时报错找不到该语句 _SSM _jetty/tomcat 】

使用SSM时，在Mapper.xml中添加了SQL语句，但运行时报错找不到该语句
我也踩过这个坑( 1 )
已统计您的踩坑,无需重复点击
回答(1)
SSM jetty/tomcat
详细描述
错误截图
源码
<?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.jnshu.dao.UserMapper">
    <resultMap id="BaseResultMap" type="com.jnshu.model.User">
        <constructor>
            <idArg column="id" jdbcType="INTEGER" javaType="java.lang.Integer"/>
            <arg column="user_name" jdbcType="VARCHAR" javaType="java.lang.String"/>
            <arg column="password" jdbcType="VARCHAR" javaType="java.lang.String"/>
            <arg column="tel_num" jdbcType="VARCHAR" javaType="java.lang.String"/>
            <arg column="email" jdbcType="VARCHAR" javaType="java.lang.String"/>
            <arg column="user_image" jdbcType="VARCHAR" javaType="java.lang.String"/>
            <arg column="salt" jdbcType="VARCHAR" javaType="java.lang.String"/>
            <arg column="login_time" jdbcType="BIGINT" javaType="java.lang.Long"/>
            <arg column="creat_name" jdbcType="CHAR" javaType="java.lang.String"/>
            <arg column="creat_time" jdbcType="BIGINT" javaType="java.lang.Long"/>
            <arg column="update_name" jdbcType="CHAR" javaType="java.lang.String"/>
            <arg column="update_time" jdbcType="BIGINT" javaType="java.lang.Long"/>
        </constructor>
    </resultMap>

    <sql id="Base_Column_List">
    id, user_name, tel_num, email, user_image, password, salt, login_time, creat_name, creat_time, update_name, update_time
  </sql>

    <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer">
        select
        <include refid="Base_Column_List"/>
        from user
        where id = #{id,jdbcType=INTEGER}
    </select>

    <select id="selectByName" resultType="com.jnshu.model.User" parameterType="java.lang.String">
        select
       password,salt
        from user
        where user_name = #{userName,jdbcType=VARCHAR}
    </select>

    <update id="updateByName" parameterType="com.jnshu.model.User">
update user
set
login_time = #{loginTime,jdbcType=BIGINT}
where
user_name = #{userName,jdbcType=VARCHAR}
</update>

    <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">
    delete from user
    where id = #{id,jdbcType=INTEGER}
  </delete>


    <insert id="insert" parameterType="com.jnshu.model.User">
    insert into user (id, user_name, tel_num, email, user_image, password, salt,
      login_time, creat_name, creat_time, 
      update_name, update_time)
    values (#{id,jdbcType=INTEGER}, #{userName,jdbcType=VARCHAR},#{telNum,jdbcType=VARCHAR},#{eamil,jdbcType=VARCHAR},#{userImage,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR},
      #{loginTime,jdbcType=BIGINT}, #{creatName,jdbcType=CHAR}, #{creatTime,jdbcType=BIGINT}, 
      #{updateName,jdbcType=CHAR}, #{updateTime,jdbcType=BIGINT})
  </insert>
    <insert id="insertSelective" parameterType="com.jnshu.model.User">
        insert into user
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">
                id,
            </if>
            <if test="userName != null">
                user_name,
            </if>
            <if test="telNum != null">
                tel_num,
            </if>
            <if test="email != null">
                email,
            </if>
            <if test="userImage != null">
                user_image,
            </if>
            <if test="password != null">
                password,
            </if>
            <if test="salt != null">
                salt,
            </if>
            <if test="loginTime != null">
                login_time,
            </if>
            <if test="creatName != null">
                creat_name,
            </if>
            <if test="creatTime != null">
                creat_time,
            </if>
            <if test="updateName != null">
                update_name,
            </if>
            <if test="updateTime != null">
                update_time,
            </if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null">
                #{id,jdbcType=INTEGER},
            </if>
            <if test="userName != null">
                #{userName,jdbcType=VARCHAR},
            </if>
            <if test="telNum != null">
                #{telNum,jdbcType=VARCHAR},
            </if>
            <if test="email != null">
                #{email,jdbcType=VARCHAR},
            </if>
            <if test="userImage != null">
                #{userImage,jdbcType=VARCHAR},
            </if>
            <if test="password != null">
                #{password,jdbcType=VARCHAR},
            </if>
            <if test="salt != null">
                #{salt,jdbcType=VARCHAR},
            </if>
            <if test="loginTime != null">
                #{loginTime,jdbcType=BIGINT},
            </if>
            <if test="creatName != null">
                #{creatName,jdbcType=CHAR},
            </if>
            <if test="creatTime != null">
                #{creatTime,jdbcType=BIGINT},
            </if>
            <if test="updateName != null">
                #{updateName,jdbcType=CHAR},
            </if>
            <if test="updateTime != null">
                #{updateTime,jdbcType=BIGINT},
            </if>
        </trim>
    </insert>


    <update id="updateByPrimaryKeySelective" parameterType="com.jnshu.model.User">
        update user
        <set>
            <if test="userName != null">
                user_name = #{userName,jdbcType=VARCHAR},
            </if>
            <if test="telNum != null">
                tel_num = #{telNum,jdbcType=VARCHAR},
            </if>
            <if test="email != null">
                email = #{email,jdbcType=VARCHAR},
            </if>
            <if test="userImage != null">
                user_image = #{userImage,jdbcType=VARCHAR},
            </if>
            <if test="password != null">
                password = #{password,jdbcType=VARCHAR},
            </if>
            <if test="salt != null">
                salt = #{salt,jdbcType=VARCHAR},
            </if>
            <if test="loginTime != null">
                login_time = #{loginTime,jdbcType=BIGINT},
            </if>
            <if test="creatName != null">
                creat_name = #{creatName,jdbcType=CHAR},
            </if>
            <if test="creatTime != null">
                creat_time = #{creatTime,jdbcType=BIGINT},
            </if>
            <if test="updateName != null">
                update_name = #{updateName,jdbcType=CHAR},
            </if>
            <if test="updateTime != null">
                update_time = #{updateTime,jdbcType=BIGINT},
            </if>
        </set>
        where id = #{id,jdbcType=INTEGER}
    </update>
    <update id="updateByPrimaryKey" parameterType="com.jnshu.model.User">
    update user
    set user_name = #{userName,jdbcType=VARCHAR},
      password = #{password,jdbcType=VARCHAR},
      tel_num = #{telNum,jdbcType=VARCHAR},
      email = #{email,jdbcType=VARCHAR},
      user_image = #{userImage,jdbcType=VARCHAR},
      salt = #{salt,jdbcType=VARCHAR},
      login_time = #{loginTime,jdbcType=BIGINT},
      creat_name = #{creatName,jdbcType=CHAR},
      creat_time = #{creatTime,jdbcType=BIGINT},
      update_name = #{updateName,jdbcType=CHAR},
      update_time = #{updateTime,jdbcType=BIGINT}
    where id = #{id,jdbcType=INTEGER}
  </update>
    <select id="selectByIdAndName" resultMap="BaseResultMap" parameterType="com.jnshu.model.User">
select * from user
where  user_name = #{userName} and password = #{password}
</select>
    <select id="countAll" resultType="java.lang.Integer">
    SELECT count(*)  FROM user
  </select>

    <update id="updateImageByName" parameterType="java.lang.String">
        update user
        set
        user_image = #{userImage,jdbcType=VARCHAR}
        where user_name = #{userName,jdbcType=VARCHAR}
    </update>

</mapper>
编辑于2024-11-23
时间排序
热门排序
[无名弟子]王志冲
0

项目每次运行都会在项目文件夹target中生成项目所需的各个文件，但是再对项目的UserMapper.xml文件进行修改之后，target里面的UserMapper.xml没有发生改变，就导致项目在运行时仍然采用未修改的UserMapper.xml，导致添加的功能无法实现。
所以每次有大的修改，最好运行一下Maven clean

查看全部>

编辑于2018-07-20
去第页