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 }