使用pojo类映射
<insert id="insert" parameterType="com.test.Student">
INSERT INTO student(
id,
code,
name,
status
) VALUES (
#{id},
#{code},
#{name},
#{status}
)
</insert>
使用map对象映射
<insert id="addCategory" parameterType="java.util.Map" >
insert into student
<trim prefix="(" suffix=")" suffixOverrides="," >
<if test="ID != null" >
ID,
</if>
<if test="NAME != null" >
NAME,
</if>
<if test="CODE != null" >
CODE,
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides="," >
<if test="ID != null" >
#{ID,jdbcType=INTEGER},
</if>
<if test="NAME != null" >
#{NAME,jdbcType=LONGVARCHAR},
</if>
<if test="CODE != null" >
#{CODE,jdbcType=LONGVARCHAR},
</if>
</trim>
</insert>