这一篇主要介绍:使用 XML 配置 SQL 映射器
INSERT 映射语句
UPDATE 映射语句
DELETE 映射语句
SELECT 映射语
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.java.mappers.StudentMapper">
<resultMap type="Student" id="StudentMap">
<id property="id" column="id"/>
<result property="name" column="name"/>
<result property="age" column="age"/>
</resultMap>
<insert id="add" parameterType="Student" >
insert into t_student values(null,#{name},#{age})
</insert>
<update id="update" parameterType="Student">
update t_student set name=#{name},age=#{age} where id=#{id}
</update>
<delete id="delete" parameterType="Integer">
delete from t_student where id=#{id}
</delete>
<select id="findById" parameterType="Integer" resultType="Student">
select * from t_student where id=#{id}
</select>
<select id="find" resultMap="StudentMap">
select * from t_student
</select>
</mapper>
- insert语句 看上面的例子,id是方法名,parameterType是方法的参数类型
- update语句 id是方法名,parameterType是方法参数类型
- delete语句 id是方法名, parameterType是方法参数类型,resultType是返回类型
- select语句 id是方法名, parameterType是方法参数类型,如果返回的是集合,那就用resultMap ,在前面定义好: