source: main/trunk/model-sites-dev/cambridge-museum/collect/waikato-independent/pre-import/EditableDatabaseTable/src/jquery/datatables/controller/UpdateData.java@ 34511

package jquery.datatables.controller;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import jquery.datatables.model.RecordHashmap;
import jquery.datatables.model.DataRepository;

/**
 * Handler for the update cell action
 */
@WebServlet("/UpdateData")
public class UpdateData extends HttpServlet
{
    private static final long serialVersionUID = 1L;

    /**
     * @see HttpServlet#HttpServlet()
     */
    public UpdateData()
    {
    // Nothing special to do for UpdateData servlet at construction time
        super();
    }
    

    /**
     * This servlet handles post request from the JEditable and updates the (database) record entry that was edited
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
    {
    int id = Integer.parseInt(request.getParameter("id"));
    // //int columnId = Integer.parseInt(request.getParameter("columnId"));
    // int columnPosition = Integer.parseInt(request.getParameter("columnPosition"));
    String columnName = request.getParameter("columnName");
    
    //int rowId = Integer.parseInt(request.getParameter("rowId"));
    String value = request.getParameter("value");
    //String columnName = request.getParameter("columnName");
    
    for (RecordHashmap rh: DataRepository.GetRecords()) {
        if (rh.getId() == id) {

        rh.setFieldValue(columnName,value);
        
        /*                  
        switch (columnPosition) {
        case 0:
            rh.setFieldValue("Year",value);
            break;
        case 1:
            rh.setFieldValue("Name",value);
            break;
        case 2:
            rh.setFieldValue("Address",value);
            break;
        default:
            break;
        }
        */
        
        response.getWriter().print(value);
        return;
        }
    }
    response.getWriter().print("Error - database record cannot be found");
    }
    
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
    {
    doPost(request, response);
    }

}