Advertisement
Guest User

why i still get false heuSet when it is print out as true?

a guest
Apr 27th, 2017
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.20 KB | None | 0 0
  1. statement = connection.createStatement();
  2. statement1 = connection.createStatement();
  3. statement2 = connection.createStatement();
  4. statement3 = connection.createStatement();
  5. String sql2 = "SELECT mt.staffNo as staffNo, pc.idprogramme as program, pc.numOfStu as numOfStu, mt.pc as pc "
  6. + "FROM mastertimetable mt INNER JOIN programmecourse pc "
  7. + "ON mt.pc=pc.pc WHERE SemesterSession='" + ss + "'";
  8. resultSet2 = statement.executeQuery(sql2);
  9.  
  10. String staffNo = null;
  11. String sessions = null;
  12. int numOfStu = 0;
  13.  
  14. int day = 0;
  15. int times = 0;
  16.  
  17. while (resultSet2.next()) {
  18. staffNo = resultSet2.getString("staffNo");
  19. program = resultSet2.getString("program");
  20. numOfStu = resultSet2.getInt("numOfStu");
  21. String pc = resultSet2.getString("pc");
  22.  
  23.  
  24.  
  25.  
  26. String Class = "SELECT * FROM class "
  27. + "WHERE capacity>='" + numOfStu + "' "
  28. + "ORDER BY capacity desc";
  29.  
  30.  
  31.  
  32.  
  33. Class1 = statement1.executeQuery(Class);
  34. String idClass = null;
  35. while (Class1.next()) {
  36. idClass = Class1.getString("idClass");
  37. list.add(idClass);
  38. //out.println(list);
  39. }
  40. int c = 0;
  41. // int x = 1, y = 1;
  42. int size = list.size();
  43. while (c < size) {//d5-0-10 //
  44. int x = 1;
  45. while (x < 6) {//ahad
  46. int y = 1;
  47. while (y < 10) {//09:00
  48.  
  49. String heu = "SELECT mt.staffNo as staffNo, pc.idprogramme as program, mt.idClass as idClass,"
  50. + " mt.day as day, mt.times as times "
  51. + "FROM mastertimetable mt INNER JOIN programmecourse pc ON mt.pc=pc.pc"
  52. + " WHERE (mt.staffNo='" + staffNo + "' OR pc.idprogramme='" + program + "') AND (mt.idClass='" + list.get(c) + "' "
  53. + "OR mt.day=" + x + " OR mt.times=" + y + ") AND mt.SemesterSession='" + ss + "'";
  54.  
  55. heuSet = statement2.executeQuery(heu);
  56.  
  57. out.println(heuSet.next());
  58. out.println("<br>");
  59.  
  60. if (heuSet.next() == false) {
  61. s = list.get(c).toString();
  62. day = x;
  63. times = y;
  64. out.println(heu);
  65. break;
  66. } else {
  67. y++;
  68. }
  69.  
  70.  
  71.  
  72. }
  73. x++;
  74. break;
  75.  
  76. }
  77.  
  78. c++;
  79. break;
  80.  
  81. }
  82.  
  83. out.println("<br>");
  84. out.println(staffNo);
  85. out.println("<br>");
  86. out.println(program);
  87. out.println("<br>");
  88. out.println(numOfStu);
  89. out.println("<br>");
  90. out.println(idClass);
  91. out.println("<br>");
  92. out.println("x = " + day);
  93. out.println("y = " + times);
  94. out.println("<br>");
  95. String sql = "UPDATE mastertimetable SET idClass='" + idClass + "', day='" + day + "', times='" + times + "'"
  96. + " WHERE (staffNo='" + staffNo + "' AND pc='" + pc + "') AND SemesterSession='" + ss + "'";
  97. int q = statement3.executeUpdate(sql);
  98.  
  99. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement