xin.dayukeji.common.dao.log

接口 LogDao

所有超级接口:

BaseRepository<Log,java.lang.Integer>, org.springframework.data.repository.CrudRepository<Log,java.lang.Integer>, org.springframework.data.jpa.repository.JpaRepository<Log,java.lang.Integer>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<Log>, org.springframework.data.repository.PagingAndSortingRepository<Log,java.lang.Integer>, org.springframework.data.repository.query.QueryByExampleExecutor<Log>, org.springframework.data.repository.Repository<Log,java.lang.Integer>

public interface LogDao
extends BaseRepository<Log,java.lang.Integer>

In DingTalkPro-xin.dayukeji.dingtalk.common.dao Create in 13:09 2018/4/11 author canfuu version v1.0 descriotion 描述

方法概要

限定符和类型	方法和说明
long	countByClient(java.lang.String client)
long	countByClientLike(java.lang.String client)
long	countByClientLikeAndTimeAfter(java.lang.String client, java.sql.Timestamp time)
long	countByTimeAfter(java.sql.Timestamp time)
long	countByTimeBetween(java.sql.Date start, java.sql.Date end)
java.util.List<java.lang.Long>	countByTimeFormatIn(java.util.Date start, java.util.Date end, java.lang.String client)
java.util.List<java.lang.String>	findAllDistinct()

从接口继承的方法 org.springframework.data.jpa.repository.JpaRepository

deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAll, findAllById, flush, getOne, saveAll, saveAndFlush

从接口继承的方法 org.springframework.data.repository.PagingAndSortingRepository

findAll

从接口继承的方法 org.springframework.data.repository.CrudRepository

count, delete, deleteAll, deleteAll, deleteById, existsById, findById, save

从接口继承的方法 org.springframework.data.repository.query.QueryByExampleExecutor

count, exists, findAll, findOne

从接口继承的方法 org.springframework.data.jpa.repository.JpaSpecificationExecutor

count, findAll, findAll, findAll, findOne

方法详细资料

countByTimeAfter

long countByTimeAfter(java.sql.Timestamp time)

countByTimeFormatIn

@Query(value="SELECT count(l.id) FROM (SELECT id,time FROM log WHERE client=:client) l RIGHT JOIN time t ON date_format(l.time,\'%Y-%m-%d\')=t.time WHERE t.time BETWEEN :start AND :end GROUP BY t.time ORDER BY t.time ASC",
       nativeQuery=true)
java.util.List<java.lang.Long> countByTimeFormatIn(@Param(value="start")
                                                                                                                                                                                                                                                                                                           java.util.Date start,
                                                                                                                                                                                                                                                                                                           @Param(value="end")
                                                                                                                                                                                                                                                                                                           java.util.Date end,
                                                                                                                                                                                                                                                                                                           @Param(value="client")
                                                                                                                                                                                                                                                                                                           java.lang.String client)

findAllDistinct

@Query(value="select DISTINCT l.client from log l",
       nativeQuery=true)
java.util.List<java.lang.String> findAllDistinct()

countByTimeBetween

long countByTimeBetween(java.sql.Date start,
                        java.sql.Date end)

countByClient

long countByClient(java.lang.String client)

countByClientLike

@Query(value="select count(id) from Log where client like :client")
long countByClientLike(@Param(value="client")
                                                                                           java.lang.String client)

countByClientLikeAndTimeAfter

@Query(value="select count(id) from Log where client like :client and time > :time")
long countByClientLikeAndTimeAfter(@Param(value="client")
                                                                                                                        java.lang.String client,
                                                                                                                        @Param(value="time")
                                                                                                                        java.sql.Timestamp time)