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");
}
}
} |
Partager