Untitled



import java.io.IOException;
import java.io.PrintWriter;

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.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * Servlet implementation class Login
 */
@WebServlet("/Login")
public class Login extends HttpServlet {
    private static final long serialVersionUID = 1L;

    /**
     * @see HttpServlet#HttpServlet()
     */
    public Login() {
        super();
        // TODO Auto-generated constructor stub
    }

    /**
     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        PrintWriter out = response.getWriter();

        out.println("<html>");
        out.println("<body>");
        out.println("<html>");
        out.println("<form name='login' method='post' action='Login'>");
        out.println("<input type='text' name='txtuname' placeholder='Username' />");
        out.println("<input type='text' name='txtpass' placeholder='Password' />");
        out.println("<input type='submit' name='submit' value='submit' />");
        out.println("</form>");

        out.println("</body>");
        out.println("</html>");
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    public void doPost(HttpServletRequest req, HttpServletResponse res)throws IOException, ServletException
    {
        String name , pass;
        name = req.getParameter("txtuname");
        pass = req.getParameter("txtpass");

            res.setContentType("text/html");
            PrintWriter pw = res.getWriter();

        try
        {
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            Connection con = DriverManager.getConnection("jdbc:mysql://mysql.cc.puv.fi/", name, pass);
        }

        catch( ClassNotFoundException e)
        {
            pw.println(" Class not found " +e);
        }

        catch(Exception e)
        {
            pw.println("Insertion Failed !" +e);
        }

        pw.println("Kirjautuminen tietokantaan onnistui! Ohjataan HobbyServlettiin 5 sekunnin kuluttua..");

        res.setHeader("Refresh", "5;url=HobbyServlet");

    }

}