Wills Wills - 5 months ago 19
Java Question

insert query using Jooq is it possible?

I have insert statement in a string value now i want to change that into Jooq and excute the jooq on the DB is it possible ? or am i over expecting ?

My Insert Query :

INSERT INTO ANTIQUES (ID,TYPE,NAME,PRICE) VALUES (21, 01, 'Ottoman', 200.00);

Answer

Yes, you can do this. It should be similiar with the following code.

create.insertInto(ANTIQUES,
    ANTIQUES.ID, ANTIQUES.TYPE, ANTIQUES.NAME, ANTIQUES.PRICE)
    .values(21, 01, 'Ottoman', 200.00);

Please check the tutorial and document.

  1. The INSERT statement
  2. Tutorial: Getting started with jOOQ