• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Ron McLeod
  • Jeanne Boyarsky
Sheriffs:
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

parsing in servlet

 
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
i am accepting string from html page to my servlet using dopost method.
but this is the date my user is entering from the page.
i want to insert this date into my database(ms access)where i have defined a field of data type "date/time".
the program throws sql exception regarding the mis match of data type.
because i have "date/time " in the table and string in the servlet.
is their any way by which i can parse the string in to date??
thanks in advance
 
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
This isn't a servlet specific issue. You need to look at the "DateFormat" class, and its methods for converting between Strings and Dates.
 
Author and all-around good cowpoke
Posts: 13078
6
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Good practice requires that you verify that you have a reasonable date in your user's input. Since in order to do that you will have to parse the submission, you will have all the parts to create a date in the format the database wants.
Exactly how you do the parsing depends on the format your form asks for. Look at the java.util.Calendar class
Bill
 
Happily living in the valley of the dried frogs with a few tiny ads.
Clean our rivers and oceans from home
https://www.kickstarter.com/projects/paulwheaton/willow-feeders
reply
    Bookmark Topic Watch Topic
  • New Topic