koding mysql_jOOQ查询Mysql简单实例

/**

* This class is generated by jOOQ

*/

package com.hellokoding.jooq.model.tables;

import com.hellokoding.jooq.model.Keys;

import com.hellokoding.jooq.model.Library;

import com.hellokoding.jooq.model.tables.records.AuthorRecord;

import java.util.Arrays;

import java.util.List;

import javax.annotation.Generated;

import org.jooq.Field;

import org.jooq.Schema;

import org.jooq.Table;

import org.jooq.TableField;

import org.jooq.UniqueKey;

import org.jooq.impl.TableImpl;

/**

* This class is generated by jOOQ.

*/

@Generated(

value = {

"http://www.jooq.org",

"jOOQ version:3.8.3"

},

comments = "This class is generated by jOOQ"

)

@SuppressWarnings({ "all", "unchecked", "rawtypes" })

public class Author extends TableImpl {

private static final long serialVersionUID = 620228564;

/**

* The reference instance of library.author

*/

public static final Author AUTHOR = new Author();

/**

* The class holding records for this type

*/

@Override

public Class getRecordType() {

return AuthorRecord.class;

}

/**

* The column library.author.id.

*/

public final TableField ID = createField("id", org.jooq.impl.SQLDataType.INTEGER.nullable(false), this, "");

/**

* The column library.author.first_name.

*/

public final TableField FIRST_NAME = createField("first_name", org.jooq.impl.SQLDataType.VARCHAR.length(255), this, "");

/**

* The column library.author.last_name.

*/

public final TableField LAST_NAME = createField("last_name", org.jooq.impl.SQLDataType.VARCHAR.length(255), this, "");

/**

* Create a library.author table reference

*/

public Author() {

this("author", null);

}

/**

* Create an aliased library.author table reference

*/

public Author(String alias) {

this(alias, AUTHOR);

}

private Author(String alias, Table aliased) {

this(alias, aliased, null);

}

private Author(String alias, Table aliased, Field>[] parameters) {

super(alias, null, aliased, parameters, "");

}

/**

* {@inheritDoc}

*/

@Override

public Schema getSchema() {

return Library.LIBRARY;

}

/**

* {@inheritDoc}

*/

@Override

public UniqueKey getPrimaryKey() {

return Keys.KEY_AUTHOR_PRIMARY;

}

/**

* {@inheritDoc}

*/

@Override

public List> getKeys() {

return Arrays.>asList(Keys.KEY_AUTHOR_PRIMARY);

}

/**

* {@inheritDoc}

*/

@Override

public Author as(String alias) {

return new Author(alias, this);

}

/**

* Rename this table

*/

public Author rename(String name) {

return new Author(name, null);

}

}