Examples of org.jooq.DSLContext.selectFrom()

org.jooq.DSLContext.selectFrom()

Create a new DSL select statement.

Example:

 SELECT * FROM [table] WHERE [conditions] ORDER BY [ordering] LIMIT [limit clause]


        AuthorRecord author;


        try {
            Tools.title("Loading and changing active records");
            author = dsl.selectFrom(AUTHOR).where(AUTHOR.ID.eq(1)).fetchOne();
            author.setDateOfBirth(Date.valueOf("2000-01-01"));
            author.store();
            Tools.print(author);

View Full Code Here

            Tools.print(author);




            Tools.title("Deleting an active record");
            author.delete();
            Tools.print(dsl.selectFrom(AUTHOR).fetch());


        }


        // Don't store the changes
        finally {

View Full Code Here

        DSLContext dsl = DSL.using(connection, new Settings().withExecuteWithOptimisticLocking(true));


        try {
            Tools.title("Applying optimistic locking");


            BookRecord book1 = dsl.selectFrom(BOOK).where(BOOK.ID.eq(1)).fetchOne();
            BookRecord book2 = dsl.selectFrom(BOOK).where(BOOK.ID.eq(1)).fetchOne();


            book1.setTitle("New Title");
            book1.store();

View Full Code Here


        try {
            Tools.title("Applying optimistic locking");


            BookRecord book1 = dsl.selectFrom(BOOK).where(BOOK.ID.eq(1)).fetchOne();
            BookRecord book2 = dsl.selectFrom(BOOK).where(BOOK.ID.eq(1)).fetchOne();


            book1.setTitle("New Title");
            book1.store();


            book2.setTitle("Another Title");

View Full Code Here

        }
    }


    private final int executeSelectFrom() {
        DSLContext create = create(configuration);
        Result<?> result = create.selectFrom(table(asField())).fetch();
        outValues.put(returnParameter, result);
        return 0;
    }


    private final int executeSelect() {

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.