mybatis增删改查基本语句

<!--查询所有-->
<select id="getall" resultType="Studnet">
    select id,name,eamail,age
    from student
</select>

<!--通过主键id查询-->
<select id="getbyid" parameterType="int" resultType="Studnet">
    select id,name,eamail,age
    from student
    where id = #{id}
</select>

<!--按学生名字模糊查询-->
<select id="getbyname" parameterType="string" resultType="Studnet">
    select id,name,eamail,age
    from student
    where name like '%${value}%'
</select>

<!--添加学生-->
<insert id="inset" parameterType="Studnet">
    insert into student(name,eamail,age) values (#{name},#{eamail},#{age})
</insert>

<!--删除学生-->
<insert id="delete" parameterType="int">
  delete from student where id = #{id}
</insert>

<!--更新学生-->
<update id="update" parameterType="Studnet">
    update student set name=#{name},eamail=#{eamail},age=#{age}
    where id=#{id}
</update>