class ScodesController < ApplicationController
def create
scodes_url = "#{BASE_SCODES_URL}?startDate=#{start_date}&endDate=#{end_date}"
redirect_to scodes_url
end
end
and groovy code:
import groovy.sql.Sql
import java.sql.ResultSet
import java.sql.SQLException
import net.sf.jasperreports.engine.*
import net.sf.jasperreports.engine.design.JasperDesign
import net.sf.jasperreports.engine.xml.JRXmlLoader
import com.baldwinmutual.BmicJasper
String path = context.getRealPath("forms") + "/sCodeListForLegacy.jrxml"
reportParameters = new HashMap()
def startDate = params.startDate
def endDate = params.endDate
db = Sql.newInstance('jdbc:mysql://legacy.bmic/legacy_bmic_production',
'user','pass',
'com.mysql.jdbc.Driver')
reportParameters.put("EFFDA",startDate)
reportParameters.put("EXPDA",endDate)
inputFile = new File(path);
baos = new ByteArrayOutputStream()
jasperizer = new BmicJasper(db.getConnection())
baos = jasperizer.setParameters( reportParameters )
.compileReport( inputFile )
.fillReport()
.createReportStream()
response.setHeader("Expires", "30")
response.setHeader("Cache-Control", "must-revalidate, post-check=0, pre-check=0")
response.setHeader("Pragma", "public")
// setting the content type
response.setContentType("application/pdf")
// the contentlength is needed for MSIE!!!
response.setContentLength(baos.size());
// write ByteArrayOutputStream to the ServletOutputStream
ot = response.getOutputStream()
baos.writeTo(ot)
ot.flush()