汤臣一品java项目书

<?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" > <!--namespace属性：指定DAO接口中类全名，与映射接口全限定名完全一致--> <mapper namespace="dao.MemberDao"> <resultMap id="MemberMapper" type="entity.Member"> <result property="uid" column="uid"/> <result property="name" column="name"/> <result property="gender" column="gender"/> <result property="role" column="role"/> <result property="classId" column="class_id"/> <result property="number" column="number"/> </resultMap> <select id="list" resultMap="MemberMapper"> select * from `manage-system`.member_info; </select> <select id="searchByNumber" resultMap="MemberMapper"> select * from `manage-system`.member_info where number = #{number} </select> <select id="searchByUid" resultMap="MemberMapper"> select * from `manage-system`.member_info where uid = #{uid} </select> <insert id="add"> insert into `manage-system`.member_info (uid, gender, name, role, class_id, number) values (#{uid}, #{gender}, #{name}, #{role}, #{classId}, #{number}) </insert> <update id="update"> update `manage-system`.member_info set name=#{name}, role=#{role}, class_id=#{classId}, number=#{number}, gender=#{gender} where uid = #{uid} </update> <delete id="delete"> delete from `manage-system`.member_info where uid = #{uid}; </delete> </mapper>