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
143
|
package projet;
import java.io.*;
import java.util.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import projet.*;
import projet.enseignant.*;
public class InscriptionResponsable extends HttpServlet implements Servlet {
private Vector v=new Vector();
int j=0;
private Connection con;
private Statement st;
public ResultSet rs;
int []tb={10,10,10,10,10,50,50};
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
//String var0 = request.getParameter("Matiere");
//if (var0 == null){
//var0 = "3";
//}
//final int i=Integer.parseInt(var0);
final int i=3;
System.out.print(i);
try{
//i=Integer.parseInt(var0);
Etudiant e = new Etudiant();
String Req= "SELECT Etudiant.IdEtudiant, Etudiant.Nom, Etudiant.Prenom, Inscription.IdMatiere "+
"FROM Etudiant JOIN "+
"Inscription on Etudiant.IdEtudiant= Inscription.IdEtudiant "+
"WHERE Inscription.IdMatiere='"+ i +"' "+
"AND Inscription.Annee='"+ "2007/2008" +"' ";
String url = "jdbc:odbc:li";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection(url, "sa", "adminadmin");
st = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE );
rs=st.executeQuery(Req);
while(rs.next()){
v.addElement(rs.getInt(1));
}
//final int cap=v.size();
//final int l=cap-2;
while(j<v.size()){
int idEtud=Integer.parseInt(String.valueOf(v.elementAt(j)));
e.cherch(i, idEtud);
e.setCompt(j);
//int l=cap-2;
j++;
HttpSession session=request.getSession(true);
session.setAttribute("bean3",e);
getServletContext().getRequestDispatcher("/note.jsp").forward(request,response);
//return;
break;
}
}
catch (ClassNotFoundException e) {
response.sendRedirect("http://localhost:8080/test/ClassNotFoundException.html");
}
catch (SQLException a) {
response.sendRedirect("http://localhost:8080/test/SQLException.html");
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
// doGet(request, response);
String v0 = request.getParameter("id");
if (v0 == null){
v0 ="1";
}
int b=Integer.parseInt(v0);
String v1 = request.getParameter("mat");
if (v1 == null){
v1 ="1";
}
int w=Integer.parseInt(v1);
String var0 = request.getParameter("c1");
if (var0 == null){
var0 ="0";
}
v.addElement(var0);
String var1 = request.getParameter("c2");
if (var1 == null){
var1 ="0";
}
v.addElement(var1);
String var2 = request.getParameter("c3");
if (var2 == null){
var2 ="0";
}
v.addElement(var2);
String var3 = request.getParameter("tp");
if (var3 == null){
var3 ="0";
}
v.addElement(var3);
String var4 = request.getParameter("ass");
if (var4 == null){
var4 ="0";
}
v.addElement(var4);
String var5 = request.getParameter("exam");
if (var5 == null){
var5 ="0";
}
v.addElement(var5);
String var6 = request.getParameter("rat");
if (var6 == null){
var6 ="0";
}
v.addElement(var6);
try{
Etudiant e = new Etudiant();
for(int l=1;l<=(v.size()+1);l++){
float nt=(Float.valueOf(String.valueOf(v.elementAt(l)))).floatValue();
int cf=tb[l];
e.note(b,w,l,nt,cf);
}
//break;
//HttpSession session=request.getSession(true);
//session.setAttribute("bean3",e);
//getServletContext().setRequestDispatcher("/note.jsp").forward(request,response);
}
catch (ClassNotFoundException e) {
response.sendRedirect("http://localhost:8080/test/ClassNotFoundException.html");
}
catch (SQLException a) {
response.sendRedirect("http://localhost:8080/test/SQLException.html");
}
}
} |
