JSP RSS JSP RSS

how to convert string values to date and compare them while using an array

Thread Solved

•
•
Join Date: Jul 2008
Posts: 50
Reputation: shijunair is an unknown quantity at this point 
Solved Threads: 0
shijunair shijunair is offline Offline
Junior Poster in Training

how to convert string values to date and compare them while using an array

 
0
  #1
Apr 29th, 2009
hello everyone,
I am stuck with this problem.If anyone could help me, it would be a great favour.
I am working on a leave application.
Here the leaves are been applied by employees and accordingly the leaves are been approved or cancelled.
so the problem is that when i am retrieving values such as from date and to date from another jsp i am using 

String[] leavefrom;
String[] until;

leavefrom=request.getParameterValues("leavefrom");
for(int counter=0; counter < leavefrom.length; counter++) 
{ 

} 

until=request.getParameterValues("until");
for(int counter=0; counter < until.length; counter++) 
{ 

}

so that i get all the values of different employees.but when i am comparing it with the database values i am facing an error such as ,
only the dates which are from 12 to 30/31 .rest all the dates from 1 to 11 are not been updated in the database.i am just giving the code where the problem exists.I know how to do the connectivity and everything is working fine except for this one.

 ps=con.prepareStatement("update emp_leave_application set status='"+approved[counter]+"' where approver='"+username+"' and  m_emp_no='"+userid[counter]+"' and leave_type='"+leavetype[counter]+"'and from_date=? and to_date=?");
ps.setString(1,leavefrom[counter]);
ps.setString(2,until[counter]);

ps.executeUpdate();
here i am using ps.setString() wherein, i have to use ps.setDate() instead to compare it with the database, but how to write it when i am using an array .It is giving me an error saying that cant convert string to date.
Pls help me

Thanks in advance.
Reply With Quote Quick reply to this message  
•
•
Join Date: Dec 2007
Posts: 1,677
Reputation: javaAddict is a name known to all javaAddict is a name known to all javaAddict is a name known to all javaAddict is a name known to all javaAddict is a name known to all javaAddict is a name known to all 
Solved Threads: 226
Featured Poster
javaAddict's Avatar
javaAddict javaAddict is offline Offline
Posting Virtuoso

Re: how to convert string values to date and compare them while using an array

 
1
  #2
Apr 29th, 2009
First of all what type of argument does ps.setDate() have and what type are the to_date, from_date at your database?

Also if you need to convert a String to a Date try this:

JSP Syntax (Toggle Plain Text) 
  1. String sDate = 01/04/2009;  // 1st of April
  2. String format = "dd/MM/yyyy"
  3.  
  4. SimpleDateFormat sdf = new SimpleDateFormat(format);
  5. sdf.setLenient(false);
  6.  
  7. Date date = sdf.parse(sDate);

Check the API for more: SimpleDateFormat
Check out my New Bike at my Public Profile at the "About Me" tab
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2008
Posts: 50
Reputation: shijunair is an unknown quantity at this point 
Solved Threads: 0
shijunair shijunair is offline Offline
Junior Poster in Training

Re: how to convert string values to date and compare them while using an array

 
0
  #3
May 3rd, 2009
•
•
•
•
Originally Posted by javaAddict View Post
First of all what type of argument does ps.setDate() have and what type are the to_date, from_date at your database?

Also if you need to convert a String to a Date try this:

JSP Syntax (Toggle Plain Text) 
  1. String sDate = 01/04/2009;  // 1st of April
  2. String format = "dd/MM/yyyy"
  3.  
  4. SimpleDateFormat sdf = new SimpleDateFormat(format);
  5. sdf.setLenient(false);
  6.  
  7. Date date = sdf.parse(sDate);

Check the API for more: SimpleDateFormat

hi,
Thanks for your reply.
the code which i have written is given above in the previous post
i.e
JSP Syntax (Toggle Plain Text) 
  1. ps.setString(1,leavefrom[counter]);
  2.      ps.setString(2,until[counter]);
leavefrom and until are in String type.
and i am comparing this with the database which is in
JSP Syntax (Toggle Plain Text) 
  1. Date type 
  2. i.e to_date, from_date
and because of this i am facing error while updating i.e some of them are updated and some are not. so i want to use ps.setDate instead of ps.setString to compare it with the database and update all the values properly and i dont know what arguments i should pass in ps.setDate().because i tried using
JSP Syntax (Toggle Plain Text) 
  1. ps.setDate(1,leavefrom[counter]);
  2.      ps.setDate(2,until[counter]);
to compare all the values but getting error because leavefrom and until are in string type.Pls have a look at the whole code which i have sent previously.
If there is a problem to understand the query then pls let me know.I will clarify it.It is very urgent and important for me.
Pls find a solution.
Thanks in advance.
Reply With Quote Quick reply to this message  
•
•
Join Date: Nov 2007
Posts: 10
Reputation: deepalihanand is an unknown quantity at this point 
Solved Threads: 4
deepalihanand deepalihanand is offline Offline
Newbie Poster

Re: how to convert string values to date and compare them while using an array

 
0
  #4
May 4th, 2009
Hello,

Just remember that SimpleDateFormat.parse(String source) returns java.util.Date

and PreparedStatement.setDate(int i, Date d) takes java.sql.Date .
So, while passing the date parameter here, casting is required.

2nd thing keep in mind that while converting a String to Date - take care of format according to your database. Some may take as mm/dd/yyyy or dd/mm/yyyy. So, accordingly pass the parameter to SimpleDateFormat constructor.

Hope it solves your problem. And do let me know.
Reply With Quote Quick reply to this message  
•
•
Join Date: Dec 2007
Posts: 1,677
Reputation: javaAddict is a name known to all javaAddict is a name known to all javaAddict is a name known to all javaAddict is a name known to all javaAddict is a name known to all javaAddict is a name known to all 
Solved Threads: 226
Featured Poster
javaAddict's Avatar
javaAddict javaAddict is offline Offline
Posting Virtuoso

Re: how to convert string values to date and compare them while using an array

 
0
  #5
May 4th, 2009
•
•
•
•
Originally Posted by deepalihanand View Post
2nd thing keep in mind that while converting a String to Date - take care of format according to your database. Some may take as mm/dd/yyyy or dd/mm/yyyy. So, accordingly pass the parameter to SimpleDateFormat constructor.

Hope it solves your problem. And do let me know.
If the column in the DB is declared to be type Date, the format is irrelevant. Because the column will contain Date not a Varchar. The data int the column doesn't have a format nor it needs one because it is type data. You can put data inside it in any way you want as long it is type Date.

Check for these sql functions:
to_date(), to_char()
Check out my New Bike at my Public Profile at the "About Me" tab
Reply With Quote Quick reply to this message  
•
•
Join Date: Nov 2007
Posts: 10
Reputation: deepalihanand is an unknown quantity at this point 
Solved Threads: 4
deepalihanand deepalihanand is offline Offline
Newbie Poster

Re: how to convert string values to date and compare them while using an array

 
0
  #6
May 4th, 2009
•
•
•
•
Originally Posted by javaAddict View Post
If the column in the DB is declared to be type Date, the format is irrelevant. Because the column will contain Date not a Varchar. The data int the column doesn't have a format nor it needs one because it is type data. You can put data inside it in any way you want as long it is type Date.

Check for these sql functions:
to_date(), to_char()
According to me, MS-Access database require format before entering date field for more accuracy. Correct me, if I am wrong. This forum helps me in learning.
Thanks
Last edited by deepalihanand; May 4th, 2009 at 4:07 pm.
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2008
Posts: 50
Reputation: shijunair is an unknown quantity at this point 
Solved Threads: 0
shijunair shijunair is offline Offline
Junior Poster in Training

Re: how to convert string values to date and compare them while using an array

 
0
  #7
May 5th, 2009
hi,
Thanks for the reply.
I do understand that SimpleDateFormat.parse(String source) returns java.util.Date

and PreparedStatement.setDate(int i, Date d) takes java.sql.Date .
but i am using arrays in which a counter is set , so will that make any difference because the error that i am recieving is

•
•
•
•
Error: 500
Internal Servlet Error:

org.apache.jasper.JasperException: Unable to compile class for JSPC:\j2sdkee1.2.1\repository\shiju-f70efc8fa\web\_0005cupdate_0002ejspupdate_jsp_11.java:191: Incompatible type for method. Can't convert java.lang.String to java.sql.Date.
ps.setDate(1,leavefrom[counter]);
^
C:\j2sdkee1.2.1\repository\shiju-f70efc8fa\web\_0005cupdate_0002ejspupdate_jsp_11.java:192: Incompatible type for method. Can't convert java.lang.String to java.sql.Date.
ps.setDate(2,until[counter]);
^
2 errors

at org.apache.jasper.compiler.Compiler.compile(Compiler.java:248)
at org.apache.jasper.runtime.JspLoader$2.run(JspLoader.java:273)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.jasper.runtime.JspLoader.loadJSP(JspLoader.java:270)
at org.apache.jasper.runtime.JspServlet$JspServletWrapper.loadIfNecessary(JspServlet.java:137)
at org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java:148)
at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:247)
at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:352)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)
at org.apache.tomcat.core.ServiceInvocationHandler.method(ServletWrapper.java:626)
at org.apache.tomcat.core.ServletWrapper.handleInvocation(ServletWrapper.java:534)
at org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:378)
at org.apache.tomcat.core.Context.handleRequest(Context.java:644)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:440)
at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:144)
at org.apache.tomcat.service.TcpConnectionThread.run(TcpEndpoint.java:310)
at java.lang.Thread.run(Thread.java:484)
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2008
Posts: 50
Reputation: shijunair is an unknown quantity at this point 
Solved Threads: 0
shijunair shijunair is offline Offline
Junior Poster in Training

Re: how to convert string values to date and compare them while using an array

 
0
  #8
May 5th, 2009
when i am using the code to convert string to sql.Date
Java Syntax (Toggle Plain Text) 
  1. DateFormat df = new SimpleDateFormat("dd/MM/yyyy");
  2. Date d = df.parse(leavefrom);
  3. String dfrom=df.format(d);
  4.  
  5. java.sql.Date dd = new java.sql.Date(d.getTime());
  6.  
  7. Date dt = df.parse(until);
  8. String dto=df.format(dt);
  9.  
  10. java.sql.Date ddt = new java.sql.Date(dt.getTime());

I am facing the error given below because of the array so how should i code to convert it into sql.Date when the string[] is to be converted to sql.Date.Pls suggest me.
Thanks in advance.

•
•
•
•
Error: 500
Internal Servlet Error:

org.apache.jasper.JasperException: Unable to compile class for JSPC:\j2sdkee1.2.1\repository\shiju-f70efc8fa\web\_0005cupdate_0002ejspupdate_jsp_11.java:184: Incompatible type for method. Can't convert java.lang.String[] to java.lang.String.
Date d = df.parse(leavefrom);
^
C:\j2sdkee1.2.1\repository\shiju-f70efc8fa\web\_0005cupdate_0002ejspupdate_jsp_11.java:189: Incompatible type for method. Can't convert java.lang.String[] to java.lang.String.
Date dt = df.parse(until);
^
C:\j2sdkee1.2.1\repository\shiju-f70efc8fa\web\_0005cupdate_0002ejspupdate_jsp_11.java:201: [] can only be applied to arrays. It can't be applied to java.sql.Date.
ps.setDate(1,dd[counter]);
^
C:\j2sdkee1.2.1\repository\shiju-f70efc8fa\web\_0005cupdate_0002ejspupdate_jsp_11.java:202: [] can only be applied to arrays. It can't be applied to java.sql.Date.
ps.setDate(2,ddt[counter]);
^
4 errors

at org.apache.jasper.compiler.Compiler.compile(Compiler.java:248)
at org.apache.jasper.runtime.JspLoader$2.run(JspLoader.java:273)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.jasper.runtime.JspLoader.loadJSP(JspLoader.java:270)
at org.apache.jasper.runtime.JspServlet$JspServletWrapper.loadIfNecessary(JspServlet.java:137)
at org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java:148)
at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:247)
at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:352)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)
at org.apache.tomcat.core.ServiceInvocationHandler.method(ServletWrapper.java:626)
at org.apache.tomcat.core.ServletWrapper.handleInvocation(ServletWrapper.java:534)
at org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:378)
at org.apache.tomcat.core.Context.handleRequest(Context.java:644)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:440)
at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:144)
at org.apache.tomcat.service.TcpConnectionThread.run(TcpEndpoint.java:310)
at java.lang.Thread.run(Thread.java:484)
Last edited by peter_budo; May 5th, 2009 at 4:53 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.
Reply With Quote Quick reply to this message  
•
•
Join Date: Nov 2007
Posts: 10
Reputation: deepalihanand is an unknown quantity at this point 
Solved Threads: 4
deepalihanand deepalihanand is offline Offline
Newbie Poster

Re: how to convert string values to date and compare them while using an array

 
0
  #9
May 5th, 2009
•
•
•
•
Originally Posted by shijunair View Post
when i am using the code to convert string to sql.Date
Java Syntax (Toggle Plain Text) 
  1. DateFormat df = new SimpleDateFormat("dd/MM/yyyy");
  2. Date d = df.parse(leavefrom);
  3. String dfrom=df.format(d);
  4.  
  5. java.sql.Date dd = new java.sql.Date(d.getTime());
  6.  
  7. Date dt = df.parse(until);
  8. String dto=df.format(dt);
  9.  
  10. java.sql.Date ddt = new java.sql.Date(dt.getTime());

I am facing the error given below because of the array so how should i code to convert it into sql.Date when the string[] is to be converted to sql.Date.Pls suggest me.
Thanks in advance.

Error: 500
Internal Servlet Error:

org.apache.jasper.JasperException: Unable to compile class for JSPC:\j2sdkee1.2.1\repository\shiju-f70efc8fa\web\_0005cupdate_0002ejspupdate_jsp_11.java:184: Incompatible type for method. Can't convert java.lang.String[] to java.lang.String.
Date d = df.parse(leavefrom);
^
C:\j2sdkee1.2.1\repository\shiju-f70efc8fa\web\_0005cupdate_0002ejspupdate_jsp_11.java:189: Incompatible type for method. Can't convert java.lang.String[] to java.lang.String.
Date dt = df.parse(until);
^
C:\j2sdkee1.2.1\repository\shiju-f70efc8fa\web\_0005cupdate_0002ejspupdate_jsp_11.java:201: [] can only be applied to arrays. It can't be applied to java.sql.Date.
ps.setDate(1,dd[counter]);
^
C:\j2sdkee1.2.1\repository\shiju-f70efc8fa\web\_0005cupdate_0002ejspupdate_jsp_11.java:202: [] can only be applied to arrays. It can't be applied to java.sql.Date.
ps.setDate(2,ddt[counter]);
^
4 errors

These errors help to understand the problem -

For 1st Error - use Date d = df.parse(leavefrom[counter]);
For 2nd error - use Date dt = df.parse(until[counter]);

and then in last 2 errors why are you using ps.setDate(1,dd[counter])
instead it should be ps.setDate(1,dd);
Last edited by deepalihanand; May 5th, 2009 at 2:23 pm.
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2008
Posts: 50
Reputation: shijunair is an unknown quantity at this point 
Solved Threads: 0
shijunair shijunair is offline Offline
Junior Poster in Training

Re: how to convert string values to date and compare them while using an array

 
0
  #10
May 15th, 2009
Thanks for the reply deepalihanand,
I am very thankful to you that you have solved my query.I wont ever forget your help.
Thanks once again.
Bye take care.
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread has been marked solved.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the JSP Forum
Thread Tools Search this Thread



apache array backbutton combobox comma connection csv database development directorystructure dropdownlist dynamicpagetitles eclipse frames glassfish ie8 imagetodatabse imageupload integer internet java javaee javascript jsf jsp jsppagetitles levels mvc2 mvcmodel2 mysql netbeans network parameters passing ping printinserverinsteadofclient read redirect request.getparameter response seperated servlet servletdopost()readxml sessions software sql ssl state_saving_method stocks sun tomcat tutorial update values video web write
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC