Java Code Examples for net.sf.jsqlparser.statement.select.Union

最新推荐文章于 2024-06-21 15:30:17 发布
最新推荐文章于 2024-06-21 15:30:17 发布
阅读量2.5k 收藏
点赞数
分类专栏： 数据库开发

The following are top voted examples for showing how to use net.sf.jsqlparser.statement.select.Union. These examples are extracted from open source projects. You can vote up the examples you like and your votes will be used in our system to product more good examples.

+ Save this class to your library
Example 1
Project: pepe   File: SqlParse.java View source code Vote up 6 votes
@SuppressWarnings("unchecked")
public void visit(Union arg0) {
    List<PlainSelect> plainSelects = arg0.getPlainSelects();
    for (PlainSelect select : plainSelects) {
        select.accept(new SelectVisitorImplementation());
    }
}
Example 2
Project: pepe   File: CCJSqlParser.java View source code Vote up 6 votes
final public SelectBody SelectBody() throws ParseException {
SelectBody selectBody = null;
  if (jj_2_5(2147483647)) {
    selectBody = Union();
  } else {
    switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
    case K_SELECT:
      selectBody = PlainSelect();
      break;
    default:
      jj_la1[23] = jj_gen;
      jj_consume_token(-1);
      throw new ParseException();
    }
  }
        {if (true) return selectBody;}
  throw new Error("Missing return statement in function");
}
Example 3
Project: jdbc4sparql   File: SparqlSelectVisitor.java View source code Vote up 6 votes
@Override
public void visit(final Union union) {
	// TODO implement ALL
	if (union.isDistinct()) {
		queryBuilder.setDistinct();
	}
	final List<SparqlQueryBuilder> unionBuilders = new ArrayList<SparqlQueryBuilder>();
	for (final Iterator<?> iter = union.getPlainSelects().iterator(); iter
			.hasNext();) {
		final PlainSelect ps = (PlainSelect) iter.next();
		final SparqlQueryBuilder sqb = new SparqlQueryBuilder(queryBuilder);
		ps.accept(new SparqlSelectVisitor(sqb));
		unionBuilders.add(sqb);

	}

	try {
		queryBuilder.addUnion(unionBuilders);
	} catch (final SQLDataException e) {
		throw new IllegalStateException(e);
	}

	deparseOrderBy(union.getOrderByElements());
	deparseLimit(union.getLimit());
	throw new UnsupportedOperationException("UNION is not supported");
}
Example 4
Project: geotools-old   File: ViewRegisteringFactoryHelper.java View source code Vote up 6 votes
public static PlainSelect parseSqlQuery(String selectStatement) throws IOException {
    CCJSqlParserManager pm = new CCJSqlParserManager();
    Reader reader = new StringReader(selectStatement);
    Statement statement;
    try {
        statement = pm.parse(reader);
    } catch (Exception e) {
        throw new DataSourceException("parsing select statement: " + e.getCause().getMessage(),
                e);
    }
    if (!(statement instanceof Select)) { // either PlainSelect or Union
        throw new IllegalArgumentException("expected select or union statement: " + statement);
    }
    SelectBody selectBody = ((Select) statement).getSelectBody();
    if (selectBody instanceof Union) {
        // dataStore.registerView(typeName, (Union) selectBody);
        throw new UnsupportedOperationException(
                "ArcSDEDataStore does not supports registering Union queries");
    } else if (selectBody instanceof PlainSelect) {
        return (PlainSelect) selectBody;
    } else {
        throw new IllegalStateException(selectBody.getClass().getName());
    }
}
Example 5
Project: PlatypusJS   File: SourcesFinder.java View source code Vote up 6 votes
@Override
public void visit(Union union) {
    Iterator iter = union.getPlainSelects().iterator();
    if (iter.hasNext()) {
        PlainSelect plainSelect = (PlainSelect) iter.next();
        visit(plainSelect);
    }
}
Example 6
Project: PlatypusJS   File: CCJSqlParser.java View source code Vote up 6 votes
final public SelectBody SelectBody() throws ParseException {SelectBody selectBody = null;
    if (jj_2_5(2147483647)) {
      selectBody = Union();
    } else {
      switch ((jj_ntk==-1)?jj_ntk_f():jj_ntk) {
      case K_SELECT:{
        selectBody = PlainSelect();
        break;
        }
      default:
        jj_la1[25] = jj_gen;
        jj_consume_token(-1);
        throw new ParseException();
      }
    }
{if ("" != null) return selectBody;}
    throw new Error("Missing return statement in function");
  }
Example 7
Project: mimir   File: MimirJSqlParser.java View source code Vote up 6 votes
final public SelectBody SelectBody() throws ParseException {
SelectBody selectBody = null;
  if (jj_2_5(2147483647)) {
    selectBody = Union();
  } else {
    switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
    case K_SELECT:
      selectBody = PlainSelect();
      break;
    default:
      jj_la1[29] = jj_gen;
      jj_consume_token(-1);
      throw new ParseException();
    }
  }
        {if (true) return selectBody;}
  throw new Error("Missing return statement in function");
}
Example 8
Project: geotools_trunk   File: ViewRegisteringFactoryHelper.java View source code Vote up 6 votes
public static PlainSelect parseSqlQuery(String selectStatement) throws IOException {
    CCJSqlParserManager pm = new CCJSqlParserManager();
    Reader reader = new StringReader(selectStatement);
    Statement statement;
    try {
        statement = pm.parse(reader);
    } catch (Exception e) {
        throw new DataSourceException("parsing select statement: " + e.getCause().getMessage(),
                e);
    }
    if (!(statement instanceof Select)) { // either PlainSelect or Union
        throw new IllegalArgumentException("expected select or union statement: " + statement);
    }
    SelectBody selectBody = ((Select) statement).getSelectBody();
    if (selectBody instanceof Union) {
        // dataStore.registerView(typeName, (Union) selectBody);
        throw new UnsupportedOperationException(
                "ArcSDEDataStore does not supports registering Union queries");
    } else if (selectBody instanceof PlainSelect) {
        return (PlainSelect) selectBody;
    } else {
        throw new IllegalStateException(selectBody.getClass().getName());
    }
}
Example 9
Project: geotools-2.7.x   File: ViewRegisteringFactoryHelper.java View source code Vote up 6 votes
public static PlainSelect parseSqlQuery(String selectStatement) throws IOException {
    CCJSqlParserManager pm = new CCJSqlParserManager();
    Reader reader = new StringReader(selectStatement);
    Statement statement;
    try {
        statement = pm.parse(reader);
    } catch (Exception e) {
        throw new DataSourceException("parsing select statement: " + e.getCause().getMessage(),
                e);
    }
    if (!(statement instanceof Select)) { // either PlainSelect or Union
        throw new IllegalArgumentException("expected select or union statement: " + statement);
    }
    SelectBody selectBody = ((Select) statement).getSelectBody();
    if (selectBody instanceof Union) {
        // dataStore.registerView(typeName, (Union) selectBody);
        throw new UnsupportedOperationException(
                "ArcSDEDataStore does not supports registering Union queries");
    } else if (selectBody instanceof PlainSelect) {
        return (PlainSelect) selectBody;
    } else {
        throw new IllegalStateException(selectBody.getClass().getName());
    }
}
Example 10
Project: geotools-2.7.x   File: ViewRegisteringFactoryHelper.java View source code Vote up 6 votes
/**
 * Registers the sql views provided in <code>params</code> on the
 * SqlDataStore <code>dataStore</code>
 * 
 * @param dataStore
 * @param params
 * @throws IOException
 */
public static void registerSqlViews(SqlDataStore dataStore, Map params)
		throws IOException {
	Map cleanedUp = cleanUpViewDefinitions(params);
	for (Iterator it = cleanedUp.entrySet().iterator(); it.hasNext();) {
		Map.Entry entry = (Map.Entry) it.next();
		String typeName = (String) entry.getKey();
		String sqlQuery = (String) entry.getValue();
		
		LOGGER.finer("registering view " + typeName);
		LOGGER.finest("sql query is '" + sqlQuery + "'");

		SelectBody selectBody = SqlParser.parse(sqlQuery);
		if(selectBody instanceof Union){
			dataStore.registerView(typeName, (Union)selectBody);
		}else if(selectBody instanceof PlainSelect){
			dataStore.registerView(typeName, (PlainSelect)selectBody);
		}else{
			throw new IllegalStateException(selectBody.getClass().getName());
		}
		
		//dataStore.registerView(typeName, sqlQuery);

	}
}
Example 11
Project: geotools   File: ViewRegisteringFactoryHelper.java View source code Vote up 6 votes
public static PlainSelect parseSqlQuery(String selectStatement) throws IOException {
    CCJSqlParserManager pm = new CCJSqlParserManager();
    Reader reader = new StringReader(selectStatement);
    Statement statement;
    try {
        statement = pm.parse(reader);
    } catch (Exception e) {
        throw new DataSourceException("parsing select statement: " + e.getCause().getMessage(),
                e);
    }
    if (!(statement instanceof Select)) { // either PlainSelect or Union
        throw new IllegalArgumentException("expected select or union statement: " + statement);
    }
    SelectBody selectBody = ((Select) statement).getSelectBody();
    if (selectBody instanceof Union) {
        // dataStore.registerView(typeName, (Union) selectBody);
        throw new UnsupportedOperationException(
                "ArcSDEDataStore does not supports registering Union queries");
    } else if (selectBody instanceof PlainSelect) {
        return (PlainSelect) selectBody;
    } else {
        throw new IllegalStateException(selectBody.getClass().getName());
    }
}
Example 12
Project: mdrill   File: CCJSqlParser.java View source code Vote up 6 votes
final public SelectBody SelectBody() throws ParseException {
SelectBody selectBody = null;
  if (jj_2_5(2147483647)) {
    selectBody = Union();
  } else {
    switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
    case K_SELECT:
      selectBody = PlainSelect();
      break;
    default:
      jj_la1[23] = jj_gen;
      jj_consume_token(-1);
      throw new ParseException();
    }
  }
        {if (true) return selectBody;}
  throw new Error("Missing return statement in function");
}
Example 13
Project: mdrill   File: SelectDeParser.java View source code Vote up 6 votes
public void visit(Union union) {
	for (Iterator iter = union.getPlainSelects().iterator(); iter.hasNext();) {
		buffer.append("(");
		PlainSelect plainSelect = (PlainSelect) iter.next();
		plainSelect.accept(this);
		buffer.append(")");
		if (iter.hasNext()) {
			buffer.append(" UNION ");
		}

	}

	if (union.getOrderByElements() != null) {
		deparseOrderBy(union.getOrderByElements());
	}

	if (union.getLimit() != null) {
		deparseLimit(union.getLimit());
	}

}
Example 14
Project: geotools-tike   File: ViewRegisteringFactoryHelper.java View source code Vote up 6 votes
public static PlainSelect parseSqlQuery(String selectStatement) throws IOException {
    CCJSqlParserManager pm = new CCJSqlParserManager();
    Reader reader = new StringReader(selectStatement);
    Statement statement;
    try {
        statement = pm.parse(reader);
    } catch (Exception e) {
        throw new DataSourceException("parsing select statement: " + e.getCause().getMessage(),
                e);
    }
    if (!(statement instanceof Select)) { // either PlainSelect or Union
        throw new IllegalArgumentException("expected select or union statement: " + statement);
    }
    SelectBody selectBody = ((Select) statement).getSelectBody();
    if (selectBody instanceof Union) {
        // dataStore.registerView(typeName, (Union) selectBody);
        throw new UnsupportedOperationException(
                "ArcSDEDataStore does not supports registering Union queries");
    } else if (selectBody instanceof PlainSelect) {
        return (PlainSelect) selectBody;
    } else {
        throw new IllegalStateException(selectBody.getClass().getName());
    }
}
Example 15
Project: geotools-tike   File: ViewRegisteringFactoryHelper.java View source code Vote up 6 votes
/**
 * Registers the sql views provided in <code>params</code> on the
 * SqlDataStore <code>dataStore</code>
 * 
 * @param dataStore
 * @param params
 * @throws IOException
 */
public static void registerSqlViews(SqlDataStore dataStore, Map params)
		throws IOException {
	Map cleanedUp = cleanUpViewDefinitions(params);
	for (Iterator it = cleanedUp.entrySet().iterator(); it.hasNext();) {
		Map.Entry entry = (Map.Entry) it.next();
		String typeName = (String) entry.getKey();
		String sqlQuery = (String) entry.getValue();
		
		LOGGER.finer("registering view " + typeName);
		LOGGER.finest("sql query is '" + sqlQuery + "'");

		SelectBody selectBody = SqlParser.parse(sqlQuery);
		if(selectBody instanceof Union){
			dataStore.registerView(typeName, (Union)selectBody);
		}else if(selectBody instanceof PlainSelect){
			dataStore.registerView(typeName, (PlainSelect)selectBody);
		}else{
			throw new IllegalStateException(selectBody.getClass().getName());
		}
		
		//dataStore.registerView(typeName, sqlQuery);

	}
}
Example 16
Project: mimir   File: MimirJSqlParser.java View source code Vote up 5 votes
final public Union Union() throws ParseException {
      Union union = new Union();
      List orderByElements = null;
      Limit limit = null;
      PlainSelect select = null;
      ArrayList selects = new ArrayList();
  switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
  case 86:
    jj_consume_token(86);
    select = PlainSelect();
                                                selects.add(select);
    jj_consume_token(87);
    jj_consume_token(K_UNION);
    switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
    case K_ALL:
    case K_DISTINCT:
      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
      case K_ALL:
        jj_consume_token(K_ALL);
                                                    union.setAll(true);
        break;
      case K_DISTINCT:
        jj_consume_token(K_DISTINCT);
                                                                                                union.setDistinct(true);
        break;
      default:
        jj_la1[40] = jj_gen;
        jj_consume_token(-1);
        throw new ParseException();
      }
      break;
    default:
      jj_la1[41] = jj_gen;
      ;
    }
    jj_consume_token(86);
    select = PlainSelect();
                                                selects.add(select);
    jj_consume_token(87);
    label_9:
    while (true) {
      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
      case K_UNION:
        ;
        break;
      default:
        jj_la1[42] = jj_gen;
        break label_9;
      }
      jj_consume_token(K_UNION);
      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
      case K_ALL:
      case K_DISTINCT:
        switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
        case K_ALL:
          jj_consume_token(K_ALL);
          break;
        case K_DISTINCT:
          jj_consume_token(K_DISTINCT);
          break;
        default:
          jj_la1[43] = jj_gen;
          jj_consume_token(-1);
          throw new ParseException();
        }
        break;
      default:
        jj_la1[44] = jj_gen;
        ;
      }
      jj_consume_token(86);
      select = PlainSelect();
                                                                                             selects.add(select);
      jj_consume_token(87);
    }
    switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
    case K_ORDER:
      orderByElements = OrderByElements();
                                                          union.setOrderByElements(orderByElements);
      break;
    default:
      jj_la1[45] = jj_gen;
      ;
    }
    switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
    case K_LIMIT:
    case K_OFFSET:
      limit = Limit();
                                      union.setLimit(limit);
      break;
    default:
      jj_la1[46] = jj_gen;
      ;
    }
    break;
  case K_SELECT:
    select = PlainSelect();
                                            selects.add(select);
    jj_consume_token(K_UNION);
    switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
    case K_ALL:
    case K_DISTINCT:
      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
      case K_ALL:
        jj_consume_token(K_ALL);
                                                    union.setAll(true);
        break;
      case K_DISTINCT:
        jj_consume_token(K_DISTINCT);
                                                                                                union.setDistinct(true);
        break;
      default:
        jj_la1[47] = jj_gen;
        jj_consume_token(-1);
        throw new ParseException();
      }
      break;
    default:
      jj_la1[48] = jj_gen;
      ;
    }
    select = PlainSelect();
                                            selects.add(select);
    label_10:
    while (true) {
      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
      case K_UNION:
        ;
        break;
      default:
        jj_la1[49] = jj_gen;
        break label_10;
      }
      jj_consume_token(K_UNION);
      switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
      case K_ALL:
      case K_DISTINCT:
        switch ((jj_ntk==-1)?jj_ntk():jj_ntk) {
        case K_ALL:
          jj_consume_token(K_ALL);
          break;
        case K_DISTINCT:
          jj_consume_token(K_DISTINCT);
          break;
        default:
          jj_la1[50] = jj_gen;
          jj_consume_token(-1);
          throw new ParseException();
        }
        break;
      default:
        jj_la1[51] = jj_gen;
        ;
      }
      select = PlainSelect();
                                                                                         selects.add(select);
    }
    break;
  default:
    jj_la1[52] = jj_gen;
    jj_consume_token(-1);
    throw new ParseException();
  }
              union.setPlainSelects(selects);
              {if (true) return union;}
  throw new Error("Missing return statement in function");
}
javastart
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
SQLQueryEvaluator:使用JSQLParser在Java中实现一个简单的数据库SQL查询评估器，该评估器支持Select，Project，Join，Limit，Order by，Bag Union和Aggregate操作
05-15
SQLQueryEvaluator 使用JSQLParser在Java中实现一个简单的数据库SQL查询评估器，该评估器支持Select，Project，Join，Limit，Order by，Bag Union和Aggregate操作。 实现了查询优化，例如选择下推，投影下推，混合哈希聚合和哈希联接算法，从而缩短了查询响应时间。
spring boot pageHelper 分页不生效
yu1xue1fei的博客
09-03 367
装载路径 ：https://blog.csdn.net/qq_28762295/article/details/80597197 springboot坏境要用 的依赖 <dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper-sprin...
【JSqlParser】Java使用JSqlParser解析SQL语句总结
最新发布
RudolphLiu的博客
06-21 2259
熟悉JDBC的程序员一般都知道Statement，其实就是语句的意思，不过在Jsqlparser中Statement已经面向对象，被设计成了一个interface，之所以设计成interface大概都可以猜到，因为Jsqlparser既然要去解析SQL，那必然要对SQL语句做区分，到底是Select、还是Insert、还是Delete、甚至是Create，而Jsqlparser对每种语句都做了一个封装，它们都继承了Statement。
java.lang.NoSuchMethodError: net.sf.jsqlparser.statement.select.PlainSelect.getGroupByColumnReferenc
Lizhj的博客
06-02 614
jar包冲突
java.lang.NoSuchMethodError: net.sf.jsqlparser.statement.select.PlainSelect.getGroupBy()Lnet/sf/jsql
qq_41018670的博客
10-20 8019
现象： 021-10-20 11:03:54.506 INFO 10528 --- [nio-8080-exec-9] c.c.t.h.w.interceptor.LoginInterceptor : 拦截到了方法：error 2021-10-20 11:03:54.506 INFO 10528 --- [nio-8080-exec-9] c.c.t.h.w.interceptor.LoginInterceptor : 和redis中匹配，放行，执行接口 2021-10-20 11:03:5
JSqlParser-解析SQL工具类
zuihongyan518的博客
04-14 6784
JSqlParse是一款很精简的sql解析工具，本文封装JSqlParse解析SQL处理工具。
Java_examples.rar_java examples_progressbardemo.java
09-21
"Java_examples.rar" 是一个包含100多个Java程序实例的压缩包，旨在帮助初学者深入理解和掌握Java编程技术。这个资源包特别关注了“progressbardemo.java”，这是一个关于进度条控件的示例，对于那些想学习如何在...
java_100examples.rar_Java 小程序_Java_100examples.rar
09-21
这个名为"java_100examples.rar"的压缩包文件显然包含了100个Java编程示例，旨在帮助初学者理解并掌握Java编程的基础概念和技巧。下面我们将详细探讨这些Java小程序可能涵盖的知识点。 首先，基础语法是所有编程...
jna-3.0.9.jar和examples.jar.zip
07-27
jna-3.0.9.jar和examples.jar.zip这两个文件，就是JNA库的一个版本及其示例集，它们为我们提供了一个更便捷地在Java中调用本地库的方法。 JNA是Java平台上的一个开源项目，它允许Java程序直接调用操作系统内核函数...
com.sun.jna.examples
04-13
7. **Examples分析**：`examples.jar`包含了各种实际示例，如文件系统操作、进程管理、窗口操作等，这些都是通过JNA调用本地API实现的。通过分析这些例子，开发者可以深入理解如何在实际项目中应用JNA。 8. **性能...
Java_100examples.rar_Java 100例_Java_100examples.rar_java 100例
09-20
"Java_100examples.rar" 是一个专门为了帮助学习者深入理解和实践Java编程而编译的资源包，其中包含了100个精心挑选的Java实例，涵盖了从基础语法到高级特性的各种应用。 首先，让我们来看看这个压缩包中的...
jsqlparser0.7解决中文问题
09-23
解决jsqlparser中文问题，修改JSqlParserCC.jj使用jcc重新编译，打包。
JSQLParser 解析 复杂sql （表别名、字段与表对应关系）
m0_54892309的博客
03-13 1万+
个人代码分享- 使用Java的JSqlParser工具来解析复杂SQL（SQL的基本结构、表|别名、字段|别名|关联表）
Sql解析转换之JSqlParse完整介绍
热门推荐
Interest1_wyt的博客
03-26 2万+
1、 jsqlparse介绍 JSqlParse是一款很精简的sql解析工具，它可以将常用的sql文本解析成具有层级结构的“语法树”，我们可以针对解析后的“树节点（也即官网里说的有层次结构的java类）”进行处理进而生成符合我们要求的sql形式。 官网给的介绍很简洁：JSqlParser 解析 SQL 语句并将其转换为 Java 类的层次结构。生成的层次结构可以使用访问者模式进行访问（官网地址：JSqlParser - Home）。 官网的介绍即是该中间件的全部，虽然介绍很短，但是其功能着实强悍。
jsqlparser解析SQL工具类(转载)
星的奏鸣曲
05-07 5952
JSQLParser官网地址：http://jsqlparser.sourceforge.net/ JSQLParserGitHub地址：https://github.com/JSQLParser/JSqlParser pom.xml <dependency> <groupId>com.github.jsqlparser</groupI...
JSqlParser基本应用文档-select部分
weixin_34364071的博客
08-30 3939
2019独角兽企业重金招聘Python工程师标准>>> ...
java sqlparser_使用Jsqlparser从复杂SQL语句中提取表名
weixin_35849560的博客
02-16 3397
如果从简单的SQL语句中获取表名，那么可以通过不严谨的关键字匹配的方式获取或者正则表达式的方式获取表名。但是这种做法不具有通用性，遇到复杂的SQL语句就会存在BUG。严谨的做法当然是通过SQL分析工具分析SQL结构并获取SQL信息，Jsqlparser就是这样的工具，为我们的SQL分析提供了便利。下面通过一个简单的例子可以了解到Jsqlparser的实现机制，举一反三，更多的应用都是可以做到的。/...
azure kinect examples for unity.unitypackage
05-12
Azure Kinect Examples for Unity.unitypackage是一个Unity插件，它使用户能够轻松地与Azure Kinect相机进行交互。该插件包含一系列示例场景和脚本，向用户展示如何使用Azure Kinect以及如何融合其数据流到Unity应用...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值