使用实体类映射文件增删改查

1.在map接口里写入如下代码

点击查看代码

// 使用xml方法调接口

	List<Admin> findAdmin2();

	int delAdmin2(String id2);

	int addAdmin2(Admin admin);

	int updateAdmin2(Admin admin);
	
	int addAdmin3(@Param("username")String username,@Param("realName")String realName,@Param("userRole")String userRole,@Param("userState")String userState);

2.创建对应的映射文件

3.编写xml内的代码（注意xml内代码id要与mapper内方法名相同，）

点击查看代码

<?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.mhys.mapper.AdminMapper">
	<select id="findAdmin2" resultType="Admin">
		select*from tb_admin
	</select>
	
	<delete id="delAdmin2">
		delete from tb_admin where id=#{id2}
	</delete>
	
	<insert id="addAdmin2" useGeneratedKeys="true" keyProperty="id">
		insert tb_admin values(null,#{username},#{realName},#{userRole},#{userState})
	</insert>
	
	<update id="updateAdmin2">
		update tb_admin set username=#{username},realName=#{realName},userRole=#{userRole},userState=#{userState} where id=#{id}
	</update>
	
	<insert id="addAdmin3">
		insert tb_admin values(null,#{username},#{realName},#{userRole},#{userState})
	</insert>
</mapper>

4.测试无误