Untitled
plain_text
8 days ago
1.9 kB
1
Indexable
Never
import javax.swing.*; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.util.Vector; public class StudentGUI { public static void main(String[] args) { JFrame frame = new JFrame("Students with Distinction in Data Science"); frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); frame.setSize(600, 400); JTable table = new JTable(fetchStudents()); JScrollPane scrollPane = new JScrollPane(table); frame.add(scrollPane); frame.setVisible(true); } private static Vector < Vector < Object >> fetchStudents() { Vector < Vector < Object >> data = new Vector < > (); String jdbcUrl = "jdbc:mysql://localhost:3306/college"; String username = "your_db_username"; String password = "your_db_password"; try { Class.forName("com.mysql.cj.jdbc.Driver"); Connection connection = DriverManager.getConnection(jdbcUrl, username, password); Statement statement = connection.createStatement(); String sql = "SELECT rollno, Name, Level, Division, Major FROM students " + "WHERE Division = 'Distinction' AND Major = 'Data Science'"; ResultSet resultSet = statement.executeQuery(sql); while (resultSet.next()) { Vector < Object > row = new Vector < > (); row.add(resultSet.getString("rollno")); row.add(resultSet.getString("Name")); row.add(resultSet.getString("Level")); row.add(resultSet.getString("Division")); row.add(resultSet.getString("Major")); data.add(row); } resultSet.close(); statement.close(); connection.close(); } catch (Exception e) { JOptionPane.showMessageDialog(null, "Error fetching data: " + e.getMessage()); } return data; } }