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);}
 }

}