MyBatis中的SQL语句

*Mapper.xml文件中进行SQL语句的书写

namespace属性是mapper.xml文件对应dao层的哪个接口，通过全路径名进行映射绑定。

<?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">
<!-- 相当于DAO接口的实现类-->
<mapper namespace="com.zzb.dao.StudentDao">

</mapper>

在*Mapper.xml文件中进行增删改查

<!--  添加  -->
<!--  useGeneratedKeys 设置添加操作是否需要回填生成的主键  -->
<!--  keyProperty 设置回填的主键赋值到参数对象的哪个属性  -->
    <insert id="insertStudent" useGeneratedKeys="true" keyProperty="id">
        insert into t_student(sno,sname,sex,age,classname,email)
        values(#{sno},#{name},#{sex},#{age},#{classname},#{email})
    </insert>
<!--  删除  -->
<!--  id对应dao层接口的方法命名  -->
    <delete id="deleteStudent">
        delete from t_student where sno=#{sno}
    </delete>

<!--  修改  -->
    <update id="updateStudent">
        update t_student
        set
            sname=#{name},
            sex=#{sex},
            age=#{age},
            classname=#{classname},
            email=#{email}
        where
            sno=#{sno}
    </update>

<!--  查询方法1  -->
<!--  resultType指定查询结果封装的对象的实体类  -->
<!--  resultSets="java.util.List"指定当前操作返回的集合类型，可省略不写  -->
<!--    <select id="selectStudent" resultType="com.zzb.pojo.Student" resultSets="java.util.List">
        select id id,sno sno,sname name,sex sex,age age,classname cname,email email from t_student

    </select>-->
<!--  查询方法2  建议使用方法 -->
<!--  id="studentMap"名字自定义 -->
    <resultMap id="studentMap" type="com.zzb.pojo.Student">
        <id column="id" property="id"/>
        <result column="sno" property="sno"/>
        <result column="sname" property="name"/>
        <result column="sex" property="sex"/>
        <result column="age" property="age"/>
        <result column="classname" property="classname"/>
        <result column="email" property="email"/>
    </resultMap>

<!-- resultMap="studentMap"与id="studentMap"对应-->
    <select id="selectStudent" resultMap="studentMap">
        select id,sno,sname,sex,age,classname,email
        from t_student
    </select>

<!--  查询指定数据  -->
    <select id="queryStudent" resultMap="studentMap">
        select id,sno,sname,sex,age,classname,email
        from t_student
        where  sno=#{sno}
    </select>

<!--  查询从第start开始的pageSize条数据  -->
<!--
    <select id="listStudentByPage" resultMap="studentMap">
        select id,sno,sname,sex,age,classname,email
        from t_student
        limit #{start},#{pageSize}
    </select>
    -->
<!--  查询共有多少条信息 -->
<!--    <select id="getCount" resultType="int">
        select count(1) from t_student
    </select>
    -->