@Query写HQL和SQL区别，亲测好用
1.SQL，写nativeQuery=true
@Query(nativeQuery = true,value = "SELECT ID, PID AS pId,name , ( CASE WHEN (pId = 0 OR pId IS NULL) THEN 'true' ELSE 'false' END ) AS isOpen FROM T_SYS_GOODS")
2.HQL，不写nativeQuery=true
@Query(value = "FROM Goods WHERE pId != 0 ")
