3.4 1.1 DB taglib http://www.servletsuite.com/servlets/dbtag DB tags openConnection com.cj.dbtag.openConnection com.cj.dbtag.objectVariable empty Opens JDBC connection driver false true jndiname false true user false true password false true url false true id true true closeConnection com.cj.dbtag.closeConnection empty Closes JDBC connection id true true closeStatement com.cj.dbtag.closeStatement empty Closes CallableStatement res true true transaction com.cj.dbtag.transaction JSP Marks transaction id true true getError com.cj.dbtag.getError empty Prints error message id true true ifError com.cj.dbtag.ifError JSP Executes own body in case of errors id true true setQuery com.cj.dbtag.setQuery com.cj.dbtag.objectVariable1 JSP Executes query id true true query false true res false true maxRows false true startRow false true setBlobQuery com.cj.dbtag.setBlobQuery com.cj.dbtag.objectVariable2 JSP Executes select query for BLOB field id true true query false true contentType true true res false true setParameter com.cj.dbtag.setParameter JSP Sets parameter value position false true type false true setOutputParameter com.cj.dbtag.setOutputParameter JSP Sets output parameter position false true type false true getCount com.cj.dbtag.getCount com.cj.dbtag.intVariable empty Counts rows res true true id false true moveFirst com.cj.dbtag.moveFirst empty Changes current row res true true moveLast com.cj.dbtag.moveLast empty Changes current row res true true moveNext com.cj.dbtag.moveNext empty Changes current row res true true step false true movePrev com.cj.dbtag.movePrev empty Changes current row res true true step false true getColumn com.cj.dbtag.getColumn com.cj.dbtag.objectVariable empty Reads column from the current row res false true position false true name false true id false true getColumnName com.cj.dbtag.getColumnName com.cj.dbtag.strVariable empty Reads column name from the current row res false true position false true id false true getColumnType com.cj.dbtag.getColumnType com.cj.dbtag.strVariable empty Reads column name from the current row res false true position false true id false true ifFound com.cj.dbtag.ifFound JSP Executes own body if query's result is not empty res true true ifNotFound com.cj.dbtag.ifNotFound JSP Executes own body if query's result is empty res true true forEachRow com.cj.dbtag.dataLoop com.cj.dbtag.intVariable1 JSP a loop over resultset res true true from false true to false true currentRow false true forEachColumn com.cj.dbtag.columnLoop com.cj.dbtag.intVariable2 JSP a loop over resultset res false true from false true to false true currentColumn false true escape com.cj.dbtag.escape JSP Replaces single quote with a pair of quotes data false true sortRows com.cj.dbtag.sortRows empty sorts rows res true true position false true direction false true ifNullColumn com.cj.dbtag.ifNullColumn JSP Executes own body if column value is null res false true position false true ifNotNullColumn com.cj.dbtag.ifNotNullColumn JSP Executes own body if column value is not null res false true position false true ifCached com.cj.dbtag.ifCached JSP Executes own body if cache is Ok key true true scope false true ifNotCached com.cj.dbtag.ifNotCached JSP Executes own body if cache is not valid key true true scope false true clearCache com.cj.dbtag.clearCache empty Clears cache key true true scope false true setCache com.cj.dbtag.setCache empty Describes cache policy key true true scope false true refresh false true setSQL com.cj.dbtag.setSQL JSP Describes SQL string