Examples of QuerySnapshot

net.sourceforge.javautil.database.query.QuerySnapshot
A snapshot of the current state of a {@link IQueryBuilder}. @author elponderador @author $Author: ponderator $ @version $Id: QuerySnapshot.java 2286 2010-06-14 04:18:27Z ponderator $

Examples of net.sourceforge.javautil.database.query.QuerySnapshot


    StringBuilder builder = this.buildQuery(parameters);
    
    this.lastBuilt = System.currentTimeMillis();
    
    return new QuerySnapshot(this, builder.toString(), parameters);
  }

View Full Code Here

Examples of net.sourceforge.javautil.database.query.QuerySnapshot

  public QueryExecutorJPA(EntityManager em) {
    this.em = em;
  }


  public List<Object> execute(QueryBuilderSelectJPA builder) {
    QuerySnapshot snapshot = builder.build();
    
    String queryString = snapshot.getQueryString();
    Query query = em.createQuery(queryString);
    
    if (snapshot.getArguments().size() > 0) {
      for (IQueryFragmentCriteriaParameter parameter : snapshot.getArguments()) {
        for (String name : parameter.getNamedParameters()) {
          if (queryString.contains(":" + name))
            query.setParameter(name, builder.getParameters().get(name));
        }
      }

View Full Code Here

Examples of net.sourceforge.javautil.database.query.QuerySnapshot

    Connection connection = null;
    Statement statement = null;
    ResultSet set = null;
    try {
      connection = dataSource.getConnection();
      QuerySnapshot snapshot = builder.build();
      
      if (builder.getParameters().size() > 0) {
        PreparedStatement prepared = connection.prepareStatement(snapshot.getQueryString());


        int index = 1;
        for (IQueryFragmentCriteriaParameter parameter : snapshot.getArguments()) {
          for (String name : parameter.getNamedParameters()) {
            prepared.setObject(index++, builder.getParameters().get(name));
          }
        }
        return translate( prepared.executeQuery() );
      } else { 
        statement = connection.createStatement();
        return translate( statement.executeQuery( snapshot.getQueryString() ) );
      }
    } catch (SQLException e) {
      throw ThrowableManagerRegistry.caught(e);
    } finally {
      if (set != null) try { set.close(); } catch (SQLException e) {

View Full Code Here

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.