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