java/sql-dk/src/info/globalcode/sql/dk/formatting/ColumnsHeader.java
author František Kučera <franta-hg@frantovo.cz>
Fri, 20 Dec 2013 22:19:10 +0100
branchv_0
changeset 23 d8faf91519a5
parent 22 37fe883f8410
child 37 9e6f8e5d5f98
permissions -rw-r--r--
formatter: ColumnDescriptor
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
22
37fe883f8410 formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     1
/**
37fe883f8410 formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     2
 * SQL-DK
37fe883f8410 formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     3
 * Copyright © 2013 František Kučera (frantovo.cz)
37fe883f8410 formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     4
 *
37fe883f8410 formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     5
 * This program is free software: you can redistribute it and/or modify
37fe883f8410 formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     6
 * it under the terms of the GNU General Public License as published by
37fe883f8410 formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     7
 * the Free Software Foundation, either version 3 of the License, or
37fe883f8410 formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     8
 * (at your option) any later version.
37fe883f8410 formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
     9
 *
37fe883f8410 formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    10
 * This program is distributed in the hope that it will be useful,
37fe883f8410 formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    11
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
37fe883f8410 formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    12
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
37fe883f8410 formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    13
 * GNU General Public License for more details.
37fe883f8410 formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    14
 *
37fe883f8410 formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    15
 * You should have received a copy of the GNU General Public License
37fe883f8410 formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    16
 * along with this program. If not, see <http://www.gnu.org/licenses/>.
37fe883f8410 formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    17
 */
37fe883f8410 formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    18
package info.globalcode.sql.dk.formatting;
37fe883f8410 formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    19
23
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    20
import java.sql.ResultSetMetaData;
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    21
import java.sql.SQLException;
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    22
import java.util.ArrayList;
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    23
import java.util.List;
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    24
22
37fe883f8410 formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    25
/**
37fe883f8410 formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    26
 *
37fe883f8410 formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    27
 * @author Ing. František Kučera (frantovo.cz)
37fe883f8410 formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    28
 */
37fe883f8410 formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    29
public class ColumnsHeader {
37fe883f8410 formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    30
23
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    31
	ResultSetMetaData metaData;
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    32
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    33
	public ColumnsHeader(ResultSetMetaData metaData) {
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    34
		this.metaData = metaData;
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    35
	}
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    36
22
37fe883f8410 formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    37
	public int getColumnCount() {
23
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    38
		try {
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    39
			return metaData.getColumnCount();
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    40
		} catch (SQLException e) {
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    41
			throw new IllegalStateException("Error during getting column count.", e);
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    42
		}
22
37fe883f8410 formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    43
	}
23
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    44
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    45
	public List<ColumnDescriptor> getColumnDescriptors() {
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    46
		try {
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    47
			int count = metaData.getColumnCount();
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    48
			List<ColumnDescriptor> list = new ArrayList<>(count);
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    49
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    50
			for (int i = 1; i <= count; i++) {
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    51
				ColumnDescriptor cd = new ColumnDescriptor();
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    52
				cd.setLabel(metaData.getColumnLabel(i));
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    53
				cd.setName(metaData.getColumnName(i));
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    54
				cd.setType(metaData.getColumnType(i));
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    55
				cd.setTypeName(metaData.getColumnTypeName(i));
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    56
				/** TODO: more properties */
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    57
				list.add(cd);
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    58
			}
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    59
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    60
			return list;
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    61
		} catch (SQLException e) {
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    62
			throw new IllegalStateException("Error during building column descriptors.", e);
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    63
		}
d8faf91519a5 formatter: ColumnDescriptor
František Kučera <franta-hg@frantovo.cz>
parents: 22
diff changeset
    64
	}
22
37fe883f8410 formatter: interface and abstract class
František Kučera <franta-hg@frantovo.cz>
parents:
diff changeset
    65
}