Hi Naga,
res.setContentType("application/vnd.ms-excel");
Thats the kinda output content u want to generate. I
mean in which format ur output will be.
Thnx
Pratik.
--- Nagamani Nutulapati
<[EMAIL PROTECTED]> wrote:
> Richards,
>
> Though new to the topic, I just tried out the
> example given by you. I'm
> using IE. The servlet generates the output on to the
> browser but not to an
> excel sheet.
>
> Also, could u please be elaborate on
>
> res.setContentType("application/vnd.ms-excel");
>
> Thanks,
> Mani
>
> -----Original Message-----
> From: Ryan Richards [ mailto:[EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]> ]
> Sent: Wednesday, April 05, 2000 10:18 PM
> To: [EMAIL PROTECTED]
> Subject: servlet using Excel example code
>
>
> OK guys, here a little servlet I wrote to place a
> query returned from a
> database into an excel spreadsheet. I modified the
> code to make it simpler,
> hopefully I didnt make any mistakes in editing. Feel
> free to email me if you
> have any questions.
>
> If you are using Netscape it prompts you to open or
> save. If you open the
> Excel is laucnhed and your spreadsheet contains the
> data. If you are using
> IE then it automatically opens an excel spreadsheet.
>
> HTH
> Ryan
>
--------------------------------------------------------
> import java.sql.*;
> import java.io.*;
> import javax.servlet.*;
> import javax.servlet.http.*;
> import java.util.StringTokenizer;
>
> public class dbServlet extends HttpServlet
> implements
> SingleThreadModel {
> Connection conn = null;
>
> public void init( ServletConfig config ) throws
> ServletException {
> super.init(config);
> ...
> ...
> snip
> } // init
>
> public void doGet( HttpServletRequest req,
> HttpServletResponse res )
> throws ServletException, IOException {
>
> // Setup the stream
> PrintWriter out = res.getWriter();
>
> res.setContentType("application/vnd.ms-excel");
>
> try { // Create a Statement
> Statement stmt = conn.createStatement ();
> ResultSet rset = null;
>
> rset = stmt.executeQuery(
> "select name,"+
> "salary,"+
> "dept,"+
> "from employee_table"+
> //
> // Send the information to Excel.
> // The tabs (\t) tell the code to
> place
> // each rset item into it's own
> column.
> //
>
> out.println("Name\tSalary\tDept");
> while ( rset.next () )
> {
> out.println(rset.getString(1)+"\t"+
> rset.getString(2)+"\t"+
> rset.getString(3));
> }
>
> } catch ( SQLException e ) {
> System.err.println("A database error
> occurred.");
> }
> out.close();
> } // doGet
> } // dbServlet
>
> Ryan Richards
> Technical Consultant
> Database Consultants, Inc.
> Oklahoma City, OK
> -----------------------------------------------
> FREE! The World's Best Email Address @email.com
> Reserve your name now at http://www.email.com
> <http://www.email.com>
>
>
___________________________________________________________________________
> 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
>
<http://archives.java.sun.com/archives/servlet-interest.html>
> Resources:
>
http://java.sun.com/products/servlet/external-resources.html
>
<http://java.sun.com/products/servlet/external-resources.html>
> LISTSERV Help:
> http://www.lsoft.com/manuals/user/user.html
> <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
>
__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com
___________________________________________________________________________
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
