bonjour tous le monddddee
vous allez bien
?
moi non
ma jsp/servlete ne marche pas
c 'est une servlete d'ajout des utilisateur dans la base donne
Code :
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
Insert title here
bonjour admin
ajouter user
[/del]
et voici le code de la servlet
Code Java :
package calcul;
import java.io.*;
import java.util.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class modificationBd extends HttpServlet {
private static final long serialVersionUID = 1L;
public void init(ServletConfig config)
throws ServletException{
super.init(config);
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException,IOException{
PrintWriter out = response.getWriter();
String connectionURL = "jdbc:mysql://localhost/calcul";
Connection connection=null;
String user1="";
String passwrd="";
String typ="";
response.setContentType("text/html");
try {
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection(connectionURL, "root", "");
user1=request.getParameter("user");
passwrd=request.getParameter("pass");
typ=request.getParameter("type");
String sql = "INSERT INTO `utilisateur` (`libelle` ,`nUtilisateur` ,`type` ,`password`)VALUES (`user1`,3,`typ`,`pass`);";
Statement s = connection.createStatement();
s.executeQuery (sql);
}catch(Exception e){
System.out.println("Exception is ;"+e);
}
}
}