public static void printRS(Recordset rs) { Fields fs = rs.getFields(); for (int i = 0; i < fs.getCount(); i++) { System.out.print(fs.getItem(i).getName() + " "); } System.out.println(""); rs.MoveFirst(); while (!rs.getEOF()) { for (int i = 0; i < fs.getCount(); i++) { Field f = fs.getItem(i); Variant v = f.getValue(); System.out.print(v + " "); } System.out.println(""); rs.MoveNext(); } }
/* (non-Javadoc) * @see dinamica.AbstractValidator#isValid(javax.servlet.http.HttpServletRequest, dinamica.Recordset, java.util.HashMap) */ public boolean isValid( HttpServletRequest req, Recordset inputParams, HashMap<String, String> attribs) throws Throwable { boolean bParam = attribs.containsKey("parameter"); if (!bParam) throw new Throwable( "[" + this.getClass().getName() + "] Missing attribute [parameter] in validator.xml"); boolean bRule = attribs.containsKey("rule"); if (!bRule) throw new Throwable( "[" + this.getClass().getName() + "] Missing attribute [rule] in validator.xml"); String rule = (String) attribs.get("rule"); if (!rule.equalsIgnoreCase("like") && !rule.equalsIgnoreCase("contains")) throw new Throwable( "[" + this.getClass().getName() + "] Invalid attribute value [rule] in validator.xml: " + rule + " - Accepted values are 'like' or 'contains'"); String paramName = (String) attribs.get("parameter"); if (!inputParams.isNull(paramName)) { String value = inputParams.getString(paramName); value = StringUtil.replace(value, "%", ""); if (rule.equalsIgnoreCase("like")) value = value + "%"; if (rule.equalsIgnoreCase("contains")) value = "%" + value + "%"; inputParams.setValue(paramName, value); } else { boolean x = attribs.containsKey("ifnull"); if (x) { String value = (String) attribs.get("ifnull"); inputParams.setValue(paramName, value); } } return true; }
// open a recordset directly public static void getRS(String con, String query) { System.out.println("Recordset Open"); Recordset rs = new Recordset(); rs.Open(new Variant(query), new Variant(con)); printRS(rs); }