Spring MVC 实现CRUD功能

最新推荐文章于 2023-09-08 20:51:32 发布

不务正业的野猴子

最新推荐文章于 2023-09-08 20:51:32 发布

阅读量1.1k

点赞数

分类专栏： Spring

本文链接：https://blog.csdn.net/quan20111992/article/details/88712521

版权

本文介绍了如何在Spring MVC项目中集成MyBatis，详细讲解了从项目搭建到实现CRUD功能的步骤。在实现编辑保存功能时，特别提到了因未对字段值是否为空进行判断导致的问题，并提供了修正后的SQL语句。

摘要由CSDN通过智能技术生成

Spring web项目开发

一、Spring MVC 项目搭建

二、Spring MVC 集成 MyBatis

三、Spring MVC 实现CRUD功能

UserMapper.xml

<?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="spring.mybatis.sample.basic.user.dao.UserDao">

    <select id="selectOne" parameterType="spring.mybatis.sample.basic.user.dao.domain.User"
            resultType="spring.mybatis.sample.basic.user.dao.domain.User">
        SELECT
        id as id,
        user_name as userName,
        age as age,
        sex as sex,
        address as address
        FROM SYSTEM_USER
        <trim prefix="WHERE" prefixOverrides="AND">
            <if test="id != null and id != ''">
                and id = #{id}
            </if>
            <if test="userName != null and userNmae != ''">
                and user_name = #{userName}
            </if>
            <if test="age != null">
                and age = #{age}
            </if>
            <if test="sex != null">
                and sex = #{sex}
            </if>
            <if test="address != null and address != ''">
                and address = #{address}
            </if>
        </trim>
    </select>

    <insert id="insert" parameterType="spring.mybatis.sample.basic.user.dao.domain.User">
        INSERT INTO SYSTEM_USER (id, user_name, age, sex, address)
        VALUES (#{id}, #{userName}, #{age}, #{sex}, #{address})
    </insert>

    <update id="update" parameterType="spring.mybatis.sample.basic.user.dao.domain.User">
        UPDATE SYSTEM_USER
        <trim prefix="SET" suffixOverrides=",">
            user_name = #{userName},
            age = #{age},
            sex = #{sex},
            address = #{address},
        </trim>
        <trim prefix="WHERE" prefixOverrides="AND">
            AND id = #{id}
        </trim>
    </update>

    <delete id="delete" parameterType="spring.mybatis.sample.basic.user.dao.domain.User">
        DELETE FROM SYSTEM_USER
        <trim prefix="WHERE" prefixOverrides="AND">
            <if test="id != null and id != ''">
                AND id = #{id}
            </if>
            <if