StudentMapper.xml

    1. <?xml version="1.0" encoding="UTF-8" ?>
    2. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3//EN"
    3.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    4. <!--
    5.     mapper:是个整体文件的大标签，用来开始和结束xml文件
    6.     属性: namespace指定命名空间(相当于包名)用来区分不同mapper.xml文件中相同的id属性
    7. -->
    8. <mapper namespace="zar">
    9.     <!--
    10.         完成查询全部学生的功能
    11.         之前是List<Student> getAll();
    12.         resultType:指定查询返回的结果集的类型，如果是集合则必须是泛型的类型
    13.         parameterType: 如果有参数，则通过它来指定参数的类型
    14.     -->
    15.     <select id="getAll" resultType="org.pojo.Student">
    16.         select * from student
    17.     </select>
    19.     <!--
    20.         按学生名模糊查询
    21.         List<Student> getByName(String name);
    22.     -->
    23.     <select id="getByName" parameterType="string" resultType="org.pojo.Student">
    24.         select * from student where name like '%${name}%'
    25.     </select>
    26.     <!--
    27.         增加学生
    28.             int insert(Student stu);
    29.         实体类:
    30.             private Integer id;
    31.             private String name;
    32.             private String email;
    33.             private Integer age;
    34.     -->
    35.     <insert id="insert1" parameterType="org.pojo.Student">
    36.         insert into student (id,name,email,age) values (#{id},#{name},#{email},#{age})
    37.     </insert>
    39.     <!--
    40.        按主键删除学生
    41.        int delete(Integer id);
    42.     -->
    43.     <delete id="delete1" parameterType="int">
    44.         delete from student where id=#{id}
    45.     </delete>
    47.     <!--
    48.         更新学生
    49.         int update(Student stu);
    50.     -->
    51.     <update id="update1" parameterType="org.pojo.Student">
    52.         update student set name=#{name},email=#{email},age=#{age} where id=#{id}
    53.     </update>
    54. </mapper>
    public class AppTest{
    @Test
    public void update1() throws IOException{
        InputStream in = Resources.getResourceAsStream("mybatis.xml");
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);
        SqlSession sqlSession = factory.openSession();
        int num = sqlSession.update("zar.update1",new Student(1002,"王五","wangwu@qq.com",30));
        System.out.println(num);
        sqlSession.commit();
        sqlSession.close();
    }
}