Curriculum
Course: Learn Java Programming
Login

Curriculum

Learn Java Programming

Video lesson

Eclipse IDE: Displaying MySQL Data on Swing JTable in Java

 

In this lesson, you will learn.

  • Displaying MySQL Data on Swing JTable
  • Examples

 

Displaying MySQL Data on Swing JTable in Java

 

Example-1: Fetch and Display Data on JTable From MySQL Table

package fetchdatafrommysql;

import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JFrame;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;

public class FetchDataOnJTable {

	public static void main(String[] args) {
		// Frame setup
		JFrame frame = new JFrame("Employee Data");
		frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		frame.setSize(400, 300);

		// Table model setup
		DefaultTableModel model = new DefaultTableModel();
		model.addColumn("Employee ID");
		model.addColumn("Name");
		model.addColumn("BirthDate");
		model.addColumn("Salary");

		// JTable setup
		JTable table = new JTable(model);
		JScrollPane scrollPane = new JScrollPane(table);
		frame.add(scrollPane);

		// Database connection
		String url = "jdbc:mysql://localhost:3306/jcodebook";
		String username = "root";
		String password = "root";

		try {
			// Load MySQL JDBC driver
			Class.forName("com.mysql.cj.jdbc.Driver");
			// Establish connection
			Connection connection = DriverManager.getConnection
					(url, username, password);
			// Create statement
			Statement statement = connection.createStatement();
			// Execute query
			String query = "SELECT * FROM employees";
			ResultSet resultSet = statement.executeQuery(query);

			// Fetch data and add to table model
			while (resultSet.next()) {
				int id = resultSet.getInt(1);
				String name = resultSet.getString(2);
				Date bdate = resultSet.getDate(3);
				double salary = resultSet.getDouble(4);
				model.addRow(new Object[]{id, name, bdate, salary});
			}

			// Close resources
			resultSet.close();statement.close();connection.close();
		} catch (ClassNotFoundException | SQLException e) {
			e.printStackTrace();
		}

		// Display frame
		frame.setVisible(true);
	}
}

 

Output

 

 


 

End of the lesson….enjoy learning

 

 

Student Ratings and Reviews

 

 

 

There are no reviews yet. Be the first one to write one.

 

 

Submit a Review

 

 

 

Layer 1
Login Categories