问题:在spring boot中使用jpa进行条件查询,报错:Unknown column 'userId' in 'where clause'
查询语句:
/**
*@Author: ZongMao on 2020/3/4 14:56
*通过userId查询符合的所有数据
*@return
*/
@Modifying
@Transactional
@Query(value = "select * from Repair as r where r.userId=?1",nativeQuery = true)
public List<Repair> getRepair(Integer userId);
控制台报错:
怀疑是userId的问题,但其他的jpa语句同样使用的为userId,均正常。查看数据库后数据库中字段名为user_id,遂修改语句为:
@Modifying
@Transactional
@Query(value = "select * from Repair as r where r.user_id=?1",nativeQuery = true)
public List<Repair> getRepair(Integer userId);
正常查询:
但没搞明白