import java.awt.BorderLayout;
import java.awt.Font;
import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.*;

import javax.swing.table.DefaultTableModel;

public class combinedresult {
	JFrame f;

	combinedresult() {
		try {
			// create a mysql database connection
			String myDriver = "com.mysql.jdbc.Driver";
			String myUrl = "jdbc:mysql://localhost:3307/quiz";
			Class.forName(myDriver);
			Connection conn = DriverManager.getConnection(myUrl, "root", "");
			String query = "select * from student";
			Statement st = conn.createStatement();
			ResultSet rs = st.executeQuery(query);
			rs.first();
			int n = 0;
			String query2 = "select count(*) from student";
			PreparedStatement st2 = conn.prepareStatement(query);
			ResultSet rs2 = st2.executeQuery();
			while (rs.next()) {
				n = rs2.getInt("count(*)"); // number of entries in the table
			}
			int total = 0;
			f = new JFrame("Students marks");
			String sub = "Physics"; // This input has to come from another
									// interface, not going to define it
									// now.

			JPanel jp = new JPanel();
			jp.setSize(400, 200);

			String[] tblHead = { "Name", "Enrollment no.", "Marks" };
			String name[] = new String[n];
			String enroll[] = new String[n];
			int marks[] = new int[n];
			String details[] = new String[n];
			int i = 0;
			while (rs.next()) {
				// entries will be filled from the database here
				name[i] = rs.getString("sname");
				enroll[i] = rs.getString("enroll");
				marks[i] = rs.getInt("corr_incorr");
				i++;
			}
			int k = 0, l = 0;
			for (; k < n - 1; k++) {
				if (enroll[k] == enroll[k + 1])
					total = total + marks[k];
				else {
					details[l] = name[k] + " " + enroll[k] + "/" + total;
					l++;
				}
			}
			String names[] = new String[l];
			String enrollment[] = new String[l];
			String marksFinal[] = new String[l];
			int checker1 = 0;
			for (k = 0; k < l; k++) {
				for (i = 0; i < details[k].length(); i++) {
					if (details[k].charAt(i) == ' ') {
						names[k] = details[k].substring(0, i);
						checker1 = i;
					}
					if (details[k].charAt(i) == '/') {
						enrollment[k] = details[k].substring(checker1, i);
						marksFinal[k] = details[k].substring(i + 1,
								details[k].length());
					}
				}
			}

			DefaultTableModel dtm = new DefaultTableModel(tblHead, 0);
			int p = 0;
			JTable jt = new JTable(dtm);
			for (int j = 0; j < l; j++) {
				dtm.insertRow(p, new Object[] { names[j], enrollment[j],
						marksFinal[j] });
			}

			JScrollPane sp = new JScrollPane(jt);
			JLabel l1 = l1 = new JLabel(
					"                     Subject : " + sub);
			l1.setFont(new Font("Arial", Font.TRUETYPE_FONT, 24));

			jp.add(sp);
			f.getContentPane().setLayout(new BorderLayout());

			f.getContentPane().add(l1, BorderLayout.NORTH);
			// f.getContentPane().add(sp,BorderLayout.CENTER);
			JButton b = new JButton("OK");
			b.addActionListener(new ActionListener()

			{

				public void actionPerformed(ActionEvent e) {

					menu obj = new menu();
				}
			});
			b.setBounds(180, 490, 100, 30);
			f.add(b);

			f.add(jp);
			f.setSize(500, 600);
			f.setVisible(true);
			f.setLayout(new BorderLayout());
			f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		} catch (

		Exception e) {
			System.err.println("Got an exception!");
			System.err.println(e.getMessage());

		}

	}

	public static void main(String[] args) {
		new combinedresult();
	}
}