代码拉取完成，页面将自动刷新
| keyword | sample | SQL |
|---|---|---|
| And | findByLastnameAndFirstname | ... where lastname = ? and firstname = ? |
| Or | findByLastnameOrFirstname | ... where lastname = ? or firstname = ? |
| Is, Eq | findByLastnameEq/findByLastname | … where lastname = ? |
| not | findByLastnameNot | … where lastname != ? |
| Between | findByStartDateBetween | … where startDate between ? and ? |
| Lt | findByStartDateLt | … where startDate > ? |
| Lte | findByStartDateLte | … where startDate >= ? |
| Gt | findByStartDateGr | … where startDate > ? |
| Gte | findByStartDateGte | … where startDate >= ? |
| After | findByStartDateAfter | … where startDate > ? |
| Before | findByStartDateBefore | … where startDate < ? |
| Like | findByFirstnameLike | … where firstname like ? |
| NotLike | findByFirstnameNotLike | … where firstname not like ? |
| OrderBy | findByAgeOrderByLastnameDesc | … where age = ? order by lastname desc |
| in | findByAgeIn | … where age in (?,?) |
| NotIn | findByAgeNotIn | … where age not in (?,?) |
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手