发表于: 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>
明天计划的事情:(一定要写非常细致的内容)
学习任务三
遇到的问题:(遇到什么困难,怎么解决的)
收获:(通过今天的学习,学到了什么知识)
评论