salut je vais te donner un exemple de codes
tu cree un bean exemple "Categorie":
1 2 3 4 5 6 7
| package servlet;
public class Categorie {
public String nom;
public int idcategorie;
} |
tu cree ton bean "acces base de donnees"
exemple de code : ce code donne acces a la base de données de mysql
et transmet les informations dans le bean "Categorie"
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
| package servlet;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Vector;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.PreparedStatement;
import com.mysql.jdbc.Statement;
public class Bdmysql {
public Connection accesbase() throws SQLException
{
try{
Class.forName("com.mysql.jdbc.Driver");
System.out.println("JDBC Load entreprise ok");
}
catch (ClassNotFoundException e1)
{
System.out.println(e1);
}
java.sql.Connection connexion = DriverManager.getConnection("jdbc:mysql://localhost/ecommerce","pseudo","password");
System.out.println("bonne connexion ");
return (Connection) connexion;
}
public ArrayList getCategorie() throws SQLException
{
Categorie categorie =null;
ArrayList<Categorie> list=new ArrayList<Categorie>();
String sql="select idcategorie,nomcategorie from Categorie";
Statement st =(Statement) accesbase().createStatement();
ResultSet re =st.executeQuery(sql);
while (re.next())
{ categorie=new Categorie();
categorie.idcategorie= re.getInt("idcategorie");
categorie.nom=re.getString("nomcategorie");
list.add(categorie);
}
accesbase().close();
re.close();
st.close();
return list;
} |
ta page jsp qui doit afficher les categorie
exemple de code :
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
| <?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.util.* "%>
<jsp:useBean id="bdmysql" scope="application" class="servlet.Bdmysql"/>
<%@ page import="servlet.Categorie" %>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>bienvenue</title>
</head>
<body>
<h2>Les Categorie </h2>
<%
String base= "http://localhost:8080/Salut/Controller";
ArrayList categorie = bdmysql.getCategorie();
Iterator iterator = categorie.iterator();
while(iterator.hasNext())
{
Categorie cat =(Categorie) iterator.next();%>
<p> <a href="<%=base%>?action=souscategorie&categorieid=<%=cat.idcategorie%>"><%=cat.nom %></a></p>
<%} %>
<p> <a href="<%=base %>?action=inscription">Incription</a></p>
</body>
</html> |
voici l'element du code qui te permet d'afficher les categorie sous form de lien :
1 2 3 4 5 6 7 8 9 10 11
| <%
String base= "http://localhost:8080/Salut/Controller";
ArrayList categorie = bdmysql.getCategorie();
Iterator iterator = categorie.iterator();
while(iterator.hasNext())
{
Categorie cat =(Categorie) iterator.next();%>
<p> <a href="<%=base%>?action=souscategorie&categorieid=<%=cat.idcategorie%>"><%=cat.nom %></a></p>
<%} %> |
ce petit bout de code sert a transmettre les information a la servlet et de le dispacher sur une autre page jsp action est un nom que tu cree pour prendre une action ex: souscategorie :
<%=base%>?action=souscategorie&categorieid=<%=cat.idcategorie%>
voici la servlet qui te sert a dispacher sur une autre page jsp avec action.equals("souscategorie");:
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
| package servlet;
import java.io.IOException;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletConfig;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* Servlet implementation class for Servlet: Controller
*
*/
public class Controller extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
/**
*
*/
private static final long serialVersionUID = 1L;
/* (non-Java-doc)
* @see javax.servlet.http.HttpServlet#HttpServlet()
*/
public void init(ServletConfig config) throws ServletException{
ServletContext context =config.getServletContext();
context.setAttribute("base", config.getInitParameter("base"));
Bdmysql mysql =new Bdmysql();
context.setAttribute("mysql",mysql );
super.init(config);
}
public Controller() {
super();
}
/* (non-Java-doc)
* @see javax.servlet.http.HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doPost(request,response);
}
/* (non-Java-doc)
* @see javax.servlet.http.HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
String base ="/com/";
String url =base +"Default.jsp";
String action =request.getParameter("action");
if (action!=null)
{
if(action.equals("souscategorie"))
{
url = base +"Souscategorie.jsp";
RequestDispatcher requestDispatcher =getServletContext().getRequestDispatcher(url);
requestDispatcher.forward(request, response);
return;
}
} |
Partager