Mybatis: insert
2022/4/28 23:16:23
本文主要是介绍Mybatis: insert,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
<?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="us.transcode.thymeleaf.dao.EmployeeDao"> <!--插入一条记录--> <insert id="insertOne" parameterType="Employee" keyProperty="id" useGeneratedKeys="true"> INSERT INTO thymeleaf.employee <trim prefix="(" suffix=")" suffixOverrides=","> <if test="id!=null"> id, </if> <if test="username!=null and username!=''"> username, </if> <if test="birthday!=null"> birthday, </if> <if test="salary!=null"> salary, </if> <if test="photo!=null and photo!=''"> photo, </if> </trim> VALUES <trim prefix="(" suffix=")" suffixOverrides=","> <if test="id!=null"> "${id}", </if> <if test="username!=null and username!=''"> #{username}, </if> <if test="birthday!=null"> #{birthday}, </if> <if test="salary!=null"> #{salary}, </if> <if test="photo!=null and photo!=''"> #{photo}, </if> </trim> </insert> <!--通过Id查询--> <select id="selectOneById" parameterType="Integer" resultType="Employee"> SELECT id, username, birthday, salary, photo FROM thymeleaf.employee WHERE id = #{id} </select> <!--查询所有--> <select id="selectAll" resultType="Employee"> SELECT id, username, birthday, salary, photo FROM thymeleaf.employee </select> <!--通过set动态更新--> <update id="updateById" parameterType="Employee"> UPDATE thymeleaf.employee <set> <if test="username!=null and username!=''"> username=#{username}, </if> <if test="birthday!=null"> birthday=#{birthday}, </if> <if test="salary!=null"> salary=#{salary}, </if> <if test="photo!=null and photo!=''"> photo=#{photo}, </if> </set> WHERE id=#{id} </update> <!--通过Id删除--> <delete id="deleteOneById" parameterType="Integer"> DELETE FROM thymeleaf.employee WHERE id = #{id} </delete> </mapper>
这篇关于Mybatis: insert的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2024-06-26结对编程到底难不难?答案在这里
- 2024-06-19《2023版Java工程师》课程升级公告
- 2024-06-15matplotlib作图不显示3D图,怎么办?
- 2024-06-1503-Loki 日志监控
- 2024-06-1504-让LLM理解知识 -Prompt
- 2024-06-05做软件测试需要懂代码吗?
- 2024-06-0514-ShardingSphere的分布式主键实现
- 2024-06-03为什么以及如何要进行架构设计权衡?
- 2024-05-31全网首发第二弹!软考2024年5月《软件设计师》真题+解析+答案!(11-20题)
- 2024-05-31全网首发!软考2024年5月《软件设计师》真题+解析+答案!(21-30题)