API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 15th, 2017
71
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 24.31 KB | None | 0 0
raw download clone embed print report
  1. import java.awt.BorderLayout;
  2. import java.awt.EventQueue;
  3. import java.awt.TextField;
  4. import java.awt.event.ActionEvent;
  5. import java.awt.event.ActionListener;
  6. import java.awt.event.ItemEvent;
  7. import java.awt.event.ItemListener;
  8. import java.sql.Connection;
  9. import java.sql.DriverManager;
  10. import java.sql.PreparedStatement;
  11. import java.sql.ResultSet;
  12. import java.sql.Statement;
  13. import java.util.Calendar;
  14.  
  15. import javax.swing.AbstractAction;
  16. import javax.swing.Action;
  17. import javax.swing.DefaultComboBoxModel;
  18. import javax.swing.JButton;
  19. import javax.swing.JComboBox;
  20. import javax.swing.JFrame;
  21. import javax.swing.JLabel;
  22. import javax.swing.JOptionPane;
  23. import javax.swing.JTable;
  24. import javax.swing.JTextField;
  25. import javax.swing.SwingConstants;
  26. import javax.swing.SwingUtilities;
  27.  
  28. import java.awt.Font;
  29.  
  30. public class GUI {
  31.  
  32. public JFrame frame;
  33. private JTextField textField;
  34. private JTextField textField_1;
  35. private JTextField textField_2;
  36. private JTextField textField_3;
  37. private JTextField textField_5;
  38. private JTextField textField_6;
  39. private JTextField textField_7;
  40. String driverName = "com.mysql.jdbc.Driver";
  41. String url = "jdbc:mysql://localhost/students";
  42. String userName = "root";
  43. String password = "";
  44. private JTextField textField_8;
  45. private Connection connect = null;
  46. private Statement statement = null;
  47. private PreparedStatement preparedStatement = null;
  48. private ResultSet resultSet = null;
  49.  
  50. /**
  51. * Launch the application.
  52. *
  53. * @throws Exception
  54. */
  55. public static void main(String[] args) throws Exception {
  56. EventQueue.invokeLater(new Runnable() {
  57. public void run() {
  58. try {
  59. GUI window = new GUI();
  60. window.frame.setVisible(true);
  61. } catch (Exception e) {
  62. e.printStackTrace();
  63. }
  64. }
  65. });
  66.  
  67. // AccessStudentsCalls db = new AccessStudentsCalls();
  68. // db.connectToDB();
  69. // db.readStudents();
  70. // db.close();
  71.  
  72. }
  73.  
  74. /**
  75. * Create the application.
  76. */
  77. public GUI() {
  78. initialize();
  79. }
  80.  
  81. /**
  82. * Initialize the contents of the frame.
  83. */
  84. private void initialize() {
  85.  
  86. frame = new JFrame();
  87. frame.setBounds(100, 100, 498, 670);
  88. frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
  89. frame.getContentPane().setLayout(null);
  90.  
  91. JLabel lblNewLabel = new JLabel("Item Name : ");
  92. lblNewLabel.setHorizontalAlignment(SwingConstants.CENTER);
  93. lblNewLabel.setBounds(10, 11, 80, 23);
  94. frame.getContentPane().add(lblNewLabel);
  95.  
  96. textField = new JTextField();
  97. textField.setBounds(84, 12, 164, 20);
  98. frame.getContentPane().add(textField);
  99. textField.setColumns(10);
  100.  
  101. JLabel lblQuantity = new JLabel("Quantity :");
  102. lblQuantity.setHorizontalAlignment(SwingConstants.CENTER);
  103. lblQuantity.setBounds(10, 41, 70, 23);
  104. frame.getContentPane().add(lblQuantity);
  105. int id = 0;
  106. try {
  107. Class.forName(driverName);
  108. Connection con = DriverManager.getConnection(url, userName, password);
  109. String sql = "select * from mkrisele";
  110. PreparedStatement ps = con.prepareStatement(sql);
  111. ResultSet rs = ps.executeQuery();
  112. int i = 0;
  113. while (rs.next()) {
  114. id = rs.getInt("ID");
  115. i++;
  116. }
  117.  
  118. } catch (Exception ex) {
  119. }
  120.  
  121. textField_1 = new JTextField();
  122. textField_1.setBounds(84, 42, 30, 20);
  123. frame.getContentPane().add(textField_1);
  124. textField_1.setColumns(10);
  125.  
  126. JLabel lblCustomer = new JLabel("Customer : ");
  127. lblCustomer.setHorizontalAlignment(SwingConstants.CENTER);
  128. lblCustomer.setBounds(10, 65, 80, 23);
  129. frame.getContentPane().add(lblCustomer);
  130.  
  131. textField_2 = new JTextField();
  132. textField_2.setBounds(84, 66, 164, 20);
  133. frame.getContentPane().add(textField_2);
  134. textField_2.setColumns(10);
  135.  
  136. JLabel lblNewLabel_1 = new JLabel("Auxilliary Supply : ");
  137. lblNewLabel_1.setHorizontalAlignment(SwingConstants.CENTER);
  138. lblNewLabel_1.setBounds(0, 96, 123, 23);
  139. frame.getContentPane().add(lblNewLabel_1);
  140.  
  141. JComboBox comboBox = new JComboBox();
  142. comboBox.setModel(new DefaultComboBoxModel(new String[] { "220V AC", "515V AC", "SMPS", "Other" }));
  143. comboBox.setBounds(112, 97, 123, 20);
  144. frame.getContentPane().add(comboBox);
  145. TextField textField_4 = new TextField();
  146.  
  147. comboBox.addItemListener(new ItemListener() {
  148.  
  149. @Override
  150. public void itemStateChanged(ItemEvent e) {
  151. // TODO Auto-generated method stub
  152. if (e.getStateChange() == ItemEvent.SELECTED) {
  153. textField_4.setVisible(false);
  154. textField_4.setBounds(217, 97, 173, 22);
  155. frame.getContentPane().add(textField_4);
  156. textField_4.setVisible("Other".equals(comboBox.getSelectedItem()));
  157. }
  158. }
  159. });
  160.  
  161. JLabel lblNoOfDisplays = new JLabel("No. Of Displays : ");
  162. lblNoOfDisplays.setHorizontalAlignment(SwingConstants.CENTER);
  163. lblNoOfDisplays.setBounds(0, 122, 123, 23);
  164. frame.getContentPane().add(lblNoOfDisplays);
  165.  
  166. JComboBox comboBox_1 = new JComboBox();
  167. comboBox_1.setModel(new DefaultComboBoxModel(new String[] { "1", "2", "3" }));
  168. comboBox_1.setBounds(112, 125, 37, 20);
  169. frame.getContentPane().add(comboBox_1);
  170.  
  171. JLabel lblNoOfSwitches = new JLabel("No. Of Switches : ");
  172. lblNoOfSwitches.setHorizontalAlignment(SwingConstants.CENTER);
  173. lblNoOfSwitches.setBounds(0, 150, 123, 23);
  174. frame.getContentPane().add(lblNoOfSwitches);
  175.  
  176. JComboBox comboBox_2 = new JComboBox();
  177. comboBox_2.setModel(new DefaultComboBoxModel(new String[] { "1", "2", "3", "4" }));
  178. comboBox_2.setBounds(112, 153, 37, 20);
  179. frame.getContentPane().add(comboBox_2);
  180.  
  181. JLabel lblNoOfRelays = new JLabel("No. Of Relays : ");
  182. lblNoOfRelays.setHorizontalAlignment(SwingConstants.CENTER);
  183. lblNoOfRelays.setBounds(0, 178, 123, 23);
  184. frame.getContentPane().add(lblNoOfRelays);
  185.  
  186. JComboBox comboBox_3 = new JComboBox();
  187. comboBox_3.setModel(new DefaultComboBoxModel(new String[] { "1", "2" }));
  188. comboBox_3.setBounds(112, 179, 37, 20);
  189. frame.getContentPane().add(comboBox_3);
  190.  
  191. JLabel lblRs = new JLabel("RS-485 ?");
  192. lblRs.setHorizontalAlignment(SwingConstants.CENTER);
  193. lblRs.setBounds(-9, 201, 123, 23);
  194. frame.getContentPane().add(lblRs);
  195.  
  196. JComboBox comboBox_4 = new JComboBox();
  197. comboBox_4.setModel(new DefaultComboBoxModel(new String[] { "Y", "N" }));
  198. comboBox_4.setBounds(112, 202, 37, 20);
  199. frame.getContentPane().add(comboBox_4);
  200.  
  201. JLabel lblAnalogOp = new JLabel("Analog O/P 1 ");
  202. lblAnalogOp.setHorizontalAlignment(SwingConstants.CENTER);
  203. lblAnalogOp.setBounds(-9, 228, 123, 23);
  204. frame.getContentPane().add(lblAnalogOp);
  205.  
  206. JComboBox comboBox_5 = new JComboBox();
  207. comboBox_5.setModel(new DefaultComboBoxModel(new String[] { "4-20 mA", "0-20 mA", "0-5V DC", "Other" }));
  208. comboBox_5.setBounds(112, 229, 94, 20);
  209. frame.getContentPane().add(comboBox_5);
  210. textField_5 = new JTextField();
  211.  
  212. System.out.println(new java.util.Date());
  213.  
  214. comboBox_5.addItemListener(new ItemListener() {
  215.  
  216. @Override
  217. public void itemStateChanged(ItemEvent e) {
  218. // TODO Auto-generated method stub
  219. textField_5.setVisible(false);
  220. textField_5.setBounds(218, 229, 172, 20);
  221. frame.getContentPane().add(textField_5);
  222. textField_5.setVisible("Other".equals(comboBox_5.getSelectedItem()));
  223. }
  224.  
  225. });
  226.  
  227. JLabel lblAnalogOp_1 = new JLabel("Analog O/P 2");
  228. lblAnalogOp_1.setHorizontalAlignment(SwingConstants.CENTER);
  229. lblAnalogOp_1.setBounds(-9, 251, 123, 23);
  230. frame.getContentPane().add(lblAnalogOp_1);
  231.  
  232. JComboBox comboBox_6 = new JComboBox();
  233. comboBox_6.setModel(new DefaultComboBoxModel(new String[] { "4-20 mA", "0-20 mA", "0-5V DC", "Other" }));
  234. comboBox_6.setBounds(112, 252, 94, 20);
  235. frame.getContentPane().add(comboBox_6);
  236. textField_7 = new JTextField();
  237.  
  238. comboBox_6.addItemListener(new ItemListener() {
  239.  
  240. @Override
  241. public void itemStateChanged(ItemEvent e) {
  242. // TODO Auto-generated method stub
  243. textField_7.setEnabled(false);
  244. textField_7.setBounds(217, 252, 180, 20);
  245. frame.getContentPane().add(textField_7);
  246. textField_7.setEnabled("Other".equals(comboBox_6.getSelectedItem()));
  247. }
  248.  
  249. });
  250.  
  251. JLabel lblSoftwareVersion = new JLabel("Software Version :");
  252. lblSoftwareVersion.setHorizontalAlignment(SwingConstants.CENTER);
  253. lblSoftwareVersion.setBounds(0, 274, 123, 23);
  254. frame.getContentPane().add(lblSoftwareVersion);
  255.  
  256. textField_3 = new JTextField();
  257. textField_3.setColumns(10);
  258. textField_3.setBounds(112, 277, 164, 20);
  259. frame.getContentPane().add(textField_3);
  260.  
  261. JLabel lblLedPositions = new JLabel("L.E.D Positions");
  262. lblLedPositions.setHorizontalAlignment(SwingConstants.CENTER);
  263. lblLedPositions.setBounds(-9, 300, 123, 23);
  264. frame.getContentPane().add(lblLedPositions);
  265.  
  266. JComboBox comboBox_7 = new JComboBox();
  267. comboBox_7.setModel(new DefaultComboBoxModel(new String[] { "Y", "N" }));
  268. comboBox_7.setBounds(143, 303, 37, 20);
  269. frame.getContentPane().add(comboBox_7);
  270.  
  271. JLabel lblD = new JLabel("D1 :");
  272. lblD.setHorizontalAlignment(SwingConstants.CENTER);
  273. lblD.setBounds(105, 300, 30, 23);
  274. frame.getContentPane().add(lblD);
  275.  
  276. JComboBox comboBox_8 = new JComboBox();
  277. comboBox_8.setModel(new DefaultComboBoxModel(new String[] { "Y", "N" }));
  278. comboBox_8.setBounds(143, 326, 37, 20);
  279. frame.getContentPane().add(comboBox_8);
  280.  
  281. JLabel lblD_1 = new JLabel("D2 :");
  282. lblD_1.setHorizontalAlignment(SwingConstants.CENTER);
  283. lblD_1.setBounds(105, 322, 30, 23);
  284. frame.getContentPane().add(lblD_1);
  285.  
  286. JComboBox comboBox_9 = new JComboBox();
  287. comboBox_9.setModel(new DefaultComboBoxModel(new String[] { "Y", "N" }));
  288. comboBox_9.setBounds(143, 348, 37, 20);
  289. frame.getContentPane().add(comboBox_9);
  290.  
  291. JComboBox comboBox_10 = new JComboBox();
  292. comboBox_10.setModel(new DefaultComboBoxModel(new String[] { "Y", "N" }));
  293. comboBox_10.setBounds(143, 393, 37, 20);
  294. frame.getContentPane().add(comboBox_10);
  295.  
  296. JComboBox comboBox_11 = new JComboBox();
  297. comboBox_11.setModel(new DefaultComboBoxModel(new String[] { "Y", "N" }));
  298. comboBox_11.setBounds(143, 437, 37, 20);
  299. frame.getContentPane().add(comboBox_11);
  300.  
  301. JComboBox comboBox_13 = new JComboBox();
  302. comboBox_13.setModel(new DefaultComboBoxModel(new String[] { "Y", "N" }));
  303. comboBox_13.setBounds(143, 415, 37, 20);
  304. frame.getContentPane().add(comboBox_13);
  305.  
  306. JComboBox comboBox_12 = new JComboBox();
  307. comboBox_12.setModel(new DefaultComboBoxModel(new String[] { "Y", "N" }));
  308. comboBox_12.setBounds(143, 371, 37, 20);
  309. frame.getContentPane().add(comboBox_12);
  310.  
  311. JLabel lblD_2 = new JLabel("D3 :");
  312. lblD_2.setHorizontalAlignment(SwingConstants.CENTER);
  313. lblD_2.setBounds(105, 347, 30, 23);
  314. frame.getContentPane().add(lblD_2);
  315.  
  316. JLabel lblD_4 = new JLabel("D5 :");
  317. lblD_4.setHorizontalAlignment(SwingConstants.CENTER);
  318. lblD_4.setBounds(105, 392, 30, 23);
  319. frame.getContentPane().add(lblD_4);
  320.  
  321. JLabel lblD_3 = new JLabel("D4 :");
  322. lblD_3.setHorizontalAlignment(SwingConstants.CENTER);
  323. lblD_3.setBounds(105, 370, 30, 23);
  324. frame.getContentPane().add(lblD_3);
  325.  
  326. JLabel lblD_5 = new JLabel("D6 :");
  327. lblD_5.setHorizontalAlignment(SwingConstants.CENTER);
  328. lblD_5.setBounds(105, 414, 30, 23);
  329. frame.getContentPane().add(lblD_5);
  330.  
  331. JLabel lblD_6 = new JLabel("D7 :");
  332. lblD_6.setHorizontalAlignment(SwingConstants.CENTER);
  333. lblD_6.setBounds(105, 436, 30, 23);
  334. frame.getContentPane().add(lblD_6);
  335.  
  336. JLabel lblD_7 = new JLabel("D8 :");
  337. lblD_7.setHorizontalAlignment(SwingConstants.CENTER);
  338. lblD_7.setBounds(105, 458, 30, 23);
  339. frame.getContentPane().add(lblD_7);
  340.  
  341. JComboBox comboBox_15 = new JComboBox();
  342. comboBox_15.setModel(new DefaultComboBoxModel(new String[] { "Y", "N" }));
  343. comboBox_15.setBounds(143, 459, 37, 20);
  344. frame.getContentPane().add(comboBox_15);
  345.  
  346. JButton btnSave = new JButton("SAVE");
  347. btnSave.setBounds(301, 315, 149, 43);
  348. frame.getContentPane().add(btnSave);
  349. btnSave.addActionListener(new ActionListener() {
  350.  
  351. // insert data
  352. @Override // main work
  353. public void actionPerformed(ActionEvent e) {
  354. int ids = 0;
  355. try {
  356. Class.forName(driverName);
  357. Connection con = DriverManager.getConnection(url, userName, password);
  358. String sql = "select * from mkrisele";
  359. PreparedStatement ps = con.prepareStatement(sql);
  360. ResultSet rs = ps.executeQuery();
  361. int i = 0;
  362. while (rs.next()) {
  363. ids = rs.getInt("ID");
  364. i++;
  365. }
  366.  
  367. } catch (Exception ex) {
  368. }
  369. try {
  370. theQuery(
  371. " insert into mkrisele (DateAdded,Itemname, Quantity, Customername,NoofDisplays,NoofSwitches,NoofRelays,RS485,softver,d1,d2,d3,d4,d5,d6,d7,d8)"
  372. + " values ('" + new java.util.Date() + "','" + textField.getText() + "','"
  373. + textField_1.getText() + "','" + textField_2.getText() + "','"
  374. + comboBox_1.getSelectedItem().toString() + "','"
  375. + comboBox_2.getSelectedItem().toString() + "','"
  376. + comboBox_3.getSelectedItem().toString() + "','"
  377. + comboBox_4.getSelectedItem().toString() + "','" + textField_3.getText() + "','"
  378. + comboBox_7.getSelectedItem().toString() + "','"
  379. + comboBox_8.getSelectedItem().toString() + "','"
  380. + comboBox_9.getSelectedItem().toString() + "','"
  381. + comboBox_12.getSelectedItem().toString() + "','"
  382. + comboBox_10.getSelectedItem().toString() + "','"
  383. + comboBox_13.getSelectedItem().toString() + "','"
  384. + comboBox_11.getSelectedItem().toString() + "','"
  385. + comboBox_15.getSelectedItem().toString() + "')");
  386. } catch (Exception ex) {
  387. }
  388.  
  389. // TODO Auto-generated method stub
  390. if (comboBox.getSelectedItem().toString().equals("Other")) {
  391. try {
  392. theQuerys("update mkrisele set Auxsupp = '" + textField_4.getText() + "' where ID = "
  393. + (ids + 1));
  394. } catch (Exception ex) {
  395. }
  396.  
  397. } else {
  398. try {
  399. theQuerys("update mkrisele set Auxsupp = '" + comboBox.getSelectedItem().toString()
  400. + "' where ID = " + (ids + 1));
  401. } catch (Exception ex) {
  402. }
  403. }
  404. if (comboBox_5.getSelectedItem().toString().equals("Other")) {
  405. try {
  406. theQuerys("update mkrisele set Analogop1 = '" + textField_5.getText() + "' where ID = "
  407. + (ids + 1));
  408. } catch (Exception ex) {
  409. }
  410. } else {
  411. try {
  412.  
  413. theQuerys("update mkrisele set Analogop1 = '" + comboBox_5.getSelectedItem().toString()
  414. + "' where ID = " + (ids + 1));
  415. } catch (Exception ex) {
  416. }
  417. }
  418. if (comboBox_6.getSelectedItem().toString().equals("Other")) {
  419. try {
  420. theQuerys("update mkrisele set Analogop2 = '" + textField_7.getText() + "' where ID = "
  421. + (ids + 1));
  422. } catch (Exception ex) {
  423. }
  424. } else {
  425. try {
  426.  
  427. theQuerys("update mkrisele set Analogop2 = '" + comboBox_6.getSelectedItem().toString()
  428. + "' where ID = " + (ids + 1));
  429. } catch (Exception ex) {
  430. }
  431. }
  432.  
  433. }
  434.  
  435. });
  436.  
  437. JButton btnQuit = new JButton("QUIT");
  438. btnQuit.setBounds(301, 493, 149, 43);
  439. frame.getContentPane().add(btnQuit);
  440.  
  441. btnQuit.addActionListener(new ActionListener() {
  442. // quit gui
  443. @Override
  444. public void actionPerformed(ActionEvent e) {
  445. // TODO Auto-generated method stub
  446. System.exit(0);
  447. }
  448.  
  449. });
  450.  
  451. JButton btnNewButton = new JButton("Show Existing");
  452. btnNewButton.setBounds(301, 360, 149, 43);
  453. frame.getContentPane().add(btnNewButton);
  454.  
  455. JLabel lblId = new JLabel("ID=");
  456. lblId.setBounds(317, 37, 19, 30);
  457. frame.getContentPane().add(lblId);
  458.  
  459. JButton btnUpdateExis = new JButton("Update");
  460. btnUpdateExis.setBounds(301, 404, 149, 42);
  461. frame.getContentPane().add(btnUpdateExis);
  462.  
  463. textField_8 = new JTextField();
  464. textField_8.setBounds(344, 42, 86, 20);
  465. frame.getContentPane().add(textField_8);
  466. textField_8.setColumns(10);
  467.  
  468. JButton btnShow = new JButton("Show");
  469. btnShow.setBounds(341, 65, 89, 23);
  470. frame.getContentPane().add(btnShow);
  471.  
  472. JButton btnNewButton_1 = new JButton("Delete");
  473. btnNewButton_1.setBounds(301, 448, 149, 43);
  474. frame.getContentPane().add(btnNewButton_1);
  475.  
  476. JLabel lblIdforUpdate = new JLabel("Form Number = " + (id + 1));
  477. lblIdforUpdate.setBounds(328, 7, 122, 30);
  478. frame.getContentPane().add(lblIdforUpdate);
  479.  
  480. JLabel lblTime = new JLabel("Time :" + new java.util.Date());
  481. lblTime.setFont(new Font("Tahoma", Font.PLAIN, 14));
  482. lblTime.setBounds(193, 592, 237, 28);
  483. frame.getContentPane().add(lblTime);
  484.  
  485. JButton btnNewButton_2 = new JButton("Show And create Pdf");
  486. btnNewButton_2.setBounds(301, 270, 149, 43);
  487. frame.getContentPane().add(btnNewButton_2);
  488.  
  489. btnNewButton_2.addActionListener(new ActionListener() {
  490.  
  491. @Override
  492. public void actionPerformed(ActionEvent arg0) {
  493. // TODO Auto-generated method stub
  494. SearchResultLO Lol = new SearchResultLO();
  495. Lol.main(null);
  496.  
  497. }
  498.  
  499. });
  500.  
  501. btnNewButton_1.addActionListener(new ActionListener() {
  502. // delete data
  503. @Override
  504. public void actionPerformed(ActionEvent e) {
  505. // TODO Auto-generated method stub
  506. int id = 0;
  507. int i = 0;
  508. try {
  509. Class.forName(driverName);
  510. Connection con = DriverManager.getConnection(url, userName, password);
  511. String sql = "select * from mkrisele";
  512. PreparedStatement ps = con.prepareStatement(sql);
  513. ResultSet rs = ps.executeQuery();
  514.  
  515. while (rs.next()) {
  516. id = rs.getInt("ID");
  517. i++;
  518. }
  519.  
  520. } catch (Exception ex) {
  521. }
  522.  
  523. try {
  524.  
  525. theQuerydel("delete from mkrisele where ID = " + textField_8.getText());
  526. theQueryid("ALTER TABLE `mkrisele` auto_increment = " + (i));
  527. } catch (Exception ex) {
  528. }
  529. }
  530.  
  531. });
  532.  
  533. btnShow.addActionListener(new ActionListener() {
  534. // show data
  535. @Override
  536. public void actionPerformed(ActionEvent arg0) {
  537. // TODO Auto-generated method stub
  538. try {
  539. Connection con = DriverManager.getConnection("jdbc:mysql://localhost/students", "root", "");
  540. statement = con.createStatement();
  541. resultSet = statement.executeQuery("select * from mkrisele where ID =" + textField_8.getText());
  542. while (resultSet.next()) {
  543. String Itemname = resultSet.getString("Itemname");
  544. String Quantity = resultSet.getString("Quantity");
  545. String Customernam = resultSet.getString("Customername");
  546. String Auxsupp = resultSet.getString("Auxsupp");
  547. String NoofDisplays = resultSet.getString("NoofDisplays");
  548. String NoofSwitches = resultSet.getString("NoofSwitches");
  549. String NoofRelays = resultSet.getString("NoofRelays");
  550. String RS485 = resultSet.getString("RS485");
  551. String Analogop1 = resultSet.getString("Analogop1");
  552. String Analogop2 = resultSet.getString("Analogop2");
  553. String softver = resultSet.getString("softver");
  554. String d1 = resultSet.getString("d1");
  555. String d2 = resultSet.getString("d2");
  556. String d3 = resultSet.getString("d3");
  557. String d4 = resultSet.getString("d4");
  558. String d5 = resultSet.getString("d5");
  559. String d6 = resultSet.getString("d6");
  560. String d7 = resultSet.getString("d7");
  561. String d8 = resultSet.getString("d8");
  562.  
  563. textField.setText(Itemname);
  564. textField_1.setText(Quantity);
  565. textField_2.setText(Customernam);
  566. textField_3.setText(softver);
  567. comboBox.getModel().setSelectedItem(Auxsupp);
  568. comboBox_1.getModel().setSelectedItem(NoofDisplays);
  569. comboBox_2.getModel().setSelectedItem(NoofSwitches);
  570. comboBox_3.getModel().setSelectedItem(NoofRelays);
  571. comboBox_4.getModel().setSelectedItem(RS485);
  572. comboBox_5.getModel().setSelectedItem(Analogop1);
  573. comboBox_6.getModel().setSelectedItem(Analogop2);
  574. comboBox_7.getModel().setSelectedItem(d1);
  575. comboBox_8.getModel().setSelectedItem(d2);
  576. comboBox_9.getModel().setSelectedItem(d3);
  577. comboBox_12.getModel().setSelectedItem(d4);
  578. comboBox_10.getModel().setSelectedItem(d5);
  579. comboBox_13.getModel().setSelectedItem(d6);
  580. comboBox_11.getModel().setSelectedItem(d7);
  581. comboBox_15.getModel().setSelectedItem(d8);
  582.  
  583. }
  584. } catch (Exception e) {
  585. try {
  586. throw e;
  587. } catch (Exception e1) {
  588. // TODO Auto-generated catch block
  589. e1.printStackTrace();
  590. }
  591. }
  592.  
  593. }
  594.  
  595. });
  596.  
  597. btnUpdateExis.addActionListener(new ActionListener() {
  598. // update data
  599. @Override
  600. public void actionPerformed(ActionEvent arg0) {
  601. // TODO Auto-generated method stub
  602. try {
  603.  
  604. theQueryup("update mkrisele set DateModified = '" + new java.util.Date() + "',Itemname = '"
  605. + textField.getText() + "',Quantity = '" + textField_1.getText() + "',Customername = '"
  606. + textField_2.getText() + "',NoofDisplays = '" + comboBox_1.getSelectedItem().toString()
  607. + "',NoofSwitches = '" + comboBox_2.getSelectedItem().toString() + "',NoofRelays = '"
  608. + comboBox_3.getSelectedItem().toString() + "',RS485 = '"
  609. + comboBox_4.getSelectedItem().toString() + "',d1 = '"
  610. + comboBox_7.getSelectedItem().toString() + "',d2 = '"
  611. + comboBox_8.getSelectedItem().toString() + "',d3 = '"
  612. + comboBox_9.getSelectedItem().toString() + "',d4 = '"
  613. + comboBox_12.getSelectedItem().toString() + "',d5 = '"
  614. + comboBox_10.getSelectedItem().toString() + "',d6 = '"
  615. + comboBox_13.getSelectedItem().toString() + "',d7 = '"
  616. + comboBox_11.getSelectedItem().toString() + "',d8 = '"
  617. + comboBox_15.getSelectedItem().toString() + "' where ID = " + textField_8.getText());
  618. } catch (Exception ex) {
  619. throw ex;
  620. }
  621. if (comboBox.getSelectedItem().toString().equals("Other")) {
  622. try {
  623. theQuerys("update mkrisele set Auxsupp = '" + textField_4.getText() + "' where ID = "
  624. + textField_8.getText());
  625. } catch (Exception ex) {
  626. }
  627.  
  628. } else {
  629. try {
  630. theQuerys("update mkrisele set Auxsupp = '" + comboBox.getSelectedItem().toString()
  631. + "' where ID = " + textField_8.getText());
  632. } catch (Exception ex) {
  633. }
  634. }
  635. if (comboBox_5.getSelectedItem().toString().equals("Other")) {
  636. try {
  637. theQuerys("update mkrisele set Analogop1 = '" + textField_5.getText() + "' where ID = "
  638. + textField_8.getText());
  639. } catch (Exception ex) {
  640. }
  641. } else {
  642. try {
  643.  
  644. theQuerys("update mkrisele set Analogop1 = '" + comboBox_5.getSelectedItem().toString()
  645. + "' where ID = " + textField_8.getText());
  646. } catch (Exception ex) {
  647. }
  648. }
  649. if (comboBox_6.getSelectedItem().toString().equals("Other")) {
  650. try {
  651. theQuerys("update mkrisele set Analogop2 = '" + textField_7.getText() + "' where ID = "
  652. + textField_8.getText());
  653. } catch (Exception ex) {
  654. }
  655. } else {
  656. try {
  657.  
  658. theQuerys("update mkrisele set Analogop2 = '" + comboBox_6.getSelectedItem().toString()
  659. + "' where ID = " + textField_8.getText());
  660. } catch (Exception ex) {
  661. }
  662. }
  663. }
  664.  
  665. });
  666.  
  667. btnNewButton.addActionListener(new ActionListener() {
  668. // show table
  669. @Override
  670. public void actionPerformed(ActionEvent e) {
  671. // TODO Auto-generated method stub
  672. SearchResultLO sr = new SearchResultLO();
  673. sr.showTableData();
  674.  
  675. }
  676.  
  677. });
  678.  
  679. }
  680.  
  681. public void theQueryup(String query) {
  682. Connection con = null;
  683. Statement st = null;
  684. try {
  685. con = DriverManager.getConnection("jdbc:mysql://localhost/students", "root", "");
  686. st = con.createStatement();
  687. st.executeUpdate(query);
  688. JOptionPane.showMessageDialog(null, "Data Successfully updated to the database.");
  689.  
  690. } catch (Exception ex) {
  691. JOptionPane.showMessageDialog(null, ex.getMessage());
  692. }
  693. }
  694.  
  695. public void theQuerydel(String query) {
  696. Connection con = null;
  697. Statement st = null;
  698. try {
  699. con = DriverManager.getConnection("jdbc:mysql://localhost/students", "root", "");
  700. st = con.createStatement();
  701. st.executeUpdate(query);
  702. JOptionPane.showMessageDialog(null, "Data Successfully deleted to the database.");
  703.  
  704. } catch (Exception ex) {
  705. JOptionPane.showMessageDialog(null, ex.getMessage());
  706. }
  707. }
  708.  
  709. public void theQueryid(String query) {
  710. Connection con = null;
  711. Statement st = null;
  712. try {
  713. con = DriverManager.getConnection("jdbc:mysql://localhost/students", "root", "");
  714. st = con.createStatement();
  715. st.executeUpdate(query);
  716. } catch (Exception ex) {
  717. JOptionPane.showMessageDialog(null, ex.getMessage());
  718. }
  719.  
  720. }
  721.  
  722. public void theQuerys(String query) {
  723. Connection con = null;
  724. Statement st = null;
  725. try {
  726. con = DriverManager.getConnection("jdbc:mysql://localhost/students", "root", "");
  727. st = con.createStatement();
  728. st.executeUpdate(query);
  729. } catch (Exception ex) {
  730. JOptionPane.showMessageDialog(null, ex.getMessage());
  731. }
  732. }
  733.  
  734. public void theQuery(String query) {
  735. Connection con = null;
  736. Statement st = null;
  737. try {
  738. con = DriverManager.getConnection("jdbc:mysql://localhost/students", "root", "");
  739. st = con.createStatement();
  740. st.executeUpdate(query);
  741. JOptionPane.showMessageDialog(null, "Data Successfully added to the database.");
  742. } catch (Exception ex) {
  743. JOptionPane.showMessageDialog(null, ex.getMessage());
  744. }
  745.  
  746. }
  747.  
  748. public void close() {
  749. try {
  750. if (resultSet != null) {
  751. resultSet.close();
  752. }
  753.  
  754. if (statement != null) {
  755. statement.close();
  756. }
  757.  
  758. if (connect != null) {
  759. connect.close();
  760. }
  761. } catch (Exception e) {
  762.  
  763. }
  764. }
  765. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!