本文共 5551 字，大约阅读时间需要 18 分钟。

    
   
        
    
            
     
            
     
            
     
                
      
                
      
                    
       
                    
       
                    
       
                    
       
                    
       
                    
       
                    
       
                    
       
                    
       
                    
       
                    
       
                    
       
                    
       
                    
       
                    
       
                    
       
                
      
                
      
                
      
                    
       
                    
       
                    
       
                    
       
                    
       
                    
       
                    
       
                
      
                
      
                
      
                    select count(*) from user
                
                
      
                
      
                    select * from user
                
                
      
                
      
                    select * from user where userName like concat('%', #{userName}, '%')
                
                
      
                
      
                    select * from user where userName like concat('%', #{userName}, '%') and userRole = #{userrole}
                
                
      
                
      
                    select * from user where userName like concat('%', #{userName}, '%') and userRole = #{userrole}
                
                
      
                
      
                    select u.* from user u join role r on u.userRole = r.id where u.userName like concat('%', #{userName}, '%') and u.userrole = #{userrole}
                
                
      
                
      
       
                    insert into user
                    (userCode, userName, userPassword, gender, birthday, phone, address, userRole, createdBy, creationDate, modifyBy, modifyDate)
                    values #{userCode}, #{userName}, #{userPassword}, #{gender}, #{birthday}, #{phone}, #{address}, #{userrole}, #{createBy}, #{creationDate}, #{modifyBy}, #{modifyDate}
                
      
                
      
                
      
       
                    update user
                        set userCode=#{userCode}, userName=#{userName}, userPassword=#{userPassword}, 
                           gender=#{gender}, birthday=#{birthday}, phone=#{phone}, address=#{address}, userRole=#{userrole}, 
                           createdBy=#{createBy}, creationDate=#{creationDate}, modifyBy=#{modifyBy}, modifyDate=#{modifyDate}
                    where id=#{id}
                
      
                
      
                
      
       
                    delete from user where id=#{id}
                
      
                
      
                
      
                    select * from user where id = #{id}
                
                
      
                
      
                    select u.* from user u, role r where u.userrole = #{userrole} and r.id = u.userrole
                
                
      
                
      
                    select u.* from user u, role r where u.userrole = r.id and userrole = #{userrole} and userName like concat('%', #{userName}, '%')
                
                
      
                
      
                    select * from user where userrole = #{userrole} and userName like concat('%', #{userName}, '%')
                
                
      
                
      
       
                    update user
                    
       
                        
        
         userCode=#{userCode}
        
                        
        
         userName=#{userName}
        
                        
        
         userPassword=#{userPassword}
        
                        
        
         gender=#{gender}
        
                        
        
         birthday=#{birthday}
        
                        
        
         phone=#{phone}
        
                        
        
         address=#{address}
        
                        
        
         userrole=#{userrole}
        
                        
        
         createdBy=#{createBy}
        
                        
        
         creationDate=#{creationDate}
        
                        
        
         modifyBy=#{modifyBy}
        
                        
        
         modifyDate=#{modifyDate}
        
                    
       
                    where id=#{id}
                
      
                
      
                
      
       
                    update user
                    
       
                        
        
         userCode=#{userCode}
        
                        
        
         userName=#{userName}
        
                        
        
         userPassword=#{userPassword}
        
                        
        
         gender=#{gender}
        
                        
        
         birthday=#{birthday}
        
                        
        
         phone=#{phone}
        
                        
        
         address=#{address}
        
                        
        
         userrole=#{userrole}
        
                        
        
         createdBy=#{createBy}
        
                        
        
         creationDate=#{creationDate}
        
                        
        
         modifyBy=#{modifyBy}
        
                        
        
         modifyDate=#{modifyDate}
        
                    
       
                
      
                
      
                
      
                    select * from user where userrole in #{roleids}
                
                
      
                    select * from user where userrole in #{roleids}
                
                
      
                    select * from user where gender = #{gender} and userrole in #{roleMap}
                
                
      
                    select * from user where userrole in #{roleMap}
                
                
      
                
      
                    select * from user where 1=1
                        and userName like concat('%', #{userName}, '%') 
                        and userrole = #{userrole}
                        and userCode = #{userCode}
                        and YEAR(creationDate) = YEAR(#{creationDate})
                
                
      
                
      
                    select * from user limit #{from}, #{pageSize}