code in java to retrieve data from database and display them on table

Question

Tuhin Paul · Answer

import javax.swing.*; import javax.swing.table.DefaultTableModel; import java.sql.*; public class DatabaseTableExample { public static void main(String[] args) { // Database credentials String url = "jdbc:mysql://localhost:3306/mydatabase"; String user = "myuser"; String password = "mypassword"; // Table model DefaultTableModel model = new DefaultTableModel(); // Column names model.addColumn("ID"); model.addColumn("Name"); model.addColumn("Email"); // Retrieve data from database try (Connection conn = DriverManager.getConnection(url, user, password); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("SELECT * FROM mytable")) { // Add rows to table model while (rs.next()) { model.addRow(new Object[]{rs.getInt("id"), rs.getString("name"), rs.getString("email")}); } } catch (SQLException e) { System.out.println("Error: " + e.getMessage()); } // Create JTable and display data JTable table = new JTable(model); JScrollPane pane = new JScrollPane(table); JFrame frame = new JFrame("Database Data"); frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); frame.add(pane); frame.pack(); frame.setVisible(true); } } Error handling is minimal in this example. Add proper error handling

Aman Gupta · Answer

Hi Kivutha, To retrieve data from a database and display it in a table in a Java application, you can follow these steps: Set up your environment : Ensure you have the necessary JDBC driver for your database. Create a database connection : Use JDBC to connect to your database. Retrieve data from the database : Execute a SQL query to get the data. Display the data in a table : Use a JTable to display the data in a Swing application. Here is an example that demonstrates these steps: Step 1: Set up your environment Make sure you have the JDBC driver for your database (e.g., mysql-connector-java for MySQL). Step 2: Create a database connection Create a class to handle the database connection and data retrieval. import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class DatabaseConnection { private static final String URL = "jdbc:mysql://localhost:3306/your_database"; private static final String USER = "your_username"; private static final String PASSWORD = "your_password"; public static Connection getConnection() { try { return DriverManager.getConnection(URL, USER, PASSWORD); } catch (Exception e) { e.printStackTrace(); return null; } } public static ResultSet getData() { Connection connection = getConnection(); if (connection != null) { try { Statement statement = connection.createStatement(); return statement.executeQuery("SELECT * FROM your_table"); } catch (Exception e) { e.printStackTrace(); } } return null; } } Step 3: Retrieve data from the database Fetch the data using the DatabaseConnection class. Step 4: Display the data in a table Create a Swing application with a JTable to display the data. import javax.swing.*; import javax.swing.table.DefaultTableModel; import java.awt.*; import java.sql.ResultSet; import java.sql.ResultSetMetaData; public class DataTable extends JFrame { public DataTable() { setTitle("Database Table"); setSize(800, 600); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); setLocationRelativeTo(null); // Create the table model DefaultTableModel tableModel = new DefaultTableModel(); JTable table = new JTable(tableModel); // Fetch data from the database ResultSet resultSet = DatabaseConnection.getData(); if (resultSet != null) { try { ResultSetMetaData metaData = resultSet.getMetaData(); int columnCount = metaData.getColumnCount(); // Add column names to the table model for (int i = 1; i { DataTable dataTable = new DataTable(); dataTable.setVisible(true); }); } } Explanation DatabaseConnection class : This class handles the connection to the database and data retrieval. DataTable class : This class creates a Swing application with a JTable to display the data. JTable and DefaultTableModel : Used to dynamically create and populate the table with data from the database. SwingUtilities.invokeLater : Ensures the UI updates are done on the Event Dispatch Thread. Replace "jdbc:mysql://localhost:3306/your_database" , "your_username" , "your_password" , and "your_table" with your actual database details. This example demonstrates how to connect to a MySQL database, retrieve data, and display it in a JTable. Adjustments might be necessary based on your specific database and requirements. Thanks

code in java to retrieve data from database and display them on table

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)