import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.servlet.Servlet;
import javax.servlet.ServletConfig;
import javax.servlet.ServletContext;
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 org.json.JSONObject;
import org.json.simple.JSONObject;

import com.mysql.jdbc.Statement;
/**
 * Servlet implementation class Login
 */
@WebServlet("/Login")
public class Login extends HttpServlet {
    private static final long serialVersionUID = 1L;
    private Connection connection;
    /**
     * @see HttpServlet#HttpServlet()
     */
    public Login() {
        super();
        // TODO Auto-generated constructor stub
    }

    public void init(ServletConfig config) throws ServletException {
        ServletContext context = config.getServletContext();
        String url = context.getInitParameter("dbUrl");
        String dbUser = context.getInitParameter("dbUser");
        String dbPassword = context.getInitParameter("dbPassword");
        try {
            Class.forName("com.mysql.jdbc.Driver");
            connection = DriverManager.getConnection(url, dbUser, dbPassword);
        } catch (ClassNotFoundException | SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

    public void destroy() {
        if (connection != null) {
            try {
                connection.close();
            } catch (SQLException e) {
            }
        }
    }
    /**
     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request, response);

    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        response.setContentType("plain/text");

        JSONObject json = new JSONObject();
        PrintWriter out = response.getWriter();
        String usernameV = request.getParameter("usernameV");
        String passwordV = request.getParameter("passwordV");

        json.put("ris", 0);
        try {
            String sql = "SELECT * FROM user WHERE username = ? AND password = ? ";
            PreparedStatement stmt = connection.prepareStatement(sql);
            stmt.setString(1, usernameV);
            stmt.setString(2, passwordV);
            json.put("password", usernameV);
            json.put("username", usernameV);

            out.print(json.toJSONString());
            ResultSet rs = stmt.executeQuery();
            if (rs.next()) {
                json.replace("ris", 1);
                out.print(json.toJSONString());
                stmt.close();
                rs.close();
                return;
            }
            stmt.close();
            rs.close();
        } catch (SQLException e) {
            json.replace("err", e.getMessage());
            out.print(json.toJSONString());

        }


        out.print(json.toJSONString());``
    }

    }