import java.io.*;
import mixer.*;
import java.util.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class info extends HttpServlet{
	String html = null;
	Connection con = null;
	PreparedStatement pqstmt = 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");
			pqstmt = con.prepareStatement("SELECT * FROM roombooking AS r, user AS u WHERE bid = ? AND r.uid = u.uid;");
		}catch(ClassNotFoundException cnfe){
			log("Couldn't load database driver: " + cnfe.getMessage());
		}catch(SQLException sqle){
			log("SQLException caught: " + sqle.getMessage());
		}
		if (html == null) {
			html = Mixer.getContent(new File(getServletContext().getRealPath("/WEB-INF/classes/info.html")));
		}
	}
	
	public String parseNumber(int num){
		String tmp = null;
		if (num < 10)
			tmp = "0" + Integer.toString(num);
		else
			tmp = Integer.toString(num);
		return tmp;
	}
	
	public void doGet(HttpServletRequest req, HttpServletResponse res) throws IOException, ServletException{
		Mixer mix = new Mixer(html);
		res.setContentType("text/html");
		PrintWriter out = res.getWriter();
		try{
			pqstmt.setString(1, req.getParameter("bid"));
			ResultSet rs = pqstmt.executeQuery();
			rs.next();
			//Skriver ut info om bokningen.
			mix.add("===comment===", rs.getString("comment"));
			mix.add("===date===", rs.getTimestamp("sdate").toString().substring(0, 10));
			mix.add("===time===", rs.getTimestamp("sdate").toString().substring(11, 16) + "-" + rs.getTimestamp("edate").toString().subSequence(11, 16));
			mix.add("===room===", rs.getString("room"));
			mix.add("===bookedby===", rs.getString("username"));
		}catch(SQLException sqle){
			log("SQLException caught: " + sqle.getMessage());
		}
		out.println(mix.getMix());
	}
}