Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private JDateChooser date11;
- private JDateChooser date22;
- static final String JDBC_DRIVER="org.h2.Driver";
- static final String DB_URL="jdbc:h2:~/test";
- //Database credentials
- static final String USERNAME="sa";
- static final String PASSWORD="";
- Connection connection=null;
- ResultSet rs=null;
- PreparedStatement statement=null;
- JasperDesign jd;
- JasperReport jr;
- JasperPrint jp;
- HashMap params;
- public void commonPrintFunction(String sql, String date1, String date2,
- String jasper) {
- try {
- Class.forName(JDBC_DRIVER);
- Connection connection=DriverManager.getConnection(DB_URL , USERNAME , PASSWORD);
- jd=JRXmlLoader.load(new File("").getAbsolutePath()+"/src/"+jasper+".jrxml");
- params=new HashMap();
- JRDesignQuery newQuery=new JRDesignQuery();
- newQuery.setText(sql);
- jd.setQuery(newQuery);
- jr=JasperCompileManager.compileReport(jd);
- jp=JasperFillManager.fillReport(jr, params,connection);
- }catch(Exception e) {e.printStackTrace();
- }
- }
- [enter image description here][1] JButton btnView = new JButton("ANGALIA");
- btnView.addActionListener(new ActionListener() {
- public void actionPerformed(ActionEvent arg0) {
- try {
- Connection connection=DriverManager.getConnection(DB_URL , USERNAME , PASSWORD);
- String Query="select *from MAPATO " ;
- commonPrintFunction(Query, "","", "RIPOTIDOMINIKA");
- Show_report.removeAll();
- Show_report.setLayout(new BorderLayout());
- Show_report.add(new JRViewer(jp));
- Show_report.revalidate();
- Show_report.repaint();
- }catch(Exception ae) {
- }
- }
- });
Add Comment
Please, Sign In to add comment