001    // Copyright 2004, 2005 The Apache Software Foundation
002    //
003    // Licensed under the Apache License, Version 2.0 (the "License");
004    // you may not use this file except in compliance with the License.
005    // You may obtain a copy of the License at
006    //
007    //     http://www.apache.org/licenses/LICENSE-2.0
008    //
009    // Unless required by applicable law or agreed to in writing, software
010    // distributed under the License is distributed on an "AS IS" BASIS,
011    // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
012    // See the License for the specific language governing permissions and
013    // limitations under the License.
014    
015    package org.apache.tapestry.contrib.table.model.sql;
016    
017    import java.sql.ResultSet;
018    import java.sql.SQLException;
019    
020    import org.apache.commons.logging.Log;
021    import org.apache.commons.logging.LogFactory;
022    import org.apache.tapestry.contrib.table.model.simple.SimpleTableColumn;
023    
024    /**
025     * 
026     * @author mindbridge
027     */
028    public class SqlTableColumn extends SimpleTableColumn
029    {
030            private static final long serialVersionUID = 1L;
031            private static final Log LOG = LogFactory.getLog(SqlTableColumn.class);
032    
033            /**
034             * Creates an SqlTableColumn
035             * @param strSqlField the identifying name of the column and the SQL field it refers to
036             * @param strDisplayName the display name of the column
037             */
038            public SqlTableColumn(String strSqlField, String strDisplayName)
039            {
040                    super(strSqlField, strDisplayName);
041            }
042    
043            /**
044             * Creates an SqlTableColumn
045             * @param strSqlField the identifying name of the column and the SQL field it refers to
046             * @param strDisplayName the display name of the column
047             * @param bSortable whether the column is sortable
048             */
049            public SqlTableColumn(
050                    String strSqlField,
051                    String strDisplayName,
052                    boolean bSortable)
053            {
054                    super(strSqlField, strDisplayName, bSortable);
055            }
056    
057            /**
058             * @see org.apache.tapestry.contrib.table.model.simple.SimpleTableColumn#getColumnValue(Object)
059             */
060            public Object getColumnValue(Object objRow)
061            {
062                    try
063                    {
064                            ResultSet objRS = (ResultSet) objRow;
065                String strColumnName = getColumnName();
066                            Object objValue = objRS.getObject(strColumnName);
067                            if (objValue == null)
068                                    objValue = "";
069                            return objValue;
070                    }
071                    catch (SQLException e)
072                    {
073                            LOG.error("Cannot get the value for column: " + getColumnName(), e);
074                            return "";
075                    }
076            }
077    
078    }