mybatis-mapper.xml配置

   
    
        insert into dept(name,type_id,note) values(#{name},#{typeId},#{note})
    
    
        delete from dept where no in (${ids})
    
    
        delete from dept where no in
        
            #{id}
        

    
    
        select no,name,type_id,note from dept
    
    
        select * from dept where name = '${name}'
    
    
        select * from dept where name = #{name} or type_id = #{typeId}
    
    
        select * from dept where name like '%${name}%'
--       select * from dept where name like concat ('%',#{name},'%')
    
    
        select * from ${tableName}
    
    
        select * from dept where no = #{no}
    
    
       select * from dept left join emp  on dept.no = emp.dept_no where dept.no = #{id}
    
    
        select * from dept where no = #{no}
    
    
        select * from dept
        
       
           
                name = #{name}  and
           
           
              note = #{note}  or