gmatou/dataupload/ViewFile.java

package com.grundfos.gmatou.dataupload;

import java.io.IOException;
import java.sql.Connection;

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


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

    public ViewFile() {
        super();
    }

        protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
                String strId = request.getParameter("id");
                
                int id = Integer.parseInt(strId);

                try
                {
                        Connection conn = DBConnection.getDbConnection();
                        PreparedStatement stmt = conn.prepareStatement("SELECT data FROM dataentries WHERE ID = ?");
                        stmt.setInt(1, id);
                        ResultSet rs = stmt.executeQuery();
                        String data = " -- no data found with id=" + id;
                        while (rs.next())
                                data = rs.getString(1);
                        
                        rs.close();
                        stmt.close();
                        conn.close();
                        
                        response.setContentType("text/plain");
                        response.getWriter().print(data);
                        
                        
                } catch (Exception e) {
                        throw new ServletException(e);
                }
        }

}
1	torben	593	package com.grundfos.gmatou.dataupload;
2
3			import java.io.IOException;
4			import java.sql.Connection;
5
6			import javax.servlet.ServletException;
7			import javax.servlet.http.HttpServlet;
8			import javax.servlet.http.HttpServletRequest;
9			import javax.servlet.http.HttpServletResponse;
10			import java.sql.*;
11
12
13			public class ViewFile extends HttpServlet {
14			private static final long serialVersionUID = 1L;
15
16
17			public ViewFile() {
18			super();
19			}
20
21			protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
22			String strId = request.getParameter("id");
23
24			int id = Integer.parseInt(strId);
25
26			try
27			{
28			Connection conn = DBConnection.getDbConnection();
29			PreparedStatement stmt = conn.prepareStatement("SELECT data FROM dataentries WHERE ID = ?");
30			stmt.setInt(1, id);
31			ResultSet rs = stmt.executeQuery();
32			String data = " -- no data found with id=" + id;
33			while (rs.next())
34			data = rs.getString(1);
35
36			rs.close();
37			stmt.close();
38			conn.close();
39
40			response.setContentType("text/plain");
41			response.getWriter().print(data);
42
43
44			} catch (Exception e) {
45			throw new ServletException(e);
46			}
47			}
48
49			}