MyBatis

MyBatis 实现动态SQL语句： 

    
    
    
    
        select id,last_name lastName,gender,email  FROM tbl_employee
        
        
        
             id=#{id}
        

        
            AND last_name like #{lastName}
        

        
        
            AND email = #{email}
        

        
            AND gender = #{gender}
        
        
    


    
    
    select id,last_name lastName,gender,email
    FROM tbl_employee
        
        

        
            id=#{id} AND
        

        
            last_name like #{lastName} AND
        

        
        
             email = #{email} AND
        

        
            gender = #{gender}
        
        
    


    
    
        
        
        SELECT id,last_name lastName,gender,email
        FROM tbl_employee
        
            
                
                    id=#{id}
                
                
                    last_name LIKE #{my_lastname}
                
                
                    email LIKE #{email}
                
                
                    gender = #{gender}
                
                
                    1=1
                
            

        

    


    
    
        UPDATE tbl_employee
        
            
                last_name = #{lastName},
            
            
                email = #{email},
            
            
                gender = #{gender},
            
        
        
            id=#{id}
        
    


    
    
        SELECT id,last_name lastName,gender,email
        FROM tbl_employee
        WHERe id IN
        
        
          #{ltem_id}
        

    

    
    
        INSERT INTO tbl_employee( last_name,gender,email)
        VALUES
        
            (#{item_emps.lastName},#{item_emps.gender},#{item_emps.email})