-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathStudentServlet.java
More file actions
142 lines (107 loc) · 5.49 KB
/
Copy pathStudentServlet.java
File metadata and controls
142 lines (107 loc) · 5.49 KB
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
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
package codes;
import java.io.IOException;
import java.sql.*;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.*;
@WebServlet("/StudentServlet")
public class StudentServlet extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String action = request.getParameter("action");
System.out.println("Action: " + action);
try {
Connection con = Dbconnection.getConnection();
// ===== ADD =====
if ("add".equals(action)) {
System.out.println("Adding student...");
String name = request.getParameter("name");
String email = request.getParameter("email");
String contact = request.getParameter("contact");
String dob = request.getParameter("dob");
String year = request.getParameter("year");
String prn = request.getParameter("prn");
String department = request.getParameter("department");
int dbms = 0, cn = 0, mp = 0, daa = 0, oe = 0;
try { dbms = Integer.parseInt(request.getParameter("dbms")); } catch(Exception e){}
try { cn = Integer.parseInt(request.getParameter("cn")); } catch(Exception e){}
try { mp = Integer.parseInt(request.getParameter("mp")); } catch(Exception e){}
try { daa = Integer.parseInt(request.getParameter("daa")); } catch(Exception e){}
try { oe = Integer.parseInt(request.getParameter("oe")); } catch(Exception e){}
// ✅ CALCULATE PERCENTAGE
int total = dbms + cn + mp + daa + oe;
double percentage = total / 5.0;
PreparedStatement ps = con.prepareStatement(
"INSERT INTO studentss1(name,email,contact,dob,percentage,year,prn,department,dbms,cn,mp,daa,oe) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?)");
ps.setString(1, name);
ps.setString(2, email);
ps.setString(3, contact);
ps.setString(4, dob);
ps.setDouble(5, percentage);
ps.setString(6, year);
ps.setString(7, prn);
ps.setString(8, department);
ps.setInt(9, dbms);
ps.setInt(10, cn);
ps.setInt(11, mp);
ps.setInt(12, daa);
ps.setInt(13, oe);
int rows = ps.executeUpdate();
System.out.println("Inserted Rows: " + rows);
ps.close();
}
// ===== DELETE =====
else if ("delete".equals(action)) {
int id = Integer.parseInt(request.getParameter("id"));
PreparedStatement ps = con.prepareStatement(
"DELETE FROM studentss1 WHERE id=?");
ps.setInt(1, id);
ps.executeUpdate();
ps.close();
}
// ===== UPDATE =====
else if ("update".equals(action)) {
int id = Integer.parseInt(request.getParameter("id"));
String name = request.getParameter("name");
String email = request.getParameter("email");
String contact = request.getParameter("contact");
String dob = request.getParameter("dob");
String year = request.getParameter("year");
String prn = request.getParameter("prn");
String department = request.getParameter("department");
int dbms = 0, cn = 0, mp = 0, daa = 0, oe = 0;
try { dbms = Integer.parseInt(request.getParameter("dbms")); } catch(Exception e){}
try { cn = Integer.parseInt(request.getParameter("cn")); } catch(Exception e){}
try { mp = Integer.parseInt(request.getParameter("mp")); } catch(Exception e){}
try { daa = Integer.parseInt(request.getParameter("daa")); } catch(Exception e){}
try { oe = Integer.parseInt(request.getParameter("oe")); } catch(Exception e){}
// ✅ CALCULATE PERCENTAGE AGAIN
int total = dbms + cn + mp + daa + oe;
double percentage = total / 5.0;
PreparedStatement ps = con.prepareStatement(
"UPDATE studentss1 SET name=?, email=?, contact=?, dob=?, percentage=?, year=?, prn=?, department=?, dbms=?, cn=?, mp=?, daa=?, oe=? WHERE id=?");
ps.setString(1, name);
ps.setString(2, email);
ps.setString(3, contact);
ps.setString(4, dob);
ps.setDouble(5, percentage);
ps.setString(6, year);
ps.setString(7, prn);
ps.setString(8, department);
ps.setInt(9, dbms);
ps.setInt(10, cn);
ps.setInt(11, mp);
ps.setInt(12, daa);
ps.setInt(13, oe);
ps.setInt(14, id);
int rows = ps.executeUpdate();
System.out.println("Updated Rows: " + rows);
ps.close();
}
con.close();
} catch (Exception e) {
e.printStackTrace();
}
response.sendRedirect("dashboard.jsp");
}
}