Examples of org.jooq.Query.execute()

org.jooq.Query.execute()
Execute the query, if it has been created with a properly configured factory @return A result value, depending on the concrete implementation of{@link Query}:
- {@link Delete} : the number of deleted records
- {@link Insert} : the number of inserted records
- {@link Merge} : the result may have no meaning
- {@link Select} : the number of resulting records
- {@link Truncate} : the result may have no meaning
- {@link Update} : the number of updated records
@throws DataAccessException If anything goes wrong in the database

        DSLContext e = DSL.using(new MockConnection(new Exceptional()), SQLDialect.H2);


        Query query = e.query("insert into x values(1)");


        try {
            query.execute();
            fail();
        }
        catch (DataAccessException expected) {
            assertEquals("Expected", expected.getCause().getMessage());
        }

View Full Code Here

        }


        Tools.title("You always know whether a result set is produced with jOOQ, because of the type");
        Query q1 = DSL.using(connection).query("UPDATE AUTHOR SET LAST_NAME = LAST_NAME");
        System.out.println(
            q1.execute()
        );


        ResultQuery<Record> q2 = DSL.using(connection).resultQuery("SELECT * FROM AUTHOR");
        System.out.println(
            q2.fetch()

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.