Examples of org.jooq.impl.Factory

org.jooq.impl.Factory
A factory providing implementations to the org.jooq interfaces
This factory is the main entry point for client code, to access jOOQ classes and functionality. Here, you can instanciate all of those objects that cannot be accessed through other objects. For example, to create a {@link Field}representing a constant value, you can write:
```
 Field<String> field = Factory.val("Hello World") 
```
Also, some SQL clauses cannot be expressed easily with DSL, for instance the EXISTS clause, as it is not applied on a concrete object (yet). Hence you should write
```
 Condition condition = Factory.exists(new Factory().select(...)); 
```
A Factory holds a reference to a JDBC {@link Connection} andoperates upon that connection. This means, that a Factory is not thread-safe, since a JDBC Connection is not thread-safe either. @author Lukas Eder


    public static void main(String[] args) throws Exception {
        Class.forName("com.mysql.jdbc.Driver");
        Connection connection = DriverManager.getConnection("jdbc:mysql://localhost/sakila", "root", "");


        Factory create = new SakilaFactory(connection);


        System.out.println(create
              .select()
              .from(CUSTOMER)
              .join(ADDRESS)
              .using(ADDRESS.ADDRESS_ID)
              .join(CITY)

View Full Code Here


    public static void main(String[] args) throws Exception {
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        Connection connection = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=AdventureWorks;integratedSecurity=true");


        Factory create = new SQLServerFactory(connection);


        System.out.println(create
              .select(Employee.getFields())
              .select(val("###"))
              .select(Department.getFields())
              .select(val("###"))
              .select(Contact.getFields())

View Full Code Here

import org.jooq.test.mysql.generatedclasses.tables.records.TBookRecord;


public class Library {


    private static Factory create() throws Exception {
        return new Factory(getConnection(), SQLDialect.MYSQL);
    }

View Full Code Here

    private ResourceService resourceService;


    private ConfigurationService configurationService;


    public SparqlToSQLMapper(Connection connection, SQLDialect dialect, CastType typeCast) {
        create = new Factory(connection,dialect);
        create.getSettings().setRenderFormatted(true);
        create.getSettings().setRenderNameStyle(RenderNameStyle.LOWER);
        create.getSettings().setStatementType(StatementType.STATIC_STATEMENT);


        this.dialect = dialect;

View Full Code Here

0 1

TOP

Related Classes of org.jooq.impl.Factory

org.apache.marmotta.platform.sparql.services.evaluation.sql.SparqlToSQLMapper

org.jooq.Configuration

org.jooq.examples.AdventureWorks

org.jooq.examples.Library

org.jooq.examples.Sakila

org.jooq.ExecuteContext

org.jooq.ExecuteListener

org.jooq.FieldProvider

org.jooq.test._.testcases.ExecuteListenerTests

org.jooq.test._.testcases.GeneralTests

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.