Java Reference
In-Depth Information
{
Connection connection;
Statement statement;
ResultSet resultSet;
ServletOutputStream servletOutputStream =
response.getOutputStream();
InputStream reportStream = getServletConfig().getServletContext().
getResourceAsStream("/reports/DbReportDS.jasper");
try
{
String query = "select a.tail_num, a.aircraft_serial, "
+ "am.model as aircraft_model, ae.model as engine_model from
aircraft a, "
+ "aircraft_models am, aircraft_engines ae where a.aircraft_
engine_code in ("
+ "select aircraft_engine_code from aircraft_engines "
+ "where horsepower >= 1000) and am.aircraft_model_code =
a.aircraft_model_code "
+ "and ae.aircraft_engine_code = a.aircraft_engine_code";
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection ("jdbc:mysql://
localhost:3306/flightstats?user=dbuser&password=secret");
statement = connection.createStatement();
resultSet = statement.executeQuery(query);
JRResultSetDataSource resultSetDataSource = new
JRResultSetDataSource(resultSet);
JasperRunManager.runReportToPdfStream(reportStream,
servletOutputStream, new HashMap(), resultSetDataSource);
resultSet.close();
statement.close();
connection.close();
response.setContentType("application/pdf");
servletOutputStream.flush();
servletOutputStream.close();
 
Search WWH ::




Custom Search