*ma 1ere page
<%@ page language="java" import="java.sql.*" pageEncoding="ISO-8859-1"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>My JSP 'ConnectiondelaBase.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<FORM Method="POST" Action="http://localhost:8080/PFE/resultatRecherche.jsp">
<input name="textRechercheRapide" type="text" style="position:absolute;width:137px;left:40px;top:194px;z-index:12">
<input name="bouttonRechercheRapide" type="submit" value="Recherche" style="position:absolute;left:60px;top:224px;z-index:13">
</FORM>
<%
// javax.servlet.http.HttpSession sess;
Connection con = null;
Statement st = null;
ResultSet rs = null;
String CIN;
boolean bol=false;
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/gestStage","root","");
}
catch(Exception e){
System.out.println(e.getMessage());}
%>
<%!String log;%>
<%
try {
String requete ;
log=request.getParameter("login");
String pass=request.getParameter("passChef");
requete = ("SELECT * FROM chefProjet;");
st = con.createStatement();
rs = st.executeQuery(requete);
while (rs.next()) {
System.out.print("Colonne 1 renvoyée ");
System.out.println(rs.getString(1));
String loginBD=rs.getString(1);
String passBD=rs.getString(7);
if(loginBD.equals(log)&&passBD.equals(pass)) {
bol=true;
break;
}//fin if
}// fin while
if (bol==false)
%>
<H1>password incorecte</H1>
<%}else{%>
<%
HttpSession ses = request.getSession(true);
session.setAttribute("CIN",2656);
%>
<jsp:forward page="espaceChef.jsp"/>
<% }
catch(SQLException s){
System.out.println(s.getMessage());
}
%>
</body>
</html>
*page espaceChef.jsp
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ page language="java" import="java.sql.*" import="javax.servlet.http.*" pageEncoding="ISO-8859-1"%>
<%@page language="java" session="true" %>
<html>
<head>
<title>Untitled</title>
</head>
<body>
<div id="image1" style="position:absolute; overflow:hidden; left:204px; top:143px; width:28px; height:47px; z-index:0"><img src="topmenu_img1.gif" alt="" title="" border=0 width=28 height=47></div>
<div id="image2" style="position:absolute; overflow:hidden; left:18px; top:190px; width:187px; height:85px; z-index:1"><img src="users_feedback_bg.gif" alt="" title="" border=0 width=187 height=85></div>
<div id="image3" style="position:absolute; overflow:hidden; left:18px; top:143px; width:187px; height:47px; z-index:2"><img src="users_feedback_s.gif" alt="" title="" border=0 width=187 height=47></div>
<div id="image4" style="position:absolute; overflow:hidden; left:231px; top:829px; width:536px; height:47px; z-index:3"><img src="botmenu_bg.gif" alt="" title="" border=0 width=536 height=47></div>
<div id="image5" style="position:absolute; overflow:hidden; left:16px; top:829px; width:187px; height:47px; z-index:4"><img src="bot1.gif" alt="" title="" border=0 width=187 height=47></div>
<div id="image6" style="position:absolute; overflow:hidden; left:203px; top:829px; width:28px; height:47px; z-index:5"><img src="bot2.gif" alt="" title="" border=0 width=28 height=47></div>
<div id="image7" style="position:absolute; overflow:hidden; left:231px; top:143px; width:1500px; height:47px; z-index:6"><img src="products_b.gif" alt="" title="" border=0 width=1015 height=47></div>
<div id="image8" style="position:absolute; overflow:hidden; left:17px; top:347px; width:186px; height:25px; z-index:7"><img src="new_releases_s.gif" alt="" title="" border=0 width=186 height=25></div>
<div id="image9" style="position:absolute; overflow:hidden; left:17px; top:372px; width:186px; height:204px; z-index:8"><img src="new_releases_bg.gif" alt="" title="" border=0 width=186 height=204></div>
<div id="shape1" style="position:absolute; overflow:hidden; left:16px; top:879px; width:751px; height:15px; z-index:9"><img border=0 width="100%" height="100%" alt="" src="shapeITQRA.png"></div>
<div id="text5" style="position:absolute; overflow:hidden; left:571px; top:81px; width:192px; height:60px; z-index:10">
<div class="wpmd">
<div><font class="ws11" color="#FFFFFF" face="Tahoma"><B><I></I></B></font></div>
</div></div>
<div id="text7" style="position:absolute; overflow:hidden; left:262px; top:158px; width:497px; height:20px; z-index:11">
<div class="wpmd">
<div><font face="Tahoma"><B><a href="acceuil.jsp" class="style1">ACCEUIL</a></B></font><font color="#333333" face="Tahoma"><B> </B></font><font face="Tahoma"><B><a href="pageChef.jsp" class="style1">CHEF DE PROJET</a></B></font><font color="#333333" face="Tahoma"><B> </B></font><font face="Tahoma"><B><a href="pageEtudiant.jsp" class="style1">ETUDIANT</a></B></font><font color="#333333" face="Tahoma"><B> </B></font><font face="Tahoma"><B><a href="mailto:Y.Morjane@gmail.com" class="style1">CONTACTS</a></B></font></div>
</div></div>
<div id="image10" style="position:absolute; overflow:hidden; left:16px; top:11px; width:1500px; height:145px; z-index:12"><img src="header.JPG" alt="" title="" border=0 width=1230 height=145></div>
<div id="text2" style="position:absolute; overflow:hidden; left:249px; top:238px; width:368px; height:37px; z-index:11">
<div class="wpmd">
<div><font class="ws18">Bonjour Monsieur
//c'est ce que j'ai fait pour récupéré le CIN
<%
String username = (String)session.getAttribute("CIN");
out.print("<b>Welcome " + username + "!</b>");
%>
</font></div>
<div><font class="ws18"><BR></font></div>
</div></div>
<div id="text3" style="position:absolute; overflow:hidden; left:850px; top:230px; width:150px; height:90px; z-index:12">
<div class="wpmd">
<div><font class="ws18"><a href="Profil.jsp">Profil</a></font></div>
</div></div>
<div id="text4" style="position:absolute; overflow:hidden; left:243px; top:326px; width:143px; height:28px; z-index:13">
<div class="wpmd">
<div><font class="ws14"><a href="">*Deposer projet</a></font></div>
</div></div>
<div id="text5" style="position:absolute; overflow:hidden; left:242px; top:359px; width:200px; height:33px; z-index:14">
<div class="wpmd">
<div><font class="ws14">*Projets déposés :</font></div>
</div></div>
</body>
</html>