Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
- try {
- Class.forName("org.postgresql.Driver");
- String url = "jdbc:postgresql://localhost:5432/dbtester";
- Connection cn = DriverManager.getConnection (url, "postgres", "");
- String SQL = "SELECT * from dbtestfinal where lower(nama) like '%"+ nama.getText().toLowerCase()+"%'"
- + "and thntes like '%" + tahunuji.getText() + "%'"
- + "order by nama asc";
- Statement st = cn.createStatement();
- ResultSet rs = st.executeQuery(SQL);
- JasperPrint jasperPrint;
- JRResultSetDataSource jrRS = new JRResultSetDataSource (rs);
- JasperReport jasperReport = JasperCompileManager.compileReport(System.getProperties().getProperty("java.class.path").split(";")[System.getProperties().getProperty("java.class.path").split(";").length - 1] + "\\report1.jrxml");
- jasperPrint = JasperFillManager.fillReport(jasperReport, null, jrRS);
- JRViewer aViewer = new JRViewer(jasperPrint);
- JDialog viewer = new JDialog();
- viewer.setTitle(".: Jasper Report :.");
- viewer.setAlwaysOnTop(true);
- viewer.getContentPane().add(aViewer);
- Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
- viewer.setBounds(0,0,screenSize.width, screenSize.height);
- viewer.setVisible(true);
- st.close();
- cn.close();
- } catch(Exception e)
- {
- System.out.println(e);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement