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 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113
| /*
* ServletConnection.java
*
* Created on 31 mai 2001, 12:42
*/
import java.io.*;
import java.net.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
/**
*
* @author Nissarte
* @version
* Code pour se connecter à une base de données Mysql depuis une servlet java.
*/
public class ServletConnection extends HttpServlet {
/** Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
* @param request servlet request
* @param response servlet response
*/
private Connection con;
private PrintWriter out;
private Statement stmt;
public void init(ServletConfig conf) throws ServletException
{
super.init(conf);
try
{
String NomDriver ="mysql-connector-java-3.1.12-bin.jar";
Class.forName(NomDriver).newInstance();
System.out.println("Chargement du pilote Mysql réussi");
}catch(Exception e)
{
System.err.print("Erreur de chargement du pilote : ");
System.err.println(e.getMessage());
}
try{
con =DriverManager.getConnection ("jdbc:mysql://localhost/mysql/test");
System.out.println("Connection base de donnée réussi");
}catch(SQLException sqle)
{
System.err.print("Erreur connexion base de donnée : ");
System.err.println(sqle.getMessage());
}
}
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
try
{
out = response.getWriter();
out.println("<html><head><title>");
out.println("JDBC Servlet");
out.println("</title></head><body>");
stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM essai");
out.println("<UL>");
while(rs.next())
{
out.println("<LI>" + rs.getString("Nom"));
}
out.println("</UL>");
rs.close();
stmt.close();
}
catch(SQLException e)
{
out.println("Exception SQL");
}
catch(IOException e)
{
}
out.println("</body></html>");
out.close();
}
// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
/** Handles the HTTP <code>GET</code> method.
* @param request servlet request
* @param response servlet response
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/** Handles the HTTP <code>POST</code> method.
* @param request servlet request
* @param response servlet response
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/** Returns a short description of the servlet.
*/
public String getServletInfo() {
return "Short description";
}
// </editor-fold>
} |
Partager