mybatils 增删改查

<?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.cloudtech.web.dao.AdminMapper">
  
  <resultMap id="BaseResultMap" type="com.cloudtech.web.entity.Admin">
    <id column="id" property="id" />
    <result column="operator_id" property="operatorId" />
    <result column="operator_name" property="operatorName" />
    <result column="role_id" property="roleId" />
    <result column="role_name" property="roleName" />
    <result column="username"  property="username" />
    <result column="password" property="password" />
    <result column="is_enabled" property="isEnabled" />
    <result column="is_locked" property="isLocked" />
    <result column="login_ip" property="loginIp" />
    <result column="login_date" property="loginDate" />
    <result column="login_failure_count" property="loginFailureCount" />
    <result column="locked_date" property="lockedDate" />
    <result column="name" property="name" />
    <result column="mobile" property="mobile" />
    <result column="email" property="email" />
    <result column="introduction" property="introduction" />
    <result column="add_time" property="addTime" />
  </resultMap>
   <select id="listLikeSearch" parameterType="java.util.Map" resultMap="BaseResultMap">
  		SELECT
			a.id,
			a.username,
			o. NAME AS operatorName,
			r. NAME AS roleName,
			a. NAME,
			a.is_locked,
			a.is_enabled,
			a.mobile,
			a.login_date,
			a.add_time
		FROM
			admin a
		INNER JOIN operator o ON o.id = a.operator_id
		INNER JOIN role r ON r.id = a.role_id
		where 1=1
  		<if test="publicvo.search != null">
  		 and (a.username LIKE '${publicvo.search}%' or a.name LIKE '${publicvo.search}%' or a.mobile LIKE '${publicvo.search}%')
		</if>
  </select>
  
</mapper>

namespace 是dao类的位置

id="listLikeSearch"  listLikeSearch是dao类的一个方法名

parameterType是形参

resultMap是返回值，一般有两种，返回resultMap或者resultType