ResultSetMetaDataTest.java

import java.sql.*;

public class ResultSetMetaDataTest {
	public static void main(String[] args) {
		try {
			Class.forName("com.mysql.jdbc.Driver");
			String url = "jdbc:mysql://185.44.192.164/book";
			Connection con = DriverManager.getConnection(url, "root", "godoro");

			Statement stmt = con.createStatement();
			ResultSet rs = stmt.executeQuery("select * from Users");
			ResultSetMetaData rsmd = rs.getMetaData();
			System.out.println(rsmd.getColumnCount());
			for (int i = 1; i < rsmd.getColumnCount() + 1; i++) {
				System.out.println(rsmd.getColumnName(i) + " " + rsmd.getColumnTypeName(i));
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}