SQLite
public interface Callback
class TableFmt implements SQLite.Callback {
public void columns(String cols[]) {
System.out.println("<TH><TR>");
for (int i = 0; i < cols.length; i++) {
System.out.println("<TD>" + cols[i] + "</TD>");
}
System.out.println("</TR></TH>");
}
public boolean newrow(String cols[]) {
System.out.println("<TR>");
for (int i = 0; i < cols.length; i++) {
System.out.println("<TD>" + cols[i] + "</TD>");
}
System.out.println("</TR>");
return false;
}
}
...
SQLite.Database db = new SQLite.Database();
db.open("db", 0);
System.out.println("<TABLE>");
db.exec("select * from TEST", new TableFmt());
System.out.println("</TABLE>");
...
| Method Summary | |
|---|---|
| void | columns(String[] coldata)
Reports column names of the query result.
|
| boolean | newrow(String[] rowdata)
Reports row data of the query result.
|
| void | types(String[] types)
Reports type names of the columns of the query result.
|
Parameters: coldata string array holding the column names
Parameters: rowdata string array holding the column values of the row
Parameters: types string array holding column types