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

public class NewClass7 extends JFrame {
	JLabel l1, l2, l3, l4, l5, l6;
	JLabel ll3, ll4, ll5, ll6;
	String name, enroll, sub = "Math", date;
	JPanel jp;
	JButton b;
	final int total = 10;
	int obtained;

	public NewClass7() {
		Container c;
		c = getContentPane();
		setLayout(null);
		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();
			name = rs.getString("sname");
			enroll = rs.getString("enroll");
			//sub = rs.getString("subject");
			date = rs.getString("date");
			obtained = (rs.getInt("q1") +rs.getInt("q2") +rs.getInt("q3") +rs.getInt("q4") +rs.getInt("q5") +
					rs.getInt("q10") +rs.getInt("q9") +rs.getInt("q8") +rs.getInt("q7") +rs.getInt("q6"));
			String s1 = date.substring(0, 2);
			String s2 = date.substring(2, 4);
			String s3 = date.substring(4, 8);
			date = s1 + "/" + s2 + "/" + s3;

			jp = new JPanel();
			l1 = new JLabel("Score obtained");
			l1.setFont(new Font("Ariel", Font.ITALIC, 25));
			l1.setBounds(75, 50, 200, 50);

			l2 = new JLabel(obtained + "/" + total);
			l2.setFont(new Font("Ariel", Font.BOLD, 45));

			if ((obtained * 100) / (total * 10) > 4) {
				l2.setForeground(Color.GREEN);
			} else {
				l2.setForeground(Color.RED);
			}
			l2.setBounds(115, 140, 150, 50);

			l3 = new JLabel("Student Name             :");
			l3.setBounds(40, 270, 130, 25);
			l4 = new JLabel("Enrollment Number   :");
			l4.setBounds(40, 295, 130, 25);
			l5 = new JLabel("Subject                         :");
			l5.setBounds(40, 320, 130, 25);
			l6 = new JLabel("Date                              :");
			l6.setBounds(42, 345, 130, 25);
			ll3 = new JLabel(name);
			ll3.setBounds(200, 270, 130, 25);
			ll4 = new JLabel(enroll);
			ll4.setBounds(200, 295, 130, 25);
			// l3.setBounds(300,400,100,25);
			ll5 = new JLabel(sub);
			ll5.setBounds(200, 320, 130, 25);
			ll6 = new JLabel(date);
			ll6.setBounds(200, 345, 130, 25);

			b = new JButton("OK");
			b.addActionListener(new ActionListener()

			{

				public void actionPerformed(ActionEvent e) {

					menu obj = new menu();
				}
			});
			b.setBounds(110, 415, 100, 30);
			jp.add(b);
			jp.add(l1);
			// jp.add(i1);
			jp.add(l2);
			jp.add(ll3);
			jp.add(l3);
			jp.add(ll4);
			jp.add(l4);
			jp.add(ll5);
			jp.add(l5);
			jp.add(l6);
			jp.add(ll6);
			jp.setLayout(null);
			jp.setSize(350, 500);
			jp.setVisible(true);
			add(jp);
			// add(c);
			setSize(350, 500);

			setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

			setLayout(null);

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

		}
	}
}