java使用@query使用Spring数据创建自定义查询
我有一个消息实体和一个管理实体。 信息是:
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private long id;
@Column(name = "text")
private String text;
@OneToOne
@JoinColumn(name = "id_from")
private Admin idFrom;
@OneToOne
@JoinColumn(name = "id_too")
private Admin idToo;
管理员是:
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private long id;
@Column(name = "username")
private String username;
@Column(name = "password")
private String password;
@Column(name = "email")
private String email;
如何创建此查询:
select id_from, text from message
where id_from = from and id_too = too
or id_from = too and id_too = from;
使用@Query注释
大概是这样的:
@Query("SELECT m FROM Message m WHERE m.id_from = :from.id and m.id_too = :too.id or m.id_from = :too.id and m.id_too = :from.id")
List<Message> findMessages(@Param("from") Admin from, @Param("too") Admin too);
多谢各位
# 1 楼答案