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