public void setQueryParams(Collection queryParams, PreparedStatement ps) throws Exception {
		if ((queryParams == null) || (queryParams.size() == 0))
			return;
		int i = 1;
		Object key = null;

		Iterator iter = queryParams.iterator();
		while (iter.hasNext()) {
			key = iter.next();
			if (key != null) {
				convertType(i, key, ps);
				Debug.logVerbose("[JdonFramework] parameter " + i + " = " + key.toString(), module);
			} else {
				Debug.logWarning("[JdonFramework] parameter " + i + " is null", module);
				ps.setString(i, "");
			}
			i++;
		}

	}
public void setQueryParams ( Collection queryParams , PreparedStatement ps ) throws Exception { if ( ( queryParams == null ) || ( queryParams . size ( ) == 0 ) ) return ; int i = 1 ; Object key = null ; Iterator iter = queryParams . iterator ( ) ; while ( iter . hasNext ( ) ) { key = iter . next ( ) ; if ( key != null ) { convertType ( i , key , ps ) ; Debug . logVerbose ( "[JdonFramework] parameter " + i + " = " + key . toString ( ) , module ) ; } else { Debug . logWarning ( "[JdonFramework] parameter " + i + " is null" , module ) ; ps . setString ( i , "" ) ; } i ++ ; } }
queryParam type only support String Integer Float or Long Double Bye
Short if you need operate other types, you must use JDBC directly!