//Copyright (c) 2000, Art Gittleman
//This example is provided WITHOUT ANY WARRANTY either expressed or implied.

/* Queries the Sales database.  Needs to be modified
 * to use metadata to correctly output the result set.
 */

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import sun.jdbc.odbc.JdbcOdbcDriver;

public class SalesServlet extends HttpServlet {
  Connection con;
  Statement stmt;

  public void init(ServletConfig sc) throws ServletException {
    super.init(sc);
    try{ 
      new JdbcOdbcDriver();
      String url = "jdbc:odbc:Sales";
      String user = "";
      String password = "";
      con = DriverManager.getConnection(url, user, password);
      stmt = con.createStatement();
    }catch (Exception e) {
        e.printStackTrace();
        System.exit(1);
    }
  } 
  public void doGet(HttpServletRequest req,
                    HttpServletResponse resp) 
                throws ServletException, IOException {
    resp.setContentType("text/html");
    PrintWriter  out = resp.getWriter();
    try{
      String query = req.getParameter("select");
      ResultSet rs = stmt.executeQuery(query);
      ResultSetMetaData rsMetaData = rs.getMetaData();
      int cols = rsMetaData.getColumnCount();
      while(rs.next()) {
        String s = "";
        for(int i=1; i<=cols; i++)
          s += rs.getString(i) + ' ';
        s += "<br>";
        out.println(s);
      }
    }catch(Exception e) {
       e.printStackTrace();
    }
    out.close();
  }
  public void doPost(HttpServletRequest req,
                    HttpServletResponse resp)
       throws ServletException, IOException {
    doGet(req,resp);
  }
}