<?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.qf.mds.mapper.DeptMapper"> <select id="findAll" resultType="com.qf.mds.po.Dept"> SELECT id,dname,loc from dept </select> <delete id="DeleteDept" > DELETE from dept where id=#{id} </delete> <update id="UpdateDept"> UPDATE dept set dname=#{dname} ,loc=#{loc} where id=#{id} </update> <insert id="InsertDept" useGeneratedKeys="true" keyProperty="id"> INSERT INTO dept (dname,loc) VALUES ( #{dname},#{loc}) </insert> </mapper>
DeptMapper
最新推荐文章于 2023-03-21 22:58:34 发布