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);
Yes, you can do this. It should be similiar with the following code.
ANTIQUES.ID, ANTIQUES.TYPE, ANTIQUES.NAME, ANTIQUES.PRICE)
.values(21, 01, 'Ottoman', 200.00);
Please check the tutorial and document.