gmatou/dataupload/GetConfig.java

package com.grundfos.gmatou.dataupload;

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

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * Servlet implementation class GetConfig
 */
public class GetConfig extends HttpServlet {
        private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public GetConfig() {
        super();
        // TODO Auto-generated constructor stub
    }

        /**
         * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
         */
        protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

                try
                {
                        Connection conn = DBConnection.getDbConnection();
                        PreparedStatement stmt = conn.prepareStatement("SELECT value FROM config");
                        ResultSet rs = stmt.executeQuery();
                        String data = " -- no config data found --";
                        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			import java.sql.PreparedStatement;
6			import java.sql.ResultSet;
7
8			import javax.servlet.ServletException;
9			import javax.servlet.http.HttpServlet;
10			import javax.servlet.http.HttpServletRequest;
11			import javax.servlet.http.HttpServletResponse;
12
13			/**
14			* Servlet implementation class GetConfig
15			*/
16			public class GetConfig extends HttpServlet {
17			private static final long serialVersionUID = 1L;
18
19			/**
20			* @see HttpServlet#HttpServlet()
21			*/
22			public GetConfig() {
23			super();
24			// TODO Auto-generated constructor stub
25			}
26
27			/**
28			* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
29			*/
30			protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
31
32			try
33			{
34			Connection conn = DBConnection.getDbConnection();
35			PreparedStatement stmt = conn.prepareStatement("SELECT value FROM config");
36			ResultSet rs = stmt.executeQuery();
37			String data = " -- no config data found --";
38			while (rs.next())
39			data = rs.getString(1);
40
41			rs.close();
42			stmt.close();
43			conn.close();
44
45			response.setContentType("text/plain");
46			response.getWriter().print(data);
47
48
49			} catch (Exception e) {
50			throw new ServletException(e);
51			}
52			}
53
54			}