Advertisement
Guest User

print

a guest
Aug 4th, 2016
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.75 KB | None | 0 0
  1.  private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                        
  2.      try {
  3.             Class.forName("org.postgresql.Driver");
  4.             String url = "jdbc:postgresql://localhost:5432/dbtester";
  5.             Connection cn = DriverManager.getConnection (url, "postgres", "");
  6.             String SQL = "SELECT * from dbtestfinal where lower(nama) like '%"+ nama.getText().toLowerCase()+"%'"
  7.                     + "and thntes like  '%" + tahunuji.getText() + "%'"
  8.                     + "order by nama asc";
  9.             Statement st = cn.createStatement();
  10.             ResultSet rs = st.executeQuery(SQL);
  11.  
  12.             JasperPrint jasperPrint;      
  13.             JRResultSetDataSource jrRS = new JRResultSetDataSource (rs);            
  14.             JasperReport jasperReport = JasperCompileManager.compileReport(System.getProperties().getProperty("java.class.path").split(";")[System.getProperties().getProperty("java.class.path").split(";").length - 1] + "\\report1.jrxml");          
  15.             jasperPrint = JasperFillManager.fillReport(jasperReport, null, jrRS);
  16.             JRViewer aViewer = new JRViewer(jasperPrint);                  
  17.             JDialog viewer = new JDialog();    
  18.             viewer.setTitle(".: Jasper Report :.");            
  19.             viewer.setAlwaysOnTop(true);
  20.             viewer.getContentPane().add(aViewer);                  
  21.             Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();    
  22.             viewer.setBounds(0,0,screenSize.width, screenSize.height);
  23.             viewer.setVisible(true);              
  24.             st.close();
  25.             cn.close();
  26.           } catch(Exception e)
  27.           {
  28.                System.out.println(e);
  29.           }
  30.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement