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 }