---

JspTool.java

Go to the documentation of this file.

package net.threebit.utils.sosc;

/*
        Copyright 2003 Shawn Deleurme
        Copyright 2003 Kevin O'Donnell

        This program is free software; you can redistribute it and/or modify
        it under the terms of the GNU General Public License as published by
        the Free Software Foundation; either version 2 of the License, or
        (at your option) any later version.

        This program is distributed in the hope that it will be useful,
        but WITHOUT ANY WARRANTY; without even the implied warranty of
        MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
        GNU General Public License for more details.

        You should have received a copy of the GNU General Public License
        along with this program; if not, write to the Free Software
        Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
*/

import com.oreilly.servlet.*;
import java.io.*;
import java.sql.*;
import java.util.*;
import javax.servlet.jsp.*;
import javax.servlet.http.*;

public class JspTool {

        private HttpServletRequest request;
        private HttpServletResponse response;
        private JspWriter out;
        private MultipartRequest multi = null;

        public int minYear = 2000;
        public int maxYear = 2005;

        public JspTool (HttpServletRequest request, HttpServletResponse response, JspWriter out) throws Exception {
                this.request = request;
                this.response = response;
                this.out = out;
        }

        /*
         * Wrapper for request.getParameter(String s) but guarantees that nulls are nuver
         * returned. "" is returned in the place of nulls
         */
        public String getParameter (String name) {
                String result;
                if (multi != null) {
                        result = multi.getParameter(name);
                }
                else {
                        result = request.getParameter(name);
                }
                if (result == null) { return ""; }
                return result;
        }

        public String getParameter (String name, String def) throws Exception {
                String result = getParameter(name);
                if (result.equals("")) {
                        return def;
                }
                return result;
        }

        public String[] getParameterValues (String name) throws Exception {
                return getParameterValues(name,null);
        }

        public String[] getParameterValues (String name, String def) throws Exception {
                String[] result = null;
                if (multi != null) {
                        result = multi.getParameterValues(name);
                }
                else {
                        result = request.getParameterValues(name);
                }
                if (result == null || result.length == 0) {
                        if (def != null) { result = new String[] { def }; }
                        else { result = new String[] { }; }
                }
                return result;
        }

        public String getJspPath (javax.servlet.ServletContext application) {
                return application.getRealPath(request.getRequestURI());
        }

        public String getJspBaseDir (javax.servlet.ServletContext application) {
                File file = new File(application.getRealPath(request.getRequestURI()));
                return file.getParent();
        }

        public MultipartRequest multipartRequest(String uploadDir, int maxSize) throws Exception {
                if (multi == null) { multi = new MultipartRequest( request, uploadDir, maxSize); }
                return multi;
        }

        public int[] today() {
                Calendar c = Calendar.getInstance();
                int year = c.get(c.YEAR);
                int month = c.get(c.MONTH);
                int day = c.get(c.DAY_OF_MONTH);
                month ++;
                return new int[] {year,month,day};
        }

        public String dateSelect (String prefix) throws Exception {
                if (prefix == null) { prefix = ""; }
                else { prefix = prefix + "-"; }

                // Get the current date
                int[] today = today();

                // Determine the current valures of 'name-year', etc from the current request
                int year = Integer.parseInt(getParameter(prefix+"year",""+today[0]));
                int month = Integer.parseInt(getParameter(prefix+"month",""+today[1]));
                int day = Integer.parseInt(getParameter(prefix+"day",""+today[2]));

                StringBuffer r = new StringBuffer(1000);

                // year
                r.append("<select name='" + prefix + "year'>\n");
                for (int x = minYear; x <= maxYear; x++) {
                        r.append("\t<option value='" + x + "'" + (x == year ? " selected='yes' " : "") + ">" + x + "\n");
                }
                r.append("</select>\n");

                // month
                r.append("<select name='" + prefix + "month'>\n");
                for (int x = 1; x <= 12; x++) {
                        r.append("\t<option value='" + (x<10?"0"+x:""+x) + "'" + (x == month ? " selected='yes' " : "") + ">" + (x<10?"0"+x:""+x) + "\n");
                }
                r.append("</select>\n");

                // day
                r.append("<select name='" + prefix + "day'>\n");
                for (int x = 1; x <= 31; x++) {
                        r.append("\t<option value='" + (x<10?"0"+x:""+x) + "'" + (x == day ? " selected='yes' " : "") + ">" + (x<10?"0"+x:""+x) + "\n");
                }
                r.append("</select>\n");

                return r.toString();
        }

        public String dateFromForm (String prefix) throws Exception {
                if (prefix == null) { prefix = ""; }
                else { prefix = prefix + "-"; }
                String year = getParameter(prefix+"year");
                String month = getParameter(prefix+"month");
                String day = getParameter(prefix+"day");
                String result = year + "-" + month + "-" + day;
                if (result.equals("--")) { return ""; }
                return result;
        }

  public Map fixMap( Map map ) throws Exception {
    Map m = new HashMap ( map.size() );
    for ( Iterator i = map.keySet().iterator();i.hasNext(); ){
      String key = i.next().toString();
      String value = ((String[])map.get(key))[0] ;
      m.put ( key, value );
    }
    return m;
  }

        public String resultSetToHTMLTable (ResultSet r, String title) throws Exception {
                return resultSetToHTMLTable(r,title,null,null,null,null,true);
        }

        public String resultSetToHTMLTable
                (ResultSet r, String title, String tableClass, String headingClass, String thClass, String tdClass, boolean autoSum) 
                throws Exception {

                if (headingClass == null) { headingClass = "style='padding: 10px; text-align: left; border: 1px solid #c0c0c0;'"; }
                if (tableClass == null) { tableClass = "style='border-collapse: collapse;'"; }
                if (thClass == null) { thClass = "style='border: 1px solid #c0c0c0; padding: 5px;'"; }
                if (tdClass == null) { tdClass = "style='padding-left: 5px; padding-right: 5px; text-align: right;'"; }

                StringWriter sw = new StringWriter();
                PrintWriter pw = new PrintWriter(sw);
                int columnCount = r.getMetaData().getColumnCount();
                String[] columnNames = new String[ columnCount ];
                int[] columnTypes = new int[ columnCount ];
                Object[] columnSums = new Object[ columnCount ];

                pw.println("<table " + tableClass + ">");
                pw.println("<tr><th colspan='" + columnCount + "' " + headingClass + ">" + title + "</th></tr>");
                pw.println("<tr>");
                ResultSetMetaData md = null;
                for (int i=1; i <= columnCount; i++) {
                        try {
                        md = r.getMetaData();   
                        columnNames[i-1] = md.getColumnName(i);
                        columnTypes[i-1] = md.getColumnType(i);
                        pw.println("<th " + thClass + ">" + columnNames[i-1] + "</th>");
                        } catch (Exception e) {
                                throw new Exception("column: " + i,e);
                        }
                }
                pw.println("</tr>");

                // Do we need to advance?
                if (r.getRow() == 0) { r.first(); }
                // If still no valid row then report no data and exit
                if (r.getRow() != 0) {
                        do {
                                pw.println("<tr>");
                                for (int i=1; i <= columnCount; i++) {
                                        pw.println("<td " + tdClass + ">" + r.getObject(i) + "</td>");
                                        if (autoSum) {
                                                Object o = columnSums[i-1];
                                                if (columnTypes[i-1] == Types.INTEGER) {
                                                        if (o == null) { o = new Integer(0); }
                                                        o = new Integer(((Integer) o).intValue() + r.getInt(i));
                                                }
                                                else if (columnTypes[i-1] == Types.NUMERIC) {
                                                        if (o == null) { o = new Double(0); }
                                                        o = new Double(((Double) o).doubleValue() + r.getDouble(i));
                                                }
                                                else {
                                                        o = "<!-- Unknown column type " + columnTypes[i-1] + " -->";
                                                }
                                                columnSums[i-1] = o;
                                        }
                                }
                                pw.println("</tr>");
                        } while (r.next());
                }
                else {
                        pw.println("<tr><th colspan='" + columnCount + "' " + headingClass + ">No Data</th></tr>");
                }

                if (autoSum) {
                        pw.println("<tr>");
                        for (int i=1; i <= columnCount; i++) {
                                pw.println("<td " + tdClass + "><strong>" + columnSums[i-1] + "</strong></td>");
                        }
                        pw.println("</tr>");
                }

                pw.println("</table>");
                return sw.getBuffer().toString();
        }



}

---