Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import net.sf.jasperreports.view.JasperViewer;
- import net.sf.jasperreports.engine.JasperPrint;
- import net.sf.jasperreports.engine.JasperFillManager;
- import net.sf.jasperreports.engine.JasperManager;
- import net.sf.jasperreports.engine.JasperReport;
- import java.sql.*;
- import java.util.*;
- import java.net.URL;
- public class Relatório {
- private JasperViewer jasper;
- /** Creates a new instance of Relatório */
- public Relatório() {
- // JasperPrint impressao = JasperFillManager.fillReport(getClass().getResourceAsStream("teste"), parâmetros, ds);
- ok();
- }
- public void ok()
- {
- try
- {
- Class.forName("org.postgresql.Driver");
- Connection con = DriverManager.getConnection("jdbc:postgresql://inf.upf.br/dbxxxxx","xxxx","xxxx");
- Statement st=con.createStatement();
- st.execute("SET search_path = postosaude, pg_catalog;");
- ResultSet rs=st.executeQuery("SELECT * FROM PACIENTE");
- HashMap parametros=new HashMap();
- URL urlFile = getClass().getClassLoader().getResource("classic.jrxml");
- JasperPrint impressao=JasperManager.fillReport(getClass().getResourceAsStream("classic.jrxml"),parametros,con);
- JasperViewer viewer=new JasperViewer(impressao,true);
- viewer.setTitle("Relatório de Turmas");
- viewer.setBounds(0,0,400,300);
- viewer.show();
- st.close();
- con.close();
- }
- catch(Exception e)
- {
- System.out.println(e);
- e.printStackTrace();
- }
- }
- public static void main(String args[])
- {
- Relatório r = new Relatório();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement