Examples of com.vaadin.addon.sqlcontainer.query.generator.StatementHelper

Package com.vaadin.addon.sqlcontainer.query.generator

Examples of com.vaadin.addon.sqlcontainer.query.generator.StatementHelper

com.vaadin.addon.sqlcontainer.query.generator.StatementHelper
StatementHelper is a simple helper class that assists TableQuery and the query generators in filling a PreparedStatement. The actual statement is generated by the query generator methods, but the resulting statement and all the parameter values are stored in an instance of StatementHelper. This class will also fill the values with correct setters into the PreparedStatement on request.

    public RowId storeRowImmediately(RowItem row) throws SQLException {
        beginTransaction();
        /* Set version column, if one is provided */
        setVersionColumnFlagInProperty(row);
        /* Generate query */
        StatementHelper sh = sqlGenerator.generateInsertQuery(tableName, row);
        PreparedStatement pstmt = activeConnection.prepareStatement(
                sh.getQueryString(), primaryKeyColumns.toArray(new String[0]));
        sh.setParameterValuesToStatement(pstmt);
        debug("DB -> " + sh.getQueryString());
        int result = pstmt.executeUpdate();
        if (result > 0) {
            /*
             * If affected rows exist, we'll get the new RowId, commit the
             * transaction and return the new RowId.

View Full Code Here

        for (String colName : primaryKeyColumns) {
            filtersAndKeys.add(new Filter(colName, ComparisonType.EQUALS,
                    keys[ix]));
            ix++;
        }
        StatementHelper sh = sqlGenerator.generateSelectQuery(tableName,
                filtersAndKeys, orderBys, 0, 0, "*");


        boolean shouldCloseTransaction = false;
        if (!transactionOpen) {
            shouldCloseTransaction = true;

View Full Code Here

0 1

TOP

Related Classes of com.vaadin.addon.sqlcontainer.query.generator.StatementHelper

com.example.reclaadmin._FreeFormDelegate

com.vaadin.addon.sqlcontainer.query.FreeformQuery

com.vaadin.addon.sqlcontainer.query.TableQuery

java.sql.SQLException

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.