Jquery datepicker works only after a page refresh

Greenhorn

Posts: 22

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi,

I'm writing a program where there is a table to be created when ever there id a date change. But the problem here, first the table gets created on selecting date, But when i start changing the date the table doesn't get created, and there are no errors in the console. Below are my codes.

table.jsp

tableGenerator.js

}

});
});

Controller

import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;

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 org.bean.UserBean;

import com.dao.DataDao;
import com.google.gson.Gson;

@WebServlet("/Controller")
public class Controller extends HttpServlet {
    private static final long serialVersionUID = 1L;

protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        try {
            /* Date Start */
            String startDateStr = request.getParameter("startDate");
            String endDateStr = request.getParameter("endDate");
            System.out.println("Start date got is " + startDateStr + " and end date is " + endDateStr);
            SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
            SimpleDateFormat print = new SimpleDateFormat("yyyy-MM-dd");
            Date startParsedDate = null, endParsedDate = null;
            String startDate = null, endDate = null;
            if (startDateStr != null && !startDateStr.equals("")) {
                startParsedDate = sdf.parse(startDateStr);
                startDate = print.format(startParsedDate);
            }
            if (endDateStr != null && !endDateStr.equals("")) {
                endParsedDate = sdf.parse(endDateStr);
                endDate = print.format(endParsedDate);
            }

System.out.println(startDate + " value and " + endDate);
            /* Date End */
            DataDao dataDao = new DataDao();
            ArrayList<UserBean> list = dataDao.getFrameWork(startDate, endDate);
            String searchList = new Gson().toJson(list);
            response.setContentType("application/json");
            response.setCharacterEncoding("UTF-8");
            response.getWriter().write(searchList);
            System.out.println("servlet Done");
        } catch (Exception e) {
            System.err.println(e.getMessage() + " servlet Errotr");
        }
    }
}

DataDAO.java

package com.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import org.bean.UserBean;

public class DataDao {
    private Connection connection;

public DataDao() throws Exception {
        connection = DBUtility.getConnection();
    }

public ArrayList<UserBean> getFrameWork(String startDate, String endDate) throws SQLException {
        String startDateFromController = startDate;
        String endDateFromController = endDate;
        System.out.println("DAO VAlues are " + startDateFromController + " and " + endDateFromController);
        ArrayList<UserBean> list = new ArrayList<UserBean>();
        PreparedStatement ps = null;
        try {
            String query;

if (!(startDateFromController == null) && endDateFromController == null) {
                System.out.println("first block imvoked");
                query = "select * from StatusTable where convert(date, [Start Time]) >= ?";
                ps = connection.prepareStatement(query);
                ps.setString(1, startDateFromController);
            } else if (startDateFromController == null && !(endDateFromController == null)) {
                System.out.println("end date is " + endDateFromController);
                System.out.println("second");
                query = "select * from StatusTable where convert(date, [Start Time]) <= ?";
                ps = connection.prepareStatement(query);
                ps.setString(1, endDateFromController);
            } else if (startDateFromController == null && endDateFromController == null) {
                System.out.println("Thuird block");
                query = "select * from StatusTable where [Start Time] Is NOT NULL";
                ps = connection.prepareStatement(query);
            } else {
                System.out.println("Forth block");
                query = "select * from StatusTable where convert(date, [Start Time]) between ? and ?";
                ps = connection.prepareStatement(query);
                ps.setString(1, startDate);
                ps.setString(2, endDate);
            }
            ResultSet rs = ps.executeQuery();
            if (!rs.next()) {
                System.out.println("No records found");
            } else {
                do {
                    UserBean userBean = new UserBean();
                    userBean.setCaseNumber(rs.getString("Case Number"));
                    userBean.setCaseOwner(rs.getString("Case Owner"));
                    userBean.setStatus(rs.getString("Status"));
                    userBean.setIssue(rs.getString("Issue"));
                    userBean.setReason(rs.getString("Reason"));
                    userBean.setDateOpened(rs.getString("Date/Time Opened"));
                    userBean.setAge(rs.getInt("Age"));
                    userBean.setFinalStatus(rs.getString("Final Status"));
                    list.add(userBean);
                } while (rs.next());
            }
        } catch (Exception e) {
            System.out.println(e + " DAO Error");
        }
        return list;
    }
}

please let me know how can i do this. I should get the data without refreshing the page. i.e. As soon as i change the date, the changes should be reflecting. When I saw in developer options in Chrome, it is the same JSON response. I mean there is no error or such thing, json data is displayed in the log.

The problems come up only there is a change in date. The data doesn't get displayed, But the data is reflected in Console.

Thanks,
Marsoni

Morning came much too soon and it brought along a friend named Margarita Hangover, and a tiny ad.

Clean our rivers and oceans from home

https://www.kickstarter.com/projects/paulwheaton/willow-feeders