Dynamic View Generation By Fetching Data From MySQL Database

If you run a select query where the number of columns and their data types are unknown, you may generate different numbers of columns and rows from the populated result-set.


Download the required jar file, mysql-connector with revision number and add it to your project library.

package com.ba.test; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; public class TestMain { public static void main(String args[]) { try { Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException e1) { e1.printStackTrace(); } try { Connection connection = DriverManager .getConnection("jdbc:mysql://localhost:3306/dbname", "username", "password"); PreparedStatement pStatement = connection .prepareStatement("select * from userstab"); ResultSet rs = pStatement.executeQuery(); ResultSetMetaData rSetMetaData = rs.getMetaData(); int colCount = rSetMetaData.getColumnCount(); System.out.println("Columns are: "); for (int c = 1; c <= colCount; c++) { System.out.print(" " + rSetMetaData.getColumnName(c)); System.out.print(" " + rSetMetaData.getColumnDisplaySize(c)); System.out.print(" " + rSetMetaData.getColumnTypeName(c)); System.out.println(); } while (rs.next()) { for (int c = 1; c <= colCount; c++) { if (rSetMetaData.getColumnTypeName(c).equalsIgnoreCase( "VARCHAR")) { System.out.print(" " + rs.getString(c)); } else if (rSetMetaData.getColumnTypeName(c) .equalsIgnoreCase("NUMBER")) { System.out.print(" " + rs.getInt(c)); } else { // ...... } } } } catch (SQLException e) { e.printStackTrace(); } } }

Happy Exploring!