ID, NAME, PASSWORD, CREATE_DATE, CREATE_TIME select from user where ID = #{id,jdbcType=INTEGER} delete from user where ID = #{id,jdbcType=INTEGER} insert into user (ID, NAME, PASSWORD, CREATE_DATE, CREATE_TIME) values (#{id,jdbcType=INTEGER}, #{name,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR}, #{createDate,jdbcType=VARCHAR}, #{createTime,jdbcType=VARCHAR}) insert into user ID, NAME, PASSWORD, CREATE_DATE, CREATE_TIME, #{id,jdbcType=INTEGER}, #{name,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR}, #{createDate,jdbcType=VARCHAR}, #{createTime,jdbcType=VARCHAR}, update user NAME = #{name,jdbcType=VARCHAR}, PASSWORD = #{password,jdbcType=VARCHAR}, CREATE_DATE = #{createDate,jdbcType=VARCHAR}, CREATE_TIME = #{createTime,jdbcType=VARCHAR}, where ID = #{id,jdbcType=INTEGER} update user set NAME = #{name,jdbcType=VARCHAR}, PASSWORD = #{password,jdbcType=VARCHAR}, CREATE_DATE = #{createDate,jdbcType=VARCHAR}, CREATE_TIME = #{createTime,jdbcType=VARCHAR} where ID = #{id,jdbcType=INTEGER} select from user where name = #{name,jdbcType=VARCHAR}