Untitled

mail@pastecode.io avatarunknown
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;
  }
}