发表于: 2025-05-31 20:30:00

0 38


今天完成的事情:(一定要写非常细致的内容,比如说学会了盒子模型,了解了Margin)

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="org.example.mapper.UserMapper">

<insert id="addUser" parameterType="org.example.model.User" useGeneratedKeys="true" keyProperty="id">
       INSERT INTO hua (name, type,kinds, state, create_at, update_at,author) VALUES (#{name}, #{type}, #{kinds}, #{state}, #{createAt}, #{updateAt},#{author})
   </insert>

<update id="updateUser" parameterType="org.example.model.User">
       UPDATE hua SET name = #{name},type = #{type},kinds = #{kinds},state = #{state},create_at = #{createAt},update_at = #{updateAt},author = #{author} WHERE id = #{id}
   </update>

<delete id="deleteUser" parameterType="int">
       DELETE FROM hua WHERE id = #{id}
   </delete>

<select id="queryAllUsers" resultType="org.example.model.User">
       SELECT * FROM hua
   </select>

<select id="getUserById" parameterType="int" resultType="org.example.model.User">
       SELECT * FROM hua WHERE id = #{id}
   </select>
<select id="selectAll" resultType="org.example.model.User">
       SELECT id, name, type,kinds, state, create_at, update_at,author FROM hua
   </select>
</mapper>

明天计划的事情:(一定要写非常细致的内容)

学习任务三

遇到的问题:(遇到什么困难,怎么解决的)

收获:(通过今天的学习,学到了什么知识)



返回列表 返回列表
评论

    分享到