JPA 查询Like示例JPA 查询Like示例.pdf

JPA 查询Like⽰例 JPA教程 - JPA查询Like⽰例 JPQL⽀持SQL LIKE操作符，以提供有限形式的字符串模式匹配。 每个LIKE表达式由要有哪些信誉好的足球投注网站的字符串表达式，以及定义匹配 件的模式字符串和可选转 义序列组成。 模式字符串使⽤的通配符是单字符通配符的下划线(_)和多字符通配符的百分号(%) 。 在下⾯的JPQL 中，我们使⽤两个下划线字符的前缀来通配字符串候选的前两个字符。 SELECT d FROM Department d WHERE LIKE __Eng% 模式匹配区分⼤⼩写。 例⼦ 下⾯的代码来⾃Department .j ava 。 package cn.w mon; import java.util.HashSet; import java.util.Set; import javax .persistence.Entity; import javax .persistence.Id; import javax .persistence.OneToMany; @Entity public class Department { @Id private int id; private String name; @OneToMany(mappedBy=department) private SetProfessor employees = new HashSetProfessor(); public int getId() { return id; } public void setId(int deptNo) { this.id = deptNo; } public String getName() { return name; } public void setName(String deptName) { = deptName; } public SetProfessor getProfessors() { return employees; } public String toString() { return Department no: + getId() + , name: + getName(); } } 以下代码来⾃Address.j ava 。 package cn.w mon; import javax .persistence.Entity; import javax .persistence.Id; @Entity public class Address { @Id private int id; private String street; private String city; private String state; private String zip; public int getId() { return id; } public void setId(int id) { this.id = id; } public String getStreet() { return street; } public void setStreet(String address) { this.street = address; } public String getCity() { return city; } public void setCity(String city) { this.city = city; } public String getState() { return state; } public void setState(String state) { this.state = sta