use Local sql
public interface TBankRepository extends JpaRepository<TBank,Integer> {
@Transactional
@Query(value = "update TBank set bankMoney = bankMoney + ?2 where bankNo = ?1")
@Modifying
public int updateByNum(String num,double money);
List<TBank> findByUserId(Integer id);
// 查询根据卡号
TBank findByBankNo (String num);
}