jpa 多对多

@Entity
public class Task implements Serializable {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    private String governitem;

    private String number;

    private String title;

    private String description;

    private Date lastbasemodify;
    
    @JsonIgnoreProperties(value = { "tasks" })
    @ManyToMany
    @JoinTable(name="TaskBaseline",joinColumns={@JoinColumn(name="taskid")},inverseJoinColumns={@JoinColumn(name="baselineid")})
    private List<Baseline> baselines;

JsonIgnoreProperties //json不死循环

//json不死循环

@Entity
public class Baseline implements Serializable {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    private String project;

    private  String dutyman;

    private  String name;

    private  String path;

    private  String cspversion;

    private  boolean ifmain;

    private  String client;

    private   String supplement;


    @ManyToMany
    @JoinTable(name="TaskBaseline",joinColumns={@JoinColumn(name="baselineid")},inverseJoinColumns={@JoinColumn(name="taskid")})
    private List<Task> tasks;

 

稍微用点sql的查询

public interface TaskDao extends CrudRepository<Task, Integer> {

    @Query(value = "SELECT * FROM task WHERE number = ?1",nativeQuery = true)
    Task findByNumber(String number);
}