Advertisement
Guest User

jsp

a guest
Nov 3rd, 2016
1,146
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.30 KB | None | 0 0
  1. <%@page import="java.io.*, java.util.*, java.sql.*"%>
  2. <%@page import="net.sf.jasperreports.engine.*"%>
  3. <%@page import="net.sf.jasperreports.view.JasperViewer.*"%>
  4. <%@page import="javax.servlet.ServletResponse"%>
  5. <%@page contentType="text/html"
  6.         pageEncoding="UTF-8"%>
  7.  
  8. <!DOCTYPE html>
  9. <html>
  10.     <head>
  11.         <meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
  12.         <title>Laporan Barang</title>
  13.     </head>
  14.     <body>
  15.         <%
  16.         Connection conn = null;
  17.         String url="jdbc:mysql://localhost:3306/penjualan_wiketriana_11141072";
  18.         String username="root";
  19.         String password="";
  20.         Class.forName("com.mysql.jdbc.Driver");
  21.         conn = DriverManager.getConnection(url, username,password);              
  22.         File reportFile = new
  23.         File(application.getRealPath("/laporanbarang.jasper"));
  24.         Map<String, Object> param=new HashMap<String,Object>();
  25.         byte[] bytes =JasperRunManager.runReportToPdf(reportFile.getPath(),param, conn);
  26.         response.setContentType("application/pdf");
  27.         response.setContentLength(bytes.length);
  28.         ServletOutputStream outStream =response.getOutputStream();
  29.         outStream.write(bytes, 0, bytes.length);
  30.         outStream.flush();
  31.         outStream.close();
  32. %>
  33. </body>
  34. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement