la servlet
import java.io.*; import javax.servlet.*; import javax.servlet.http.*; import java.sql.*; import java.util.*; /** * @version 1.0 * @author */ public class ServletJdbcMVC extends HttpServlet { private Connection dbcon; public void init(ServletConfig config) throws ServletException { super.init(config); // init de la classe parente puis connexion à la base. try { //Déclaration du driver : Class.forName("com.ibm.as400.access.AS400JDBCDriver"); //Url de connexion String dbUrl = "jdbc:as400://AS400/BDVIN1"; //Connexion à la BDD String user = "UUUUUUUU"; String password = "PPPPP"; dbcon = DriverManager.getConnection(dbUrl,user,password); } catch (Exception e) { throw new UnavailableException(e.getMessage()); } } /** * @see javax.servlet.http.HttpServlet#void (javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse) */ public void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { ListePays listP = new ListePays(); listP.setCurseur(new Vector()); try { } /** * @see javax.servlet.http.HttpServlet#void (javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse) */ public void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { // même traitement pour les méthodes Post et Get |