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); }