SqlConstant.java 2.0 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253
  1. package com.boman.domain.constant;
  2. /**
  3. * @author shiqian
  4. * @date 2021年04月16日 16:10
  5. **/
  6. public class SqlConstant {
  7. public static final String EMPTY = "";
  8. public static final String SPACE = " ";
  9. public static final String SELECT = " select ";
  10. public static final String UPDATE = " update ";
  11. public static final String DELETE = " delete ";
  12. public static final String INSERT_INTO = " insert into ";
  13. public static final String VALUES = " values ";
  14. public static final String ALL = " * ";
  15. public static final String SET = " set ";
  16. public static final String FROM = " from ";
  17. public static final String COMMA = " , ";
  18. public static final String POINT = " . ";
  19. public static final String LIMIT = " limit ";
  20. public static final String OFFSET = " offset ";
  21. public static final String ORDER_BY = " orderBy ";
  22. public static final String PK_NAME = " pkName ";
  23. public static final String TABLE_NAME = " tableName ";
  24. public static final String COUNT_1 = " count(1) ";
  25. public static final String WHERE = " where ";
  26. public static final String AND = " and ";
  27. public static final String OR = " or ";
  28. public static final String LIKE = " like ";
  29. public static final String EQ = " = ";
  30. public static final String NOT_EQ = " != ";
  31. public static final String GT = " > ";
  32. public static final String GT_EQ = " >= ";
  33. public static final String LT = " < ";
  34. public static final String LT_EQ = " <= ";
  35. public static final String BETWEEN = " between ";
  36. public static final String PERCENT = " % ";
  37. public static final String LEFT = " ( ";
  38. public static final String RIGHT = " ) ";
  39. public static final String IN = " in ";
  40. public static final String GROUP_BY = " group by ";
  41. public static final String JING_LEFT = " #{model. ";
  42. public static final String ID_LIST = " #{idList ";
  43. public static final String BIG_RIGHT = " } ";
  44. public static final String LEFT_JOIN = " left join ";
  45. public static final String ON = " on ";
  46. }