ToDoMapper.xml
src/main/resources
com.example.webapp.repository
関連タイピング
-
src/main/resources
プレイ回数137 英語長文410打 -
src/main/java
プレイ回数88 英語長文492打 -
src/main/resources
プレイ回数85 英語長文294打 -
src/main/java
プレイ回数118 英語長文187打 -
src/main/resources
プレイ回数144 英語長文815打 -
src/main/resources
プレイ回数107 英語長文105打 -
src/main/java
プレイ回数73 英語長文184打 -
src/main/resources
プレイ回数118 英語長文279打
問題文
ふりがな非表示
ふりがな表示
(<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>