com.jfinal.plugin.activerecord

类 DbTemplate

java.lang.Object

com.jfinal.plugin.activerecord.DbTemplate

public class DbTemplate
extends Object

DbTemplate

 例子：
 Db.template("find", 123).find();
 

字段概要

字段

限定符和类型	字段和说明
protected DbPro	db
protected SqlPara	sqlPara

构造器概要

构造器

构造器和说明
DbTemplate(boolean byString, DbPro db, String content, Map<?,?> data)
DbTemplate(boolean byString, DbPro db, String content, Object... paras)
DbTemplate(DbPro db, String key, Map<?,?> data)
DbTemplate(DbPro db, String key, Object... paras)

方法概要

限定符和类型	方法和说明
int	delete()
void	each(Function<Record,Boolean> func)
List<Record>	find()
List<Record>	findByCache(String cacheName, Object key)
Record	findFirst()
Record	findFirstByCache(String cacheName, Object key)
SqlPara	getSqlPara()
Page<Record>	paginate(int pageNumber, int pageSize)
Page<Record>	paginate(int pageNumber, int pageSize, boolean isGroupBySql)
Page<Record>	paginateByCache(String cacheName, Object key, int pageNumber, int pageSize)
Page<Record>	paginateByCache(String cacheName, Object key, int pageNumber, int pageSize, boolean isGroupBySql)
<T> List<T>	query()
BigDecimal	queryBigDecimal()
BigInteger	queryBigInteger()
Boolean	queryBoolean()
<T> T	queryColumn()
Date	queryDate()
Double	queryDouble()
<T> T	queryFirst()
Integer	queryInt()
LocalDateTime	queryLocalDateTime()
Long	queryLong()
String	queryStr()
Timestamp	queryTimestamp()
int	update()

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

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

字段详细资料

db

protected DbPro db

sqlPara

protected SqlPara sqlPara

构造器详细资料

DbTemplate

public DbTemplate(DbPro db,
                  String key,
                  Map<?,?> data)

DbTemplate

public DbTemplate(DbPro db,
                  String key,
                  Object... paras)

DbTemplate

public DbTemplate(boolean byString,
                  DbPro db,
                  String content,
                  Map<?,?> data)

DbTemplate

public DbTemplate(boolean byString,
                  DbPro db,
                  String content,
                  Object... paras)

方法详细资料

getSqlPara

public SqlPara getSqlPara()

find

public List<Record> find()

findFirst

public Record findFirst()

update

public int update()

paginate

public Page<Record> paginate(int pageNumber,
                             int pageSize)

paginate

public Page<Record> paginate(int pageNumber,
                             int pageSize,
                             boolean isGroupBySql)

each

public void each(Function<Record,Boolean> func)

delete

public int delete()

queryStr

public String queryStr()

queryInt

public Integer queryInt()

queryLong

public Long queryLong()

queryDouble

public Double queryDouble()

queryBigDecimal

public BigDecimal queryBigDecimal()

queryBigInteger

public BigInteger queryBigInteger()

queryDate

public Date queryDate()

queryLocalDateTime

public LocalDateTime queryLocalDateTime()

queryTimestamp

public Timestamp queryTimestamp()

queryBoolean

public Boolean queryBoolean()

queryColumn

public <T> T queryColumn()

query

public <T> List<T> query()

queryFirst

public <T> T queryFirst()

findByCache

public List<Record> findByCache(String cacheName,
                                Object key)

findFirstByCache

public Record findFirstByCache(String cacheName,
                               Object key)

paginateByCache

public Page<Record> paginateByCache(String cacheName,
                                    Object key,
                                    int pageNumber,
                                    int pageSize)

paginateByCache

public Page<Record> paginateByCache(String cacheName,
                                    Object key,
                                    int pageNumber,
                                    int pageSize,
                                    boolean isGroupBySql)