Package org.jeecgframework.minidao.sqlparser.impl.util.v49

Class JSqlRemoveSqlOrderBy49

java.lang.Object
org.jeecgframework.minidao.sqlparser.impl.util.v49.JSqlRemoveSqlOrderBy49
public class JSqlRemoveSqlOrderBy49 extends Object
sqlserver工具类，去掉order by

  • Field Details

    • dynamic

      public static Pattern dynamic
      匹配:user.name这样的参数表达式

    • DIAN

      public static String DIAN

    • DIAN_TMP

      public static String DIAN_TMP

  • Constructor Details

    • JSqlRemoveSqlOrderBy49

      public JSqlRemoveSqlOrderBy49()

  • Method Details

    • removeOrderBy

      public String removeOrderBy(String sql) throws net.sf.jsqlparser.JSQLParserException
      SQLServer去除子查询中的order by
      Parameters:
      sql -
      Returns:
      Throws:
      net.sf.jsqlparser.JSQLParserException

    • getKeyListByContent

      public static List<String> getKeyListByContent(String content)
      按照动态内容的参数出现顺序,将参数放到List中
      Parameters:
      content -
      Returns:

    • processSelectBody

      public void processSelectBody(net.sf.jsqlparser.statement.select.Select selectBody)

    • processPlainSelect

      public void processPlainSelect(net.sf.jsqlparser.statement.select.PlainSelect plainSelect)

    • processFromItem

      public void processFromItem(net.sf.jsqlparser.statement.select.FromItem fromItem)

    • orderByHashParameters

      public boolean orderByHashParameters(List<net.sf.jsqlparser.statement.select.OrderByElement> orderByElements)