Guest User

Untitled

a guest
Aug 29th, 2018
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.73 KB | None | 0 0
  1. private void jCcatItemStateChanged(java.awt.event.ItemEvent evt) {
  2. //jlsubtype.removeAll();
  3. System.out.println(jCcat.getSelectedItem().toString());
  4. if (jCcat.getSelectedItem().toString().matches("Uniform")) {
  5. jCsubCat.removeAllItems();
  6. jCsubCat.addItem("Long Sleeve");
  7. jCsubCat.addItem("Short Sleeve");
  8. jCsubCat.addItem("Overcoat");
  9. jCsubCat.addItem("Overoll");
  10. } else if (jCcat.getSelectedItem().toString().matches("Headwear")) {
  11. jCsubCat.removeAllItems();
  12. jCsubCat.addItem("Caps");
  13. jCsubCat.addItem("Scaffs");
  14. } else if (jCcat.getSelectedItem().toString().matches("Footwear")) {
  15. jCsubCat.removeAllItems();
  16. jCsubCat.addItem("Shoes");
  17. jCsubCat.addItem("Slippers");
  18. }
  19. if (jCcat.getSelectedItem().toString().matches("Uniform")) {
  20. jCsSize.removeAllItems();
  21. jCsSize.addItem("XS");
  22. jCsSize.addItem("S");
  23. jCsSize.addItem("M");
  24. jCsSize.addItem("L");
  25. jCsSize.addItem("XL");
  26. jCsSize.addItem("XXL");
  27. jCsSize.addItem("XXXL");
  28. } else if (jCcat.getSelectedItem().toString().matches("Headwear")) {
  29. jCsSize.removeAllItems();
  30. jCsSize.addItem("Free Size");
  31.  
  32. } else if (jCcat.getSelectedItem().toString().matches("Footwear")) {
  33. jCsSize.removeAllItems();
  34. jCsSize.addItem("35");
  35. jCsSize.addItem("36");
  36. jCsSize.addItem("37");
  37. jCsSize.addItem("38");
  38. jCsSize.addItem("39");
  39. jCsSize.addItem("40");
  40. jCsSize.addItem("4");
  41. jCsSize.addItem("5");
  42. jCsSize.addItem("6");
  43. jCsSize.addItem("7");
  44. jCsSize.addItem("8");
  45. jCsSize.addItem("9");
  46. }
  47. }
  48.  
  49. private void jCsubCatItemStateChanged(java.awt.event.ItemEvent evt) {
  50.  
  51. if (jCcat.getSelectedItem().toString().matches("Uniform")) {
  52. DefaultListModel lists = new DefaultListModel();
  53. try {
  54. Class.forName("com.mysql.jdbc.Driver").newInstance();
  55. //Connection con = DriverManager.getConnection("jdbc:sqlserver://10.228.59.2:1433;databaseName=uniforminventorydb;user=SA;password=KreedaIntimo@2017;");
  56. Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/uniforminventorydb", "root", "");
  57. Statement st = con.createStatement();
  58. PreparedStatement pst;
  59.  
  60. String Catagory;
  61. String Type;
  62.  
  63. Catagory = jCcat.getSelectedItem().toString();
  64. Type = jCsubCat.getSelectedItem().toString();
  65.  
  66. String sql = "Select Distinct SubType from add_stock Where Catergory = '" + Catagory + "' and Type = '" + Type + "'";
  67. pst = con.prepareStatement(sql);
  68. ResultSet rs = pst.executeQuery();
  69.  
  70. while (rs.next()) {
  71.  
  72. System.out.println(rs.getString(1));
  73. String ls = rs.getString(1);
  74. lists.addElement(ls);
  75.  
  76. jLsType.setModel(lists);
  77.  
  78. }
  79.  
  80. } catch (Exception e) {
  81. e.printStackTrace();
  82. }
  83. } else if (jCcat.getSelectedItem().toString().matches("Footwear")) {
  84. DefaultListModel lists = new DefaultListModel();
  85. try {
  86. Class.forName("com.mysql.jdbc.Driver").newInstance();
  87. //Connection con = DriverManager.getConnection("jdbc:sqlserver://10.228.59.2:1433;databaseName=uniforminventorydb;user=SA;password=KreedaIntimo@2017;");
  88. Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/uniforminventorydb", "root", "");
  89. Statement st = con.createStatement();
  90. PreparedStatement pst;
  91.  
  92. String Catagory;
  93. String Type;
  94.  
  95. //Catagory = jCcat.getSelectedItem().toString();
  96. Catagory = "Footwear";
  97.  
  98. Type = jCsubCat.getSelectedItem().toString();
  99.  
  100. String sql = "Select Distinct SubType from add_stock Where Catergory = '" + Catagory + "' and Type = '" + Type + "'";
  101. pst = con.prepareStatement(sql);
  102. ResultSet rs = pst.executeQuery();
  103.  
  104. while (rs.next()) {
  105.  
  106. System.out.println(rs.getString(1));
  107. String ls = rs.getString(1);
  108. lists.addElement(ls);
  109.  
  110. jLsType.setModel(lists);
  111.  
  112. }
  113.  
  114. } catch (Exception e) {
  115. e.printStackTrace();
  116. }
  117.  
  118. } else if (jCcat.getSelectedItem().toString().matches("Headwear")) {
  119. DefaultListModel lists = new DefaultListModel();
  120. try {
  121. Class.forName("com.mysql.jdbc.Driver").newInstance();
  122. //Connection con = DriverManager.getConnection("jdbc:sqlserver://10.228.59.2:1433;databaseName=uniforminventorydb;user=SA;password=KreedaIntimo@2017;");
  123. Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/uniforminventorydb", "root", "");
  124. Statement st = con.createStatement();
  125. PreparedStatement pst;
  126.  
  127. String Catagory;
  128. String Type;
  129.  
  130. // Catagory = jCcat.getSelectedItem().toString();
  131. Catagory = "Headwear";
  132. //Type = jCsubCat.getSelectedItem().toString();
  133.  
  134. String sql = "Select Distinct SubType from add_stock Where Catergory = '" + Catagory + "'";
  135. pst = con.prepareStatement(sql);
  136. ResultSet rs = pst.executeQuery();
  137.  
  138. while (rs.next()) {
  139.  
  140. System.out.println(rs.getString(1));
  141. String ls = rs.getString(1);
  142. lists.addElement(ls);
  143.  
  144. jLsType.setModel(lists);
  145.  
  146. }
  147.  
  148. } catch (Exception e) {
  149. e.printStackTrace();
  150. }
  151. }
  152.  
  153. java.lang.NullPointerException
  154. at uniforminventorysystem.HomeAdmin.jCsubCatItemStateChanged(HomeAdmin.java:2068)
  155. at uniforminventorysystem.HomeAdmin.access$600(HomeAdmin.java:47)
  156.  
  157. private void catergorySelect(){
  158. try {
  159. Class.forName("com.mysql.jdbc.Driver").newInstance();
  160. //Connection con = DriverManager.getConnection("jdbc:sqlserver://10.228.59.2:1433;databaseName=uniforminventorydb;user=SA;password=KreedaIntimo@2017;");
  161. Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/uniforminventorydb", "root", "");
  162. String sql = "select * from catergoryLoad";
  163. pst = con.prepareStatement(sql);
  164. ResultSet r = pst.executeQuery();
  165.  
  166. while (r.next()) {
  167.  
  168. jCcat.addItem(r.getString("Catergory"));
  169. jCrcat3.addItem(r.getString("Catergory"));
  170. jCocat.addItem(r.getString("Catergory"));
  171. }
  172.  
  173. con.close();
  174. } catch (Exception e) {
  175. JOptionPane.showMessageDialog(null, "Failed to Connect to Database", "Error Connection", JOptionPane.WARNING_MESSAGE);
  176. System.exit(0);
  177. }
  178.  
  179. }
Add Comment
Please, Sign In to add comment