类 com.jfinal.plugin.activerecord.Record的使用 (JFinal 2.2 API)

使用Record的程序包
程序包说明

com.jfinal.plugin.activerecord

com.jfinal.plugin.activerecord.dialect

使用Record的程序包
程序包	说明
com.jfinal.plugin.activerecord
com.jfinal.plugin.activerecord.dialect

com.jfinal.plugin.activerecord中Record的使用

返回Record的com.jfinal.plugin.activerecord中的方法
限定符和类型	方法和说明
`Record`	Record.`clear()` Remove all columns of this record.
`Record`	DbPro.`findById(String tableName, Object idValue)` Find record by id with default primary key.
`static Record`	Db.`findById(String tableName, Object idValue)` Find record by id with default primary key.
`Record`	DbPro.`findById(String tableName, String primaryKey, Object... idValue)` Find record by id.
`static Record`	Db.`findById(String tableName, String primaryKey, Object... idValue)` Find record by id.
`Record`	DbPro.`findFirst(String sql)`
`static Record`	Db.`findFirst(String sql)`
`Record`	DbPro.`findFirst(String sql, Object... paras)` Find first record.
`static Record`	Db.`findFirst(String sql, Object... paras)` Find first record.
`Record`	DbPro.`findFirstByCache(String cacheName, Object key, String sql)`
`static Record`	Db.`findFirstByCache(String cacheName, Object key, String sql)`
`Record`	DbPro.`findFirstByCache(String cacheName, Object key, String sql, Object... paras)` Find first record by cache.
`static Record`	Db.`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.

返回变量类型为Record的类型的com.jfinal.plugin.activerecord中的方法
限定符和类型	方法和说明
`static List<Record>`	RecordBuilder.`build(Config config, ResultSet rs)`
`static List<Record>`	CPI.`find(Connection conn, String sql, Object... paras)` Return the columns map of the record
`List<Record>`	DbPro.`find(String sql)`
`static List<Record>`	Db.`find(String sql)`
`static List<Record>`	CPI.`find(String configName, Connection conn, String sql, Object... paras)`
`List<Record>`	DbPro.`find(String sql, Object... paras)`
`static List<Record>`	Db.`find(String sql, Object... paras)`
`List<Record>`	DbPro.`findByCache(String cacheName, Object key, String sql)`
`static List<Record>`	Db.`findByCache(String cacheName, Object key, String sql)`
`List<Record>`	DbPro.`findByCache(String cacheName, Object key, String sql, Object... paras)` Find Record by cache.
`static List<Record>`	Db.`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)`
`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, boolean isGroupBySql, String select, String sqlExceptSelect, Object... paras)`
`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)`
`Page<Record>`	DbPro.`paginate(int pageNumber, int pageSize, String select, String sqlExceptSelect, Object... paras)` Paginate.
`static Page<Record>`	Db.`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)`
`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, boolean isGroupBySql, String select, String sqlExceptSelect, Object... paras)`
`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)`
`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.`paginateByCache(String cacheName, Object key, int pageNumber, int pageSize, String select, String sqlExceptSelect, Object... paras)` Paginate by cache.

参数类型为Record的com.jfinal.plugin.activerecord中的方法
限定符和类型	方法和说明
`boolean`	DbPro.`delete(String tableName, Record record)` Example: boolean succeed = DbPro.use().delete("user", user);
`static boolean`	Db.`delete(String tableName, Record record)` Example: boolean succeed = Db.delete("user", user);
`boolean`	DbPro.`delete(String tableName, String primaryKey, Record record)` Delete record.
`static boolean`	Db.`delete(String tableName, String primaryKey, Record record)` Delete record.
`M`	Model.`put(Record record)` Put record to the model without check attribute name.
`boolean`	DbPro.`save(String tableName, Record record)`
`static boolean`	Db.`save(String tableName, Record record)`
`boolean`	DbPro.`save(String tableName, String primaryKey, Record record)` Save record.
`static boolean`	Db.`save(String tableName, String primaryKey, Record record)` Save record.
`Record`	Record.`setColumns(Record record)` Set columns value with Record.
`boolean`	DbPro.`update(String tableName, Record record)` Update record with default primary key.
`static boolean`	Db.`update(String tableName, Record record)` Update record with default primary key.
`boolean`	DbPro.`update(String tableName, String primaryKey, Record record)` Update Record.
`static boolean`	Db.`update(String tableName, String primaryKey, Record record)` Update Record.

类型变量类型为Record的com.jfinal.plugin.activerecord中的方法参数
限定符和类型	方法和说明
`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.`batchSave(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, 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.
`static int[]`	Db.`batchUpdate(String tableName, String primaryKey, List<Record> recordList, int batchSize)`

com.jfinal.plugin.activerecord.dialect中Record的使用

返回变量类型为Record的类型的com.jfinal.plugin.activerecord.dialect中的方法
限定符和类型	方法和说明
`Page<Record>`	Dialect.`takeOverDbPaginate(Connection conn, int pageNumber, int pageSize, Boolean isGroupBySql, String select, String sqlExceptSelect, Object... paras)`
`Page<Record>`	AnsiSqlDialect.`takeOverDbPaginate(Connection conn, int pageNumber, int pageSize, Boolean isGroupBySql, String select, String sqlExceptSelect, Object... paras)`

参数类型为Record的com.jfinal.plugin.activerecord.dialect中的方法
限定符和类型	方法和说明
`void`	SqlServerDialect.`forDbSave(String tableName, String[] pKeys, Record record, StringBuilder sql, List<Object> paras)`
`void`	Sqlite3Dialect.`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`	OracleDialect.`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()
`abstract void`	Dialect.`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`	SqlServerDialect.`forDbUpdate(String tableName, String[] pKeys, Object[] ids, Record record, StringBuilder sql, List<Object> paras)`
`void`	Sqlite3Dialect.`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`	OracleDialect.`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)`
`abstract void`	Dialect.`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)`