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
___________________________________________________________________________
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
