MyBatis的基本元素架构：

    
    
                      //namespace：包名+匹配的接口类             
     
                  //id：结果集的唯一标识    type：包名+实体类                    
                   //column：数据库表字段    property：实体类成员变量                    
      
                       //property：数据库表名    javaType：包名+实体类                            
                       //column：数据库表字段    property：实体类成员变量                
       
             //增        INSERT INTO cms_approval (            id,                //表中的字段            approver,            approval_status,            is_delete,        ) VALUES (            #{approval.id,              jdbcType=VARCHAR  },            #{approval.approver,        jdbcType=VARCHAR  },            //成员变量                javaType：数据类型    typeHandler：类对象的存储规则类            #{approval.approvalStatus,  jdbcType=NUMERIC, typeHandler=approvalStatusTypeHandler }            false        )        
        
             //删    
         
                       //改        UPDATE cms_approval                //表字段       使用#号{}花括号     成员变量        数据类型            SET approver        = #{approval.approver,            jdbcType=VARCHAR  },                approval_status = #{approval.approvalStatus,      jdbcType=NUMERIC,                                   typeHandler=approvalStatusTypeHandler  },                                //类对象的存储规则类                is_delete       = #{approval.isDelete,            jdbcType=BOOLEAN  },                account_id      = #{approval.account.id,          jdbcType=VARCHAR  }        WHERE id = #{approval.id}        
          
            //查        SELECT        
                   FROM cms_approval ap        left join cms_account ac on ap.account_id = ac.id        WHERE ap.id = #{id}        
           
                //封装的公共SQL语句