package com.ngMAT.Samples.EZScott;

import  java.util.Vector;
import  com.ngMAT.HTML.HTMLTemplate;
import  com.ngMAT.HTML.HTMLComponentVector;
import  com.ngMAT.servlet.EZServlet;
import  com.ngMAT.servlet.EZServletContext;

public class EZScott    extends EZServlet
{
    public  void    processApplication (EZServletContext _context) {
        EZScottContext context = (EZScottContext)_context;
        EZScottConfig config = (EZScottConfig)context.getConfig();
        HTMLTemplate    template = context.getTemplate (config.TemplateName);
        String  order = context.getParameter ("order");
        if (order == null) order = config.DefaultOrder;
        String  option = "order by " + order;
        context.assignConnection();
        Vector  v = EZEmp.selectAll (context, option);
        HTMLComponentVector hcv = new HTMLComponentVector();
        for (int i = 0; i < v.size(); i++) {
            HTMLTemplate row = context.getTemplate (config.RowTemplateName);
            EZEmp emp = (EZEmp)v.elementAt (i);
            row.setTagValue ("EMPNO", emp.empno);
            row.setTagValue ("ENAME", emp.ename);
            row.setTagValue ("JOB", emp.job);
            row.setTagValue ("MGR", emp.mgr);
            row.setTagValue ("HIREDATE", config.df.format (emp.hiredate));
            row.setTagValue ("SAL", emp.sal);
            row.setTagValue ("COMM", emp.comm);
            row.setTagValue ("DEPTNO", emp.deptno);
            hcv.addElement (row);
        }
        template.setTagValue ("ROWS", hcv);
        context.releaseConnection();
        context.setOutput (template);
    }
}