Database db = DatabaseBuilder.open(new File("access.mdb")); for (Query query : db.getQueries()) { System.out.println(query.getName() + ": " + query.toSQLString()); }
for (Query q : db.getQueries()) { xhtml.startElement("div", "type", "sqlQuery"); String sqlString = "unsupported query type";
private void loadViews() throws SQLException, IOException { List<Query> lq = null; List<Query> procedures = new ArrayList<Query>(); try { lq = dbIO.getQueries(); Iterator<Query> it = lq.iterator(); while (it.hasNext()) { Query q = it.next(); if (!q.getType().equals(Query.Type.SELECT) && !q.getType().equals(Query.Type.UNION) && !q.getType().equals(Query.Type.CROSS_TAB)) { procedures.add(q); it.remove(); } } queryPorting(lq); } catch (Exception e) { this.notLoaded.put("", ""); } loadProcedures(procedures); }
for (Query q : db.getQueries()) { xhtml.startElement("div", "type", "sqlQuery"); xhtml.characters(q.toSQLString());
for (Query q : db.getQueries()) { xhtml.startElement("div", "type", "sqlQuery"); String sqlString = "unsupported query type";