Guest User

Untitled

a guest
Jan 27th, 2019
132
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.00 KB | None | 0 0
  1. private JDateChooser date11;
  2. private JDateChooser date22;
  3.  
  4.  
  5. static final String JDBC_DRIVER="org.h2.Driver";
  6. static final String DB_URL="jdbc:h2:~/test";
  7. //Database credentials
  8. static final String USERNAME="sa";
  9. static final String PASSWORD="";
  10. Connection connection=null;
  11. ResultSet rs=null;
  12. PreparedStatement statement=null;
  13. JasperDesign jd;
  14. JasperReport jr;
  15. JasperPrint jp;
  16. HashMap params;
  17.  
  18.  
  19. public void commonPrintFunction(String sql, String date1, String date2,
  20. String jasper) {
  21. try {
  22. Class.forName(JDBC_DRIVER);
  23. Connection connection=DriverManager.getConnection(DB_URL , USERNAME , PASSWORD);
  24.  
  25. jd=JRXmlLoader.load(new File("").getAbsolutePath()+"/src/"+jasper+".jrxml");
  26.  
  27. params=new HashMap();
  28. JRDesignQuery newQuery=new JRDesignQuery();
  29. newQuery.setText(sql);
  30. jd.setQuery(newQuery);
  31. jr=JasperCompileManager.compileReport(jd);
  32. jp=JasperFillManager.fillReport(jr, params,connection);
  33. }catch(Exception e) {e.printStackTrace();
  34.  
  35. }
  36.  
  37. }
  38. [enter image description here][1] JButton btnView = new JButton("ANGALIA");
  39. btnView.addActionListener(new ActionListener() {
  40. public void actionPerformed(ActionEvent arg0) {
  41. try {
  42. Connection connection=DriverManager.getConnection(DB_URL , USERNAME , PASSWORD);
  43.  
  44. String Query="select *from MAPATO " ;
  45. commonPrintFunction(Query, "","", "RIPOTIDOMINIKA");
  46. Show_report.removeAll();
  47. Show_report.setLayout(new BorderLayout());
  48. Show_report.add(new JRViewer(jp));
  49. Show_report.revalidate();
  50. Show_report.repaint();
  51. }catch(Exception ae) {
  52. }
  53. }
  54. });
Add Comment
Please, Sign In to add comment