and ${criterion.condition}
and ${criterion.condition} #{criterion.value}
and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}
and ${criterion.condition}
#{listItem}
and ${criterion.condition}
and ${criterion.condition} #{criterion.value}
and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}
and ${criterion.condition}
#{listItem}
id, dname, dtel, description, establishmentdate
delete from game
where id = #{id,jdbcType=INTEGER}
delete from game
insert into game (id, dname, dtel,
description, establishmentdate)
values (#{id,jdbcType=INTEGER}, #{dname,jdbcType=VARCHAR}, #{dtel,jdbcType=VARCHAR},
#{description,jdbcType=VARCHAR}, #{establishmentdate,jdbcType=TIMESTAMP})
insert into game
id,
dname,
dtel,
description,
establishmentdate,
#{id,jdbcType=INTEGER},
#{dname,jdbcType=VARCHAR},
#{dtel,jdbcType=VARCHAR},
#{description,jdbcType=VARCHAR},
#{establishmentdate,jdbcType=TIMESTAMP},
update game
id = #{record.id,jdbcType=INTEGER},
dname = #{record.dname,jdbcType=VARCHAR},
dtel = #{record.dtel,jdbcType=VARCHAR},
description = #{record.description,jdbcType=VARCHAR},
establishmentdate = #{record.establishmentdate,jdbcType=TIMESTAMP},
update game
set id = #{record.id,jdbcType=INTEGER},
dname = #{record.dname,jdbcType=VARCHAR},
dtel = #{record.dtel,jdbcType=VARCHAR},
description = #{record.description,jdbcType=VARCHAR},
establishmentdate = #{record.establishmentdate,jdbcType=TIMESTAMP}
update game
dname = #{dname,jdbcType=VARCHAR},
dtel = #{dtel,jdbcType=VARCHAR},
description = #{description,jdbcType=VARCHAR},
establishmentdate = #{establishmentdate,jdbcType=TIMESTAMP},
where id = #{id,jdbcType=INTEGER}
update game
set dname = #{dname,jdbcType=VARCHAR},
dtel = #{dtel,jdbcType=VARCHAR},
description = #{description,jdbcType=VARCHAR},
establishmentdate = #{establishmentdate,jdbcType=TIMESTAMP}
where id = #{id,jdbcType=INTEGER}