如何在Spring Boot中获取json格式的select数据

Question

@Repository
public interface UserDao extends JpaRepository<User, Long> {
    @Query(value = "SELECT ss.name AS name, \n" +
            " SUM(pp.amount) AS amount, \n" +
            " REPLACE(ss.name, 'SomeName', 'DifferentName') AS cname \n" +
            " FROM payments AS pp\n" +
            " INNER JOIN auth_user AS au ON au.id = pp.creator_id\n" +
            " INNER JOIN services AS ss ON ss.id = pp.service_id\n" +
            " WHERE\n" +
            " pp.created_dt >= '2021-09-28' AND pp.created_dt < '2021-09-29' \n" +
            " AND ss.name = 'SomeName' AND pp.status = 'SUCCESS' \n" +
            " GROUP BY ss.name\n" //+
             , nativeQuery = true)
    List<User> findAll();
}

@Entity
//@Table(name = "payment")
public class User {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private long id;

    //@Column(name = "name")
    private String name;

    //@Column(name = "amount")
    private long amount;

   // @Column(name = "name")
    private String cName;

    public User(
            @JsonProperty("name") String name,
            @JsonProperty("amount")long amount,
            @JsonProperty("cName")String cName) {
        this.name = name;
        this.amount = amount;
        this.cName = cName;
    }

    public User(long id, String name, long amount, String cName) {
        this.id = id;
        this.name = name;
        this.amount = amount;
        this.cName = cName;
    }

    public long getId() {
        return id;
    }

    public String getName() {
        return name;
    }

    public long getAmount() {
        return amount;
    }

    public String getcName() {
        return cName;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", amount=" + amount +
                ", cName='" + cName + '\'' +
                '}';
    }
}

@Service(value = "userService")
public class UserServiceImpl implements UserService {

    @Autowired
    private UserDao userDao;

    private List<SimpleGrantedAuthority> getAuthority() {
        return Arrays.asList(new SimpleGrantedAuthority("ROLE_ADMIN"));
    }

    public List<User> findAll() {
        List<User> list = new ArrayList<>();
        userDao.findAll();
        return list;
    }

    @Override
    public User save(User user) {
        return userDao.save(user);
    }
}

@RestController
@RequestMapping("/users")
public class UserController {

    @Autowired
    private UserService userService;

    @GetMapping("/users")
    public List<User> getAllUsers() {
        return userService.findAll();
    }

    @RequestMapping(value = "/user", method = RequestMethod.GET)
    public List<User> listUser() {
        return userService.findAll();
    }

    @RequestMapping(value = "/user", method = RequestMethod.POST)
    public User create(@RequestBody User user) {
        return userService.save(user);
    }

                                                                                                                  

Answer 1

在UserServiceImpl类的公共列表用户findAll（）方法上添加@Override

试试看，

http://localhost:8080/users/users

和

http://localhost:8080/users/user