cn.xphsc.jpamapper.core.jdbc

类 SQLSelector

java.lang.Object

cn.xphsc.jpamapper.core.jdbc.SQLSelector

public class SQLSelector
extends Object

SQL

从以下版本开始:

1.0.0

作者:

huipei.x

构造器概要

构造器

构造器和说明
SQLSelector(org.springframework.data.jpa.repository.support.SimpleJpaRepository jpaRepository, javax.persistence.EntityManager entityManager, Class<?> clazz)

方法概要

方法

限定符和类型	方法和说明
SQLSelector	AND()
int	count() 查询实体数量
SQLSelector	entityClass(Class<?> entityClass) 实体类型
SQLSelector	FROM(String table)
<T> T	get() 获取单个实体
SQLSelector	GROUP_BY(String columns)
SQLSelector	HAVING(String conditions)
SQLSelector	INNER_JOIN(String join)
SQLSelector	JOIN(String join)
SQLSelector	LEFT_OUTER_JOIN(String join)
<T> List<T>	list() 查询实体列表
SQLSelector	offsetPage(int offset, int limit)
SQLSelector	OR()
SQLSelector	ORDER_BY(String columns)
SQLSelector	OUTER_JOIN(String join)
<T> PageInfo<T>	page()
SQLSelector	pageInfo(int pageNum, int pageSize)
SQLSelector	parameters(Object parameters) parameters any JavaBean or POJO or Map or Object[]{}
SQLSelector	RIGHT_OUTER_JOIN(String join)
SQLSelector	SELECT_DISTINCT(String columns)
SQLSelector	SELECT(String columns)
SQLSelector	sql(String sql) 查询SQL
SQLSelector	WHERE(String conditions)

从类继承的方法 java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

构造器详细资料

SQLSelector

public SQLSelector(org.springframework.data.jpa.repository.support.SimpleJpaRepository jpaRepository,
           javax.persistence.EntityManager entityManager,
           Class<?> clazz)

方法详细资料

entityClass

public SQLSelector entityClass(Class<?> entityClass)

实体类型

参数:

entityClass - 实体类型

pageInfo

public SQLSelector pageInfo(int pageNum,
                   int pageSize)

offsetPage

public SQLSelector offsetPage(int offset,
                     int limit)

parameters

public SQLSelector parameters(Object parameters)

parameters any JavaBean or POJO or Map or Object[]{}

sql

public SQLSelector sql(String sql)

查询SQL

参数:

sql - SQL语句

get

public <T> T get()

获取单个实体

list

public <T> List<T> list()

查询实体列表

page

public <T> PageInfo<T> page()

count

public int count()

查询实体数量

返回:

条目数

SELECT

public SQLSelector SELECT(String columns)

SELECT_DISTINCT

public SQLSelector SELECT_DISTINCT(String columns)

FROM

public SQLSelector FROM(String table)

JOIN

public SQLSelector JOIN(String join)

INNER_JOIN

public SQLSelector INNER_JOIN(String join)

LEFT_OUTER_JOIN

public SQLSelector LEFT_OUTER_JOIN(String join)

RIGHT_OUTER_JOIN

public SQLSelector RIGHT_OUTER_JOIN(String join)

OUTER_JOIN

public SQLSelector OUTER_JOIN(String join)

WHERE

public SQLSelector WHERE(String conditions)

OR

public SQLSelector OR()

AND

public SQLSelector AND()

GROUP_BY

public SQLSelector GROUP_BY(String columns)

HAVING

public SQLSelector HAVING(String conditions)

ORDER_BY

public SQLSelector ORDER_BY(String columns)