/* selectSample */
SELECT ID
, FOO
, BAR
, FOOBAR
FROM SAMPLE
WHERE ID = #{id}
/* insertSample */
INSERT
INTO SAMPLE
(
ID
, FOO
, BAR
, FOOBAR
)
VALUES
(
#{id}
, #{foo}
, #{bar}
, #{fooBar}
)
/* updateSample */
UPDATE SAMPLE
SET FOO = #{foo}
, BAR = #{bar}
, FOOBAR = #{fooBar}
WHERE ID = #{id}
/* deleteSample */
DELETE
FROM SAMPLE
WHERE ID = #{id}