spring - 使用 Tomcat（无 Spring-Boot）和 PostgreSQL 在 Spring 中创建 findAll

Question

大家，早安。我创建了一个带有“活动”实体的 PostgreSQL 数据库。在此之后，我使用 JPA 工具从表中生成了实体，所以我有这个类：

import java.io.Serializable;
import javax.persistence.*;
import java.sql.Timestamp;
import java.util.List;


/**
 * The persistent class for the activity database table.
 * 
 */
@Entity
@NamedQuery(name="Activity.findAll", query="SELECT a FROM Activity a")
public class Activity implements Serializable {
    private static final long serialVersionUID = 1L;

    @Id
    private Integer id;

    @Column(name="create_time")
    private Timestamp createTime;

    @Column(name="created_by")
    private String createdBy;

    private String description;

    @Column(name="update_time")
    private Timestamp updateTime;

    @Column(name="updated_by")
    private String updatedBy;

    //bi-directional many-to-one association to CalendarHeader
    @OneToMany(mappedBy="activity")
    private List<CalendarHeader> calendarHeaders;

    public Activity() {
    }

    public Integer getId() {
        return this.id;
    }

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

    public Timestamp getCreateTime() {
        return this.createTime;
    }

    public void setCreateTime(Timestamp createTime) {
        this.createTime = createTime;
    }

    public String getCreatedBy() {
        return this.createdBy;
    }

    public void setCreatedBy(String createdBy) {
        this.createdBy = createdBy;
    }

    public String getDescription() {
        return this.description;
    }

    public void setDescription(String description) {
        this.description = description;
    }

    public Timestamp getUpdateTime() {
        return this.updateTime;
    }

    public void setUpdateTime(Timestamp updateTime) {
        this.updateTime = updateTime;
    }

    public String getUpdatedBy() {
        return this.updatedBy;
    }

    public void setUpdatedBy(String updatedBy) {
        this.updatedBy = updatedBy;
    }

    public List<CalendarHeader> getCalendarHeaders() {
        return this.calendarHeaders;
    }

    public void setCalendarHeaders(List<CalendarHeader> calendarHeaders) {
        this.calendarHeaders = calendarHeaders;
    }

    public CalendarHeader addCalendarHeader(CalendarHeader calendarHeader) {
        getCalendarHeaders().add(calendarHeader);
        calendarHeader.setActivity(this);

        return calendarHeader;
    }

    public CalendarHeader removeCalendarHeader(CalendarHeader calendarHeader) {
        getCalendarHeaders().remove(calendarHeader);
        calendarHeader.setActivity(null);

        return calendarHeader;
    }

}

我想做一个findAll。我应该怎么办？我试图创建一个扩展 CrudRepository 的新接口，但它不起作用。

提前致谢！

标签： springpostgresqljpatomcatfindall