package com.ntsky.note;

import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import com.ntsky.note.SQLDBOperator;

public class DelNote extends HttpServlet {

    private SQLDBOperator sdbo = null;
    private static final String CONTENT_TYPE = "text/html; charset=GBK";
    //Initialize global variables
    public void init() throws ServletException {
    }
    //Process the HTTP Post request
    public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        response.setContentType(CONTENT_TYPE);
        PrintWriter out = response.getWriter();
        int noteId = Integer.parseInt(request.getParameter("noteId"));
        out.print(noteId);
        if (sdbo==null)
            sdbo = SQLDBOperator.getInstance("Connection");
        String strSql = "delete from guest where noteId=?";
        try{
            sdbo.prepareStatement(strSql);
            sdbo.setInt(1,noteId);
            sdbo.executeUpdate();
            URLServlet.getUrl(response,"default.jsp");
        }
        catch(Exception e){
            System.out.print(e.getMessage());
        }
        finally{
            sdbo.Close();
            out.close();
        }
    }
    //Clean up resources
    public void destroy() {
    }
}