Result Set Meta Data

PHOTO EMBED

Fri Nov 15 2024 19:07:47 GMT+0000 (Coordinated Universal Time)

Saved by @login123 

// File: ResultSetMetaDataExample.java
import java.sql.*;

public class ResultSetMetaDataExample {
    public static void main(String[] args) throws ClassNotFoundException {
   
        String jdbcURL = "jdbc:mysql://localhost:3306/jdbcdb"; 
         //String DB_URL = "jdbc:oracle:thin:@localhost:1521:XE";
   
        String username = "";
        String password = "";

       
        String query = "SELECT * FROM employee"; 
//Class.forName("oracle.jdbc.driver.OracleDriver");

        try (Connection connection = DriverManager.getConnection(jdbcURL, username, password);
             Statement statement = connection.createStatement();
             ResultSet resultSet = statement.executeQuery(query)) {

           
            ResultSetMetaData metaData = resultSet.getMetaData();

           
            int columnCount = metaData.getColumnCount();

           
            System.out.println("Table and Column names:");
            for (int i = 1; i <= columnCount; i++) {
                String tableName = metaData.getTableName(i);
                String columnName = metaData.getColumnName(i);
                System.out.print(columnName + " (" + tableName + ") | ");
            }
            System.out.println();

            System.out.println("\nRow data:");
            while (resultSet.next()) {
                for (int i = 1; i <= columnCount; i++) {
                    Object columnValue = resultSet.getObject(i);
                    System.out.print(columnValue + " | ");
                }
                System.out.println(); 
            }

        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}
content_copyCOPY