package com.grundfos.gmatou.dataupload;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;
import java.util.*;

public class DataViewer extends HttpServlet {
	private static final long serialVersionUID = 1L;
       

    public DataViewer() {
        super();
    }

	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		try {
			
			Connection conn = DBConnection.getDbConnection();
			PreparedStatement stmt = conn.prepareStatement("SELECT id, date, device, length(data) FROM dataentries ORDER BY id" );
			
			ResultSet rs = stmt.executeQuery();
			
			ArrayList<DataBean> beans = new ArrayList<DataBean>();
			while (rs.next())
			{
				DataBean bean = new DataBean();
				bean.setId( rs.getInt(1) );
				bean.setDate( rs.getTimestamp(2));
				bean.setDevice( rs.getString(3));
				bean.setDataSize( rs.getInt(4));
				beans.add(bean);
			}
			
			rs.close();
			stmt.close();
			conn.close();
			
			request.setAttribute("databeans", beans);
			getServletContext().getRequestDispatcher("/dataviewer.jsp").forward(request,response);

		} catch (Exception e) {
			throw new ServletException(e);
		}
	}

}