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

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

package com.yuanlrc.base.dao.home;

import com.yuanlrc.base.entity.home.Member;
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.math.BigDecimal;

/**
 * 用户处理层
 */
@Repository
public interface MemberDao extends JpaRepository<Member,Long> {

    /**
     * 通过id查找
     */
    @Query("select c from Member c where id = :id")
    public Member find(@Param("id") long id);

    /**
     * 得到最大id
     */
    @Query("select max(id) from Member")
    public Integer findMaxId();

    /**
     * 通过用户名查找
     */
    @Query("select c from Member c where username = :username")
    public Member findByUsername(@Param("username") String username);

    /**
     * 通过手机号码查找
     */
    @Query("select c from Member c where mobile = :mobile")
    public Member findByMobile(@Param("mobile") String mobile);

    /**
     * 通过邮箱查找
     */
    @Query("select c from Member c where email = :email")
    public Member findByEmail(@Param("email") String email);


    /**
     * 更新用户余额
     * @param id
     * @param balance
     * @return
     */
    @Transactional
    @Modifying
    @Query(value = "update db_member set balance=:balance where id=:id",nativeQuery = true)
    public int updateBalance(@Param("id")Long id, @Param("balance")BigDecimal balance);