| // Copyright 2004, 2005 The Apache Software Foundation |
| // |
| // Licensed under the Apache License, Version 2.0 (the "License"); |
| // you may not use this file except in compliance with the License. |
| // You may obtain a copy of the License at |
| // |
| // http://www.apache.org/licenses/LICENSE-2.0 |
| // |
| // Unless required by applicable law or agreed to in writing, software |
| // distributed under the License is distributed on an "AS IS" BASIS, |
| // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
| // See the License for the specific language governing permissions and |
| // limitations under the License. |
| |
| package org.apache.tapestry.contrib.table.model.sql; |
| |
| import java.sql.ResultSet; |
| import java.sql.SQLException; |
| |
| import org.apache.commons.logging.Log; |
| import org.apache.commons.logging.LogFactory; |
| import org.apache.tapestry.contrib.table.model.simple.SimpleTableColumn; |
| |
| /** |
| * @author mindbridge |
| */ |
| public class SqlTableColumn extends SimpleTableColumn |
| { |
| |
| private static final long serialVersionUID = 1L; |
| private static final Log LOG = LogFactory.getLog(SqlTableColumn.class); |
| |
| /** |
| * Creates an SqlTableColumn. |
| * |
| * @param strSqlField |
| * the identifying name of the column and the SQL field it refers |
| * to |
| * @param strDisplayName |
| * the display name of the column |
| */ |
| public SqlTableColumn(String strSqlField, String strDisplayName) |
| { |
| super(strSqlField, strDisplayName); |
| } |
| |
| /** |
| * Creates an SqlTableColumn. |
| * |
| * @param strSqlField |
| * the identifying name of the column and the SQL field it refers |
| * to |
| * @param strDisplayName |
| * the display name of the column |
| * @param bSortable |
| * whether the column is sortable |
| */ |
| public SqlTableColumn(String strSqlField, String strDisplayName, |
| boolean bSortable) |
| { |
| super(strSqlField, strDisplayName, bSortable); |
| } |
| |
| /** |
| * @see org.apache.tapestry.contrib.table.model.simple.SimpleTableColumn#getColumnValue(Object) |
| */ |
| public Object getColumnValue(Object objRow) |
| { |
| try |
| { |
| ResultSet objRS = (ResultSet) objRow; |
| String strColumnName = getColumnName(); |
| Object objValue = objRS.getObject(strColumnName); |
| if (objValue == null) objValue = ""; |
| return objValue; |
| } |
| catch (SQLException e) |
| { |
| LOG.error("Cannot get the value for column: " + getColumnName(), e); |
| return ""; |
| } |
| } |
| |
| } |