<mapper namespace="com.java.mappers.StudentMapper">
<!--定义返回类型为student的返回集合,property对应student的属性,column对应表中的字段-->
<resultMap type="Student" id="StudentList">
<!-- <id property="id" column="id"/>,id是用来定义主键的,可以不使用,用result定义 -->
<result property="name" column="name"/>
<result property="age" column="age"/>
</resultMap>
<!--新增语句-->
insert into student values(#{id},#{name},#{age})
</insert>
<!--修改语句-->
update student set name=#{name},age=#{age} where id=#{id}
</update>
<!--删除语句-->
delete from student where id=#{id}
</delete>
<!--查找语句,两个参数,一个为入参id,一个为返回参数student-->
select * from student where id=#{id}
</select>
<!--查找语句,返回类型为结果集resultMap,在上面定义过-->
select * from student
</select>
</mapper>