官网写的比较具体，可以查看以下的网站：

另外，实际用到标准的CRUD的操作和查询列表，

     
             
                  
              
              
                   
        
         AND id = #{id}
                    
        
         AND source_code = #{sourceCode}
                    
        
         AND userid = #{userid}
                    
        
         AND auth_item_id = #{authItemId}
                    
        
         AND isvalid = #{isvalid}
                    
                
           
              
      
               INSERT INTO tab_auth_item_record        
                   
        
         ,record_time
                    
        
         ,source_code
                    
        
         ,userid
                    
        
         ,auth_item_id
                    
        
         ,isvalid
                    
        
         ,last_status_time
                
               VALUES        
                   
        
         ,#{recordTime}
                    
        
         ,#{sourceCode}
                    
        
         ,#{userid}
                    
        
         ,#{authItemId}
                    
        
         ,#{isvalid}
                    
        
         ,#{lastStatusTime}
                
           
              
      
               UPDATE tab_auth_item_record        
                   
        
         ,record_time = #{recordTime}
                    
        
         ,source_code = #{sourceCode}
                    
        
         ,userid = #{userid}
                    
        
         ,auth_item_id = #{authItemId}
                    
        
         ,isvalid = #{isvalid}
                    
        
         ,last_status_time = #{lastStatusTime}
                    
                
               WHERE id = #{id}    
              
              SELECT  FROM tab_auth_item_record                                    LIMIT #{requestOffset}, #{requestCount}                    
              SELECT  FROM tab_auth_item_record                LIMIT 1            
              SELECT  FROM tab_auth_item_record WHERE id = #{id}            
              SELECT COUNT(1) FROM tab_auth_item_record         
      
               DELETE FROM tab_auth_item_record WHERE userid = #{userid}