我正在使用Spring Jpa存储库来执行所有数据库操作。我不知道如何在不使用任何查询的情况下从表中选择特定值

Question

我的实体类在这里：

public class ClientDetails {

public ClientDetails() {
    super();
    // TODO Auto-generated constructor stub
}
@Id
@GeneratedValue
@Column(name="serialno")
public int serialno;
@Column(name="gstnum")
public int GSTnum;
@Column(name="bunk_name")
public String bunk_name;
@Column(name="mobile_num")
public int mobile_num;
@Column(name="password")
public String password;
public int getSerialno() {
    return serialno;
}
public void setSerialno(int serialno) {
    this.serialno = serialno;
}
public int getGSTnum() {
    return GSTnum;
}
public void setGSTnum(int gSTnum) {
    GSTnum = gSTnum;
}
public String getBunk_name() {
    return bunk_name;
}
public void setBunk_name(String bunk_name) {
    this.bunk_name = bunk_name;
}
public int getMobile_num() {
    return mobile_num;
}
public void setMobile_num(int mobile_num) {
    this.mobile_num = mobile_num;
}
public String getPassword() {
    return password;
}
public void setPassword(String password) {
    this.password = password;
}
}

我希望根据bunk_name从表中选择gstnum，我不想要任何本地查询，就像我在jpa存储库中对gstnum所做的那样。

从pbm.client_details中选择gstnum，其中bunk_name='yoga'；

我的JPA存储库是

public interface ClientDetailsRepository extends JpaRepository<ClientDetails,Integer> {
public static final String gst_num = "SELECT * FROM pbm.client_details;";
//public static final String login_access = "SELECT * FROM clien_details WHERE gstnum pbm.client_details;";

@Query(value = gst_num, nativeQuery = true)
List<ClientDetails> getGstnum();
}

Answer 1

您可以使用@query，但Spring数据不会有太多

@Query("SELECT GSTnum FROM ClientDetails where bunk_name = :callMeSomething")
List<ClientDetails> getGstnum(@Param("callMeSomething") String callMeSomething);

如何在这里查看JPA文档