EAS开发笔记整理----关于数据库sql和oql的使用

最新推荐文章于 2023-08-09 09:26:35 发布

秃头小淋无bug

最新推荐文章于 2023-08-09 09:26:35 发布

阅读量2.8k

点赞数

本文链接：https://blog.youkuaiyun.com/qq_35316228/article/details/85272253

版权

本文详细介绍了EAS中关于SQL和OQL的使用，包括比较类型、数据插入、数据查询的各种方法，如FilterInfo、SelectorItemCollection、Sorter等，并提供了多种查询数据的示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

sql相关：

(1)CompareType说明

   CompareType.EQUALS = ("=");                                       new FilterItemInfo("name","zll") 默认为相等
   CompareType.GREATER = (">");
   CompareType.LESS = ("<");
   CompareType.GREATER_EQUALS = (">=");
   CompareType.LESS_EQUALS = ("<=");
   CompareType.NOTEQUALS = ("<>");
   CompareType.LIKE = ("like");                                   new FilterItemInfo("name","詹%",CompareType.LIKE)
   CompareType.NOTLIKE = ("not like");
   CompareType.INCLUDE = ("in");
   CompareType.NOTINCLUDE = ("not in");
   CompareType.INNER = ("inner");
   CompareType.NOTINNER = ("not inner");
   CompareType.IS = ("is");
   CompareType.ISNOT = ("is not");
   CompareType.EXISTS = ("exists");
   CompareType.NOTEXISTS = ("not exists");
   CompareType.EMPTY = IS;
   CompareType.NOTEMPTY = ISNOT;

   *布尔类型   new FilterItemInfo("isComInspecte", Boolean.FALSE,CompareType.EQUALS)
    * in      String sql="select name from t_studnet where age=18 ";
               new FilterItemInfo("id", sql,CompareType.INCLUDE)

               String sql="'1','2','3'";
               new FilterItemInfo("i

最低0.47元/天解锁文章