import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.HashMap;

import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JRExporterParameter;
import net.sf.jasperreports.engine.JasperCompileManager;
import net.sf.jasperreports.engine.JasperExportManager;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.JasperReport;
import net.sf.jasperreports.engine.export.JRXlsExporter;

public class Main {
	private static String DATABASE_URL = "jdbc:mysql://localhost:3306/lab5?autoReconnect=true&useSSL=false";
    private static String DATABASE_USERNAME = "root";
    private static String DATABASE_PASSWORD = "ahmed";

    private static Connection instance = null;

    public static Connection getConnection() throws ClassNotFoundException, SQLException {
        Class.forName("com.mysql.jdbc.Driver");
        instance = DriverManager.getConnection(DATABASE_URL, DATABASE_USERNAME, DATABASE_PASSWORD);
        return instance;
    }

	public static void main(String[] args) throws ClassNotFoundException, SQLException {
		// TODO Auto-generated method stub
		try {
				Class.forName("com.mysql.jdbc.Driver");
				String jrxmlFileName = "C:\\Users\\Ahmed\\Desktop\\Book_Store_report\\test.jrxml";
			   	String jasperFileName = "C:\\Users\\Ahmed\\Desktop\\Book_Store_report\\test.jasper";
			   	String pdfFileName = "C:\\Users\\Ahmed\\Desktop\\Book_Store_report\\test.pdf";

			   	JasperCompileManager.compileReportToFile(jrxmlFileName, jasperFileName);

			   	JasperReport jr = JasperCompileManager.compileReport(jrxmlFileName);
//			InputStream jrxmlInput = JRLoader.getResourceInputStream("C:\\Users\\Ahmed\\Desktop\\Book_Store_report\\Top Consumers.jrxml");
//			JasperDesign jd = JRXmlLoader.load(jrxmlInput);
//			String sql = "Select * from employee";
//			JRDesignQuery query = new JRDesignQuery();
//			query.setText(sql);
//			jd.setQuery(query);

			Connection conn = getConnection();
			JasperPrint jp = JasperFillManager.fillReport(jr, null, conn);
//			JasperViewer.viewReport(jp);
		    JasperExportManager.exportReportToPdfFile(jp, pdfFileName);
		} catch (JRException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

}