Advertisement
Guest User

Untitled

a guest
Aug 19th, 2017
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.77 KB | None | 0 0
  1. import net.sf.jasperreports.view.JasperViewer;
  2. import net.sf.jasperreports.engine.JasperPrint;
  3. import net.sf.jasperreports.engine.JasperFillManager;
  4. import net.sf.jasperreports.engine.JasperManager;
  5. import net.sf.jasperreports.engine.JasperReport;
  6. import java.sql.*;
  7. import java.util.*;
  8. import java.net.URL;
  9.  
  10. public class Relatório {
  11. private JasperViewer jasper;
  12.  
  13. /** Creates a new instance of Relatório */
  14. public Relatório() {
  15. // JasperPrint impressao = JasperFillManager.fillReport(getClass().getResourceAsStream("teste"), parâmetros, ds);
  16. ok();
  17. }
  18.  
  19. public void ok()
  20. {
  21. try
  22. {
  23. Class.forName("org.postgresql.Driver");
  24. Connection con = DriverManager.getConnection("jdbc:postgresql://inf.upf.br/dbxxxxx","xxxx","xxxx");
  25. Statement st=con.createStatement();
  26. st.execute("SET search_path = postosaude, pg_catalog;");
  27. ResultSet rs=st.executeQuery("SELECT * FROM PACIENTE");
  28.  
  29. HashMap parametros=new HashMap();
  30. URL urlFile = getClass().getClassLoader().getResource("classic.jrxml");
  31.  
  32. JasperPrint impressao=JasperManager.fillReport(getClass().getResourceAsStream("classic.jrxml"),parametros,con);
  33. JasperViewer viewer=new JasperViewer(impressao,true);
  34. viewer.setTitle("Relatório de Turmas");
  35. viewer.setBounds(0,0,400,300);
  36. viewer.show();
  37.  
  38. st.close();
  39. con.close();
  40. }
  41. catch(Exception e)
  42. {
  43. System.out.println(e);
  44. e.printStackTrace();
  45. }
  46. }
  47.  
  48. public static void main(String args[])
  49. {
  50. Relatório r = new Relatório();
  51. }
  52.  
  53. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement