ToDoMapper.xml
関連タイピング
-
src/main/resources
プレイ回数117英語長文717打 -
src/main/java
プレイ回数87英語長文492打 -
src/main/java
プレイ回数116英語長文187打 -
src/main/resources
プレイ回数85英語長文294打 -
src/main/resources
プレイ回数118英語長文279打 -
src/main/resources
プレイ回数106英語長文105打 -
src/main/java
プレイ回数106英語長文254打 -
src/main/resources
プレイ回数136英語長文815打
問題文
(<mapper namespace="com.example.webapp.repository.ToDoMapper">)
<mapper namespace="com.example.webapp.repository.ToDoMapper">
(<select id="selectAll" resultType="com.example.webapp.entity.ToDo">)
<select id="selectAll" resultType="com.example.webapp.entity.ToDo">
(SELECT id, todo, detail, created_at as createdAt, updated_at as updatedAt)
SELECT id, todo, detail, created_at as createdAt, updated_at as updatedAt
(FROM todos)
FROM todos
(</select>)
</select>
(<select id="selectById" resultType="com.example.webapp.entity.ToDo">)
<select id="selectById" resultType="com.example.webapp.entity.ToDo">
(SELECT id, todo, detail, created_at as createdAt, updated_at as updatedAt)
SELECT id, todo, detail, created_at as createdAt, updated_at as updatedAt
(FROM todos WHERE id = #{id})
FROM todos WHERE id = #{id}
(</select>)
</select>
(<insert id="insert">)
<insert id="insert">
(INSERT INTO todos (todo, detail, created_at, updated_at))
INSERT INTO todos (todo, detail, created_at, updated_at)
(VALUES (#{todo}, #{detail}, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP))
VALUES (#{todo}, #{detail}, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP)
(</insert>)
</insert>
(<update id="update">)
<update id="update">
(UPDATE todos SET todo = #{todo}, detail = #{detail}, updated_at = CURRENT_TIMESTAMP)
UPDATE todos SET todo = #{todo}, detail = #{detail}, updated_at = CURRENT_TIMESTAMP
(WHERE id = #{id})
WHERE id = #{id}
(</update>)
</update>
(<delete id="delete">)
<delete id="delete">
(DELETE FROM todos WHERE id = #{id})
DELETE FROM todos WHERE id = #{id}
(</delete>)
</delete>
(</mapper>)
</mapper>