/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package general_director_the_order;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.io.InputStream;
import java.sql.PreparedStatement;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Random;
import net.sf.jasperreports.engine.*

/**
 *
 * @author Devhtml
 */
public class General_Director_the_order {
    JasperReport jasperReport;
    JasperPrint jasperPrint;
    Connection connection;
    ResultSet resultSet = null;
    PreparedStatement statement = null;

    public void generateReport() {
        try {
            Class.forName("org.postgresql.Driver");
            String query = "select ou.users.uname as uname_gen from ou.users, ecm.doc_bpm_roles, ou.orgunit where ou.users.id = ecm.doc_bpm_roles.userid and ecm.doc_bpm_roles.roleid = 31 group by ou.users.id";
            connection = DriverManager.getConnection("jdbc:postgresql://---:---/---", "---", "---");
            statement = connection.prepareStatement(query);
            resultSet = statement.executeQuery();

            JasperReport jasperReport = JasperCompileManager.compileReport("D:order1.xml");

      // Передаем resultSet в отчет
         JasperPrint jasperPrint = JasperFillManager.fillReport( jasperReport, new HashMap(), new JRResultSetDataSource(resultSet) );

      JasperExportManager.exportReportTo PdfFile(jasperPrint,"D:\\order1.pdf");

            connection.close();

        } catch (Exception e) {
            System.out.println(e + " e1");
        }
    }

    public static void main(String[] args) {
        new General_Director_the_order().generateReport();
    }
}