import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class HaldamiseServlet extends HttpServlet
{
    protected void doGet(HttpServletRequest req, HttpServletResponse resp)
        throws ServletException, IOException
    {
        PrintWriter out=resp.getWriter();
       try{
        Class.forName("org.gjt.mm.mysql.Driver");
        Connection cn=DriverManager.getConnection(
           "jdbc:mysql://greeny.cs.tlu.ee/if14_jaagup_a", "if14", "ifikas2014");
        if(req.getParameter("lisamisnupp")!=null){
           PreparedStatement st=cn.prepareStatement(
             "INSERT INTO autod(mark, regnr) VALUES (?, ?)");   
           st.setString(1, req.getParameter("muudetudmark"));
           st.setString(2, req.getParameter("muudetudregnr"));
           st.executeUpdate();
        }
        if(req.getParameter("kustutusregnr")!=null){
           PreparedStatement st=cn.prepareStatement(
             "DELETE FROM autod WHERE regnr=?");   
           st.setString(1, req.getParameter("kustutusregnr"));
           st.executeUpdate();
        }
        if(req.getParameter("muutmisnupp")!=null){
           PreparedStatement st=cn.prepareStatement(
             "UPDATE autod SET mark=? WHERE regnr=?");
           st.setString(1, req.getParameter("muudetudmark"));
           st.setString(2, req.getParameter("muudetudregnr"));
           st.executeUpdate();
           System.out.println("muudab");
        }
        cn.close();
       }catch(Exception ex){
          ex.printStackTrace(out);
       }
       System.out.println("ots");
       resp.sendRedirect("baas3.jsp");
       //Lisage kirjete kustutamise võimalus
    }
}

/*
D:\jetty\webapps\baas\WEB-INF\classes>javac -cp \jetty\lib\servlet-api-3.1.jar;.
 HaldamiseServlet.java
*/