Examples of QueryUtil

com.mysql.management.util.QueryUtil
net.yanhl.base.query.util.QueryUtil

Title: 查询工具类

Description: 把ListQuery对象解析为HQL并执行查询
@author 闫洪磊 @version 1.0.0.20080615
org.apache.chemistry.opencmis.server.support.query.QueryUtil
Class with static methods that contains convenience methods to repeating functionality in context with query and ANTLR parsing

Examples of com.mysql.management.util.QueryUtil


public class TestEmbeddedMySQL {


  public static void insertData(Connection conn) throws IOException {
    String query = "CREATE TABLE `test_table` (`idpublisher` int(11) DEFAULT NULL, `idsite` int(11) DEFAULT NULL, `country_iso` varchar(4) DEFAULT NULL, `idzone` int(11) DEFAULT NULL, `hits` int(11) DEFAULT NULL, `cpm_value` double DEFAULT NULL, `ddate` varchar(16) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin1";
    QueryUtil util = new QueryUtil(conn);
    util.execute(query);


    util.execute("BEGIN");


    for(String insert : Files.readLines(new File("src/test/resources/test.mysql"),
        Charset.defaultCharset())) {
      String[] fields = insert.split(",");
      String q = "INSERT INTO test_table VALUES (";
      for(int i = 0; i < fields.length; i++) {
        String val = fields[i];
        if(val.length() < 1) {
          val = "NULL";
        } else {
          if(i == 2 || i == 6) {
            val = "'" + val + "'";
          }
        }
        q += val;
        if(i != fields.length - 1) {
          q += ",";
        }
      }
      q += ");";
      util.execute(q);
    }


    util.execute("COMMIT");
  }

View Full Code Here

Examples of com.mysql.management.util.QueryUtil

      MySQLManager manager = new MySQLManager(mysql);
      conn = manager.getJdbcManager().getConnectionFromPool();


      insertData(conn);


      List<?> l = new QueryUtil(conn).executeQuery("SELECT * FROM test_table LIMIT 10;");
      assertEquals(10, l.size());


    } finally {
      if(conn != null) {
        conn.close();

View Full Code Here

Examples of net.yanhl.base.query.util.QueryUtil

  /* (non-Javadoc)
   * @see net.yanhl.base.dao.BaseDao#find(net.yanhl.base.query.ListQuery)
   */
  @SuppressWarnings("unchecked")
  public List find(final ListQuery listQuery) throws RuntimeException {
    final QueryUtil queryUtil = new QueryUtil();
    queryUtil.setListQuery(listQuery);
    final List result = new ArrayList();
    return getHibernateTemplate().executeFind(new HibernateCallback() {
      public Object doInHibernate(Session session) throws HibernateException, SQLException {
        try {
          queryUtil.setCommonQuery(session);
          queryUtil.setListCountQuery(session);
          result.add(queryUtil.getListCount());
          queryUtil.setResultListQuery(session);
          result.add(queryUtil.getResultColl());
        } catch (ParseException e) {
          e.printStackTrace();
        }
        return result;
      }

View Full Code Here

Examples of org.apache.chemistry.opencmis.server.support.query.QueryUtil

    private static List<String> list(String... elements) {
        return Arrays.asList(elements);
    }


    private static XPathBuilder execute(String statement) {
        QueryUtil queryUtil = new QueryUtil();
        QueryObject queryObject = new QueryObject(new JcrTypeManager());
        ParseTreeWalker<XPathBuilder> parseTreeWalker = new ParseTreeWalker<XPathBuilder>(new EvaluatorXPath());
        queryUtil.traverseStatementAndCatchExc(statement, queryObject, parseTreeWalker);
        return parseTreeWalker.getResult();
    }

View Full Code Here

Examples of org.apache.chemistry.opencmis.server.support.query.QueryUtil

    protected static final String PUB_DATE_PROP = "PublishingDate";


    protected void setUp(QueryObject qo, PredicateWalkerBase pw) {
        queryObj = qo;
        predicateWalker = pw;
        queryUtil = new QueryUtil();
    }

View Full Code Here

Examples of org.apache.chemistry.opencmis.server.support.query.QueryUtil

     * 
     * @param statement
     * @return
     */
    public String translateToXPath(String statement) {
        QueryUtil queryUtil = new QueryUtil();
        queryObject = new QueryObject(typeManager);
        ParseTreeWalker<XPathBuilder> parseTreeWalker = new ParseTreeWalker<XPathBuilder>(evaluator);
        CmisQueryWalker walker = queryUtil.traverseStatementAndCatchExc(statement, queryObject, parseTreeWalker);
        walker.setDoFullTextParse(false);
        XPathBuilder parseResult = parseTreeWalker.getResult();
        TypeDefinition fromType = getFromName(queryObject);


        String pathExpression = buildPathExpression(fromType, getFolderPredicate(parseResult));

View Full Code Here

Examples of org.apache.chemistry.opencmis.server.support.query.QueryUtil

        LOG.debug("Query result, number of matching objects: " + objList.getNumItems());
        return objList;
    }


    public void processQueryAndCatchExc(String statement) {
        QueryUtil queryUtil = new QueryUtil();
        CmisQueryWalker walker = queryUtil.traverseStatementAndCatchExc(statement, queryObj, null);
        whereTree = walker.getWherePredicateTree();
    }

View Full Code Here

Examples of org.apache.chemistry.opencmis.server.support.query.QueryUtil

        LOG.debug("Query result, number of matching objects: " + objList.getNumItems());
        return objList;
    }


    public void processQueryAndCatchExc(String statement) {
        QueryUtil queryUtil = new QueryUtil();
        CmisQueryWalker walker = queryUtil.traverseStatementAndCatchExc(statement, queryObj, null);
        whereTree = walker.getWherePredicateTree();
    }

View Full Code Here

Examples of org.apache.chemistry.opencmis.server.support.query.QueryUtil

    private static List<String> list(String... elements) {
        return Arrays.asList(elements);
    }


    private XPathBuilder execute(String statement) {
        QueryUtil queryUtil = new QueryUtil();
        QueryObject queryObject = new QueryObject(typeManager);
        ParseTreeWalker<XPathBuilder> parseTreeWalker = new ParseTreeWalker<XPathBuilder>(new EvaluatorXPath());
        queryUtil.traverseStatementAndCatchExc(statement, queryObject, parseTreeWalker);
        return parseTreeWalker.getResult();
    }

View Full Code Here

Examples of org.apache.chemistry.opencmis.server.support.query.QueryUtil

        LOG.debug("Query result, number of matching objects: " + objList.getNumItems());
        return objList;
    }


    public void processQueryAndCatchExc(String statement) {
        QueryUtil queryUtil = new QueryUtil();
        CmisQueryWalker walker = queryUtil.traverseStatementAndCatchExc(statement, queryObj, null);
        whereTree = walker.getWherePredicateTree();
    }

View Full Code Here

0 1

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.