Table of contents

JDBC

getting a database connection

String url = "jdbc:[database_brand]://[host][:port]/[database][?key1][=value1][&key2][=value2]"
Connection c = DriverManager.getConnection(url);

reading jdbc result set

public class MyResultSetHandler implements ResultSetHandler<DbqResult> {
    public Object handle(ResultSet rs) throws SQLException {
        ResultSetMetaData meta = rs.getMetaData();
        for (int row = 0; rs.next(); row++) {
            for (int col = 1; col <= meta.getColumnCount(); col++) {
		System.out.println(row + ": " + rs.getObject(col));
            }
        }
	return null;
    }
}

metadata

list database entities

try (Connection c = ds.getConnection()) {
	ResultSet rs = c.getMetaData().getTables(null, c.getSchema(), null, null);

return tables and views only

ResultSet rs = c.getMetaData().getTables(null, c.getSchema(), null, new String[] { "TABLE", "VIEW" });

describe table

try (Connection c = ds.getConnection()) {
	ResultSet rs = c.getMetaData().getColumns(null, c.getSchema(), name, null);