Oliver's Blog

MyBatis使用SQL查询

  • Sep 11, 2015

定义Mapper接口

@Repository  
public interface UserLoginLogMapper {  
    Long getLoginLogCountByLoginTime(@Param("userId")Integer userId, @Param("startTime") LocalDateTime startTime, @Param("endTime") LocalDateTime endTime);  
}

编写SQL

XML文件默认放在与Mapper接口同路径下

如Mapper接口在com.oliverclio.languagetrainer.mapper包下，则XML文件放在路径/resources/com/oliverclio/languagetrainer/mapper下

UserLoginLogMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>  
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "https://mybatis.org/dtd/mybatis-3-mapper.dtd">  
<mapper namespace="com.oliverclio.languagetrainer.mapper.UserLoginLogMapper">  
    <select id="getLoginLogCountByLoginTime" resultType="java.lang.Long">  
        select count(*) from t_user_login_log  
        where user_id = #{userId}  
        and login_time &gt;= #{startTime}  
        and login_time &lt; #{endTime}  
    </select>  
</mapper>
Search