查询语句

WITH

WITH RECURSIVE

SELECT

APT 模式

List<User> userList = Db.table(User.class)
    .searcher()
    .select(sys_user.user_name, sys_user.age)
    .where(sys_user.age.ge(18))
    .orderBy(sys_user.age.asc())
    .list();

Lambda 模式

List<User> userList = Db.table(User.class)
    .searcher()
    .select(User::getUserName, User::getAge)
    .where(o -> o.eq(User::getAge, 18))
    .orderBy(User::getAge, OrderByType.ASC)
    .list();

字符串模式

List<User> userList = Db.table(User.class)
    .searcher()
    .select("user_name", "age")
    .where(o -> o.eq("age", 18))
    .orderBy("age", OrderByType.ASC)
    .list();

无实体模式

List<Row> rowList = Db.table("sys_user")
    .searcher()
    .select("user_name", "age")
    .where(o -> o.eq("age", 18))
    .orderBy("age", OrderByType.ASC)
    .list();

原始表达式

SelectExpression sql = SelectExpression.create()
    .select(sys_user.user_name, sys_user.age)
    .from(sys_user)
    .where(sys_user.age.ge(18))
    .orderBy(sys_user.age.asc())

CASE WHEN

IF

IFNULL

HINT

FROM

SELECT 1 + 1 FROM DUAL

JOIN ON

WHERE

AND OR

GROUP BY

HAVING

WINDOW

ORDER BY

LIMIT OFFSET

UNION

UNION ALL