Mybatits的mapper.xml映射sql文件

java实习生886

于 2023-07-07 11:27:14 发布

阅读量117

点赞数

文章标签： sql xml 数据库

本文链接：https://blog.youkuaiyun.com/lmd770013209/article/details/131593292

版权

Mybatits的mapper.xml映射sql文件

<?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.bjpowernode.dao.StudentDao">
 
//namespace的值是dao接口的全限定名称（即在哪个包下面要全部写出来
//增删改查子标签的id要和接口中的方法名一样
     
   <!--实现查询功能的select子标签-->
   <select id="selectStudents" resultType="com.bjpowernode.domain.Student">
        select id,name,email,age from student order by id
    </select>
 
    <!--实现插入功能的insert子标签-->
    <insert id="insertStudent">
        insert into student values(#{id},#{name},#{email},#{age})
    </insert>
 
    <!--实现修改功能的update子标签-->
    <update id="updateEmp">
            UPDATE emp SET name = #{name} WHERE id = #{id};
    </update>
 
    <!--实现删除功能的delete子标签-->
    <delete id="deleteEmp">
            DELETE FROM emp WHERE id = #{id};
    </delete>
</mapper>