Advertisement
Guest User

Untitled

a guest
Oct 23rd, 2016
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.55 KB | None | 0 0
  1. user_view(String d1, String d2, String d3) throws ClassNotFoundException, SQLException {
  2. initComponents();
  3. int a = Integer.parseInt(d1);
  4. int b = Integer.parseInt(d2);
  5. int c = Integer.parseInt(d3);
  6. int year=a;
  7. int month=b;
  8. int date=c;
  9. String query;
  10. String query1;
  11. if(b<=6)
  12. {
  13. year=a-1;
  14. month=b+6;
  15. query="Select * from user_don_det where Year<="+ year +" and Month<="+ month +"";
  16. query1="SELECT * FROM `user_det` WHERE `Admission`=(Select Admission From user_don_det where Year<="+ year +" and Month<="+ month +")";
  17. }
  18. else
  19. {
  20. month=b-6;
  21. query="Select * from user_don_det where Month<="+ month +" or Year<="+ year +"";
  22. query1="SELECT * FROM `user_det` WHERE `Admission`=(Select Admission From user_don_det where Month<="+ month +")";
  23. }
  24.  
  25. blooddonation.dbconnectivity db=new blooddonation.dbconnectivity();
  26. ResultSet rs=db.q_execute(query);
  27. ResultSet rs1=db.q_execute(query1);
  28.  
  29. Vector data=new Vector();
  30. while(rs.next())
  31. {
  32. Vector row=new Vector();
  33. row.addElement(rs.getInt(1));
  34. row.addElement(rs.getInt(2));
  35. row.addElement(rs.getInt(3));
  36. row.addElement(rs.getInt(4));
  37.  
  38. data.addElement(row);
  39. }
  40. while(rs1.next())
  41. {Vector row=new Vector();
  42. row.addElement(rs1.getString(1));
  43. row.addElement(rs1.getString(2));
  44. row.addElement(rs1.getString(6));
  45. row.addElement(rs1.getInt(8));
  46. data.addElement(row);
  47. }
  48.  
  49.  
  50. Vector head=new Vector();
  51. head.addElement("Admission No");
  52. head.addElement("Date");
  53. head.addElement("Month");
  54. head.addElement("Year");
  55. head.addElement("Name");
  56. head.addElement("Email");
  57. head.addElement("Sex");
  58. head.addElement("Phone");
  59.  
  60. DefaultTableModel model=new DefaultTableModel(data,head);
  61. tab.setModel(model);
  62.  
  63. SEVERE: null
  64. java.sql.SQLException: Operation not allowed after ResultSet closed
  65. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
  66. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
  67. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
  68. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
  69. at com.mysql.jdbc.ResultSetImpl.checkClosed(ResultSetImpl.java:804)
  70. at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:6986)
  71. at blooddonation.user_view.<init>(user_view.java:55)
  72. at blooddonation.user_fscreen$5.actionPerformed(user_fscreen.java:263)
  73. at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement