Untitled

<%@page import="entity.Player"%>
<%@page import="logic.PlayerLogic"%>
<%@page import="java.util.Map"%>
<%@page import="java.util.Arrays"%>
<%@page import="java.util.List"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.text.SimpleDateFormat"%>
<%@page import="java.io.IOException"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>


<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Create Player</title>
        <!-- https://www.w3schools.com/css/css_table.asp -->
        <style>
            table {
                border-collapse: collapse;
                width: auto;
            }
            th,
            td {
                text-align: left;
                padding: 8px;
            }
            tr:nth-child(even) {
                background-color: #f2f2f2;
            }
        </style>


    </head>
    <body>
        <h1 align="center">Create Player</h1>
        <form name="createPlayer" id="createPlayer" method="post" action="CreatePlayer">
            <table align="center" >
                <tr>
                    <td>ID: </td>
                    <td><input type="text" name="id" id="id" size='40' required></td>
                </tr>
                <tr>
                    <td>First Name: </td>
                    <td><input type="text" name="first_name" id="first_name" size='40' required></td>
                </tr>
                <tr>
                    <td>Last Name:</td>
                    <td><input type="text" name="last_name" id="last_name" size='40' required></td>
		</tr>
                <tr>
                    <td>Email Address:</td>
                    <td><input type="text" name="email" id="email" size='40' required>
		</tr>
            </table>
            <div style="text-align: center;">
                <input type="submit" align="center" name="submit" id="submit" value="Submit">
                <pre><%=toStringMap(request.getParameterMap())%></pre>
            </div>


   <%


        try {
            Class.forName("com.mysql.jdbc.Driver");
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/servletDb", "ScoreDB", "8288");
            Statement stmt = conn.createStatement();

            String query = "INSERT INTO player (id, first_name, last_name, joined, email) VALUES (?, ?, ?, ?, ?);";
            PreparedStatement createPlayer = conn.prepareStatement(query);

            String idTemp = request.getParameter("id");
            int id = Integer.valueOf(idTemp);

//            Player player = new Player();
//            java.util.Date joinedDate = player.getJoined();
//            java.sql.Date joined = new java.sql.Date(joinedDate.getDate());

            String joined = "2018-02-21";

            createPlayer.setInt(1, id);
            createPlayer.setString(2, request.getParameter("first_name"));
            createPlayer.setString(3, request.getParameter("last_name"));
            createPlayer.setString(4, joined);
            createPlayer.setString(5, request.getParameter("email"));
            int result = stmt.executeUpdate(query);

            if (result != 0 ) {
                %><h1>Success</h1><%
            }
            else {
                %><h1>Failed</h1><%
            }

            stmt.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        };
    %>


        </form>


    </body>

    <%!
        private String toStringMap(Map<String, String[]> m) {
        StringBuilder builder = new StringBuilder();
        for (String k : m.keySet()) {
            builder.append("Key: ").append(k)
                    .append(", ")
                    .append("Value: ").append(Arrays.toString(m.get(k)))
                    .append(System.lineSeparator());
        }
        return builder.toString();
    }
    %>
</html>