SAP db User Manual
SAP AG
November 2002
showTableDef (
String tableName)
throws SQLException
{
System.out.println ("Table: " + tableName); //#print
DatabaseMetaData metaData = this.connection.getMetaData ();
ResultSet tableColumns = metaData.getColumns(null,
metaData.getUserName (), tableName, null);
while (tableColumns.next ()) {
String columnName = tableColumns.getString
("COLUMN_NAME");
String typeName = tableColumns.getString ("TYPE_NAME");
int colSize = tableColumns.getInt ("COLUMN_SIZE");
System.out.println (" " + columnName
+ ": " + typeName + " (" + colSize + ")"); //#print
}
}
/**
*
*/
protected void
close ()
{
try {
this.connection.rollback ();
this.connection.close ();
}
catch (SQLException sqlExc) {
// ignore
}
}
/**
*
*/
static protected String
join (
String [] args,
int startIndex)
{
if (startIndex >= args.length) {
return null;
}
StringBuffer result = new StringBuffer ();
for (int i = startIndex; i < args.length; ++i) {
result.append(args [i]);
result.append (' ');
}
return result.toString();
}
/**
* used when called form the command line
*/
public static void main (String [] args)
throws ClassNotFoundException
{
String url = args [0];
String tableName = args [1];
String createCommand = join (args, 2);
TableDef tableDef = null;
try {
tableDef = new TableDef (url);
if (createCommand != null) {
tableDef.createTable (tableName, createCommand);
}
tableDef.showTableDef (tableName);
}
catch (SQLException sqlExc) {
System.out.println (sqlExc);
String tableName)
throws SQLException
{
System.out.println ("Table: " + tableName); //#print
DatabaseMetaData metaData = this.connection.getMetaData ();
ResultSet tableColumns = metaData.getColumns(null,
metaData.getUserName (), tableName, null);
while (tableColumns.next ()) {
String columnName = tableColumns.getString
("COLUMN_NAME");
String typeName = tableColumns.getString ("TYPE_NAME");
int colSize = tableColumns.getInt ("COLUMN_SIZE");
System.out.println (" " + columnName
+ ": " + typeName + " (" + colSize + ")"); //#print
}
}
/**
*
*/
protected void
close ()
{
try {
this.connection.rollback ();
this.connection.close ();
}
catch (SQLException sqlExc) {
// ignore
}
}
/**
*
*/
static protected String
join (
String [] args,
int startIndex)
{
if (startIndex >= args.length) {
return null;
}
StringBuffer result = new StringBuffer ();
for (int i = startIndex; i < args.length; ++i) {
result.append(args [i]);
result.append (' ');
}
return result.toString();
}
/**
* used when called form the command line
*/
public static void main (String [] args)
throws ClassNotFoundException
{
String url = args [0];
String tableName = args [1];
String createCommand = join (args, 2);
TableDef tableDef = null;
try {
tableDef = new TableDef (url);
if (createCommand != null) {
tableDef.createTable (tableName, createCommand);
}
tableDef.showTableDef (tableName);
}
catch (SQLException sqlExc) {
System.out.println (sqlExc);
User Manual: SAP DB
95