<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.io.IOException" %>
<%@page import="java.io.PrintWriter" %>
<%@page import="java.sql.*" %>
<%@page import="javax.servlet.ServletException" %>
<%@page import="javax.servlet.http.HttpServlet" %>
<%@page import="javax.servlet.http.HttpServletRequest" %>
<%@page import="javax.servlet.http.HttpServletResponse" %>
<%
String hint="";
            /*
             * TODO output your page here. You may use following sample code.
             */
             Class.forName("com.mysql.jdbc.Driver");
            String connectionUrl = "jdbc:mysql://localhost/usuarios?" +
                                   "user=root&password=database";
            Connection con = DriverManager.getConnection(connectionUrl);
                       PreparedStatement stmt = null;
            ResultSet rs = null;
            //SQL query command
            String SQL = "INSERT INTO registrados VALUES ('" + Math.random()*999999999 + "','nombre','apellido','direccion','codigo postal','ciudad',0,'email')";
            //String SQL = "UPDATE registrados SET ciudad = \"Monterrey\" WHERE id = \"1\"" ;
            stmt = con.prepareStatement(SQL);
            stmt.executeUpdate();
           String SQL2 = "SELECT * FROM registrados";
           Statement stmt2 = null;
            stmt2 = con.createStatement();
            rs = stmt.executeQuery(SQL2);


        out.println("<tr>");
	out.println("<th>Nombre</th>");
	out.println("<th>Apellido</th>");
	out.println("<th>Dirección</th>");
	out.println("<th>Código Postal</th>");
	out.println("<th>Ciudad</th>");
	out.println("<th>Hijos</th>");
	out.println("<th>Email</th>");
        out.println("</tr>");
            while (rs.next()) {
                out.println("<<tr id=\"" + rs.getString("id") +"\">");
                out.println("<td id=\"nombre-" + rs.getString("id") + "\" class=\"celda\" ondblclick=\"modificar(this)\"" + ">" + rs.getString("nombre") + "</td>");
                out.println("<td id=\"apellido-" + rs.getString("id") + "\" class=\"celda\" ondblclick=\"modificar(this)\"" + ">" + rs.getString("apellido") + "</td>");
                out.println("<td id=\"direccion-" + rs.getString("id") + "\" class=\"celda\" ondblclick=\"modificar(this)\"" + ">" + rs.getString("direccion") + "</td>");
                out.println("<td id=\"codigo-" + rs.getString("id") + "\" class=\"celda\" ondblclick=\"modificar(this)\"" + ">" + rs.getString("codigo") + "</td>");
                out.println("<td id=\"ciudad-" + rs.getString("id") + "\" class=\"celda\" ondblclick=\"modificar(this)\"" + ">" + rs.getString("ciudad") + "</td>");
                out.println("<td id=\"hijos-" + rs.getString("id") + "\" class=\"celda\" ondblclick=\"modificar(this)\"" + ">" + rs.getString("hijos") + "</td>");
                out.println("<td id=\"email-" + rs.getString("id") + "\" class=\"celda\" ondblclick=\"modificar(this)\"" + ">" + rs.getString("email") + "</td>");
                out.println("<td><button type=\"button\" onclick=\"borrar(" + rs.getString("id") + ")\">Borrar</button></td>");
                out.println("</tr>");
            }
            out.println("</table>");


            con.close();
%>