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


public class GetWFData {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		Connection con = null;
		try {

			Class.forName("com.mysql.jdbc.Driver").newInstance();

			con = DriverManager.getConnection("jdbc:mysql://localhost:3307/sampledb?characterEncoding=UTF-8", "root", "");	


			if(!con.isClosed()){

				System.out.println("Successfully connected to MySQL server...");

				Statement st = con.createStatement();
				ResultSet rs = st.executeQuery("SELECT * FROM shkactivitydata");
				ResultSetMetaData md = rs.getMetaData();
				int col = md.getColumnCount();
				System.out.println("Number of Column : "+ col);
				System.out.println("Columns Name: ");
				for (int i = 1; i <= col; i++){
					String col_name = md.getColumnName(i);
					System.out.println("Column name "+i+" is "+col_name);
				}		        
			}

		} catch (SQLException s){
			System.out.println("SQL statement is not executed!");
			s.printStackTrace();
		}

		catch (Exception e){
			System.out.println("exception block");
			e.printStackTrace();
		}
		finally {

			try {

				if(con != null)

					con.close();

			} catch(SQLException e) {
				System.out.println("exception block in finally");
				e.printStackTrace();
			}

		}

	}

}