Examples of org.jooq.DSLContext.update()

org.jooq.DSLContext.update()

Create a new DSL update statement.

Example:

 DSLContext create = DSL.using(configuration); create.update(table) .set(field1, value1) .set(field2, value2) .where(field1.greaterThan(100)) .execute();

Note that some databases support table expressions more complex than simple table references. In CUBRID and MySQL, for instance, you can write

 create.update(t1.join(t2).on(t1.id.eq(t2.id))) .set(t1.value, value1) .set(t2.value, value2) .where(t1.id.eq(10)) .execute();

                   .fetch()
            );


            Tools.title("Update the DATE_OF_BIRTH column");
            Tools.print(
                dsl.update(AUTHOR)
                   .set(AUTHOR.DATE_OF_BIRTH, Date.valueOf("1899-08-13"))
                   .where(AUTHOR.ID.eq(3))
                   .execute()
            );

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.