import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;

public class JoltMetaData {

	public void metaData() {
		String dataSource = "jdbc:mysql://localhost/test?"
				+ "user=root&password=root";
		Statement stmt = null;
		Connection con = null;
		try {
			con = DriverManager.getConnection(dataSource);
			stmt = con.createStatement();
		} catch (Exception e) {
			System.err.println("problems connecting to " + dataSource);
		}

		try {
			ResultSet result = stmt
					.executeQuery("SELECT programmer, cups FROM JoltData ORDER BY cups DESC;");
			ResultSetMetaData meta = result.getMetaData();

			int numbers = 0;
			int columns = meta.getColumnCount();
			for (int i = 1; i <= columns; i++) {
				System.out.println(meta.getColumnLabel(i) + "\t"
						+ meta.getColumnTypeName(i));
				if (meta.isSigned(i)) { // is it a signed number?
					numbers++;
				}
			}
			System.out.println("Columns: " + columns + " Numeric: " + numbers);
			con.close();

		} catch (Exception e) {
			System.err.println("problems with SQL sent to " + dataSource + ": "
					+ e.getMessage());
		}

	}
}