Examples of org.jooq.DSLContext.insertInto()

org.jooq.DSLContext.insertInto()

Create a new DSL insert statement.

Example:

 using(configuration) .insertInto(table, field1, field2, field3, .., field10, field11) .values(valueA1, valueA2, valueA3, .., valueA10, valueA11) .values(valueB1, valueB2, valueB3, .., valueB10, valueB11) .onDuplicateKeyUpdate() .set(field1, value1) .set(field2, value2) .execute();

    public void testInsertReturning() {


        // Note: INSERT .. RETURNING is hard to mock for all dialects...
        DSLContext e = DSL.using(new MockConnection(new InsertReturning()), SQLDialect.POSTGRES);


        InsertResultStep<Table1Record> query = e
            .insertInto(TABLE1, FIELD_ID1)
            .values(1)
            .returning();


        assertEquals(1, query.execute());

View Full Code Here

        try {


            // Inserting is just as easy as selecting
            Tools.title("Inserting a new AUTHOR");
            Tools.print(
                dsl.insertInto(AUTHOR, AUTHOR.ID, AUTHOR.FIRST_NAME, AUTHOR.LAST_NAME)
                   .values(3, "Alfred", "Hitchcock")
                   .execute()
            );


            // But the Java compiler will actively check your statements. The

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.