import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.DriverManager;
import java.sql.*;
public class NewServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
Connection connection;
Statement statement;
// afficher prénom
out.println("Hello " + request.getParameter("firstName") + "!!\n<BR>");
try {
/* test du chargement du driver */
out.println("\n=> loading driver:");
Class.forName("com.mysql.jdbc.Driver");
out.println("OK");
/* test de la connection */
out.println("\n=> connecting:");
String url = "jdbc:mysql://localhost:3306/";
String user = "test";
String password = "testpassword";
connection = DriverManager.getConnection(url, user, password);
out.println("OK");
Statement stmt = connection.createStatement();
ResultSet resultat = stmt.executeQuery("SELECT * FROM Test_tbl");
while (resultat.next()) {
String nom = resultat.getString("name");
String nom2 = resultat.getString("firstname");
out.println(nom + " " + nom2);
}
out.println("OK");
connection.close();
} catch (ClassNotFoundException e) {
System.err.println("Driver non chargé !");
e.printStackTrace();
} catch (Exception x) {
System.err.println(x);
}
}
}
Partager