Thank You it worked
srikanth patibanda
-----Original Message-----
From: Tao Bai [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 01, 1999 8:09 AM
To: [EMAIL PROTECTED]
Subject: Re: Java Servlets -- JDBC
Check TimeStamp.
> -----Original Message-----
> From: PATIBANDA, SRIKANTH [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, September 30, 1999 4:24 PM
> To: [EMAIL PROTECTED]
> Subject: Java Servlets -- JDBC
>
> Hi,
>
> I am using HTML, Servlets and Jdbc. I was able to send a query constructed
> from HTML form to a servlet, was able to connect to the database, and
> retrieve the results.
> The strange part comes now..
> My code works perfectly fine if i consider all columns as a string and
> retrieve result as
>
> rs.getString(col);
>
> But if i try to retieve the data by checking its datatype , its not
> displaying data with Date , Decimal or Numeric type.
>
> and one more problem is how do i display the date along with time.
> My database is in Oracle . The column datatype is Date. (includes time
> also)
>
> switch(type) {
> case DATE:
> java.sql.Date date = rs.getDate(col);
> out.println("<td>" + date.toString() + "</td>");
> break;
> case Types.TIME:
> java.sql.Time time = rs.getTime(col);
> out.println("<td>" + time.toString() + "</td>");
> break;
> case Types.CHAR:
> case Types.VARCHAR:
> case Types.LONGVARCHAR:
> String str = rs.getString(col);
> out.println("<td>" + str + "</td>");
> break;
> case NUMERIC:
> case DECIMAL:
> java.math.BigDecimal numeric = rs.getBigDecimal(col, 5);
> out.println("<td>" + numeric.toString() + "</td>");
> break;
>
> }
>
> Thanks
> Srikanth Patibanda
> IT Specialist
> Entergy Corporation
> Ph: (W)504-576-5444
>
> __________________________________________________________________________
> _
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
