使用带有Spring Data JPA的自定义查询返回自定义对象

Question

@Entity
@Table(name="message")
public class Message {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "text_id")
    private long id;

    @NotNull
    private String author;

    @NotNull
    private String text;

    @NotNull
    private String recepient;

    public long getId() {return id;}

    public void setId(long id) {this.id = id;}

    public String getAuthor() {return author;}

    public void setAuthor(String author) {this.author = author;}

    public String getText() {return text;}

    public void setText(String text) {this.text = text;}

    public String getRecepient() {return recepient;}

    public void setRecepient(String recepient) {this.recepient = recepient;}

}

@RestController
@RequestMapping("/api")
public class MessageController {

    @Autowired
    private MessageService messageService;

    @GetMapping("/message/{id}")
    public Message getMessageTextById(@PathVariable(value="id") Long id) {
        return messageService.getMessageTextById(id);       
    }

}

@Service
public class MessageServiceImpl implements MessageService {

    @Autowired
    MessageRepository messageRepo;

    @Override
    public Message getMessageTextById(Long id) {        
        return messageRepo.findMessageTextById(id);     
    }

}

下面是存储库类

@Repository
public interface MessageRepository extends JpaRepository<Message, Long> {


    @Query("SELECT m.author, m.text FROM Message m WHERE m.id = :id")
    Message findMessageTextById(@Param("id") Long id);

}

Answer 1

如果只想检索某些列，可以使用一个简单的bean类：

public class CustomMessage{
  private String author;
  private String text;

  public CustomMessage(String author, String text) {
    this.author = author;
    this.author = text;
  }
}

然后从存储库返回一个bean实例：

@Query("SELECT new path_to_class.CustomMessage(m.author, m.text) FROM Message m WHERE m.id = :id")

或检索地图：

 @Query("SELECT new map(m.author as author, m.text as text) FROM Message m WHERE m.id = :id")