private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {
        // TODO add your handling code here:
        String b6_1_1 = jTextField18.getText();
        String b6_2_1 = jTextField19.getText();
        String b6_3_1 = jTextField20.getText();
        boolean b6_check = true;
        int b6_1_2 = 0;
        int b6_2_2 = 0;
        int b6_3_2 = 0;
        if (isNumeric(b6_1_1)) {
            b6_1_2 = Integer.parseInt(b6_1_1);
        }
        else {
            b6_check = false;
            JOptionPane.showMessageDialog(this, "'Admission no.' must be integral");
        }
        if (isNumeric(b6_2_1)) {
            b6_2_2 = Integer.parseInt(b6_2_1);
        }
        else {
            b6_check = false;
            JOptionPane.showMessageDialog(this, "'Year' must be integral");
        }
        if (isNumeric(b6_3_1)) {
            b6_3_2 = Integer.parseInt(b6_3_1);
        }
        else {
            b6_check = false;
            JOptionPane.showMessageDialog(this, "'Term' must be integral");
        }
        if (b6_check)
        {
            try {
                Class.forName("java.sql.DriverManager");
                Connection c6 = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/project", "informatics", "IPProject");
                Statement s6 = (Statement) c6.createStatement();
                String q6_s = "SELECT subject, score, maximum_marks ";
                String q6_f = "FROM marks, examinations ";
                String q6_w1 = "WHERE (admission_number = " + b6_1_2 + " AND marks.examination_id = examinations.examination_id ";
                String q6_w2 = "AND year = " + b6_2_2 + " AND term = " + b6_3_2 + " );";
                ResultSet r6_1 = s6.executeQuery(q6_s + q6_f + q6_w1 + q6_w2);
                String output = "";
                ResultSet r6_2 = s6.executeQuery("SELECT * FROM students WHERE admission_number = " + b6_1_2);
                //Adding Name
                output = output + "Name : " + r6_2.getString("name") + "\n";
                //Adding Roll number
                output = output + "Roll no. : " + r6_2.getString("roll_number") + "\n";
                //Adding Class and Section
                output = output + "Class :" + r6_2.getString("class") + " Section :" + r6_2.getString("section") + "\n";
                while (r6_1.next()) {
                    String r6_s = r6_1.getString("subject");
                    String r6_m = r6_1.getString("score");
                    String r6_mm = r6_1.getString("maximum_marks");
                    output = output + r6_s + " : " + r6_m + "/" + r6_mm + "\n";
                }
                JOptionPane.showMessageDialog (this, output);
                clear6();
            }
            catch (Exception e6) {
                JOptionPane.showMessageDialog(this, e6.getMessage());
            }
        }
    }