private static java.sql.Connection dbConnect(String tinySQLDir)// throws SQLException
{
java.sql.Connection con = null;
java.sql.DatabaseMetaData dbMeta;
java.io.File conPath;
java.io.File[] fileList;
String tableName;
java.sql.ResultSet tables_rs;
conPath = new java.io.File(tinySQLDir);
fileList = conPath.listFiles();
if (fileList == null)
{
java.lang.SystemJ.outJ.println(tinySQLDir + " is not a valid directory.");
return((java.sql.Connection)null);
}
else
{
java.lang.SystemJ.outJ.println("Connecting to " + conPath.getAbsolutePath());
con = java.sql.DriverManager.getConnection("jdbc:dbfFile:" + conPath, "", "");
}
dbMeta = con.getMetaData();
tables_rs = dbMeta.getTables(null, null, null, null);
tableList = new java.util.Vector <Object>();
while (tables_rs.next())
{
tableName = tables_rs.getString("TABLE_NAME");
tableList.addElement(tableName);
}
if (tableList.size() == 0)
{
java.lang.SystemJ.outJ.println("There are no tinySQL tables in this directory.");
}
else
{
java.lang.SystemJ.outJ.println("There are " + tableList.size() + " tinySQL tables"
+ " in this directory.");
}
return(con);
}
public DBFFileDatabaseMetaData(java.sql.Connection connection) :
base(connection)
{
}
