com.jrefinery.chart.demo.jdbc.servlet
Class ImageSelectSQL

java.lang.Object
  |
  +--javax.servlet.GenericServlet
        |
        +--javax.servlet.http.HttpServlet
              |
              +--com.jrefinery.chart.demo.jdbc.servlet.BaseImageServlet
                    |
                    +--com.jrefinery.chart.demo.jdbc.servlet.ImageSelectSQL
All Implemented Interfaces:
Constants, java.io.Serializable, javax.servlet.Servlet, javax.servlet.ServletConfig

public class ImageSelectSQL
extends BaseImageServlet

A generic image producer. The servlet takes an sql string from the request and generates an image based upon this. The sql query should return results in the form

   x_value_1, series_1_y_value, series_2_y_value, series_3_y_value .......etc
   x_value_2, series_1_y_value, series_2_y_value, series_3_y_value
   x_value_3, series_1_y_value, series_2_y_value, series_3_y_value
   x_value_4, series_1_y_value, series_2_y_value, series_3_y_value
   x_value_5, series_1_y_value, series_2_y_value, series_3_y_value
The supplied sql should not include the word select as this is added at the commencement.

See Also:
Serialized Form

Fields inherited from class com.jrefinery.chart.demo.jdbc.servlet.BaseImageServlet
chartTitle, debug, servletName, sqlServerType, xAxisTitle, yAxisTitle
 
Fields inherited from interface com.jrefinery.chart.demo.jdbc.servlet.Constants
CAUTION_FILE, CONTENT_TYPE, DB_CONNECTION, DB_DRIVER, DB_PASSWORD, DB_SCHEMA, DB_SERVER, DB_URL, DB_USER, DEBUG, FOOTER, FOOTER_FILE, HEADER, HEADER_FILE, IMAGE_URL, MYSQL, ORACLE, ORGANISATION, REPLACE_SCHEMA, RESPONSE_HTML, RESPONSE_JPEG, RESPONSE_PDF, RESPONSE_PNG, RESPONSE_PS, RESPONSE_SVG, SHARED_DB, SHARED_DB_OPENER, SHARED_VOYAGES, SHARED_VOYAGES_TIME
 
Constructor Summary
ImageSelectSQL()
           
 
Method Summary
protected  java.lang.String generateSQL(javax.servlet.http.HttpServletRequest request)
          Generate the sql from the request passed to it.
 void init(javax.servlet.ServletConfig config)
          Override init() to set up data used by invocations of this servlet.
 
Methods inherited from class com.jrefinery.chart.demo.jdbc.servlet.BaseImageServlet
createCategoryChart, createChart, createPieChart, createXYChart, destroy, doGet, doPost, draw, getColor, modifyChart, openConnection, testConnection, writeErrorPage
 
Methods inherited from class javax.servlet.http.HttpServlet
doDelete, doHead, doOptions, doPut, doTrace, getLastModified, service, service
 
Methods inherited from class javax.servlet.GenericServlet
getInitParameter, getInitParameterNames, getServletConfig, getServletContext, getServletInfo, getServletName, init, log, log
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

ImageSelectSQL

public ImageSelectSQL()
Method Detail

init

public void init(javax.servlet.ServletConfig config)
          throws javax.servlet.ServletException
Override init() to set up data used by invocations of this servlet.
Overrides:
init in class BaseImageServlet
Parameters:
config - Description of the Parameter
Throws:
javax.servlet.ServletException - Description of the Exception

generateSQL

protected java.lang.String generateSQL(javax.servlet.http.HttpServletRequest request)
Generate the sql from the request passed to it. Only one servlet request parameter is parsed sql. Select is prepended as a simple security constraint to prevent update attempts.
Overrides:
generateSQL in class BaseImageServlet
Parameters:
request - The html servlet request
Returns:
The generated sql