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
   |  
package projet;
 
import java.io.*;
import java.util.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
 
import projet.enseignant.*;
 
public class InscriptionResponsable extends HttpServlet implements Servlet {
	private Vector vect=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 abc = request.getParameter("Matiere");
		if (abc == null){
			abc = request.getParameter("mat");
		}
		final int i=Integer.parseInt(abc);
		try{
			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 );
			st = con.createStatement();
			rs=st.executeQuery(Req);
			while(rs.next()){
				vect.addElement(rs.getInt(1));
			}
 
			while(j<vect.size()){
				int idEtud=Integer.parseInt(String.valueOf(vect.elementAt(j)));
				e.cherch(i,idEtud);
				//e.setCompt(j);
				j++;
				HttpSession session=request.getSession(true);
				session.setAttribute("bean3",e);
				getServletContext().getRequestDispatcher("/note.jsp").forward(request,response);
				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);	
}
} | 
Partager