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.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

@WebServlet("/users")
public class UserServlet extends HttpServlet {
    private Connection connection;

    @Override
    public void init() throws ServletException {
        Properties properties=new Properties();

        try {
            properties.load(new FileInputStream(getServletContext().getRealPath("WEB-INF/classes/db.properties")));
            String dbUrl=properties.getProperty("db.url");
            String dbUsername=properties.getProperty("db.username");
            String dbPassword=properties.getProperty("db.password");
            String driverClassName=properties.getProperty("db.driverClassName");
            Class.forName(driverClassName);
            DriverManager.getConnection(dbUrl,dbUsername,dbPassword);

        }catch (IOException |SQLException | ClassNotFoundException e){
            throw new IllegalStateException(e);
        }
    }

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.getServletContext().getRequestDispatcher("/jsp/addUser.jsp").forward(req,resp);
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        String firstName=req.getParameter("first-name");
        String lastName=req.getParameter("last-name");

        try{
            Statement statement=connection.createStatement();
            String sqlinsert="INSERT INTO my_users(first_name, last_name) VALUES ('a','g');";
            System.out.println(sqlinsert);
            statement.execute(sqlinsert);
        } catch (SQLException e){
            throw new IllegalStateException(e);
        }
    }
}