That's baaad! You should use a PreparedStatement.
Geert Van Damme > -----Original Message----- > From: A mailing list about Java Server Pages specification and reference > [mailto:[EMAIL PROTECTED]]On Behalf Of G.Nagarajan > Sent: dinsdag 7 mei 2002 11:29 > To: [EMAIL PROTECTED] > Subject: Re: sql Date > > > hi, > > for inserting a date into the database, i use the following code. > > Calendar cal; // The date to be inserted > String colValue = ""; > colValue = > "'"+(cal.get(Calendar.MONTH)+1)+"/"+cal.get(Calendar.DAY_OF_MONTH) > +"/"+cal.g > et(Calendar.YEAR) > +" > "+cal.get(Calendar.HOUR_OF_DAY) + ":"+cal.get(Calendar.MINUTE)+"'"; > > then.. > > String sql = "Insert into table(...) values ('aa'," + colValue + ")" > > then use sql for inserting the record. > > > hth, > Nagarajan. > > > -----Original Message----- > > From: A mailing list about Java Server Pages specification and reference > > [mailto:[EMAIL PROTECTED]]On Behalf Of Bhushan_Bhangale > > Sent: Tuesday, May 07, 2002 11:14 AM > > To: [EMAIL PROTECTED] > > Subject: Re: sql Date > > > > > > You cannot cast a java.util.Date to a java.sql.Date since the > util.Date is > > the parent class of sql Date. > > > > -----Original Message----- > > From: Emmanuel Eze [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, May 07, 2002 1:46 PM > > To: [EMAIL PROTECTED] > > Subject: Re: sql Date > > > > > > Even if I do that, how do I then convert the java.util.Date to > > java.sql.Date? > > > > > > -----Original Message----- > > From: Bhushan_Bhangale [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, May 07, 2002 11:05 AM > > To: [EMAIL PROTECTED] > > Subject: Re: sql Date > > > > > > First of all:- > > > > java.util.sql birthday = null; should be java.util.Date > > birthday = null; > > > > as the Calendar.getTime() method returns a util date object. > > > > -----Original Message----- > > From: Emmanuel Eze [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, May 07, 2002 1:34 PM > > To: [EMAIL PROTECTED] > > Subject: sql Date > > > > > > Hi all, > > > > Can somebody pls tell me how I can insert a Date type into a > > database table > > with a Date datatype? > > > > I have the year, month, and day as integer values. I need to > > convert these > > values into an sql Date object so I can now insert the Date > > object into the > > table, right? > > > > I have the following code: > > Calendar cbirthday = null; > > java.util.sql birthday = null; > > . > > . > > . > > cbirthday = Calendar.getInstance(); > > cbirthday.set(Integer.parseInt(year), Integer.parseInt(month), > > Integer.parseInt(day)); > > birthday = cbirthday.getTime(); > > > > This last statement throws a cast exception! Even when I change it to: > > birthday = (java.sql.Date) cbirthday.getTime(); > > > > Pls tell me what I'm doing wrongly. > > > > Emma > > > > ================================================================== > > ========= > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > > JSP-INTEREST". > > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > > DIGEST". > > Some relevant FAQs on JSP/Servlets can be found at: > > > > http://archives.java.sun.com/jsp-interest.html > > http://java.sun.com/products/jsp/faq.html > > http://www.esperanto.org.nz/jsp/jspfaq.jsp > > http://www.jguru.com/faq/index.jsp > > http://www.jspinsider.com > > > > ================================================================== > > ========To > > unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > > JSP-INTEREST". > > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > > DIGEST". > > Some relevant FAQs on JSP/Servlets can be found at: > > > > http://archives.java.sun.com/jsp-interest.html > > http://java.sun.com/products/jsp/faq.html > > http://www.esperanto.org.nz/jsp/jspfaq.jsp > > http://www.jguru.com/faq/index.jsp > > http://www.jspinsider.com > > > > ================================================================== > > ========= > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > > JSP-INTEREST". > > For digest: mailto [EMAIL PROTECTED] with body: "set > > JSP-INTEREST DIGEST". > > Some relevant FAQs on JSP/Servlets can be found at: > > > > http://archives.java.sun.com/jsp-interest.html > > http://java.sun.com/products/jsp/faq.html > > http://www.esperanto.org.nz/jsp/jspfaq.jsp > > http://www.jguru.com/faq/index.jsp > > http://www.jspinsider.com > > > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > > JSP-INTEREST". > > For digest: mailto [EMAIL PROTECTED] with body: "set > > JSP-INTEREST DIGEST". > > Some relevant FAQs on JSP/Servlets can be found at: > > > > http://archives.java.sun.com/jsp-interest.html > > http://java.sun.com/products/jsp/faq.html > > http://www.esperanto.org.nz/jsp/jspfaq.jsp > > http://www.jguru.com/faq/index.jsp > > http://www.jspinsider.com > > ================================================================== > ========= > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > JSP-INTEREST". > For digest: mailto [EMAIL PROTECTED] with body: "set > JSP-INTEREST DIGEST". > Some relevant FAQs on JSP/Servlets can be found at: > > http://archives.java.sun.com/jsp-interest.html > http://java.sun.com/products/jsp/faq.html > http://www.esperanto.org.nz/jsp/jspfaq.jsp > http://www.jguru.com/faq/index.jsp > http://www.jspinsider.com > =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
