【IDEA操作数据库查找中文字段模糊查询不成功 _mybatis 】

IDEA操作数据库查找中文字段模糊查询不成功

我也踩过这个坑( 1 )

已统计您的踩坑,无需重复点击

回答(0)

mybatis

详细描述

错误截图

源码

<?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">

<!-- 配置命名空间，namespace的名字需要对应相应的接口名-->
<mapper namespace="com.dao.StudentMapper">
    <select id="selectStudentById" parameterType="long" resultType="com.pojo.Student">
        SELECT * FROM  student where  id =#{id}
    </select>

    <select id="selectStudentByName" parameterType="String" resultType="com.pojo.Student">
        SELECT * FROM  student where  name like CONCAT('%', #{name}, '%')
    </select>

    <insert id="insertStudent" parameterType="com.pojo.Student" keyProperty="id" useGeneratedKeys="true" >
        INSERT INTO student (age,sex,school,name,create_at,update_at) values
         (#{age} ,#{sex}, #{school} , #{name},#{create_at},#{update_at})
    </insert>

    <delete id="deleteStudentById" parameterType="long">
        delete from student where id=#{id}
    </delete>

    <update id="updateStudentById" parameterType="com.pojo.Student" >
        UPDATE student set age=#{age},sex=#{sex} ,school=#{school},name=#{name} ,update_at=#{update_at} where id=#{id}
    </update>

    <select id="selectStudent" resultType="com.pojo.Student">
        select * from student
    </select>
</mapper>

编辑于2024-11-18