前往新版Gitcode,体验更适合开发者的 AI 搜索 >>
//IntelliJ IDEA //campus //SysUserRepository //2020/5/5 // Author:御承扬 //E-mail:2923616405@qq.com package com.pyc.campus.dao; import com.pyc.campus.domain.SysUser; import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Modifying; import org.springframework.data.jpa.repository.Query; import org.springframework.transaction.annotation.Transactional;
public interface SysUserRepository extends JpaRepository<SysUser,Long> { SysUser findByUsername(String username);
@Modifying @Transactional @Query("update SysUser s set s.password=?1 where s.username=?2") int updatePassword(String password, String username);
@Modifying @Transactional @Query("delete from SysUser where username=?1") void delByUsername(String username);
}