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
|
import java.beans.Statement;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.ResultSet;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;
public class AfficherPersonne extends HttpServlet {
Connection con;
DataSource ds;
protected void doGet(HttpServletRequest req, HttpServletResponse rep) throws ServletException, IOException {
try {
con=(Connection) ds.getConnection();
Statement s = con.createStatement();
ResultSet r = s.executeQuery("select * from personne");
PrintWriter out=null;
rep.setContentType("text/html");
out = rep.getWriter();
out.println("<html>");
out.println("<head><title> Test servlet </title></head>");
out.println("<body>");
out.println("Contenu de la table personne <BR>");
out.println("<table>");
out.println("<TR>");
out.println("<TD>Nom</TD>");
out.println("<TD>Prénom</TD>");
out.println("</TR>");
while (r.next()) {
out.println("<TR>");
out.println("<TD>");
out.println(r.getString("nom"));
out.println("</TD>");
out.println("<TD>");
out.println(r.getString("prenom"));
out.println("</TD>");
out.println("</TR>");
}
out.println("</table>");
out.println("</body>");
out.println("</html>");
r.close();
s.close();
con.close();
s = null;
r = null;
} catch (java.sql.SQLException ex) {
System.out.println("Erreur d'exécution de la requête SQL \n"+ex);
}
}
public void init() throws ServletException {
try {
System.out.println("Récupération du contexte");
Context initCtx = new InitialContext();
System.out.println("lookup de env");
Context envCtx = (Context) initCtx.lookup("java:comp/env");
System.out.println("lookup de base_test");
ds=(DataSource) envCtx.lookup("base_test");
//System.out.println("Datasource chargée");
}
catch(Exception er) {
System.out.println("Erreur de chargement du contexte " + er);
}
}
} |
Partager