Advertisement
Guest User

Untitled

a guest
Jul 16th, 2016
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.33 KB | None | 0 0
  1. private void generateRptForm(String sql, String reportloader) {
  2. PreparedStatement pstmt = null;
  3. ResultSet rs = null;
  4. ByteArrayOutputStream baos = null;
  5. Connection connect = null;
  6. try {
  7. baos = new ByteArrayOutputStream();
  8. Class.forName("com.mysql.jdbc.Driver").newInstance();
  9. connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/" + "school", user, password);
  10. pstmt = connect.prepareStatement("SELECT image FROM picture WHERE id = 1");
  11. rs = pstmt.executeQuery();
  12. InputStream imageStream = null;
  13. BufferedImage image = null;
  14. while (rs.next()) {
  15. imageStream = rs.getBinaryStream(1);
  16. image = ImageIO.read(imageStream);
  17. }
  18. System.out.println("image..." + image);
  19. connect.close();
  20. connect.close();
  21.  
  22. Class.forName("com.mysql.jdbc.Driver");
  23. conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/" + "school", user, password);
  24. stmt = conn.createStatement();
  25. JasperDesign jd = JRXmlLoader.load(reportloader);
  26. String sqltrans = sql;
  27. JRDesignQuery newQuery = new JRDesignQuery();
  28. newQuery.setText(sqltrans);
  29. jd.setQuery(newQuery);
  30. // Get data from registration table
  31.  
  32. String[] split = null;
  33. String schname = this.getTitle();
  34. split = schname.split("\[");
  35. schname = split[1];
  36. split = schname.split("\]");
  37. String[] regdetails = dbutils.checker.regdetails(split[0]);
  38.  
  39. Map<String, Object> param = new HashMap<String, Object>();
  40.  
  41. param.put("schoolname", regdetails[0]);
  42. param.put("address", regdetails[3]);
  43. param.put("zipcode", regdetails[4]);
  44. param.put("telephone", regdetails[5]);
  45. param.put("location", regdetails[1]);
  46. param.put("country", regdetails[2]);
  47. param.put("email", regdetails[6]);
  48.  
  49. param.put("logo", image);
  50.  
  51. JasperReport jr = JasperCompileManager.compileReport(jd);
  52. JasperPrint jp = JasperFillManager.fillReport(jr, param, conn);
  53. JasperViewer.viewReport(jp, false);
  54. } catch (Exception e) {
  55. JOptionPane.showMessageDialog(null, e);
  56. System.out.println(e);
  57. }
  58. }
  59.  
  60. <image>
  61. <reportElement ... />
  62. <imageExpression class="java.awt.Image"><![CDATA[$P{logo}]]></imageExpression>
  63. </image>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement