Examples of org.jooq.DSLContext.select()

org.jooq.DSLContext.select()

Create a new DSL select statement.

This creates an attached, renderable and executable SELECT statement from this {@link DSLContext}. If you don't need to render or execute this SELECT statement (e.g. because you want to create a subselect), consider using the static {@link DSL#select(Collection)} instead.

Example:

 DSLContext create = DSL.using(configuration); create.select(fields) .from(table1) .join(table2).on(field1.equal(field2)) .where(field1.greaterThan(100)) .orderBy(field2);

@see DSL#select(Collection)

                create = DSL.using(DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD), JOOQ_DIALECT);
            } catch (SQLException e) {
                throw new RuntimeException("Error initializing jOOQ DSLContext", e);
            }


            q = create.select()
                      .from("post")
                      .where("id = ?", -1) // param needs an initial value, else future calls the bind() will fail.
                      .keepStatement(true);
        }

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.