insert
<insert id="insert2">
insert stu_2019 (id,name) values (#{param1},#{param2});
</insert>
upade
<update id="update">
update stu_2019 set name=#{param2} where id=#{param1}
</update>
delete
<delete id="delete">
delete from stu_2019 where id =#{id}
</delete>
select
<select resultType="java.util.Map" parameterType="Integer" id="select">
select * from stu_2019 where id=#{id}
</select>
resultType 类型的决定是由返回的类型决定 和返回的数组不数组没关系 后端接到的可以是map[]
select
<select id="select1" resultMap="select11" parameterType="int">
select name from stu_2019 where id=#{id}
</select>
<resultMap id="select11" type="hashmap">
<result column="id" property="vid"/>
<result property="vname" column="name"/>
</resultMap>
column是数据库表的列名 property 是后端获取数据的名字
select
<select id="select3" resultType="com.vo.vo">
select * from stu_2019 where id=#{id}
</select>
如果数据库表的查询结果的列名和bean的全局变量不同。查询语句使用别动和bean的全局变量名称一致