12345678910111213141516171819202122232425262728293031323334353637383940 |
- package com.boot.security.server.dao;
- import java.util.List;
- import java.util.Map;
- import org.apache.ibatis.annotations.Delete;
- import org.apache.ibatis.annotations.Insert;
- import org.apache.ibatis.annotations.Mapper;
- import org.apache.ibatis.annotations.Param;
- import org.apache.ibatis.annotations.Select;
- import com.boot.security.server.model.CusLoginInfo;
- @Mapper
- public interface CusLoginInfoDao {
- @Select("select * from cus_login_info t where t.id = #{id}")
- CusLoginInfo getById(Long id);
- @Delete("delete from cus_login_info where id = #{id}")
- int delete(Long id);
- int update(CusLoginInfo cusLoginInfo);
-
- @Insert("insert into cus_login_info(openId, session_key, unionId, token, create_time, last_mod_time) values(#{openId}, #{sessionKey}, #{unionId}, #{token}, #{createTime}, #{lastModTime})")
- int save(CusLoginInfo cusLoginInfo);
-
- int count(@Param("params") Map<String, Object> params);
- List<CusLoginInfo> list(@Param("params") Map<String, Object> params, @Param("offset") Integer offset, @Param("limit") Integer limit);
-
- @Select("select * from cus_login_info t where t.openId = #{openid}")
- CusLoginInfo getDetailByOpenId(String openid);
-
- @Select("select * from cus_login_info t where t.token = #{token}")
- CusLoginInfo getDetailByToken(String token);
-
- // 根据openid更新登录信息
- int updateByOpenId(CusLoginInfo cusLoginInfo);
- }
|