morgand 01/01/30 16:58:08 Added: jdbc/src/org/apache/taglibs/jdbc/resultset GetColumnTag.java Log: removed individual getter methods in favor of getColumn Revision Changes Path 1.1 jakarta-taglibs/jdbc/src/org/apache/taglibs/jdbc/resultset/GetColumnTag.java Index: GetColumnTag.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.sql.Clob; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.Types; import java.sql.SQLException; import java.io.IOException; import java.io.BufferedReader; import java.io.Reader; import javax.servlet.jsp.JspTagException; /** * <p>Gets the value, as a String, of a coulmn in the enclosing * resultset. The column number is set via the "position" attribute. * You can optionally set the value, as a String, to a serlvet attribute * instead of the tag body with the "to" attribute. The scope of the servlet * attribute is specified by the "scope" XML attribute (default = page).</p> * * <p>JSP Tag Lib Descriptor * <pre> * <name>getString</name> * <tagclass>org.apache.taglibs.jdbc.resultset.GetStringTag</tagclass> * <bodycontent>empty</bodycontent> * <info>Gets the value, as a String, of a coulmn in the enclosing * resultset. The column number is set via the "position" attribute. * You can optionally set the value, as a String, to a serlvet attribute * instead of the tag body with the "to" attribute. The scope of the servlet * attribute is specified by the "scope" XML attribute (default = page).</info> * <attribute> * <name>position</name> * <required>true</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> * </pre> * * @author Morgan Delagrange * @see ResultSet */ public class GetColumnTag extends BaseGetterTag { public int doStartTag() throws JspTagException { try { ResultSet rset = getResultSet(); // some complex datatypes, such as clobs, // require special handling ResultSetMetaData meta = getMetaData(); String string = null; switch (meta.getColumnType(_position)) { case (Types.CLOB): try { string = readClob(rset.getClob(_position)); } catch (IOException e) { throw new JspTagException(e.toString()); } catch (SQLException e) { throw new JspTagException(e.toString()); } break; default: string = rset.getString(_position); } // 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 String readClob(Clob clob) throws IOException, SQLException { StringBuffer buffer = new StringBuffer(); Reader reader = clob.getCharacterStream(); BufferedReader buffReader = new BufferedReader(reader); String line = buffReader.readLine(); while (line != null) { buffer.append(line); line = buffReader.readLine(); } buffReader.close(); return buffer.toString(); } }
