mybatis框架的xml映射文件常用查询指南

 org.mybatis.spring.boot
 mybatis-spring-boot-starter
 2.1.3

mybatis:
  mapper-locations: classpath:mapper/*.xml

<?xml version="1.0" encoding="UTF-8"?>


 
 
 
 
 
 
 
 
 
 
 

    select id,
           host_name,
           ip,
           user_name,
           pass_word,
           state,
           tag,
           gmt_created,
           gmt_modified
    from host
 
    
        and id = #{id}
    
    
        and host_name like CONCAT('%', #{hostName}, '%')
    
    
        and ip like CONCAT('%', #{ip}, '%')
    
    
        and user_name = #{userName}
    
    
        and pass_word = #{passWord}
    
    
        and state = #{state}
    
    
        and tag = #{tag}
    
    
        and gmt_created = #{gmtCreated}
    
    
        and gmt_modified = #{gmtModified}
    /if>
 

/**
 * 条件查询
 *
 * @param host 条件查询
 * @return 对象列表
 */
List queryAll(Host host);

 delete
    from host
            where id in
    
        
            #{id}
        
    
 

delete from host where id in(1,2,3)

/**
 * 批量删除主机
 *
 * @param hostIds 主机id数组
 * @return Integer
 */Integer deleteHostByIds(@Param("hostIds") Long[] hostIds);

 insert into host_and_group(host_group_id, host_id)
       values
    
            (#{hostGroupId}, #{hostId})
    

/**
 * 将多个主机添加至一个主机组
 *
 * @param request
 * @return Integer
 */Integer addHostList(HostAndGroupRequest request);