package com.wrappers; import java.sql.DriverManager; import java.util.HashMap; import net.sf.jasperreports.engine.JRResultSetDataSource; import net.sf.jasperreports.engine.JasperCompileManager; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.JasperReport; import com.mysql.jdbc.Connection; import com.mysql.jdbc.ResultSet; import com.mysql.jdbc.Statement; public class GoGo { Statement stmt1; Connection con1; JasperReport jasperReport; JasperPrint jasperPrint; JRResultSetDataSource obj ; ResultSet rs3; String pdftext , csvtext , htmltext , xmltext , exceltext , wordtext , path; public GoGo() { super(); System.out.println("hello"); } public void setPdftext(String pdftext) { this.pdftext=pdftext; } public void setHtmltext(String htmltext) { this.htmltext=htmltext; } public void setXmltext(String xmltext) { this.xmltext=xmltext; } public void setCsvtext(String csvtext) { this.csvtext=csvtext; } public void setExceltext(String exceltext) { this.exceltext=exceltext; } public void setWordtext(String wordtext) { this.wordtext=wordtext; } //////// / public String getPdftext() { return pdftext; } public String getHtmltext() { return htmltext; } public String getXmltext() { return xmltext; } public String getCsvtext() { return csvtext; } public String getExceltext() { return exceltext; } public String getWordtext() { return wordtext; } public void dataOut() { try { Class.forName("com.mysql.jdbc.Driver"); con1=(Connection) DriverManager.getConnection("jdbc:mysql://localhost/access","root","root"); stmt1=(Statement) con1.createStatement(); rs3=(ResultSet) stmt1.executeQuery("select * from items where"); obj = new JRResultSetDataSource(rs3); jasperReport = JasperCompileManager.compileReport("C:/items.jrxml"); jasperPrint = JasperFillManager.fillReport(jasperReport, new HashMap(),obj); }catch(Exception e){System.out.println(e);} } }
Ads