import java.sql.*;
import java.io.*;
import java.util.Vector;

import javax.servlet.*;
import javax.servlet.http.*;

public class dbQueryRunnable extends HttpServlet {

        public void doPost(HttpServletRequest req, HttpServletResponse res)
                throws ServletException,IOException {
                        try {
                                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

                        } catch(java.lang.ClassNotFoundException e) {
                                        req.setAttribute ("error", "JdbcDriver");
                                        getServletConfig().getServletContext().
                                        getRequestDispatcher("/jsp/error.jsp").forward(req,res);
                                        return;
                        }

                        try {
                                Connection con = DriverManager.getConnection("jdbc:odbc:CafeJava");
                                Statement stmt = con.createStatement();

                                String query = "select * from coffees where cof_name ='" + req.getParameter("blabla") + "'";
                                ResultSet result = stmt.executeQuery(query);
                ResultSetMetaData   metaData = result.getMetaData();

                                int numberOfColumns =  metaData.getColumnCount();

                                Vector rows = new Vector();
                                while (result.next()) {
                                        Vector newRow = new Vector();
                                        for (int i = 1; i <= numberOfColumns; i++)
                                                newRow.addElement(result.getObject(i));

                                        rows.addElement(newRow);
                                }

                                stmt.close();
                                con.close();

                                req.setAttribute ("dbData", rows);
                                getServletConfig().getServletContext().
                                getRequestDispatcher("/jsp/outPut.jsp").forward(req,res);

                        } catch (SQLException ex) {
                                req.setAttribute ("error", "SQL");
                                getServletConfig().getServletContext().
                                getRequestDispatcher("/jsp/error.jsp").forward(req,res);
                        }
                }
}