gmatou/dataupload/PostConfig.java

package com.grundfos.gmatou.dataupload;

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

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

public class PostConfig extends HttpServlet {
        private static final long serialVersionUID = 1L;
       
    public PostConfig() {
        super();
    }

        protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
                
                try
                {
                        String value = request.getParameter("value");
                        Connection conn = DBConnection.getDbConnection();
                        PreparedStatement stmt = conn.prepareStatement("UPDATE config SET modified=now(), value=?");
                        stmt.setString(1, value);
                        stmt.execute();
                } catch (Exception e) {
                        throw new ServletException(e);
                }

                response.sendRedirect("EditConfig");
        }

}
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
7			import javax.servlet.ServletException;
8			import javax.servlet.http.HttpServlet;
9			import javax.servlet.http.HttpServletRequest;
10			import javax.servlet.http.HttpServletResponse;
11
12			public class PostConfig extends HttpServlet {
13			private static final long serialVersionUID = 1L;
14
15			public PostConfig() {
16			super();
17			}
18
19			protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
20
21			try
22			{
23			String value = request.getParameter("value");
24			Connection conn = DBConnection.getDbConnection();
25			PreparedStatement stmt = conn.prepareStatement("UPDATE config SET modified=now(), value=?");
26			stmt.setString(1, value);
27			stmt.execute();
28			} catch (Exception e) {
29			throw new ServletException(e);
30			}
31
32			response.sendRedirect("EditConfig");
33			}
34
35			}