I want to get the difference of date/time captured in mysql and present date/time in jsp.
I am using the following code to get, but its getting difference only in hrs, i used split strings in jsp for that, can u please help me in this code, i have to get difference in min and sec also.
Expand|Select|Wrap|Line Numbers
- <%@ page import="java.sql.*,java.text.SimpleDateFormat" %>
- <%! int x; %>
- <%
- String EmployeeId;// = request.getParameter("EmployeeId");
- EmployeeId = session.getAttribute("ssnEmployeeId").toString();
- x = 0;
- Class.forName("com.mysql.jdbc.Driver").newInstance();
- Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/aams","root","root");
- Statement st = conn.createStatement();
- ResultSet rs = st.executeQuery("select employeename from admin where employeeid='"+EmployeeId+"' and flag = 0");
- if(rs.next()){
- //String employeeid=(String) session.getAttribute("employeeid");
- //if(employeeid.equals(employeeid) == true ){
- // session.setAttribute("employeeid",employeeid);
- //System.out.println("Reached");
- rs = st.executeQuery("select intime from admin where employeeid = '"+ EmployeeId+ "' and flag = 0 ");
- rs.next();
- java.util.Date now = new java.util.Date();
- String DATE_FORMAT = "dd-hh";
- SimpleDateFormat sdf = new SimpleDateFormat(DATE_FORMAT);
- String strDateNew = sdf.format(now) ;
- String s3 = rs.getString(1);
- String [] temp = null;
- temp = s3.split("-");
- String strDate = temp[2], strTime = temp[3];
- //System.err.println("Reached");
- s3 = strDateNew;
- temp = null;
- temp = s3.split("-");
- int curtime, oldtime;
- curtime = Integer.parseInt(temp[1]);
- oldtime = Integer.parseInt(strTime);
- System.out.println("Current Time" + curtime);
- System.out.println("Old Time" + oldtime);
- System.out.println("Current Date" + strDate);
- if(curtime<oldtime)
- {
- curtime=curtime+12;
- }
- int diff = curtime - oldtime;
- if(strDate.equals(temp[0]) == false || diff >=8)
- {
- %>
- <jsp:forward page="checkout.jsp" />
- <%
- }
- else{
- int total=diff;
- diff = 8-diff;
- session.setAttribute("ssnTimeDifference", diff);
- session.setAttribute("totaltime", total);
- response.sendRedirect("warning.jsp");
- }
- }
- else{
- %>
- <jsp:forward page="CheckIn.jsp" />
- <%
- }
- %>