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

public class delete extends HttpServlet {
	
	Connection con = null;
	PreparedStatement pstmt = null;
	
	public void init() throws ServletException {
		try{
			String url = "jdbc:mysql://localhost/booking";
			Class.forName("com.mysql.jdbc.Driver");
			con = DriverManager.getConnection(url, "josef", "cotaidis");
			pstmt = con.prepareStatement("DELETE FROM roombooking WHERE bid = ?");
		}catch(ClassNotFoundException cnfe){
			log("Couldn't load database driver: " + cnfe.getMessage());
		}catch(SQLException sqle){
			log("SQLException caught: " + sqle.getMessage());
		}
	}
	
	public void destroy(){
		try{
			con.close();
		}catch(SQLException sqle){
			log("SQLException caught: " + sqle.getMessage());
		}
	}
	
	public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
		try{
			//Ta bort bokningen.
			pstmt.setInt(1, Integer.parseInt(req.getParameter("bid")));
			pstmt.executeUpdate();
		}catch(SQLException sqle){
			log("SQLException caught: " + sqle.getMessage());
		}
		//Updatera sidan.
		res.sendRedirect("/booking/servlet/booking" + "?ar="+req.getParameter("ar")+"&manad="+req.getParameter("manad")+"&dag="+req.getParameter("dag"));
	}
}