Package | Description |
---|---|
com.jfinal.plugin.activerecord | |
com.jfinal.plugin.activerecord.builder | |
com.jfinal.plugin.activerecord.dialect |
Modifier and Type | Method and Description |
---|---|
Record |
Record.clear()
Remove all columns of this record.
|
static Record |
Db.findById(String tableName,
Object idValue)
Find record by id with default primary key.
|
Record |
DbPro.findById(String tableName,
Object idValue)
Find record by id with default primary key.
|
static Record |
Db.findById(String tableName,
String primaryKey,
Object... idValue)
Find record by id.
|
Record |
DbPro.findById(String tableName,
String primaryKey,
Object... idValue)
Find record by id.
|
static Record |
Db.findFirst(SqlPara sqlPara) |
Record |
DbPro.findFirst(SqlPara sqlPara) |
static Record |
Db.findFirst(String sql) |
Record |
DbPro.findFirst(String sql) |
static Record |
Db.findFirst(String sql,
Object... paras)
Find first record.
|
Record |
DbPro.findFirst(String sql,
Object... paras)
Find first record.
|
static Record |
Db.findFirstByCache(String cacheName,
Object key,
String sql) |
Record |
DbPro.findFirstByCache(String cacheName,
Object key,
String sql) |
static Record |
Db.findFirstByCache(String cacheName,
Object key,
String sql,
Object... paras)
Find first record by cache.
|
Record |
DbPro.findFirstByCache(String cacheName,
Object key,
String sql,
Object... paras)
Find first record by cache.
|
Record |
Record.keep(String... columns)
Keep columns of this record and remove other columns.
|
Record |
Record.keep(String column)
Keep column of this record and remove other columns.
|
Record |
Record.remove(String... columns)
Remove columns of this record.
|
Record |
Record.remove(String column)
Remove attribute of this record.
|
Record |
Record.removeNullValueColumns()
Remove columns if it is null.
|
Record |
Record.set(String column,
Object value)
Set column to record.
|
Record |
Record.setColumns(Map<String,Object> columns)
Set columns value with map.
|
Record |
Record.setColumns(Model<?> model)
Set columns value with Model object.
|
Record |
Record.setColumns(Record record)
Set columns value with Record.
|
Record |
Record.setContainerFactoryByConfigName(String configName)
Set the containerFactory by configName.
|
Record |
Model.toRecord()
Convert model to record.
|
Modifier and Type | Method and Description |
---|---|
List<Record> |
RecordBuilder.build(Config config,
ResultSet rs) |
protected Page<Record> |
DbPro.doPaginate(int pageNumber,
int pageSize,
Boolean isGroupBySql,
String select,
String sqlExceptSelect,
Object... paras) |
protected Page<Record> |
DbPro.doPaginateByCache(String cacheName,
Object key,
int pageNumber,
int pageSize,
Boolean isGroupBySql,
String select,
String sqlExceptSelect,
Object... paras) |
protected Page<Record> |
DbPro.doPaginateByFullSql(Config config,
Connection conn,
int pageNumber,
int pageSize,
Boolean isGroupBySql,
String totalRowSql,
StringBuilder findSql,
Object... paras) |
protected Page<Record> |
DbPro.doPaginateByFullSql(int pageNumber,
int pageSize,
Boolean isGroupBySql,
String totalRowSql,
String findSql,
Object... paras) |
static List<Record> |
CPI.find(Connection conn,
String sql,
Object... paras) |
static List<Record> |
Db.find(SqlPara sqlPara) |
List<Record> |
DbPro.find(SqlPara sqlPara) |
static List<Record> |
Db.find(String sql) |
List<Record> |
DbPro.find(String sql) |
static List<Record> |
CPI.find(String configName,
Connection conn,
String sql,
Object... paras) |
static List<Record> |
Db.find(String sql,
Object... paras) |
List<Record> |
DbPro.find(String sql,
Object... paras) |
static List<Record> |
Db.findByCache(String cacheName,
Object key,
String sql) |
List<Record> |
DbPro.findByCache(String cacheName,
Object key,
String sql) |
static List<Record> |
Db.findByCache(String cacheName,
Object key,
String sql,
Object... paras)
Find Record by cache.
|
List<Record> |
DbPro.findByCache(String cacheName,
Object key,
String sql,
Object... paras)
Find Record by cache.
|
static Page<Record> |
CPI.paginate(Connection conn,
int pageNumber,
int pageSize,
String select,
String sqlExceptSelect,
Object... paras) |
static Page<Record> |
Db.paginate(int pageNumber,
int pageSize,
boolean isGroupBySql,
String select,
String sqlExceptSelect,
Object... paras) |
Page<Record> |
DbPro.paginate(int pageNumber,
int pageSize,
boolean isGroupBySql,
String select,
String sqlExceptSelect,
Object... paras) |
static Page<Record> |
Db.paginate(int pageNumber,
int pageSize,
SqlPara sqlPara) |
Page<Record> |
DbPro.paginate(int pageNumber,
int pageSize,
SqlPara sqlPara) |
static Page<Record> |
Db.paginate(int pageNumber,
int pageSize,
String select,
String sqlExceptSelect) |
Page<Record> |
DbPro.paginate(int pageNumber,
int pageSize,
String select,
String sqlExceptSelect) |
static Page<Record> |
Db.paginate(int pageNumber,
int pageSize,
String select,
String sqlExceptSelect,
Object... paras)
Paginate.
|
Page<Record> |
DbPro.paginate(int pageNumber,
int pageSize,
String select,
String sqlExceptSelect,
Object... paras)
Paginate.
|
static Page<Record> |
CPI.paginate(String configName,
Connection conn,
int pageNumber,
int pageSize,
String select,
String sqlExceptSelect,
Object... paras) |
static Page<Record> |
Db.paginateByCache(String cacheName,
Object key,
int pageNumber,
int pageSize,
boolean isGroupBySql,
String select,
String sqlExceptSelect,
Object... paras) |
Page<Record> |
DbPro.paginateByCache(String cacheName,
Object key,
int pageNumber,
int pageSize,
boolean isGroupBySql,
String select,
String sqlExceptSelect,
Object... paras) |
static Page<Record> |
Db.paginateByCache(String cacheName,
Object key,
int pageNumber,
int pageSize,
String select,
String sqlExceptSelect) |
Page<Record> |
DbPro.paginateByCache(String cacheName,
Object key,
int pageNumber,
int pageSize,
String select,
String sqlExceptSelect) |
static Page<Record> |
Db.paginateByCache(String cacheName,
Object key,
int pageNumber,
int pageSize,
String select,
String sqlExceptSelect,
Object... paras)
Paginate by cache.
|
Page<Record> |
DbPro.paginateByCache(String cacheName,
Object key,
int pageNumber,
int pageSize,
String select,
String sqlExceptSelect,
Object... paras)
Paginate by cache.
|
static Page<Record> |
Db.paginateByFullSql(int pageNumber,
int pageSize,
boolean isGroupBySql,
String totalRowSql,
String findSql,
Object... paras) |
Page<Record> |
DbPro.paginateByFullSql(int pageNumber,
int pageSize,
boolean isGroupBySql,
String totalRowSql,
String findSql,
Object... paras) |
static Page<Record> |
Db.paginateByFullSql(int pageNumber,
int pageSize,
String totalRowSql,
String findSql,
Object... paras) |
Page<Record> |
DbPro.paginateByFullSql(int pageNumber,
int pageSize,
String totalRowSql,
String findSql,
Object... paras) |
Modifier and Type | Method and Description |
---|---|
static boolean |
Db.delete(String tableName,
Record record)
Example:
boolean succeed = Db.delete("user", user);
|
boolean |
DbPro.delete(String tableName,
Record record)
Example:
boolean succeed = DbPro.use().delete("user", user);
|
static boolean |
Db.delete(String tableName,
String primaryKey,
Record record)
Delete record.
|
boolean |
DbPro.delete(String tableName,
String primaryKey,
Record record)
Delete record.
|
static SqlPara |
Db.getSqlPara(String key,
Record record) |
SqlPara |
DbPro.getSqlPara(String key,
Record record) |
M |
Model.put(Record record)
Put record to the model without check attribute name.
|
static boolean |
Db.save(String tableName,
Record record) |
boolean |
DbPro.save(String tableName,
Record record) |
static boolean |
Db.save(String tableName,
String primaryKey,
Record record)
Save record.
|
boolean |
DbPro.save(String tableName,
String primaryKey,
Record record)
Save record.
|
Record |
Record.setColumns(Record record)
Set columns value with Record.
|
static void |
CPI.setColumnsMap(Record record,
Map<String,Object> columns)
Return the columns map of the record
|
static boolean |
Db.update(String tableName,
Record record)
Update record with default primary key.
|
boolean |
DbPro.update(String tableName,
Record record)
Update record with default primary key.
|
static boolean |
Db.update(String tableName,
String primaryKey,
Record record)
Update Record.
|
boolean |
DbPro.update(String tableName,
String primaryKey,
Record record)
Update Record.
|
Modifier and Type | Method and Description |
---|---|
static int[] |
Db.batchSave(String tableName,
List<Record> recordList,
int batchSize) |
int[] |
DbPro.batchSave(String tableName,
List<Record> recordList,
int batchSize)
Batch save records using the "insert into ..." sql generated by the first record in recordList.
|
static int[] |
Db.batchUpdate(String tableName,
List<Record> recordList,
int batchSize) |
int[] |
DbPro.batchUpdate(String tableName,
List<Record> recordList,
int batchSize)
Batch update records with default primary key, using the columns names of the first record in recordList.
|
static int[] |
Db.batchUpdate(String tableName,
String primaryKey,
List<Record> recordList,
int batchSize) |
int[] |
DbPro.batchUpdate(String tableName,
String primaryKey,
List<Record> recordList,
int batchSize)
Batch update records using the columns names of the first record in recordList.
|
Modifier and Type | Method and Description |
---|---|
List<Record> |
KeepByteAndShortRecordBuilder.build(Config config,
ResultSet rs) |
List<Record> |
TimestampProcessedRecordBuilder.build(Config config,
ResultSet rs) |
Modifier and Type | Method and Description |
---|---|
List<Record> |
Dialect.buildRecordList(Config config,
ResultSet rs) |
Page<Record> |
Dialect.takeOverDbPaginate(Connection conn,
int pageNumber,
int pageSize,
Boolean isGroupBySql,
String totalRowSql,
StringBuilder findSql,
Object... paras) |
Page<Record> |
AnsiSqlDialect.takeOverDbPaginate(Connection conn,
int pageNumber,
int pageSize,
Boolean isGroupBySql,
String totalRowSql,
StringBuilder findSql,
Object... paras) |
Modifier and Type | Method and Description |
---|---|
void |
Sqlite3Dialect.forDbSave(String tableName,
String[] pKeys,
Record record,
StringBuilder sql,
List<Object> paras) |
abstract void |
Dialect.forDbSave(String tableName,
String[] pKeys,
Record record,
StringBuilder sql,
List<Object> paras) |
void |
MysqlDialect.forDbSave(String tableName,
String[] pKeys,
Record record,
StringBuilder sql,
List<Object> paras)
Do not delete the String[] pKeys parameter, the element of pKeys needs to trim()
|
void |
OracleDialect.forDbSave(String tableName,
String[] pKeys,
Record record,
StringBuilder sql,
List<Object> paras) |
void |
SqlServerDialect.forDbSave(String tableName,
String[] pKeys,
Record record,
StringBuilder sql,
List<Object> paras) |
void |
AnsiSqlDialect.forDbSave(String tableName,
String[] pKeys,
Record record,
StringBuilder sql,
List<Object> paras) |
void |
PostgreSqlDialect.forDbSave(String tableName,
String[] pKeys,
Record record,
StringBuilder sql,
List<Object> paras) |
void |
Sqlite3Dialect.forDbUpdate(String tableName,
String[] pKeys,
Object[] ids,
Record record,
StringBuilder sql,
List<Object> paras) |
abstract void |
Dialect.forDbUpdate(String tableName,
String[] pKeys,
Object[] ids,
Record record,
StringBuilder sql,
List<Object> paras) |
void |
MysqlDialect.forDbUpdate(String tableName,
String[] pKeys,
Object[] ids,
Record record,
StringBuilder sql,
List<Object> paras) |
void |
OracleDialect.forDbUpdate(String tableName,
String[] pKeys,
Object[] ids,
Record record,
StringBuilder sql,
List<Object> paras) |
void |
SqlServerDialect.forDbUpdate(String tableName,
String[] pKeys,
Object[] ids,
Record record,
StringBuilder sql,
List<Object> paras) |
void |
AnsiSqlDialect.forDbUpdate(String tableName,
String[] pKeys,
Object[] ids,
Record record,
StringBuilder sql,
List<Object> paras) |
void |
PostgreSqlDialect.forDbUpdate(String tableName,
String[] pKeys,
Object[] ids,
Record record,
StringBuilder sql,
List<Object> paras) |
void |
Dialect.getRecordGeneratedKey(PreparedStatement pst,
Record record,
String[] pKeys)
用于获取 Db.save(tableName, record) 以后自动生成的主键值,可通过覆盖此方法实现更精细的控制
目前只有 PostgreSqlDialect,覆盖过此方法
|
void |
PostgreSqlDialect.getRecordGeneratedKey(PreparedStatement pst,
Record record,
String[] pKeys)
解决 PostgreSql 获取自增主键时 rs.getObject(1) 总是返回第一个字段的值,而非返回了 id 值
issue: https://www.oschina.net/question/2312705_2243354
相对于 Dialect 中的默认实现,仅将 rs.getXxx(1) 改成了 rs.getXxx(pKey)
|
Copyright © 2018. All rights reserved.