Advertisement
Guest User

Untitled

a guest
May 8th, 2016
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.95 KB | None | 0 0
  1. /*
  2. * To change this template, choose Tools | Templates
  3. * and open the template in the editor.
  4. */
  5. package GUID;
  6.  
  7. import java.awt.Container;
  8. import java.sql.Connection;
  9. import java.sql.DriverManager;
  10. import java.sql.SQLException;
  11. import java.util.HashMap;
  12. import java.util.logging.Level;
  13. import java.util.logging.Logger;
  14. import javax.swing.JFrame;
  15.  
  16. import net.sf.jasperreports.engine.*;
  17. import net.sf.jasperreports.view.*;
  18.  
  19. /**
  20. *
  21. * @author Vaio
  22. */
  23. public class Report extends JFrame {
  24.  
  25. public Report(String fileName) {
  26. this(fileName, null);
  27. }
  28.  
  29. public Report(String fileName, HashMap parameter) {
  30. super("View Report");
  31. try {
  32. KetNoi kn = new KetNoi();
  33. JasperPrint print = JasperFillManager.fillReport(fileName, parameter, Con());
  34. JRViewer viewer = new JRViewer(print);
  35.  
  36. Container c = getContentPane();
  37. c.add(viewer);
  38. } catch (Exception ex) {
  39. }
  40.  
  41. setBounds(10, 10, 600, 500);
  42. setDefaultCloseOperation(DISPOSE_ON_CLOSE);
  43. setVisible(true);
  44.  
  45. }
  46.  
  47. private Connection Con() {
  48. Connection conn = null;
  49. try {
  50. Class.forName("com.mysql.jdbc.Driver");
  51.  
  52. try {
  53. // conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/diemsv?characterEncoding=utf8", "root", "");
  54. conn = DriverManager.getConnection("jdbc:mysql://sql6.freesqldatabase.com:3306/sql6118529?characterEncoding=utf8", "sql6118529", "Bf7vdQUsEA");
  55.  
  56. } catch (SQLException ex) {
  57. Logger.getLogger(Report.class.getName()).log(Level.SEVERE, null, ex);
  58. }
  59.  
  60. } catch (ClassNotFoundException ex) {
  61. Logger.getLogger(Report.class.getName()).log(Level.SEVERE, null, ex);
  62. }
  63. if (conn == null) {
  64. System.out.println("Kết nối lỗi");
  65. } else {
  66. System.out.println("Kết nối thành công");
  67. }
  68. return conn;
  69. }
  70. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement