Untitled

package Servlet;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;


import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class Servlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        // TODO Auto-generated method stub

        String name = req.getParameter("name");
        String lastname = req.getParameter("lastname");
        String cedula = req.getParameter("cedula");

        try {
            InsertClient(name, lastname, cedula);
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

        resp.getWriter().println("<html>");
        resp.getWriter().println("<head>");
        resp.getWriter().println("<title>Cliente agregado!</title>");
        resp.getWriter().println("</head>");
        resp.getWriter().println("<body>");
        resp.getWriter().println("Cliente fue agregado.");
        resp.getWriter().println("</body>");
        resp.getWriter().println("</html>");
    }

    public static void InsertClient(String Name, String Lastname, String Cedula) throws Exception{
        try{
            Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/testdb", "root", "1990");

            PreparedStatement insert = con.prepareStatement("INSERT INTO Cliente(Nombre, Apellido, Cedula) VALUES ('"+Name+"', '"+Lastname+"', '"+Cedula+"')");

            insert.executeUpdate();

        }catch(Exception e){System.out.println(e);}
        finally{System.out.println("Insertion complete.");}


    }

}