package myjava;

import java.sql.*;
import java.util.*;
import javax.swing.JOptionPane;
import net.sf.jasperreports.engine.*;
import net.sf.jasperreports.engine.design.JasperDesign;
import net.sf.jasperreports.engine.xml.JRXmlLoader;
import net.sf.jasperreports.view.*;
public class ViewAll {

   public ViewAll()
    {
        try{
            Class.forName("com.mysql.jdbc.Driver");
            Connection conn = DriverManager.getConnection(
                "jdbc:mysql://localhost/my3csd","root","12345"
             );

            //String sn = JOptionPane.showInputDialog("Enter a Student Number:");

            Map param=new HashMap();
            //param.put("studnum", sn);
            //param.put("user", "root");

            String sourceDir="D:\\JReport3.jrxml";
            String destinationDir = "D:\\JReport3.pdf";

            JasperDesign jd = JRXmlLoader.load(sourceDir);

            JasperReport jr=JasperCompileManager.compileReport(jd);

            JasperPrint jp = JasperFillManager.fillReport(jr,param,conn);

            JasperExportManager.exportReportToPdfFile(jp,destinationDir);

            JasperViewer.viewReport(jp,false);

            //conn.close();
            }
        catch(Exception e)
        {
            JOptionPane.showMessageDialog(null, e.getMessage());
        }
    }
    public static void main(String[] args) {
        ViewAll va = new ViewAll();
    }
}