src/main/java/com/yuanlrc/base/dao/home/AddressDao.java

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.yuanlrc.base.dao.home;

import com.yuanlrc.base.entity.home.Address;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import javax.transaction.Transactional;
import java.util.List;

/**
 * 地址处理层
 */
@Repository
public interface AddressDao extends JpaRepository<Address,Long> {

    /**
     * 通过id查找
     */
    @Query("select a from Address a where id = :id")
    public Address find(@Param("id") Long id);

    /**
     * 得到当前用户的地址
     */
    public List<Address> findByMemberId(@Param("id")Long id);

    /**
     * 根据常用状态查询地址
     * @param status
     * @return
     */
    public Address findByStatus(@Param("status")int status);


    /**
     * 根据id更新状态
     * @param status
     * @param id
     * @return
     */
    @Transactional
    @Modifying
    @Query(value = "update db_address set status=:status where id=:id",nativeQuery = true)
    public int updateStatus(@Param("status")int status,@Param("id")Long id);

    /**
     * 地址个数
     * @param id
     * @return
     */
    @Query(value = "select count(*) from db_address where member_id=:id",nativeQuery = true)
    public int countAddress(@Param("id")Long id);
}