1 package net.sourceforge.backpedal.impl.db;
2
3 import net.sourceforge.backpedal.api.db.MetadataManager;
4 import net.sourceforge.backpedal.api.db.TableMetadata;
5
6 import java.sql.Connection;
7 import java.sql.DatabaseMetaData;
8 import java.sql.ResultSet;
9 import java.sql.SQLException;
10
11 public class MetadataManagerImpl implements MetadataManager {
12 final static String COLUMN_NAME = "COLUMN_NAME";
13 final static String DATA_TYPE = "DATA_TYPE";
14
15 public TableMetadata lookupMetadata(Connection connection, String tableName) throws SQLException {
16 final TableMetadataImpl result = new TableMetadataImpl(tableName);
17 final DatabaseMetaData databaseMetaData = connection.getMetaData();
18 final ResultSet columns = databaseMetaData.getColumns(null,null,tableName,null);
19 while(columns.next()) {
20 result.addColumn(new ColumnMetadataImpl(columns.getString(COLUMN_NAME),columns.getInt(DATA_TYPE)));
21 }
22 return result;
23 }
24 }
This page was automatically generated by Maven