import java.sql.Connection;
import javax.sql.DataSource;
import org.apache.commons.dbcp.BasicDataSource;
	private static DataSource getDataSource(){
		String login = "root", pwd = "kne";
		String url = "jdbc:mysql://localhost:3306/test";
		BasicDataSource ds = new BasicDataSource();
		ds.setDriverClassName("com.mysql.jdbc.Driver");
		ds.setUsername(login);
		ds.setPassword(pwd);
		ds.setUrl(url);
		return ds;
	}

	private static Object show(ResultSet rs, String title) throws Exception{
		Object r = null;
		System.out.println("[showing " + title + "]");
		ResultSetMetaData rsmd = rs.getMetaData();
		while(rs.next()){
			for(int c = 1; c <= rsmd.getColumnCount(); c++){
				String name = rsmd.getColumnName(c);
				Object value = rs.getObject(c);
				System.out.println(name + " : " + value);
				if(r == null){
					r = value;
				}
			}
		}
		System.out.println();
		return r;
	}

	public static void main(String[] args) throws Exception{
		DataSource ds = getDataSource();
		Connection con = ds.getConnection();
		DatabaseMetaData dbMetaData = con.getMetaData();
		ResultSet catalogs = dbMetaData.getCatalogs();
		String catalog = (String)show(catalogs, "catalogs");
		ResultSet schemas = dbMetaData.getSchemas();
		String schema = (String)show(schemas, "schemas");
		ResultSet tables = dbMetaData.getTables("test", null, "", null);
		show(tables, "tables");
		System.out.println("ok");
	}