Examples of org.conserve.select.StatementPrototypeGenerator.generate()

Class org.conserve.select.StatementPrototypeGenerator

Examples of org.conserve.select.StatementPrototypeGenerator.generate()

org.conserve.select.StatementPrototypeGenerator.generate()
Generate a statement prototype that looks in Class klass for objects. If addJoins is true, it will also satisfy all superclasses. @param klass the class to generate a statment prototype for. @param addJoins whether satisfy superclass constraints. @return a prototype that can be used to generate PreparedStatements. @throws SQLException

    }


    StatementPrototypeGenerator whereGenerator = new StatementPrototypeGenerator(
        adapter);
    whereGenerator.setClauses(clause);
    StatementPrototype sp = whereGenerator.generate(clazz, true);
    // get the id of clazz
    String shortName = whereGenerator.getTypeStack()
        .getActualRepresentation().getAsName();


    StringBuilder statement = new StringBuilder("SELECT ");

View Full Code Here

    }


    StatementPrototypeGenerator whereGenerator = new StatementPrototypeGenerator(
        adapter);
    whereGenerator.setClauses(clauses);
    StatementPrototype sp = whereGenerator.generate(clazz, true);
    PreparedStatement ps = sp.toPreparedStatement(cw,
        sp.getSelectStartQuery());
    ResultSet rs = ps.executeQuery();
    List<HashMap<String, Object>> propertyVector = createPropertyVector(rs);
    ps.close();

View Full Code Here

    }


    StatementPrototypeGenerator whereGenerator = new StatementPrototypeGenerator(
        adapter);
    whereGenerator.setClauses(clause);
    StatementPrototype sp = whereGenerator.generate(clazz, true);
    String tableId = sp.getIdStatementGenerator().getJoinTableIds().get(0);
    StringBuilder statement = new StringBuilder("SELECT COUNT(DISTINCT("
        + tableId + "." + Defaults.ID_COL + ")) FROM ");
    PreparedStatement ps = sp.toPreparedStatement(cw, statement.toString());
    ResultSet rs = ps.executeQuery();

View Full Code Here

      return res;
    }


    StatementPrototypeGenerator whereGenerator = new StatementPrototypeGenerator(
        adapter);
    StatementPrototype sp = whereGenerator.generate(clazz, true);
    String shortName = whereGenerator.getTypeStack()
        .getRepresentation(clazz).getAsName();


    sp.addEqualsClause(shortName + "." + Defaults.ID_COL, id);

View Full Code Here

    // erase the 'real' class entry
    map.remove(Defaults.REAL_CLASS_COL);
    StringBuilder statement = new StringBuilder("SELECT * FROM ");
    StatementPrototypeGenerator whereGenerator = new StatementPrototypeGenerator(
        adapter);
    StatementPrototype sp = whereGenerator.generate(clazz, false);
    sp.addEqualsClause(Defaults.ID_COL, dbId);
    PreparedStatement ps = sp.toPreparedStatement(cw, statement.toString());
    ResultSet rs = ps.executeQuery();
    List<HashMap<String, Object>> propertyVector = createPropertyVector(rs);
    if (propertyVector.size() != 1)

View Full Code Here

    else
    {
      StatementPrototypeGenerator gen = new StatementPrototypeGenerator(
          adapter);


      StatementPrototype sp = gen.generate(realClass, true);
      sp.addEqualsClause(
          gen.getTypeStack()
              .getRepresentation(
                  gen.getTypeStack().getLevel(realClass))
              .getAsName()

View Full Code Here

        removeObsoleteColumns(tmpRes, valueTypeMap, cw);
        // add all columns to the table
        addNewColumns(tmpRes, valueTypeMap, cw);


        StatementPrototypeGenerator statementGenerator = new StatementPrototypeGenerator(adapter);
        StatementPrototype sp = statementGenerator.generate(s, true);
        String fromName = statementGenerator.getTypeStack().getRepresentation(from.getRepresentedClass())
            .getTableName();
        String toName = statementGenerator.getTypeStack().getActualRepresentation().getTableName();
        String prestatement = "UPDATE " + toName + " SET " + toName + "." + colName + "=" + fromName + "."
            + colName + " ";

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.