UNIVERSITY-MANAGEMENT-SYSTEM/Marks.java at main · Pavithran-R-A/UNIVERSITY-MANAGEMENT-SYSTEM · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package university.management.systems;

/**
 *
 * @author R.SHANMUKH
 */
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;

public class Marks extends JFrame{

   JTextArea t1;
   JPanel p1;

   Marks(){}
   Marks(String str){
       setSize(500,600);
       setLayout(new BorderLayout());

       p1 = new JPanel();

       t1 = new JTextArea(50,15);
       JScrollPane jsp = new JScrollPane(t1);
       t1.setFont(new Font("Senserif",Font.ITALIC,18));

       add(p1,"North");

       add(jsp,"Center");

       setLocation(450,200);
       mark(str);
   }

   public void mark(String s){
    try{
           connect c = new connect();

           t1.setText("\tResult of Examination\n\nSubject\n");

           ResultSet rs1 = c.s.executeQuery("select * from subject where rollno="+s);

           if(rs1.next()){
               t1.append("\n\t"+rs1.getString("subject1"));
               t1.append("\n\t"+rs1.getString("subject2"));
               t1.append("\n\t"+rs1.getString("subject3"));
               t1.append("\n\t"+rs1.getString("subject4"));
               t1.append("\n\t"+rs1.getString("subject5"));
               t1.append("\n-----------------------------------------");
               t1.append("\n");
           }

           ResultSet rs2 = c.s.executeQuery("select * from marks where rollno="+s);

           if(rs2.next()){
               t1.append("\nMarks\n\n\t"+rs2.getString("marks1"));
               t1.append("\n\t"+rs2.getString("marks2"));
               t1.append("\n\t"+rs2.getString("marks3"));
               t1.append("\n\t"+rs2.getString("marks4"));
               t1.append("\n\t"+rs2.getString("marks5"));
               t1.append("\n-----------------------------------------");
               t1.append("\n");
           }

       }catch(Exception e){
           e.printStackTrace();
       }
   }

   public static void main(String[] args){
       new Marks().setVisible(true);
   }
}