morgand 01/02/08 17:12:12 Added: jdbc/src/org/apache/taglibs/jdbc/resultset GetNumberTag.java Log: getter tag for any SQL number Revision Changes Path 1.1 jakarta-taglibs/jdbc/src/org/apache/taglibs/jdbc/resultset/GetNumberTag.java Index: GetNumberTag.java =================================================================== /* * * ==================================================================== * * The Apache Software License, Version 1.1 * * Copyright (c) 1999 The Apache Software Foundation. All rights * reserved. * * Redistribution and use in source and binary forms, with or without * modification, are permitted provided that the following conditions * are met: * * 1. Redistributions of source code must retain the above copyright * notice, this list of conditions and the following disclaimer. * * 2. Redistributions in binary form must reproduce the above copyright * notice, this list of conditions and the following disclaimer in * the documentation and/or other materials provided with the * distribution. * * 3. The end-user documentation included with the redistribution, if * any, must include the following acknowlegement: * "This product includes software developed by the * Apache Software Foundation (http://www.apache.org/)." * Alternately, this acknowlegement may appear in the software itself, * if and wherever such third-party acknowlegements normally appear. * * 4. The names "The Jakarta Project", "Tomcat", and "Apache Software * Foundation" must not be used to endorse or promote products derived * from this software without prior written permission. For written * permission, please contact [EMAIL PROTECTED] * * 5. Products derived from this software may not be called "Apache" * nor may "Apache" appear in their names without prior written * permission of the Apache Group. * * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE * DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR * ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF * SUCH DAMAGE. * ==================================================================== * * This software consists of voluntary contributions made by many * individuals on behalf of the Apache Software Foundation. For more * information on the Apache Software Foundation, please see * <http://www.apache.org/>. * */ package org.apache.taglibs.jdbc.resultset; import java.io.IOException; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.Types; import java.sql.SQLException; import java.text.DecimalFormat; import java.text.NumberFormat; import java.util.Locale; import javax.servlet.jsp.JspTagException; /** * Translates any SQL number to a readable String. * * <p>JSP Tag Lib Descriptor * <pre> * <tag> * <name>getNumber</name> * <tagclass>org.apache.taglibs.jdbc.resultset.GetNumberTag</tagclass> * <teiclass>org.apache.taglibs.jdbc.resultset.BaseGetterTEI</teiclass> * <bodycontent>empty</bodycontent> * <info> * Similar to getColumn, but provides more precise control over * number formatting. * * The "format" attribute can be either a pattern as * accepted by the DecimalFormat constructor or a style: "CURRENCY", * "PERCENT" or "NUMBER". * * The "locale" attribute can have one to three * components as accepted by the Locale constructor: language, * country and variant. They are separated by "_". * * If neither the format nor locale attribute is set, output should be * identical to getColumn. * </info> * <attribute> * <name>position</name> * <required>false</required> * <rtexprvalue>false</rtexprvalue> * </attribute> * <attribute> * <name>colName</name> * <required>false</required> * <rtexprvalue>false</rtexprvalue> * </attribute> * <attribute> * <name>to</name> * <required>false</required> * <rtexprvalue>false</rtexprvalue> * </attribute> * <attribute> * <name>scope</name> * <required>false</required> * <rtexprvalue>false</rtexprvalue> * </attribute> * <attribute> * <name>locale</name> * <required>false</required> * <rtexprvalue>true</rtexprvalue> * </attribute> * <attribute> * <name>format</name> * <required>false</required> * <rtexprvalue>true</rtexprvalue> * </attribute> * </tag> * </pre> * * @author Morgan Delagrange * @author Marius Scurtescu */ public class GetNumberTag extends BaseGetterTag { protected String _format = null; public void setFormat (String strFormat) { _format = strFormat; } public int doStartTag() throws JspTagException { try { ResultSet rset = getResultSet(); // some complex datatypes, such as clobs, // require special handling ResultSetMetaData meta = getMetaData(); int position = getPosition(); String string = null; switch (meta.getColumnType(position)) { case Types.REAL: case Types.FLOAT: case Types.DOUBLE: { double d = rset.getDouble (position); if (rset.wasNull() == false) { if (_format == null) { string = Double.toString (d); } else { NumberFormat fmt = getNumberFormat (_format, getLocale (_locale)); string = fmt.format (d); } } break; } case Types.TINYINT: case Types.SMALLINT: case Types.INTEGER: case Types.BIGINT: { long l = rset.getLong (position); if (rset.wasNull() == false) { if (_format == null) { string = Long.toString (l); } else { NumberFormat fmt = getNumberFormat (_format, getLocale (_locale)); string = fmt.format (l); } } break; } default: throw new JspTagException("Column is not a recognized number type"); } // null results are often OK, in outer joins for example if (string == null) { return EVAL_BODY_INCLUDE; } if (_attributeName != null) { setAttribute(_attributeName, string, _scope); } else { pageContext.getOut().write(string); } } catch (SQLException e) { throw new JspTagException(e.toString()); } catch (IOException e) { throw new JspTagException(e.toString()); } return EVAL_BODY_INCLUDE; } private static NumberFormat getNumberFormat (String strFormat, Locale loc) { NumberFormat fmt; if (strFormat.equals ("CURRENCY")) fmt = NumberFormat.getCurrencyInstance (loc); else if (strFormat.equals ("PERCENT")) fmt = NumberFormat.getPercentInstance (loc); else if (strFormat.equals ("NUMBER")) fmt = NumberFormat.getPercentInstance (loc); else fmt = new DecimalFormat (strFormat); return fmt; } public void release() { super.release(); _format = null; } }
