spring boot mysql_如何在Spring Boot中使用MySql数据库查询？

I am creating an API by using spring boot. In this project, I used spring web, JPA, jstl and MySql as dependencies of the API. In this project, I have created a Controller, Model and Repository. Basically, this API does CRUD operations. When I use GET request, I want to get only 3 columns. But, the case is I used JPA in this and I don't know how to use custom queries like

"SELECT devname,hrs,ot FROM imaginaryTable"

.

How can I do this ??

My Controller class.

@RestController

@RequestMapping("/api")

public class ImController {

@Autowired

private ImRepository TaskRepository;

@GetMapping("/projects")

public List findAll() {

return (List) TaskRepository.findAll();

}

@GetMapping("/developers/{id}")

public ImModel findByName(@PathVariable final int id){

return TaskRepository.findById(id);

}

}

My Repository interface.

package com.kisalka.pacrestapi.repository;

import org.springframework.data.jpa.repository.JpaRepository;

import com.kisalka.pacrestapi.model.ImModel;

public interface ImRepository extends JpaRepository {

ImModel findById(int id);

}

解决方案

You could use @Query("Your query") annotation inside the repository to query the database.

For Example

@Query(value="SELECT devname,hrs,ot FROM imaginaryTable",nativeQuery=true)

private List getValues();

Hope it solves your issue.