import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
public class cvdelete extends HttpServlet{
public void doGet(HttpServletRequest kysimus, HttpServletResponse vastus)
throws IOException, ServletException{
doPost(kysimus, vastus);
}
public void doPost(HttpServletRequest kysimus, HttpServletResponse vastus)
throws IOException, ServletException{
HttpSession sess=kysimus.getSession();
PrintWriter valja=vastus.getWriter();
vastus.setContentType("text/html");
String kustuta=kysimus.getParameter("kustuta");
if(sess.getAttribute("Kasutaja")==null){
valja.println("\n\nSelle lehe nägemiseks on vaja sisse logida!
\n\n");
}else{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection cn=
DriverManager.getConnection("jdbc:odbc:mycv", "", "");
Statement st=cn.createStatement();
String lause="SELECT id FROM mycv where kasutaja='"+sess.getAttribute("Kasutaja")+"';";
ResultSet rs=st.executeQuery(lause);
rs.next();
String id=rs.getString("id");
String lause2="delete from mycv where id="+id+";";
st.executeUpdate(lause2);
valja.println("\n"+
"\n"+
"myCV delete\n"+
"\n"+
"\n"+
"\n"+
"\n"+
"
CV ja kasutaja on kustutatud!!!
\n"+
"
\n"+
"