Skip to content

Instantly share code, notes, and snippets.

@seysn
Created September 30, 2015 09:41
Show Gist options
  • Save seysn/278ac10e11e4321336bd to your computer and use it in GitHub Desktop.
Save seysn/278ac10e11e4321336bd to your computer and use it in GitHub Desktop.
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.annotation.WebServlet;
import java.sql.*;
@WebServlet("/servlet/Insert")
public class Insert extends HttpServlet {
public void service( HttpServletRequest req, HttpServletResponse res ) throws ServletException, IOException {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:PostgreSQL";
String nom = "";
String mdp = "";
Connection con = DriverManager.getConnection(url,nom,mdp);
Statement stmt = con.createStatement();
stmt.executeUpdate("insert into CLIENTS values(\'" + req.getParameter("NOM") + "\', \'" + req.getParameter("PRENOM") + "\'," + req.getParameter("AGE") + ")" );
con.close();
} catch (Exception e) {
e.printStackTrace();
}
res.sendRedirect("/vide/servlet/Clients");
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment