import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class Muutumisleht extends HttpServlet {

    public void doPost(HttpServletRequest kysimus, 
                      HttpServletResponse vastus)
    throws IOException, ServletException
    {
      try{
		  Class.forName("com.mysql.jdbc.Driver").newInstance();
		  Connection cn = DriverManager.getConnection(
					"jdbc:mysql://127.0.0.1/if21", "if21", "ke+88lla");
        PreparedStatement ps=cn.prepareStatement(
          "UPDATE andmetabel SET kirjeldus=?, link=? WHERE id=?"
        );
        ps.setString(1, kysimus.getParameter("kirjeldus"));
        ps.setString(2, kysimus.getParameter("link"));
        ps.setInt(3, Integer.parseInt(kysimus.getParameter("id")));
        ps.executeUpdate();
        cn.close();
        vastus.sendRedirect("Lisamine?sid="+kysimus.getParameter("sid"));
      }catch(Exception viga){
         viga.printStackTrace(vastus.getWriter());
      }
   }
}