hop

package com.corepeat;

import jdk.nashorn.internal.ir.RuntimeNode;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
/**
 * Created by tbuczek on 02.09.16.
 */
@WebServlet("/register")
public class register extends HttpServlet {
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

    }

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // Gathering information from form's inputs in register.jsp
        String username = request.getParameter("name");
        String mail = request.getParameter("email");
        String password = request.getParameter("pass");

        // Setting attribute to remember the name of the user so it can be passed to registered.jsp
        request.setAttribute("registeredUser", username);

        // Writing errors onto the screen as html
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter output = response.getWriter();

        // Connecting to database and updating USER table
        /*try {
            Class.forName("com.mysql.jdbc.driver");
        } catch(ClassNotFoundException e) {
            output.println("Wystąpił błąd - nie znaleziono biblioteki do obsługi MySQL");
        }*/
        try {

            Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/data", "lick", "T2t3t4t5");
            // Checking if there is a connection between server and mysql
            if(conn.isValid(2)) {
                output.println("Połączenie z bazą danych aktywne");
            } else {
                output.println("Nie udało się połączyć z bazą danych");
            }
            Statement sqlState = conn.createStatement();
            String addUser = "INSERT INTO users2 (username, password, email) VALUES ('" + username + "','" + password + "','" + mail + "');";
            sqlState.execute(addUser);


            // Displaying all the users
            /*sqlState.executeQuery("SELECT * FROM users2");
            ResultSet rs = sqlState.getResultSet();
            while(rs.next()) {
                output.println(rs.getString("username"));
                output.println(rs.getString("password"));
                output.println(rs.getString("email"));
            }*/

        } catch(SQLException e) {
            output.println("Wystąpił nieznany błąd");
        }


        // Sending user to 'registered' page
        /*RequestDispatcher rd = request.getRequestDispatcher("registered.jsp");
        rd.forward(request,response);*/
    }

}