DbQueryParser(final String sql) { parseSql(sql); }
public String[] getAllString(final String param) { final int[] positions = query.getNamedParameterIndices(param); final String[] result = new String[positions.length]; try { for (int i = 0; i < positions.length; i++) { result[i] = statement.getString(positions[i]); } return result; } catch (SQLException sex) { throw newGetParamError(param, sex); } }
storeNamedParameter(param, paramCount); pureSql.append('?'); saveBatchParameter(param, batchSize); storeNamedParameter(param + '.' + i, paramCount); pureSql.append('?'); storeNamedParameter(param, paramCount); pureSql.append('?'); index = right;
this.query = new DbQueryParser(sqlString);
/** * Sets batch parameters with given array of values. */ public Q setBatch(final String name, final long[] array, int startingIndex) { init(); final int batchSize = query.getBatchParameterSize(name); for (int i = 1; i <= batchSize; i++) { final String paramName = name + '.' + i; if (startingIndex < array.length) { setLong(paramName, array[startingIndex]); } else { setNull(paramName, Types.INTEGER); } startingIndex++; } return _this(); }
storeNamedParameter(param, paramCount); pureSql.append('?'); index = right; storeNamedParameter(param, paramCount); pureSql.append('?'); index = right;
int[] getNamedParameterIndices(final String name) { final DbQueryNamedParameter p = lookupNamedParameter(name); if (p == null) { throw new DbSqlException("Named parameter not found: " + name + "\nQuery: " + sql); } return p.indices; }
/** * Sets properties from the map. */ public Q setMap(final Map parameters) { if (parameters == null) { return _this(); } init(); query.forEachNamedParameter(p -> { final String paramName = p.name; setObject(paramName, parameters.get(paramName)); }); return _this(); }
this.query = new DbQueryParser(sqlString);
/** * Sets batch parameters with given array of values. */ public Q setBatch(final String name, final int[] array, int startingIndex) { init(); final int batchSize = query.getBatchParameterSize(name); for (int i = 1; i <= batchSize; i++) { final String paramName = name + '.' + i; if (startingIndex < array.length) { setInteger(paramName, array[startingIndex]); } else { setNull(paramName, Types.INTEGER); } startingIndex++; } return _this(); } /**
void storeNamedParameter(final String name, final int position) { DbQueryNamedParameter p = lookupNamedParameter(name); if (p == null) { p = new DbQueryNamedParameter(name); p.indices = new int[] {position}; p.next = rootNP; rootNP = p; } else { p.add(position); } }
/** * Sets bean parameters from bean. Non-existing bean properties are ignored. */ public Q setBean(final String beanName, final Object bean) { if (bean == null) { return _this(); } init(); final String beanNamePrefix = beanName + '.'; query.forEachNamedParameter(p -> { final String paramName = p.name; if (paramName.startsWith(beanNamePrefix)) { final String propertyName = paramName.substring(beanNamePrefix.length()); if (BeanUtil.declared.hasRootProperty(bean, propertyName)) { final Object value = BeanUtil.declared.getProperty(bean, propertyName); setObject(paramName, value); } } }); return _this(); }
public String getString(final String param) { final int[] positions = query.getNamedParameterIndices(param); try { if (positions.length == 1) { return statement.getString(positions[0]); } throw newGetParamError(param); } catch (SQLException sex) { throw newGetParamError(param, sex); } }
String prepare(String sql) { super.parseSql(sql); return this.sql; } }
storeNamedParameter(param, paramCount); pureSql.append('?'); saveBatchParameter(param, batchSize); storeNamedParameter(param + '.' + i, paramCount); pureSql.append('?'); storeNamedParameter(param, paramCount); pureSql.append('?'); index = right;
this.query = new DbQueryParser(sqlString);
/** * Sets batch parameters with given array of values. */ public Q setBatch(final String name, final Object[] array, int startingIndex) { init(); final int batchSize = query.getBatchParameterSize(name); for (int i = 1; i <= batchSize; i++) { final String paramName = name + '.' + i; if (startingIndex < array.length) { setObject(paramName, array[startingIndex]); } else { setObject(paramName, null); } startingIndex++; } return _this(); }
int[] getNamedParameterIndices(final String name) { final DbQueryNamedParameter p = lookupNamedParameter(name); if (p == null) { throw new DbSqlException("Named parameter not found: " + name + "\nQuery: " + sql); } return p.indices; }
/** * Sets properties from the map. */ public Q setMap(final Map parameters) { if (parameters == null) { return _this(); } init(); query.forEachNamedParameter(p -> { final String paramName = p.name; setObject(paramName, parameters.get(paramName)); }); return _this(); }
public float[] getAllFloat(final String param) { final int[] positions = query.getNamedParameterIndices(param); final float[] result = new float[positions.length]; try { for (int i = 0; i < positions.length; i++) { result[i] = statement.getFloat(positions[i]); } return result; } catch (SQLException sex) { throw newGetParamError(param, sex); } }