import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class Kustutus extends HttpServlet {
    public void doPost(HttpServletRequest kysimus, 
                      HttpServletResponse vastus)
    throws IOException, ServletException
    {
      try{
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        Connection cn=DriverManager.getConnection(
           "jdbc:odbc:esimene", "", "");
        PreparedStatement ps=cn.prepareStatement(
          "DELETE FROM laulud_plaadid WHERE id=?"
        );
        String[] vastused=kysimus.getParameterValues("kustutus");
        if(vastused!=null){
         for(int i=0; i<vastused.length; i++){
          ps.setInt(1, Integer.parseInt(vastused[i]));
          ps.executeUpdate();
         }
        }
        cn.close();
        vastus.sendRedirect("LauludPlaadil3");
      }catch(Exception viga){
         viga.printStackTrace(vastus.getWriter());
      }
   }
}