protected List<M> find(Config config, String sql, Object... paras) { Connection conn = null; try { conn = config.getConnection(); return find(config, conn, sql, paras); } catch (Exception e) { throw new ActiveRecordException(e); } finally { config.close(conn); } }
public Page<Record> paginate(int pageNumber, int pageSize, boolean isGroupBySql, SqlPara sqlPara) { String[] sqls = PageSqlKit.parsePageSql(sqlPara.getSql()); return doPaginate(pageNumber, pageSize, isGroupBySql, sqls[0], sqls[1], sqlPara.getPara()); } }
public Page<M> paginate(int pageNumber, int pageSize, SqlPara sqlPara) { String[] sqls = PageSqlKit.parsePageSql(sqlPara.getSql()); return doPaginate(pageNumber, pageSize, null, sqls[0], sqls[1], sqlPara.getPara()); } }
private boolean deleteById(Table table, Object... idValues) { Config config = _getConfig(); Connection conn = null; try { conn = config.getConnection(); String sql = config.dialect.forModelDeleteById(table); return Db.update(config, conn, sql, idValues) >= 1; } catch (Exception e) { throw new ActiveRecordException(e); } finally { config.close(conn); } }
/** * @see #find(String, String, Object...) */ public List<Record> find(String sql, Object... paras) { Connection conn = null; try { conn = config.getConnection(); return find(config, conn, sql, paras); } catch (Exception e) { throw new ActiveRecordException(e); } finally { config.close(conn); } }
/** * @see #query(String, String, Object...) */ public <T> List<T> query(String sql, Object... paras) { Connection conn = null; try { conn = config.getConnection(); return query(config, conn, sql, paras); } catch (Exception e) { throw new ActiveRecordException(e); } finally { config.close(conn); } }
protected Page<Record> doPaginateByFullSql(int pageNumber, int pageSize, Boolean isGroupBySql, String totalRowSql, String findSql, Object... paras) { Connection conn = null; try { conn = config.getConnection(); StringBuilder findSqlBuf = new StringBuilder().append(findSql); return doPaginateByFullSql(config, conn, pageNumber, pageSize, isGroupBySql, totalRowSql, findSqlBuf, paras); } catch (Exception e) { throw new ActiveRecordException(e); } finally { config.close(conn); } }
/** * Convert model to record. */ public Record toRecord() { return new Record().setColumns(_getAttrs()); }
protected Config _getConfig() { if (configName != null) return DbKit.getConfig(configName); return DbKit.getConfig(_getUsefulClass()); }
public SqlPara getSqlPara(String key, Record record) { return getSqlPara(key, record.getColumns()); }
/** * Execute transaction with default transaction level. * @see #tx(int, IAtom) */ public boolean tx(IAtom atom) { return tx(config, config.getTransactionLevel(), atom); }
public boolean stop() { DbKit.removeConfig(config.getName()); isStarted = false; return true; }
private Map<String, Object> createAttrsMap() { Config config = _getConfig(); if (config == null) return DbKit.brokenConfig.containerFactory.getAttrsMap(); return config.containerFactory.getAttrsMap(); }
protected Set<String> _getModifyFlag() { if (modifyFlag == null) { Config config = _getConfig(); if (config == null) modifyFlag = DbKit.brokenConfig.containerFactory.getModifyFlagSet(); else modifyFlag = config.containerFactory.getModifyFlagSet(); } return modifyFlag; }
public SqlPara getSqlPara(String key, Model model) { return getSqlPara(key, model._getAttrs()); }
public Page<Record> paginate(int pageNumber, int pageSize, SqlPara sqlPara) { String[] sqls = PageSqlKit.parsePageSql(sqlPara.getSql()); return doPaginate(pageNumber, pageSize, null, sqls[0], sqls[1], sqlPara.getPara()); }