/** * @see #setObject(String, Object, Class, int) */ public Q setObject(final String param, final Object value) { setObject(param, value, null, Types.OTHER); return _this(); }
/** * @see #setObject(String, Object, Class, int) */ public Q setObject(final int index, final Object value) { setObject(index, value, null, Types.OTHER); return _this(); }
/** * Sets an array of objects parameters in given order. */ public Q setObjects(final Object... objects) { int index = 1; for (final Object object : objects) { setObject(index++, object); } return _this(); }
/** * 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(); }
/** * @see #setObject(String, Object, Class, int) */ public Q setObject(final String param, final Object value, final Class<? extends SqlType> sqlTypeClass, final int dbSqlType) { init(); final int[] positions = query.getNamedParameterIndices(param); for (final int position : positions) { setObject(position, value, sqlTypeClass, dbSqlType); } return _this(); }
/** * Sets sql parameters from two arrays: names and values. */ public Q setObjects(final String[] names, final Object[] values) { init(); if (names.length != values.length) { throw new DbSqlException(this, "Different number of parameter names and values"); } for (int i = 0; i < names.length; i++) { setObject(names[i], values[i]); } return _this(); }
/** * 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(); }
/** * 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(); }
/** * Sets an array of objects parameters in given order. */ public void setObjects(Object... objects) { int index = 1; for (Object object : objects) { setObject(index++, object); } }
/** * @see #setObject(String, Object, Class, int) */ public void setObject(int index, Object value) { setObject(index, value, null, Types.OTHER); }
/** * @see #setObject(String, Object, Class, int) */ public void setObject(String param, Object value) { setObject(param, value, null, Types.OTHER); }
/** * @see #setObject(String, Object, Class, int) */ public Q setObject(final String param, final Object value) { setObject(param, value, null, Types.OTHER); return _this(); }
/** * Sets an array of objects parameters in given order. */ public Q setObjects(final Object... objects) { int index = 1; for (final Object object : objects) { setObject(index++, object); } return _this(); }
/** * @see #setObject(String, Object, Class, int) */ public Q setObject(final int index, final Object value) { setObject(index, value, null, Types.OTHER); return _this(); }
/** * Sets properties from the map. */ public void setMap(Map parameters) { if (parameters == null) { return; } init(); Iterator it = query.iterateNamedParameters(); while (it.hasNext()) { String paramName = (String) it.next(); setObject(paramName, parameters.get(paramName)); } }
/** * Sets sql parameters from two arrays: names and values. */ public void setObjects(String[] names, Object[] values) { init(); if (names.length != values.length) { throw new DbSqlException("Different number of parameter names and values."); } for (int i = 0; i < names.length; i++) { setObject(names[i], values[i]); } } }
/** * Sets sql parameters from two arrays: names and values. */ public Q setObjects(final String[] names, final Object[] values) { init(); if (names.length != values.length) { throw new DbSqlException(this, "Different number of parameter names and values"); } for (int i = 0; i < names.length; i++) { setObject(names[i], values[i]); } return _this(); }
/** * @see #setObject(String, Object, Class, int) */ public Q setObject(final String param, final Object value, final Class<? extends SqlType> sqlTypeClass, final int dbSqlType) { init(); final int[] positions = query.getNamedParameterIndices(param); for (final int position : positions) { setObject(position, value, sqlTypeClass, dbSqlType); } return _this(); }
/** * @see #setObject(String, Object, Class, int) */ public void setObject(String param, Object value, Class<? extends SqlType> sqlTypeClass, int dbSqlType) { init(); IntArrayList positions = query.getNamedParameterIndices(param); for (int i = 0; i < positions.size(); i++) { setObject(positions.get(i), value, sqlTypeClass, dbSqlType); } }