jahanruhi3@gmai 0 Newbie Poster
package com.schedulers;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.util.Date;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import DBConnection.DBConnect;

public class P6UserInsertScheduleServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;

	public P6UserInsertScheduleServlet() {
		super();
	}

	protected void doGet(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {

	}

	@SuppressWarnings("unused")
	protected void doPost(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		Connection conn = null;
		conn = DBConnect.getConnection();
		PreparedStatement st = null;
		String[] checked = request.getParameterValues("primTC");
		String submit = request.getParameter("submit");
		System.out.println("**********");
		System.out.println(submit);
		@SuppressWarnings("unused")
		ResultSet rs = null;
		String ids = null;
		@SuppressWarnings("unused")
		Statement statement = null;
		String s_description = "Schedule_";
		String runDate = null;
		 SimpleDateFormat monthDayYearformatter = new SimpleDateFormat("dd-MM-yyyy hh:mm:ss");
		//SimpleDateFormat monthDayYearformatter = new SimpleDateFormat("DD-MM-YYYY HH:MI:SS");
		Date date = new Date();
		runDate = monthDayYearformatter.format(date);
		System.out.println(runDate);
		String s_tasks = "1,2";
		String s_status = "R";
		String s_userschedule = "y";
		int insertQuery = 0;
		int j = 0;
		try {

			if (submit.equals("Sync")) {

				for (String string : checked) {
					try {
						@SuppressWarnings("unused")
						int id = Integer.parseInt(string);
						statement = conn.createStatement();
						String QueryString = "insert into SCHEDULE(DESCRIPTION,RUN_DATE,TASKS,STATUS,USER_SCHEDULED) values (CONCAT('"+ s_description+ "',(select max(IK)+1 from schedule)),to_date('"+runDate+"','DD-MM-YYYY HH:MI:SS'),'"+ s_tasks+ "','"+ s_status+ "','"+ s_userschedule + "')";
						System.out.print(QueryString);
						st = conn.prepareStatement(QueryString);
						System.out.print(insertQuery);
						st.execute();
						System.out.println(j);
						if (j == 0) {
							ids = string;
						} else {
							ids += "," + string;
						}
						j++;

						System.out.print(ids);
						conn.setAutoCommit(true);
					} catch (Exception e) {
						e.printStackTrace();
					}
				}

				if (!ids.isEmpty()) {
					String QueryString = "UPDATE PROJECT_STAGE SET  ACTIVE = 0 WHERE IK NOT IN ("
							+ ids + ")";
					st = conn.prepareStatement(QueryString);
					st.execute();
				}

			}
			if (submit.equals("Sync Later")) {
				String syncdate = request.getParameter("syncdate");

				for (String string : checked) {
					try {
						int id = Integer.parseInt(string);
						statement = conn.createStatement();
						String QueryString = "insert into SCHEDULE (DESCRIPTION,RUN_DATE,TASKS,STATUS,USER_SCHEDULED) values (CONCAT('"+ s_description+ "',(select max(IK)+1 from schedule)), to_date('"+runDate+"','DD-MM-YYYY HH:MI:SS'),'"+ s_tasks+ "','"+ s_status+ "','"+ s_userschedule + "')";
						System.out.print(QueryString);
						st = conn.prepareStatement(QueryString);
						System.out.print(insertQuery);
						st.execute();
						System.out.println(j);
						if (j == 0) {
							ids = string;
						} else {
							ids += "," + string;
						}
						j++;

						System.out.print(ids);
						conn.setAutoCommit(true);
					} catch (Exception e) {
						e.printStackTrace();
					}
				}

			}

		} catch (SQLException e) {
			e.printStackTrace();
		}
		String forward = "/user/index.jsp";
		RequestDispatcher rd = request.getRequestDispatcher(forward);
		rd.include(request, response);
	}
}
error:


java.lang.NullPointerException
	at java.util.Calendar.setTime(Unknown Source)
	at java.text.SimpleDateFormat.format(Unknown Source)
	at java.text.SimpleDateFormat.format(Unknown Source)
	at java.text.DateFormat.format(Unknown Source)
	at com.schedulers.UserScheduleExe.ScheduleExes(UserScheduleExe.java:30)
	at org.apache.jsp.user.schedule_jsp._jspService(schedule_jsp.java:120)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:369)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:322)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:249)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
	at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
	at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:601)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
	at java.lang.Thread.run(Unknown Source)
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.