formatter: ColumnDescriptor v_0
authorFrantišek Kučera <franta-hg@frantovo.cz>
Fri, 20 Dec 2013 22:19:10 +0100
branchv_0
changeset 23d8faf91519a5
parent 22 37fe883f8410
child 24 65e3fffae091
formatter: ColumnDescriptor
java/sql-dk/src/info/globalcode/sql/dk/formatting/ColumnDescriptor.java
java/sql-dk/src/info/globalcode/sql/dk/formatting/ColumnsHeader.java
     1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/java/sql-dk/src/info/globalcode/sql/dk/formatting/ColumnDescriptor.java	Fri Dec 20 22:19:10 2013 +0100
     1.3 @@ -0,0 +1,62 @@
     1.4 +/**
     1.5 + * SQL-DK
     1.6 + * Copyright © 2013 František Kučera (frantovo.cz)
     1.7 + *
     1.8 + * This program is free software: you can redistribute it and/or modify
     1.9 + * it under the terms of the GNU General Public License as published by
    1.10 + * the Free Software Foundation, either version 3 of the License, or
    1.11 + * (at your option) any later version.
    1.12 + *
    1.13 + * This program is distributed in the hope that it will be useful,
    1.14 + * but WITHOUT ANY WARRANTY; without even the implied warranty of
    1.15 + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
    1.16 + * GNU General Public License for more details.
    1.17 + *
    1.18 + * You should have received a copy of the GNU General Public License
    1.19 + * along with this program. If not, see <http://www.gnu.org/licenses/>.
    1.20 + */
    1.21 +package info.globalcode.sql.dk.formatting;
    1.22 +
    1.23 +/**
    1.24 + *
    1.25 + * @author Ing. František Kučera (frantovo.cz)
    1.26 + */
    1.27 +public class ColumnDescriptor {
    1.28 +
    1.29 +	private String name;
    1.30 +	private String label;
    1.31 +	private int type;
    1.32 +	private String typeName;
    1.33 +
    1.34 +	public String getName() {
    1.35 +		return name;
    1.36 +	}
    1.37 +
    1.38 +	public void setName(String name) {
    1.39 +		this.name = name;
    1.40 +	}
    1.41 +
    1.42 +	public String getLabel() {
    1.43 +		return label;
    1.44 +	}
    1.45 +
    1.46 +	public void setLabel(String label) {
    1.47 +		this.label = label;
    1.48 +	}
    1.49 +
    1.50 +	public int getType() {
    1.51 +		return type;
    1.52 +	}
    1.53 +
    1.54 +	public void setType(int type) {
    1.55 +		this.type = type;
    1.56 +	}
    1.57 +
    1.58 +	public String getTypeName() {
    1.59 +		return typeName;
    1.60 +	}
    1.61 +
    1.62 +	public void setTypeName(String typeName) {
    1.63 +		this.typeName = typeName;
    1.64 +	}
    1.65 +}
     2.1 --- a/java/sql-dk/src/info/globalcode/sql/dk/formatting/ColumnsHeader.java	Fri Dec 20 22:01:06 2013 +0100
     2.2 +++ b/java/sql-dk/src/info/globalcode/sql/dk/formatting/ColumnsHeader.java	Fri Dec 20 22:19:10 2013 +0100
     2.3 @@ -17,19 +17,49 @@
     2.4   */
     2.5  package info.globalcode.sql.dk.formatting;
     2.6  
     2.7 +import java.sql.ResultSetMetaData;
     2.8 +import java.sql.SQLException;
     2.9 +import java.util.ArrayList;
    2.10 +import java.util.List;
    2.11 +
    2.12  /**
    2.13   *
    2.14   * @author Ing. František Kučera (frantovo.cz)
    2.15   */
    2.16  public class ColumnsHeader {
    2.17  
    2.18 +	ResultSetMetaData metaData;
    2.19 +
    2.20 +	public ColumnsHeader(ResultSetMetaData metaData) {
    2.21 +		this.metaData = metaData;
    2.22 +	}
    2.23 +
    2.24  	public int getColumnCount() {
    2.25 -		/**
    2.26 -		 * TODO: getColumnCount
    2.27 -		 */
    2.28 -		throw new RuntimeException("Not yet implemented");
    2.29 +		try {
    2.30 +			return metaData.getColumnCount();
    2.31 +		} catch (SQLException e) {
    2.32 +			throw new IllegalStateException("Error during getting column count.", e);
    2.33 +		}
    2.34  	}
    2.35 -	/**
    2.36 -	 * TODO: columns descriptor
    2.37 -	 */
    2.38 +
    2.39 +	public List<ColumnDescriptor> getColumnDescriptors() {
    2.40 +		try {
    2.41 +			int count = metaData.getColumnCount();
    2.42 +			List<ColumnDescriptor> list = new ArrayList<>(count);
    2.43 +
    2.44 +			for (int i = 1; i <= count; i++) {
    2.45 +				ColumnDescriptor cd = new ColumnDescriptor();
    2.46 +				cd.setLabel(metaData.getColumnLabel(i));
    2.47 +				cd.setName(metaData.getColumnName(i));
    2.48 +				cd.setType(metaData.getColumnType(i));
    2.49 +				cd.setTypeName(metaData.getColumnTypeName(i));
    2.50 +				/** TODO: more properties */
    2.51 +				list.add(cd);
    2.52 +			}
    2.53 +
    2.54 +			return list;
    2.55 +		} catch (SQLException e) {
    2.56 +			throw new IllegalStateException("Error during building column descriptors.", e);
    2.57 +		}
    2.58 +	}
    2.59  }