gmatou/dataupload/DataViewer.java

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);
                }
        }

}
1	package com.grundfos.gmatou.dataupload;
2
3	import java.io.IOException;
4	import javax.servlet.ServletException;
5	import javax.servlet.http.HttpServlet;
6	import javax.servlet.http.HttpServletRequest;
7	import javax.servlet.http.HttpServletResponse;
8	import java.sql.*;
9	import java.util.*;
10
11	public class DataViewer extends HttpServlet {
12	private static final long serialVersionUID = 1L;
13
14
15	public DataViewer() {
16	super();
17	}
18
19	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
20	try {
21
22	Connection conn = DBConnection.getDbConnection();
23	PreparedStatement stmt = conn.prepareStatement("SELECT id, date, device, length(data) FROM dataentries ORDER BY id" );
24
25	ResultSet rs = stmt.executeQuery();
26
27	ArrayList<DataBean> beans = new ArrayList<DataBean>();
28	while (rs.next())
29	{
30	DataBean bean = new DataBean();
31	bean.setId( rs.getInt(1) );
32	bean.setDate( rs.getTimestamp(2));
33	bean.setDevice( rs.getString(3));
34	bean.setDataSize( rs.getInt(4));
35	beans.add(bean);
36	}
37
38	rs.close();
39	stmt.close();
40	conn.close();
41
42	request.setAttribute("databeans", beans);
43	getServletContext().getRequestDispatcher("/dataviewer.jsp").forward(request,response);
44
45	} catch (Exception e) {
46	throw new ServletException(e);
47	}
48	}
49
50	}