In this lesson, you will learn.
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
There are no reviews yet. Be the first one to write one.
You must be logged in to submit a review.