API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 27th, 2016
79
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 110.64 KB | None | 0 0
raw download clone embed print report
  1. /*
  2. * To change this license header, choose License Headers in Project Properties.
  3. * To change this template file, choose Tools | Templates
  4. * and open the template in the editor.
  5. */
  6. package tugas.besar.prolan;
  7. import java.awt.event.ActionEvent;
  8. import java.awt.event.ActionListener;
  9. import javax.swing.*;
  10. import java.sql.*;
  11. import java.text.SimpleDateFormat;
  12. import java.util.Date;
  13. /**
  14. *
  15. * @author Septian
  16. */
  17. public class FramePenjualan extends javax.swing.JFrame {
  18. koneksi dbsetting;
  19. String driver,database,user,pass;
  20. Object tabel;
  21. /**
  22. * Creates new form FormPenjualan
  23. */
  24. public FramePenjualan() {
  25. initComponents();
  26. dbsetting = new koneksi();
  27. driver = dbsetting.SettingPanel("DBDriver");
  28. database = dbsetting.SettingPanel("DBDatabase");
  29. user = dbsetting.SettingPanel("DBUsername");
  30. pass = dbsetting.SettingPanel("DBPassword");
  31. tabel_penjualan.setModel(tableModel);
  32. settableload();
  33. }
  34. private javax.swing.table.DefaultTableModel tableModel = getDefaultTabelModel();
  35. private javax.swing.table.DefaultTableModel getDefaultTabelModel()
  36. {
  37. //Membuat Judul Header
  38. return new javax.swing.table.DefaultTableModel
  39. (
  40. new Object[][]{},
  41. new String [] {"ID Penjualan",
  42. "Kode Pegawai",
  43. "Kode Barang",
  44. "Banyak",
  45. "Jumlah Harga",
  46. "Member",
  47. "Kode Member",
  48. "Diskon",
  49. "Total Harga",
  50. "Uang Dibayar",
  51. "Kembalian",
  52. "tanggal"}
  53. )
  54. //Disable perubahan pada grid
  55. {
  56. boolean[] canEdit = new boolean[]
  57. {
  58. false, false, false, false, false
  59. };
  60. public boolean isCellEditable(int rowIndex, int columnIndex)
  61. {
  62. return canEdit[columnIndex];
  63. }
  64. };
  65. }
  66. String data[]=new String[12];
  67. private void settableload()
  68. {
  69. String stat = "";
  70. try
  71. {
  72. Class.forName(driver);
  73. Connection kon = DriverManager.getConnection(database,user,pass);
  74.  
  75. Statement stt=kon.createStatement();
  76. String SQL = "select * from penjualan";
  77. ResultSet res = stt.executeQuery(SQL);
  78. while(res.next())
  79. {
  80. data[0] = res.getString(1);
  81. data[1] = res.getString(2);
  82. data[2] = res.getString(3);
  83. data[3] = res.getString(4);
  84. data[4] = res.getString(5);
  85. data[5] = res.getString(6);
  86. data[6] = res.getString(7);
  87. data[7] = res.getString(8);
  88. data[8] = res.getString(9);
  89. data[9] = res.getString(10);
  90. data[10] = res.getString(11);
  91. data[11] = res.getString(12);
  92. tableModel.addRow(data);
  93. }
  94. res.close();
  95. stt.close();
  96. kon.close();
  97. }
  98. catch(Exception ex)
  99. {
  100. System.err.println(ex.getMessage());
  101. JOptionPane.showMessageDialog(null, ex.getMessage(),"Error",JOptionPane.INFORMATION_MESSAGE);
  102. System.exit(0);
  103. }
  104. }
  105. /**
  106. * This method is called from within the constructor to initialize the form.
  107. * WARNING: Do NOT modify this code. The content of this method is always
  108. * regenerated by the Form Editor.
  109. */
  110. @SuppressWarnings("unchecked")
  111. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  112. private void initComponents() {
  113.  
  114. jTextField2 = new javax.swing.JTextField();
  115. jLabel1 = new javax.swing.JLabel();
  116. jButton1 = new javax.swing.JButton();
  117. jTabbedPane1 = new javax.swing.JTabbedPane();
  118. jPanel1 = new javax.swing.JPanel();
  119. jScrollPane1 = new javax.swing.JScrollPane();
  120. tabel_penjualan = new javax.swing.JTable();
  121. jPanel2 = new javax.swing.JPanel();
  122. jLabel2 = new javax.swing.JLabel();
  123. jLabel3 = new javax.swing.JLabel();
  124. jLabel4 = new javax.swing.JLabel();
  125. jLabel5 = new javax.swing.JLabel();
  126. txt_jual_nmbrg = new javax.swing.JLabel();
  127. jLabel7 = new javax.swing.JLabel();
  128. txt_jual_hrgbrg = new javax.swing.JLabel();
  129. jLabel9 = new javax.swing.JLabel();
  130. jCheckBox1 = new javax.swing.JCheckBox();
  131. jLabel10 = new javax.swing.JLabel();
  132. jLabel11 = new javax.swing.JLabel();
  133. jLabel12 = new javax.swing.JLabel();
  134. jLabel13 = new javax.swing.JLabel();
  135. jLabel14 = new javax.swing.JLabel();
  136. jLabel15 = new javax.swing.JLabel();
  137. jLabel16 = new javax.swing.JLabel();
  138. jLabel17 = new javax.swing.JLabel();
  139. txt_tmbh_kembalian = new javax.swing.JLabel();
  140. txt_tmbh_jual_kdpeg = new javax.swing.JTextField();
  141. cari_jual_kdpeg = new javax.swing.JButton();
  142. txt_tmbh_jual_kdbrg = new javax.swing.JTextField();
  143. cari_jual_kdbrg = new javax.swing.JButton();
  144. jLabel19 = new javax.swing.JLabel();
  145. txt_tmbh_uangbyr = new javax.swing.JTextField();
  146. txt_tmbh_jual_kdmem = new javax.swing.JTextField();
  147. cari_jual_kdmem = new javax.swing.JButton();
  148. txt_jual_bnyk_beli = new javax.swing.JTextField();
  149. txt_jual_nmpeg = new javax.swing.JLabel();
  150. txt_jual_nmmem = new javax.swing.JLabel();
  151. txt_jual_jnsmem = new javax.swing.JLabel();
  152. txt_jual_diskmem = new javax.swing.JLabel();
  153. txt_jual_hrgtot = new javax.swing.JLabel();
  154. btn_tmbh_penjualan = new javax.swing.JButton();
  155. btn_batal_tmbh = new javax.swing.JButton();
  156. jLabel6 = new javax.swing.JLabel();
  157. jLabel8 = new javax.swing.JLabel();
  158. jLabel18 = new javax.swing.JLabel();
  159. jLabel20 = new javax.swing.JLabel();
  160. jLabel21 = new javax.swing.JLabel();
  161. jLabel22 = new javax.swing.JLabel();
  162. jLabel23 = new javax.swing.JLabel();
  163. jLabel24 = new javax.swing.JLabel();
  164. jLabel78 = new javax.swing.JLabel();
  165. jPanel3 = new javax.swing.JPanel();
  166. jLabel25 = new javax.swing.JLabel();
  167. jLabel26 = new javax.swing.JLabel();
  168. jLabel27 = new javax.swing.JLabel();
  169. jLabel28 = new javax.swing.JLabel();
  170. jLabel29 = new javax.swing.JLabel();
  171. jLabel30 = new javax.swing.JLabel();
  172. jLabel31 = new javax.swing.JLabel();
  173. jLabel32 = new javax.swing.JLabel();
  174. jCheckBox2 = new javax.swing.JCheckBox();
  175. jLabel33 = new javax.swing.JLabel();
  176. jLabel34 = new javax.swing.JLabel();
  177. jLabel35 = new javax.swing.JLabel();
  178. jLabel36 = new javax.swing.JLabel();
  179. jLabel37 = new javax.swing.JLabel();
  180. jLabel38 = new javax.swing.JLabel();
  181. jLabel39 = new javax.swing.JLabel();
  182. jLabel40 = new javax.swing.JLabel();
  183. jLabel41 = new javax.swing.JLabel();
  184. jTextField7 = new javax.swing.JTextField();
  185. jButton5 = new javax.swing.JButton();
  186. jTextField8 = new javax.swing.JTextField();
  187. jButton6 = new javax.swing.JButton();
  188. jLabel42 = new javax.swing.JLabel();
  189. jTextField9 = new javax.swing.JTextField();
  190. jTextField10 = new javax.swing.JTextField();
  191. jButton7 = new javax.swing.JButton();
  192. jTextField11 = new javax.swing.JTextField();
  193. jLabel43 = new javax.swing.JLabel();
  194. jLabel44 = new javax.swing.JLabel();
  195. jLabel46 = new javax.swing.JLabel();
  196. jLabel47 = new javax.swing.JLabel();
  197. jLabel48 = new javax.swing.JLabel();
  198. jTextField12 = new javax.swing.JTextField();
  199. jButton8 = new javax.swing.JButton();
  200. jButton11 = new javax.swing.JButton();
  201. jButton13 = new javax.swing.JButton();
  202. jLabel86 = new javax.swing.JLabel();
  203. jLabel87 = new javax.swing.JLabel();
  204. jLabel88 = new javax.swing.JLabel();
  205. jLabel89 = new javax.swing.JLabel();
  206. jLabel45 = new javax.swing.JLabel();
  207. jLabel90 = new javax.swing.JLabel();
  208. jLabel91 = new javax.swing.JLabel();
  209. jLabel92 = new javax.swing.JLabel();
  210. jLabel93 = new javax.swing.JLabel();
  211. jLabel94 = new javax.swing.JLabel();
  212. jLabel95 = new javax.swing.JLabel();
  213. jLabel96 = new javax.swing.JLabel();
  214. jLabel97 = new javax.swing.JLabel();
  215. jPanel4 = new javax.swing.JPanel();
  216. jLabel49 = new javax.swing.JLabel();
  217. jLabel50 = new javax.swing.JLabel();
  218. jLabel51 = new javax.swing.JLabel();
  219. jLabel52 = new javax.swing.JLabel();
  220. jLabel54 = new javax.swing.JLabel();
  221. jLabel56 = new javax.swing.JLabel();
  222. jLabel57 = new javax.swing.JLabel();
  223. jLabel58 = new javax.swing.JLabel();
  224. jLabel59 = new javax.swing.JLabel();
  225. jLabel60 = new javax.swing.JLabel();
  226. jLabel61 = new javax.swing.JLabel();
  227. jLabel62 = new javax.swing.JLabel();
  228. jLabel63 = new javax.swing.JLabel();
  229. jLabel64 = new javax.swing.JLabel();
  230. jLabel65 = new javax.swing.JLabel();
  231. jLabel66 = new javax.swing.JLabel();
  232. jLabel67 = new javax.swing.JLabel();
  233. jLabel68 = new javax.swing.JLabel();
  234. jLabel69 = new javax.swing.JLabel();
  235. jLabel70 = new javax.swing.JLabel();
  236. jLabel71 = new javax.swing.JLabel();
  237. jLabel72 = new javax.swing.JLabel();
  238. txt_id_hapus = new javax.swing.JTextField();
  239. jButton12 = new javax.swing.JButton();
  240. jLabel53 = new javax.swing.JLabel();
  241. jLabel55 = new javax.swing.JLabel();
  242. jLabel73 = new javax.swing.JLabel();
  243. jLabel74 = new javax.swing.JLabel();
  244. jLabel75 = new javax.swing.JLabel();
  245. jLabel76 = new javax.swing.JLabel();
  246. jLabel77 = new javax.swing.JLabel();
  247. jButton9 = new javax.swing.JButton();
  248. jButton10 = new javax.swing.JButton();
  249. jLabel79 = new javax.swing.JLabel();
  250. jLabel80 = new javax.swing.JLabel();
  251. jLabel81 = new javax.swing.JLabel();
  252. jLabel82 = new javax.swing.JLabel();
  253. jLabel83 = new javax.swing.JLabel();
  254. jLabel84 = new javax.swing.JLabel();
  255. jLabel85 = new javax.swing.JLabel();
  256.  
  257. jTextField2.setText("jTextField2");
  258.  
  259. setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  260. setResizable(false);
  261. addWindowListener(new java.awt.event.WindowAdapter() {
  262. public void windowActivated(java.awt.event.WindowEvent evt) {
  263. formWindowActivated(evt);
  264. }
  265. });
  266.  
  267. jLabel1.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
  268. jLabel1.setText("PENJUALAN");
  269.  
  270. jButton1.setIcon(new javax.swing.ImageIcon(getClass().getResource("/tugas/besar/prolan/home.png"))); // NOI18N
  271. jButton1.setText("Kembali ke Dashboard");
  272. jButton1.setFocusPainted(false);
  273. jButton1.addActionListener(new java.awt.event.ActionListener() {
  274. public void actionPerformed(java.awt.event.ActionEvent evt) {
  275. jButton1ActionPerformed(evt);
  276. }
  277. });
  278.  
  279. jTabbedPane1.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  280.  
  281. tabel_penjualan.setModel(new javax.swing.table.DefaultTableModel(
  282. new Object [][] {
  283. {null, null, null, null},
  284. {null, null, null, null},
  285. {null, null, null, null},
  286. {null, null, null, null}
  287. },
  288. new String [] {
  289. "Title 1", "Title 2", "Title 3", "Title 4"
  290. }
  291. ));
  292. jScrollPane1.setViewportView(tabel_penjualan);
  293.  
  294. javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
  295. jPanel1.setLayout(jPanel1Layout);
  296. jPanel1Layout.setHorizontalGroup(
  297. jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  298. .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 1175, Short.MAX_VALUE)
  299. );
  300. jPanel1Layout.setVerticalGroup(
  301. jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  302. .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 484, Short.MAX_VALUE)
  303. );
  304.  
  305. jTabbedPane1.addTab("Tampil", jPanel1);
  306.  
  307. jLabel2.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  308. jLabel2.setText("Kode Pegawai");
  309.  
  310. jLabel3.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  311. jLabel3.setText("Nama Pegawai");
  312.  
  313. jLabel4.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  314. jLabel4.setText("Kode Barang");
  315.  
  316. jLabel5.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  317. jLabel5.setText("Nama Barang");
  318.  
  319. txt_jual_nmbrg.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  320.  
  321. jLabel7.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  322. jLabel7.setText("Harga Barang");
  323.  
  324. txt_jual_hrgbrg.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  325. txt_jual_hrgbrg.setText("Rp");
  326.  
  327. jLabel9.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  328. jLabel9.setText("Member");
  329.  
  330. jCheckBox1.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  331. jCheckBox1.setText("Ya");
  332. jCheckBox1.addActionListener(new java.awt.event.ActionListener() {
  333. public void actionPerformed(java.awt.event.ActionEvent evt) {
  334. jCheckBox1ActionPerformed(evt);
  335. }
  336. });
  337.  
  338. jLabel10.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  339. jLabel10.setText("Kode Member");
  340.  
  341. jLabel11.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  342. jLabel11.setText("Nama Member");
  343.  
  344. jLabel12.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  345. jLabel12.setText("Jenis Member");
  346.  
  347. jLabel13.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  348. jLabel13.setText("Diskon");
  349.  
  350. jLabel14.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  351. jLabel14.setText("Harga Total");
  352.  
  353. jLabel15.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  354. jLabel15.setText("Uang Dibayar");
  355.  
  356. jLabel16.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  357. jLabel16.setText("Rp");
  358.  
  359. jLabel17.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  360. jLabel17.setText("Kembalian");
  361.  
  362. txt_tmbh_kembalian.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  363. txt_tmbh_kembalian.setText("Rp");
  364.  
  365. cari_jual_kdpeg.setIcon(new javax.swing.ImageIcon(getClass().getResource("/tugas/besar/prolan/cari.png"))); // NOI18N
  366. cari_jual_kdpeg.addActionListener(new java.awt.event.ActionListener() {
  367. public void actionPerformed(java.awt.event.ActionEvent evt) {
  368. cari_jual_kdpegActionPerformed(evt);
  369. }
  370. });
  371.  
  372. cari_jual_kdbrg.setIcon(new javax.swing.ImageIcon(getClass().getResource("/tugas/besar/prolan/cari.png"))); // NOI18N
  373. cari_jual_kdbrg.addActionListener(new java.awt.event.ActionListener() {
  374. public void actionPerformed(java.awt.event.ActionEvent evt) {
  375. cari_jual_kdbrgActionPerformed(evt);
  376. }
  377. });
  378.  
  379. jLabel19.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  380. jLabel19.setText("Banyak Pembelian");
  381.  
  382. txt_tmbh_uangbyr.addFocusListener(new java.awt.event.FocusAdapter() {
  383. public void focusLost(java.awt.event.FocusEvent evt) {
  384. txt_tmbh_uangbyrFocusLost(evt);
  385. }
  386. });
  387. txt_tmbh_uangbyr.addInputMethodListener(new java.awt.event.InputMethodListener() {
  388. public void caretPositionChanged(java.awt.event.InputMethodEvent evt) {
  389. }
  390. public void inputMethodTextChanged(java.awt.event.InputMethodEvent evt) {
  391. txt_tmbh_uangbyrInputMethodTextChanged(evt);
  392. }
  393. });
  394.  
  395. cari_jual_kdmem.setIcon(new javax.swing.ImageIcon(getClass().getResource("/tugas/besar/prolan/cari.png"))); // NOI18N
  396. cari_jual_kdmem.addActionListener(new java.awt.event.ActionListener() {
  397. public void actionPerformed(java.awt.event.ActionEvent evt) {
  398. cari_jual_kdmemActionPerformed(evt);
  399. }
  400. });
  401.  
  402. txt_jual_bnyk_beli.addFocusListener(new java.awt.event.FocusAdapter() {
  403. public void focusLost(java.awt.event.FocusEvent evt) {
  404. txt_jual_bnyk_beliFocusLost(evt);
  405. }
  406. });
  407. txt_jual_bnyk_beli.addActionListener(new java.awt.event.ActionListener() {
  408. public void actionPerformed(java.awt.event.ActionEvent evt) {
  409. txt_jual_bnyk_beliActionPerformed(evt);
  410. }
  411. });
  412.  
  413. txt_jual_nmpeg.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  414.  
  415. txt_jual_nmmem.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  416.  
  417. txt_jual_jnsmem.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  418.  
  419. txt_jual_diskmem.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  420. txt_jual_diskmem.setText("%");
  421.  
  422. txt_jual_hrgtot.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  423. txt_jual_hrgtot.setText("Rp");
  424.  
  425. btn_tmbh_penjualan.setText("Tambah Penjualan");
  426. btn_tmbh_penjualan.addActionListener(new java.awt.event.ActionListener() {
  427. public void actionPerformed(java.awt.event.ActionEvent evt) {
  428. btn_tmbh_penjualanActionPerformed(evt);
  429. }
  430. });
  431.  
  432. btn_batal_tmbh.setText("Batal");
  433.  
  434. jLabel6.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  435.  
  436. jLabel8.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  437.  
  438. jLabel18.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  439. jLabel18.setText("0");
  440.  
  441. jLabel20.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  442. jLabel20.setText("(Setelah Diskon: Rp");
  443.  
  444. jLabel21.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  445. jLabel21.setText(")");
  446.  
  447. jLabel22.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  448.  
  449. jLabel23.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  450. jLabel23.setText("Rp");
  451.  
  452. jLabel24.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  453. jLabel24.setText("0");
  454.  
  455. jLabel78.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  456.  
  457. javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
  458. jPanel2.setLayout(jPanel2Layout);
  459. jPanel2Layout.setHorizontalGroup(
  460. jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  461. .addGroup(jPanel2Layout.createSequentialGroup()
  462. .addContainerGap()
  463. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  464. .addGroup(jPanel2Layout.createSequentialGroup()
  465. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  466. .addGroup(jPanel2Layout.createSequentialGroup()
  467. .addComponent(jLabel19)
  468. .addGap(10, 10, 10)
  469. .addComponent(txt_jual_bnyk_beli))
  470. .addGroup(jPanel2Layout.createSequentialGroup()
  471. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  472. .addComponent(jLabel4)
  473. .addComponent(jLabel2)
  474. .addComponent(jLabel3))
  475. .addGap(32, 32, 32)
  476. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  477. .addGroup(jPanel2Layout.createSequentialGroup()
  478. .addComponent(txt_jual_nmpeg)
  479. .addGap(0, 0, Short.MAX_VALUE))
  480. .addGroup(jPanel2Layout.createSequentialGroup()
  481. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  482. .addComponent(txt_tmbh_jual_kdpeg)
  483. .addComponent(txt_tmbh_jual_kdbrg))
  484. .addGap(18, 18, 18)
  485. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  486. .addComponent(cari_jual_kdpeg)
  487. .addComponent(cari_jual_kdbrg, javax.swing.GroupLayout.Alignment.TRAILING)))))
  488. .addGroup(jPanel2Layout.createSequentialGroup()
  489. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  490. .addGroup(jPanel2Layout.createSequentialGroup()
  491. .addComponent(jLabel9)
  492. .addGap(71, 71, 71)
  493. .addComponent(jCheckBox1))
  494. .addComponent(jLabel15)
  495. .addComponent(jLabel17)
  496. .addGroup(jPanel2Layout.createSequentialGroup()
  497. .addComponent(jLabel5)
  498. .addGap(38, 38, 38)
  499. .addComponent(txt_jual_nmbrg))
  500. .addGroup(jPanel2Layout.createSequentialGroup()
  501. .addComponent(jLabel7)
  502. .addGap(37, 37, 37)
  503. .addComponent(txt_jual_hrgbrg)
  504. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  505. .addComponent(jLabel6)))
  506. .addGap(0, 0, Short.MAX_VALUE)))
  507. .addContainerGap())
  508. .addGroup(jPanel2Layout.createSequentialGroup()
  509. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  510. .addComponent(jLabel10)
  511. .addComponent(jLabel12)
  512. .addComponent(jLabel11)
  513. .addComponent(jLabel13)
  514. .addComponent(jLabel14))
  515. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  516. .addGroup(jPanel2Layout.createSequentialGroup()
  517. .addGap(19, 19, 19)
  518. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  519. .addGroup(jPanel2Layout.createSequentialGroup()
  520. .addGap(13, 13, 13)
  521. .addComponent(txt_tmbh_jual_kdmem)
  522. .addGap(18, 18, 18)
  523. .addComponent(cari_jual_kdmem))
  524. .addGroup(jPanel2Layout.createSequentialGroup()
  525. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  526. .addGroup(jPanel2Layout.createSequentialGroup()
  527. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  528. .addComponent(txt_jual_jnsmem)
  529. .addComponent(txt_jual_nmmem)
  530. .addGroup(jPanel2Layout.createSequentialGroup()
  531. .addComponent(jLabel16)
  532. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  533. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  534. .addComponent(txt_tmbh_uangbyr, javax.swing.GroupLayout.PREFERRED_SIZE, 227, javax.swing.GroupLayout.PREFERRED_SIZE)
  535. .addGroup(jPanel2Layout.createSequentialGroup()
  536. .addComponent(btn_tmbh_penjualan)
  537. .addGap(18, 18, 18)
  538. .addComponent(btn_batal_tmbh))))
  539. .addGroup(jPanel2Layout.createSequentialGroup()
  540. .addComponent(txt_tmbh_kembalian)
  541. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  542. .addComponent(jLabel78)))
  543. .addGap(0, 0, Short.MAX_VALUE))
  544. .addGroup(jPanel2Layout.createSequentialGroup()
  545. .addComponent(txt_jual_hrgtot)
  546. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  547. .addComponent(jLabel8)
  548. .addGap(121, 121, 121)
  549. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  550. .addGroup(jPanel2Layout.createSequentialGroup()
  551. .addComponent(jLabel23)
  552. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  553. .addComponent(jLabel24)
  554. .addGap(0, 0, Short.MAX_VALUE))
  555. .addGroup(jPanel2Layout.createSequentialGroup()
  556. .addComponent(jLabel20)
  557. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  558. .addComponent(jLabel22)
  559. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 769, Short.MAX_VALUE)
  560. .addComponent(jLabel21)))))
  561. .addContainerGap())))
  562. .addGroup(jPanel2Layout.createSequentialGroup()
  563. .addGap(16, 16, 16)
  564. .addComponent(jLabel18)
  565. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  566. .addComponent(txt_jual_diskmem)
  567. .addGap(0, 0, Short.MAX_VALUE))))))
  568. );
  569. jPanel2Layout.setVerticalGroup(
  570. jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  571. .addGroup(jPanel2Layout.createSequentialGroup()
  572. .addContainerGap()
  573. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  574. .addComponent(cari_jual_kdpeg)
  575. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  576. .addComponent(jLabel2)
  577. .addComponent(txt_tmbh_jual_kdpeg, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
  578. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  579. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  580. .addComponent(jLabel3)
  581. .addComponent(txt_jual_nmpeg))
  582. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  583. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  584. .addComponent(jLabel4)
  585. .addComponent(txt_tmbh_jual_kdbrg, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  586. .addComponent(cari_jual_kdbrg))
  587. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  588. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  589. .addGroup(jPanel2Layout.createSequentialGroup()
  590. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  591. .addComponent(jLabel5)
  592. .addComponent(txt_jual_nmbrg))
  593. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  594. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  595. .addComponent(jLabel7)
  596. .addComponent(txt_jual_hrgbrg)
  597. .addComponent(jLabel6))
  598. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  599. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  600. .addComponent(jLabel19)
  601. .addComponent(txt_jual_bnyk_beli, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  602. .addGap(7, 7, 7)
  603. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  604. .addComponent(jLabel9)
  605. .addComponent(jCheckBox1))
  606. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  607. .addComponent(jLabel10))
  608. .addComponent(cari_jual_kdmem)
  609. .addComponent(txt_tmbh_jual_kdmem, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  610. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  611. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  612. .addGroup(jPanel2Layout.createSequentialGroup()
  613. .addComponent(jLabel11)
  614. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  615. .addComponent(jLabel12))
  616. .addGroup(jPanel2Layout.createSequentialGroup()
  617. .addComponent(txt_jual_nmmem)
  618. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  619. .addComponent(txt_jual_jnsmem)))
  620. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  621. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  622. .addComponent(txt_jual_diskmem)
  623. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  624. .addComponent(jLabel13)
  625. .addComponent(jLabel18)
  626. .addComponent(jLabel23)
  627. .addComponent(jLabel24)))
  628. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  629. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  630. .addComponent(jLabel14)
  631. .addComponent(txt_jual_hrgtot)
  632. .addComponent(jLabel8)
  633. .addComponent(jLabel20)
  634. .addComponent(jLabel21)
  635. .addComponent(jLabel22))
  636. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  637. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  638. .addComponent(jLabel15)
  639. .addComponent(jLabel16)
  640. .addComponent(txt_tmbh_uangbyr, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  641. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  642. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  643. .addComponent(jLabel17)
  644. .addComponent(txt_tmbh_kembalian)
  645. .addComponent(jLabel78))
  646. .addGap(18, 18, 18)
  647. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  648. .addComponent(btn_tmbh_penjualan)
  649. .addComponent(btn_batal_tmbh))
  650. .addContainerGap(43, Short.MAX_VALUE))
  651. );
  652.  
  653. jTabbedPane1.addTab("Tambah", jPanel2);
  654.  
  655. jLabel25.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  656. jLabel25.setText("Kode Pegawai");
  657.  
  658. jLabel26.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  659. jLabel26.setText("Nama Pegawai");
  660.  
  661. jLabel27.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  662. jLabel27.setText("Kode Barang");
  663.  
  664. jLabel28.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  665. jLabel28.setText("Nama Barang");
  666.  
  667. jLabel29.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  668.  
  669. jLabel30.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  670. jLabel30.setText("Harga Barang");
  671.  
  672. jLabel31.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  673. jLabel31.setText("Rp");
  674.  
  675. jLabel32.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  676. jLabel32.setText("Member");
  677.  
  678. jCheckBox2.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  679. jCheckBox2.setText("Ya");
  680. jCheckBox2.addActionListener(new java.awt.event.ActionListener() {
  681. public void actionPerformed(java.awt.event.ActionEvent evt) {
  682. jCheckBox2ActionPerformed(evt);
  683. }
  684. });
  685.  
  686. jLabel33.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  687. jLabel33.setText("Kode Member");
  688.  
  689. jLabel34.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  690. jLabel34.setText("Nama Member");
  691.  
  692. jLabel35.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  693. jLabel35.setText("Jenis Member");
  694.  
  695. jLabel36.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  696. jLabel36.setText("Diskon");
  697.  
  698. jLabel37.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  699. jLabel37.setText("Harga Total");
  700.  
  701. jLabel38.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  702. jLabel38.setText("Uang Dibayar");
  703.  
  704. jLabel39.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  705. jLabel39.setText("Rp");
  706.  
  707. jLabel40.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  708. jLabel40.setText("Kembalian");
  709.  
  710. jLabel41.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  711. jLabel41.setText("Rp");
  712.  
  713. jButton5.setIcon(new javax.swing.ImageIcon(getClass().getResource("/tugas/besar/prolan/cari.png"))); // NOI18N
  714. jButton5.addActionListener(new java.awt.event.ActionListener() {
  715. public void actionPerformed(java.awt.event.ActionEvent evt) {
  716. jButton5ActionPerformed(evt);
  717. }
  718. });
  719.  
  720. jButton6.setIcon(new javax.swing.ImageIcon(getClass().getResource("/tugas/besar/prolan/cari.png"))); // NOI18N
  721. jButton6.addActionListener(new java.awt.event.ActionListener() {
  722. public void actionPerformed(java.awt.event.ActionEvent evt) {
  723. jButton6ActionPerformed(evt);
  724. }
  725. });
  726.  
  727. jLabel42.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  728. jLabel42.setText("Banyak Pembelian");
  729.  
  730. jTextField9.addFocusListener(new java.awt.event.FocusAdapter() {
  731. public void focusLost(java.awt.event.FocusEvent evt) {
  732. jTextField9FocusLost(evt);
  733. }
  734. });
  735. jTextField9.addActionListener(new java.awt.event.ActionListener() {
  736. public void actionPerformed(java.awt.event.ActionEvent evt) {
  737. jTextField9ActionPerformed(evt);
  738. }
  739. });
  740.  
  741. jButton7.setIcon(new javax.swing.ImageIcon(getClass().getResource("/tugas/besar/prolan/cari.png"))); // NOI18N
  742. jButton7.addActionListener(new java.awt.event.ActionListener() {
  743. public void actionPerformed(java.awt.event.ActionEvent evt) {
  744. jButton7ActionPerformed(evt);
  745. }
  746. });
  747.  
  748. jTextField11.addFocusListener(new java.awt.event.FocusAdapter() {
  749. public void focusLost(java.awt.event.FocusEvent evt) {
  750. jTextField11FocusLost(evt);
  751. }
  752. });
  753. jTextField11.addActionListener(new java.awt.event.ActionListener() {
  754. public void actionPerformed(java.awt.event.ActionEvent evt) {
  755. jTextField11ActionPerformed(evt);
  756. }
  757. });
  758.  
  759. jLabel43.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  760.  
  761. jLabel44.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  762.  
  763. jLabel46.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  764. jLabel46.setText("%");
  765.  
  766. jLabel47.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  767. jLabel47.setText("Rp");
  768.  
  769. jLabel48.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  770. jLabel48.setText("ID Penjualan");
  771.  
  772. jButton8.setIcon(new javax.swing.ImageIcon(getClass().getResource("/tugas/besar/prolan/cari.png"))); // NOI18N
  773. jButton8.addActionListener(new java.awt.event.ActionListener() {
  774. public void actionPerformed(java.awt.event.ActionEvent evt) {
  775. jButton8ActionPerformed(evt);
  776. }
  777. });
  778.  
  779. jButton11.setText("Ubah Penjualan");
  780.  
  781. jButton13.setText("Batal");
  782.  
  783. jLabel86.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  784. jLabel86.setText("jLabel86");
  785.  
  786. jLabel87.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  787. jLabel87.setText("jLabel87");
  788.  
  789. jLabel88.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  790. jLabel88.setText("jLabel88");
  791.  
  792. jLabel89.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  793. jLabel89.setText("jLabel89");
  794.  
  795. jLabel45.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  796. jLabel45.setText("jLabel45");
  797.  
  798. jLabel90.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  799. jLabel90.setText("jLabel90");
  800.  
  801. jLabel91.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  802. jLabel91.setText("jLabel91");
  803.  
  804. jLabel92.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  805. jLabel92.setText("jLabel92");
  806.  
  807. jLabel93.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  808. jLabel93.setText("Rp");
  809.  
  810. jLabel94.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  811. jLabel94.setText("0");
  812.  
  813. jLabel95.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  814. jLabel95.setText("(Setelah Diskon: Rp");
  815.  
  816. jLabel96.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  817. jLabel96.setText("jLabel96");
  818.  
  819. jLabel97.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  820. jLabel97.setText(")");
  821.  
  822. javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3);
  823. jPanel3.setLayout(jPanel3Layout);
  824. jPanel3Layout.setHorizontalGroup(
  825. jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  826. .addGroup(jPanel3Layout.createSequentialGroup()
  827. .addContainerGap()
  828. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  829. .addGroup(jPanel3Layout.createSequentialGroup()
  830. .addComponent(jLabel42)
  831. .addGap(10, 10, 10)
  832. .addComponent(jTextField11))
  833. .addGroup(jPanel3Layout.createSequentialGroup()
  834. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  835. .addComponent(jLabel27)
  836. .addComponent(jLabel26))
  837. .addGap(32, 32, 32)
  838. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  839. .addGroup(jPanel3Layout.createSequentialGroup()
  840. .addComponent(jTextField8)
  841. .addGap(18, 18, 18)
  842. .addComponent(jButton6))
  843. .addGroup(jPanel3Layout.createSequentialGroup()
  844. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  845. .addComponent(jLabel43)
  846. .addComponent(jLabel86))
  847. .addGap(0, 0, Short.MAX_VALUE))))
  848. .addGroup(jPanel3Layout.createSequentialGroup()
  849. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  850. .addComponent(jLabel33)
  851. .addComponent(jLabel35)
  852. .addComponent(jLabel34)
  853. .addComponent(jLabel36)
  854. .addComponent(jLabel37))
  855. .addGap(32, 32, 32)
  856. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  857. .addGroup(jPanel3Layout.createSequentialGroup()
  858. .addComponent(jTextField10)
  859. .addGap(18, 18, 18)
  860. .addComponent(jButton7))
  861. .addGroup(jPanel3Layout.createSequentialGroup()
  862. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  863. .addGroup(jPanel3Layout.createSequentialGroup()
  864. .addComponent(jButton11)
  865. .addGap(18, 18, 18)
  866. .addComponent(jButton13))
  867. .addGroup(jPanel3Layout.createSequentialGroup()
  868. .addGap(6, 6, 6)
  869. .addComponent(jLabel44))
  870. .addGroup(jPanel3Layout.createSequentialGroup()
  871. .addComponent(jLabel39)
  872. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  873. .addComponent(jTextField9, javax.swing.GroupLayout.PREFERRED_SIZE, 227, javax.swing.GroupLayout.PREFERRED_SIZE))
  874. .addComponent(jLabel89)
  875. .addGroup(jPanel3Layout.createSequentialGroup()
  876. .addComponent(jLabel90)
  877. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  878. .addComponent(jLabel46)
  879. .addGap(18, 18, 18)
  880. .addComponent(jLabel93)
  881. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  882. .addComponent(jLabel94))
  883. .addComponent(jLabel45))
  884. .addGap(0, 0, Short.MAX_VALUE))
  885. .addGroup(jPanel3Layout.createSequentialGroup()
  886. .addComponent(jLabel47)
  887. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  888. .addComponent(jLabel91)
  889. .addGap(66, 66, 66)
  890. .addComponent(jLabel95)
  891. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  892. .addComponent(jLabel96)
  893. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 713, Short.MAX_VALUE)
  894. .addComponent(jLabel97))))
  895. .addGroup(jPanel3Layout.createSequentialGroup()
  896. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  897. .addComponent(jLabel48)
  898. .addComponent(jLabel25))
  899. .addGap(36, 36, 36)
  900. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  901. .addGroup(jPanel3Layout.createSequentialGroup()
  902. .addComponent(jTextField7)
  903. .addGap(18, 18, 18)
  904. .addComponent(jButton5))
  905. .addGroup(jPanel3Layout.createSequentialGroup()
  906. .addComponent(jTextField12)
  907. .addGap(18, 18, 18)
  908. .addComponent(jButton8))))
  909. .addGroup(jPanel3Layout.createSequentialGroup()
  910. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  911. .addGroup(jPanel3Layout.createSequentialGroup()
  912. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  913. .addComponent(jLabel38)
  914. .addComponent(jLabel40))
  915. .addGap(37, 37, 37)
  916. .addComponent(jLabel41)
  917. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  918. .addComponent(jLabel92))
  919. .addGroup(jPanel3Layout.createSequentialGroup()
  920. .addComponent(jLabel32)
  921. .addGap(71, 71, 71)
  922. .addComponent(jCheckBox2))
  923. .addGroup(jPanel3Layout.createSequentialGroup()
  924. .addComponent(jLabel28)
  925. .addGap(38, 38, 38)
  926. .addComponent(jLabel87)
  927. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  928. .addComponent(jLabel29))
  929. .addGroup(jPanel3Layout.createSequentialGroup()
  930. .addComponent(jLabel30)
  931. .addGap(37, 37, 37)
  932. .addComponent(jLabel31)
  933. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  934. .addComponent(jLabel88)))
  935. .addGap(0, 0, Short.MAX_VALUE)))
  936. .addContainerGap())
  937. );
  938. jPanel3Layout.setVerticalGroup(
  939. jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  940. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel3Layout.createSequentialGroup()
  941. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  942. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  943. .addComponent(jButton8)
  944. .addComponent(jTextField12, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  945. .addComponent(jLabel48))
  946. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  947. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  948. .addComponent(jButton5)
  949. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  950. .addComponent(jLabel25)
  951. .addComponent(jTextField7, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
  952. .addGap(11, 11, 11)
  953. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  954. .addComponent(jLabel26)
  955. .addComponent(jLabel43)
  956. .addComponent(jLabel86))
  957. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  958. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  959. .addComponent(jLabel27)
  960. .addComponent(jTextField8, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  961. .addComponent(jButton6))
  962. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  963. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  964. .addGroup(jPanel3Layout.createSequentialGroup()
  965. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  966. .addComponent(jLabel28)
  967. .addComponent(jLabel29)
  968. .addComponent(jLabel87))
  969. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  970. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  971. .addComponent(jLabel30)
  972. .addComponent(jLabel31)
  973. .addComponent(jLabel88))
  974. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  975. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  976. .addComponent(jLabel42)
  977. .addComponent(jTextField11, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  978. .addGap(7, 7, 7)
  979. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  980. .addComponent(jLabel32)
  981. .addComponent(jCheckBox2))
  982. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  983. .addComponent(jLabel33))
  984. .addComponent(jTextField10, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  985. .addComponent(jButton7))
  986. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  987. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  988. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  989. .addComponent(jLabel34)
  990. .addComponent(jLabel89))
  991. .addComponent(jLabel44))
  992. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  993. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  994. .addComponent(jLabel35)
  995. .addComponent(jLabel45))
  996. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  997. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  998. .addComponent(jLabel46)
  999. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  1000. .addComponent(jLabel36)
  1001. .addComponent(jLabel90)
  1002. .addComponent(jLabel93)
  1003. .addComponent(jLabel94)))
  1004. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  1005. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  1006. .addComponent(jLabel37)
  1007. .addComponent(jLabel47)
  1008. .addComponent(jLabel91)
  1009. .addComponent(jLabel95)
  1010. .addComponent(jLabel96)
  1011. .addComponent(jLabel97))
  1012. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  1013. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  1014. .addComponent(jLabel38)
  1015. .addComponent(jLabel39)
  1016. .addComponent(jTextField9, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  1017. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  1018. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  1019. .addComponent(jLabel40)
  1020. .addComponent(jLabel41)
  1021. .addComponent(jLabel92))
  1022. .addGap(16, 16, 16)
  1023. .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  1024. .addComponent(jButton11)
  1025. .addComponent(jButton13))
  1026. .addContainerGap())
  1027. );
  1028.  
  1029. jTabbedPane1.addTab("Ubah", jPanel3);
  1030.  
  1031. jLabel49.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1032. jLabel49.setText("Kode Pegawai");
  1033.  
  1034. jLabel50.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1035. jLabel50.setText("Nama Pegawai");
  1036.  
  1037. jLabel51.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1038. jLabel51.setText("Kode Barang");
  1039.  
  1040. jLabel52.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1041. jLabel52.setText("Nama Barang");
  1042.  
  1043. jLabel54.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1044. jLabel54.setText("Harga Barang");
  1045.  
  1046. jLabel56.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1047. jLabel56.setText("Member");
  1048.  
  1049. jLabel57.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1050. jLabel57.setText("Kode Member");
  1051.  
  1052. jLabel58.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1053. jLabel58.setText("Nama Member");
  1054.  
  1055. jLabel59.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1056. jLabel59.setText("Jenis Member");
  1057.  
  1058. jLabel60.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1059. jLabel60.setText("Diskon");
  1060.  
  1061. jLabel61.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1062. jLabel61.setText("Harga Total");
  1063.  
  1064. jLabel62.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1065. jLabel62.setText("Uang Dibayar");
  1066.  
  1067. jLabel63.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1068. jLabel63.setText("Rp");
  1069.  
  1070. jLabel64.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1071. jLabel64.setText("Kembalian");
  1072.  
  1073. jLabel65.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1074. jLabel65.setText("Rp");
  1075.  
  1076. jLabel66.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1077. jLabel66.setText("Banyak Pembelian");
  1078.  
  1079. jLabel67.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1080. jLabel67.setToolTipText("");
  1081.  
  1082. jLabel68.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1083.  
  1084. jLabel69.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1085.  
  1086. jLabel70.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1087. jLabel70.setText("Rp");
  1088.  
  1089. jLabel71.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1090. jLabel71.setText("Rp");
  1091.  
  1092. jLabel72.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1093. jLabel72.setText("ID Penjualan");
  1094.  
  1095. jButton12.setIcon(new javax.swing.ImageIcon(getClass().getResource("/tugas/besar/prolan/cari.png"))); // NOI18N
  1096. jButton12.addActionListener(new java.awt.event.ActionListener() {
  1097. public void actionPerformed(java.awt.event.ActionEvent evt) {
  1098. jButton12ActionPerformed(evt);
  1099. }
  1100. });
  1101.  
  1102. jLabel53.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1103. jLabel53.setText("-");
  1104.  
  1105. jLabel55.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1106. jLabel55.setText("-");
  1107.  
  1108. jLabel73.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1109. jLabel73.setText("-");
  1110.  
  1111. jLabel74.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1112. jLabel74.setText("-");
  1113.  
  1114. jLabel75.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1115. jLabel75.setText("-");
  1116.  
  1117. jLabel76.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1118. jLabel76.setText("-");
  1119.  
  1120. jLabel77.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1121. jLabel77.setText("-");
  1122.  
  1123. jButton9.setText("Hapus Penjualan");
  1124. jButton9.addActionListener(new java.awt.event.ActionListener() {
  1125. public void actionPerformed(java.awt.event.ActionEvent evt) {
  1126. jButton9ActionPerformed(evt);
  1127. }
  1128. });
  1129.  
  1130. jButton10.setText("Batal");
  1131.  
  1132. jLabel79.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1133. jLabel79.setText("-");
  1134.  
  1135. jLabel80.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1136. jLabel80.setText("-");
  1137.  
  1138. jLabel81.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1139. jLabel81.setText("-");
  1140.  
  1141. jLabel82.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1142. jLabel82.setText("-");
  1143.  
  1144. jLabel83.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1145. jLabel83.setText("-");
  1146.  
  1147. jLabel84.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1148. jLabel84.setText("-");
  1149.  
  1150. jLabel85.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
  1151. jLabel85.setText("-");
  1152.  
  1153. javax.swing.GroupLayout jPanel4Layout = new javax.swing.GroupLayout(jPanel4);
  1154. jPanel4.setLayout(jPanel4Layout);
  1155. jPanel4Layout.setHorizontalGroup(
  1156. jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  1157. .addGroup(jPanel4Layout.createSequentialGroup()
  1158. .addContainerGap()
  1159. .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  1160. .addGroup(jPanel4Layout.createSequentialGroup()
  1161. .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  1162. .addComponent(jLabel72)
  1163. .addComponent(jLabel49))
  1164. .addGap(36, 36, 36)
  1165. .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  1166. .addGroup(jPanel4Layout.createSequentialGroup()
  1167. .addComponent(txt_id_hapus)
  1168. .addGap(18, 18, 18)
  1169. .addComponent(jButton12))
  1170. .addGroup(jPanel4Layout.createSequentialGroup()
  1171. .addComponent(jLabel53)
  1172. .addGap(0, 0, Short.MAX_VALUE))))
  1173. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel4Layout.createSequentialGroup()
  1174. .addGap(269, 269, 269)
  1175. .addComponent(jButton9)
  1176. .addGap(18, 18, 18)
  1177. .addComponent(jButton10)
  1178. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 708, Short.MAX_VALUE))
  1179. .addGroup(jPanel4Layout.createSequentialGroup()
  1180. .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  1181. .addGroup(jPanel4Layout.createSequentialGroup()
  1182. .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  1183. .addComponent(jLabel51)
  1184. .addComponent(jLabel50)
  1185. .addComponent(jLabel52)
  1186. .addComponent(jLabel54))
  1187. .addGap(32, 32, 32)
  1188. .addComponent(jLabel79)
  1189. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  1190. .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  1191. .addComponent(jLabel73)
  1192. .addComponent(jLabel67)
  1193. .addComponent(jLabel55)
  1194. .addComponent(jLabel74)))
  1195. .addGroup(jPanel4Layout.createSequentialGroup()
  1196. .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  1197. .addComponent(jLabel66)
  1198. .addComponent(jLabel56))
  1199. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  1200. .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  1201. .addComponent(jLabel76)
  1202. .addComponent(jLabel75)))
  1203. .addGroup(jPanel4Layout.createSequentialGroup()
  1204. .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  1205. .addGroup(jPanel4Layout.createSequentialGroup()
  1206. .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  1207. .addComponent(jLabel57)
  1208. .addComponent(jLabel59)
  1209. .addComponent(jLabel58)
  1210. .addComponent(jLabel60)
  1211. .addComponent(jLabel61))
  1212. .addGap(32, 32, 32)
  1213. .addComponent(jLabel69))
  1214. .addComponent(jLabel62)
  1215. .addComponent(jLabel64))
  1216. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  1217. .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  1218. .addGroup(jPanel4Layout.createSequentialGroup()
  1219. .addComponent(jLabel65)
  1220. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  1221. .addComponent(jLabel85))
  1222. .addComponent(jLabel68)
  1223. .addGroup(jPanel4Layout.createSequentialGroup()
  1224. .addComponent(jLabel63)
  1225. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  1226. .addComponent(jLabel84))
  1227. .addComponent(jLabel77)
  1228. .addComponent(jLabel80)
  1229. .addComponent(jLabel81)
  1230. .addGroup(jPanel4Layout.createSequentialGroup()
  1231. .addComponent(jLabel70)
  1232. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  1233. .addComponent(jLabel82))
  1234. .addGroup(jPanel4Layout.createSequentialGroup()
  1235. .addComponent(jLabel71)
  1236. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  1237. .addComponent(jLabel83)))))
  1238. .addGap(0, 0, Short.MAX_VALUE)))
  1239. .addContainerGap())
  1240. );
  1241. jPanel4Layout.setVerticalGroup(
  1242. jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  1243. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel4Layout.createSequentialGroup()
  1244. .addContainerGap(21, Short.MAX_VALUE)
  1245. .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  1246. .addComponent(jButton12)
  1247. .addComponent(txt_id_hapus, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  1248. .addComponent(jLabel72))
  1249. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  1250. .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  1251. .addComponent(jLabel49)
  1252. .addComponent(jLabel53))
  1253. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  1254. .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  1255. .addComponent(jLabel50)
  1256. .addComponent(jLabel67)
  1257. .addComponent(jLabel79))
  1258. .addGap(12, 12, 12)
  1259. .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  1260. .addComponent(jLabel51)
  1261. .addComponent(jLabel55))
  1262. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  1263. .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  1264. .addComponent(jLabel52)
  1265. .addComponent(jLabel73))
  1266. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  1267. .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  1268. .addComponent(jLabel54)
  1269. .addComponent(jLabel74))
  1270. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  1271. .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  1272. .addComponent(jLabel66)
  1273. .addComponent(jLabel75))
  1274. .addGap(14, 14, 14)
  1275. .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  1276. .addComponent(jLabel56)
  1277. .addComponent(jLabel76))
  1278. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  1279. .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  1280. .addComponent(jLabel57)
  1281. .addComponent(jLabel77))
  1282. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  1283. .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  1284. .addGroup(jPanel4Layout.createSequentialGroup()
  1285. .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  1286. .addComponent(jLabel58)
  1287. .addComponent(jLabel80))
  1288. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  1289. .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  1290. .addComponent(jLabel59)
  1291. .addComponent(jLabel81)))
  1292. .addGroup(jPanel4Layout.createSequentialGroup()
  1293. .addComponent(jLabel68)
  1294. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  1295. .addComponent(jLabel69)))
  1296. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  1297. .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  1298. .addComponent(jLabel60)
  1299. .addComponent(jLabel82)
  1300. .addComponent(jLabel70))
  1301. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  1302. .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  1303. .addComponent(jLabel61)
  1304. .addComponent(jLabel71)
  1305. .addComponent(jLabel83))
  1306. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  1307. .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  1308. .addComponent(jLabel62)
  1309. .addComponent(jLabel63)
  1310. .addComponent(jLabel84))
  1311. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  1312. .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  1313. .addComponent(jLabel64)
  1314. .addComponent(jLabel65)
  1315. .addComponent(jLabel85))
  1316. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  1317. .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  1318. .addComponent(jButton9)
  1319. .addComponent(jButton10))
  1320. .addGap(15, 15, 15))
  1321. );
  1322.  
  1323. jTabbedPane1.addTab("Hapus", jPanel4);
  1324.  
  1325. javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  1326. getContentPane().setLayout(layout);
  1327. layout.setHorizontalGroup(
  1328. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  1329. .addGroup(layout.createSequentialGroup()
  1330. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  1331. .addComponent(jLabel1)
  1332. .addGap(369, 369, 369)
  1333. .addComponent(jButton1)
  1334. .addContainerGap())
  1335. .addGroup(layout.createSequentialGroup()
  1336. .addComponent(jTabbedPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 1180, javax.swing.GroupLayout.PREFERRED_SIZE)
  1337. .addGap(0, 0, Short.MAX_VALUE))
  1338. );
  1339. layout.setVerticalGroup(
  1340. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  1341. .addGroup(layout.createSequentialGroup()
  1342. .addContainerGap()
  1343. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  1344. .addComponent(jButton1)
  1345. .addComponent(jLabel1))
  1346. .addGap(18, 18, 18)
  1347. .addComponent(jTabbedPane1))
  1348. );
  1349.  
  1350. pack();
  1351. }// </editor-fold>
  1352.  
  1353. private void jCheckBox1ActionPerformed(java.awt.event.ActionEvent evt) {
  1354. // TODO add your handling code here:
  1355. if(jCheckBox1.isSelected()){
  1356. txt_tmbh_jual_kdmem.setEnabled(true);
  1357. }
  1358. else {
  1359. txt_tmbh_jual_kdmem.setEnabled(false);
  1360. }
  1361. }
  1362.  
  1363. private void txt_jual_bnyk_beliActionPerformed(java.awt.event.ActionEvent evt) {
  1364. // TODO add your handling code here:
  1365. }
  1366.  
  1367. private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
  1368. // TODO add your handling code here:
  1369. FramePenjualan.this.setVisible(false);
  1370. FrameUtama frm_utama = new FrameUtama();
  1371. frm_utama.setLocationRelativeTo(null);
  1372. frm_utama.setVisible(true);
  1373. }
  1374.  
  1375. private void jCheckBox2ActionPerformed(java.awt.event.ActionEvent evt) {
  1376. // TODO add your handling code here:
  1377. if(jCheckBox2.isSelected()){
  1378. jTextField10.setEnabled(true);
  1379. jTextField10.setText("");
  1380. jLabel89.setText("-");
  1381. jLabel45.setText("-");
  1382. jLabel90.setText("-");
  1383. }
  1384. else {
  1385. jTextField10.setEnabled(false);
  1386. }
  1387. }
  1388.  
  1389. private void jTextField11ActionPerformed(java.awt.event.ActionEvent evt) {
  1390. // TODO add your handling code here:
  1391. }
  1392.  
  1393. private void formWindowActivated(java.awt.event.WindowEvent evt) {
  1394. // TODO add your handling code here:
  1395. txt_tmbh_jual_kdmem.setEnabled(false);
  1396. jTextField10.setEnabled(false);
  1397. }
  1398.  
  1399. private void cari_jual_kdpegActionPerformed(java.awt.event.ActionEvent evt) {
  1400. // TODO add your handling code here:
  1401. String Jabatan;
  1402. try
  1403. {
  1404. Class.forName(driver);
  1405. Connection kon = DriverManager.getConnection(database,user,pass);
  1406. Statement stt = kon.createStatement();
  1407. String SQL = "SELECT * FROM pegawai WHERE kode_pegawai='"+txt_tmbh_jual_kdpeg.getText()+"'";
  1408. ResultSet res = stt.executeQuery(SQL);
  1409. while(res.next())
  1410. {
  1411. data[1] = res.getString(2);
  1412. txt_jual_nmpeg.setText(data[1]);
  1413. }
  1414. res.close();
  1415. stt.close();
  1416. kon.close();
  1417. }
  1418. catch (Exception ex)
  1419. {
  1420. System.err.println(ex.getMessage());
  1421. }
  1422. }
  1423.  
  1424. private void cari_jual_kdbrgActionPerformed(java.awt.event.ActionEvent evt) {
  1425. // TODO add your handling code here:
  1426. try
  1427. {
  1428. Class.forName(driver);
  1429. Connection kon = DriverManager.getConnection(database,user,pass);
  1430. Statement stt = kon.createStatement();
  1431. String SQL = "SELECT * FROM barang WHERE kode_barang='"+txt_tmbh_jual_kdbrg.getText()+"'";
  1432. ResultSet res = stt.executeQuery(SQL);
  1433. while(res.next())
  1434. {
  1435. data[1] = res.getString(2);
  1436. data[2] = res.getString(3);
  1437. data[3] = res.getString(4);
  1438. txt_jual_nmbrg.setText(data[1]);
  1439. jLabel6.setText(data[3]);
  1440. }
  1441. res.close();
  1442. stt.close();
  1443. kon.close();
  1444. }
  1445. catch (Exception ex)
  1446. {
  1447. System.err.println(ex.getMessage());
  1448. }
  1449. }
  1450.  
  1451. private void cari_jual_kdmemActionPerformed(java.awt.event.ActionEvent evt) {
  1452. // TODO add your handling code here:
  1453. try
  1454. {
  1455. Class.forName(driver);
  1456. Connection kon = DriverManager.getConnection(database,user,pass);
  1457. Statement stt = kon.createStatement();
  1458. String SQL = "SELECT * FROM member WHERE kode_member='"+txt_tmbh_jual_kdmem.getText()+"'";
  1459. ResultSet res = stt.executeQuery(SQL);
  1460. while(res.next())
  1461. {
  1462. data[1] = res.getString(2);
  1463. data[2] = res.getString(3);
  1464. data[3] = res.getString(4);
  1465. txt_jual_nmmem.setText(data[1]);
  1466. jLabel18.setText(data[3]);
  1467. if(Integer.valueOf(res.getString(3)) == 0){
  1468. txt_jual_jnsmem.setText("Pertamax");
  1469. } else {
  1470. txt_jual_jnsmem.setText("Pertalite");
  1471. }
  1472. //String.format("%.3f",hasilBagi)
  1473. jLabel24.setText(String.format("%.0f",Integer.valueOf(jLabel8.getText()) * Integer.valueOf(data[3]) * 0.01));
  1474. jLabel22.setText(String.format("%.0f",Integer.valueOf(jLabel8.getText()) - Integer.valueOf(jLabel8.getText()) * Integer.valueOf(data[3]) * 0.01));
  1475. }
  1476. res.close();
  1477. stt.close();
  1478. kon.close();
  1479. }
  1480. catch (Exception ex)
  1481. {
  1482. System.err.println(ex.getMessage());
  1483. }
  1484. }
  1485.  
  1486. private void txt_jual_bnyk_beliFocusLost(java.awt.event.FocusEvent evt) {
  1487. // TODO add your handling code here:
  1488. jLabel22.setText(String.valueOf(Integer.valueOf(txt_jual_bnyk_beli.getText()) * Integer.valueOf(jLabel6.getText())));
  1489. jLabel8.setText(String.valueOf(Integer.valueOf(txt_jual_bnyk_beli.getText()) * Integer.valueOf(jLabel6.getText())));
  1490. }
  1491.  
  1492. private void txt_tmbh_uangbyrInputMethodTextChanged(java.awt.event.InputMethodEvent evt) {
  1493. // TODO add your handling code here:
  1494. }
  1495.  
  1496. private void txt_tmbh_uangbyrFocusLost(java.awt.event.FocusEvent evt) {
  1497. // TODO add your handling code here:
  1498. jLabel78.setText(String.valueOf(Integer.valueOf(txt_tmbh_uangbyr.getText()) - Integer.valueOf(jLabel22.getText())));
  1499. //jLabel78.setText(String.valueOf(Integer.valueOf(jLabel22.getText()) - Integer.valueOf(txt_tmbh_uangbyr.getText())));
  1500. }
  1501.  
  1502. private void btn_tmbh_penjualanActionPerformed(java.awt.event.ActionEvent evt) {
  1503. // TODO add your handling code here:
  1504. // TODO add your handling code here:
  1505. String data[]=new String[12];
  1506.  
  1507. if ((txt_tmbh_jual_kdpeg.getText().isEmpty())||(txt_tmbh_jual_kdbrg.getText().isEmpty()))
  1508. {
  1509. JOptionPane.showMessageDialog(null, "Data tidak boleh kosong, silahkan dilengkapi");
  1510. txt_tmbh_jual_kdbrg.requestFocus();
  1511. }
  1512. else
  1513. {
  1514. try
  1515. {
  1516. Class.forName(driver);
  1517. Connection kon = DriverManager.getConnection(database,user,pass);
  1518. Statement stt = kon.createStatement();
  1519. String SQL = "";
  1520. if(jCheckBox1.isSelected() == true){
  1521. SQL = "INSERT INTO penjualan(kode_pegawai,"
  1522. +"kode_barang,"
  1523. +"banyak_barang,"
  1524. +"jumlah_harga,"
  1525. +"member,"
  1526. +"kode_member,"
  1527. +"diskon,"
  1528. +"total_harga,"
  1529. +"uang_dibayar,"
  1530. +"kembalian) "
  1531. +"VALUES "
  1532. + "('"+txt_tmbh_jual_kdpeg.getText()+"',"
  1533. + "'"+txt_tmbh_jual_kdbrg.getText()+" ' ,"
  1534. + "'"+txt_jual_bnyk_beli.getText()+" ',"
  1535. + "'"+jLabel6.getText()+" ',"
  1536. + "'1 ',"
  1537. + "'"+txt_tmbh_jual_kdmem.getText()+" ',"
  1538. + "'"+jLabel24.getText()+" ',"
  1539. + "'"+jLabel22.getText()+" ',"
  1540. + "'"+txt_tmbh_uangbyr.getText()+" ',"
  1541. + "'"+jLabel78.getText()+" ')";
  1542. } else {
  1543. SQL = "INSERT INTO penjualan(kode_pegawai,"
  1544. +"kode_barang,"
  1545. +"banyak_barang,"
  1546. +"jumlah_harga,"
  1547. +"member,"
  1548. +"diskon,"
  1549. +"total_harga,"
  1550. +"uang_dibayar,"
  1551. +"kembalian) "
  1552. +"VALUES "
  1553. + "('"+txt_tmbh_jual_kdpeg.getText()+"',"
  1554. + "'"+txt_tmbh_jual_kdbrg.getText()+" ' ,"
  1555. + "'"+txt_jual_bnyk_beli.getText()+" ',"
  1556. + "'"+jLabel6.getText()+" ',"
  1557. + "'0 ',"
  1558. + "'0',"
  1559. + "'"+jLabel22.getText()+" ',"
  1560. + "'"+txt_tmbh_uangbyr.getText()+" ',"
  1561. + "'"+jLabel78.getText()+" ')";
  1562. }
  1563. stt.executeUpdate(SQL);
  1564. data[1]=txt_tmbh_jual_kdpeg.getText();
  1565. data[2]=txt_tmbh_jual_kdbrg.getText();
  1566. data[3]=txt_jual_bnyk_beli.getText();
  1567. data[4]=txt_jual_hrgbrg.getText();
  1568. data[5]=jCheckBox1.getText();
  1569. data[6]=txt_tmbh_jual_kdmem.getText();
  1570. data[7]=txt_jual_hrgtot.getText();
  1571. data[8]=txt_tmbh_uangbyr.getText();
  1572. data[9]=txt_tmbh_kembalian.getText();
  1573. stt.close();
  1574. kon.close();
  1575. JOptionPane.showMessageDialog(null,"Data Berhasil Ditambahkan");
  1576. tableModel.setRowCount(0);
  1577. settableload();
  1578.  
  1579. }
  1580. catch (Exception ex)
  1581. {
  1582. JOptionPane.showMessageDialog(null, ex.getMessage(),"Error",JOptionPane.INFORMATION_MESSAGE);
  1583. }
  1584. }
  1585. }
  1586.  
  1587. private void jButton12ActionPerformed(java.awt.event.ActionEvent evt) {
  1588. // TODO add your handling code here:
  1589. String Jabatan;
  1590. try
  1591. {
  1592. Class.forName(driver);
  1593. Connection kon = DriverManager.getConnection(database, user, pass);
  1594. Statement stt = kon.createStatement();
  1595. String SQL = "SELECT penjualan.kode_pegawai, \n" +
  1596. " penjualan.kode_barang, \n" +
  1597. " penjualan.banyak_barang, \n" +
  1598. " penjualan.jumlah_harga, \n" +
  1599. " penjualan.member, \n" +
  1600. " penjualan.kode_member,\n" +
  1601. " penjualan.diskon,\n" +
  1602. " penjualan.total_harga,\n" +
  1603. " penjualan.uang_dibayar,\n" +
  1604. " penjualan.kembalian,\n" +
  1605. " pegawai.nama_pegawai,\n" +
  1606. " barang.nama_barang,\n" +
  1607. " barang.harga\n" +
  1608. "FROM penjualan\n" +
  1609. "INNER JOIN pegawai\n" +
  1610. " on penjualan.kode_pegawai = pegawai.kode_pegawai\n" +
  1611. "INNER JOIN barang\n" +
  1612. " on penjualan.kode_barang = barang.kode_barang\n" +
  1613. "WHERE penjualan.id ='" + txt_id_hapus.getText() + "'";
  1614. ResultSet res = stt.executeQuery(SQL);
  1615. while (res.next()) {
  1616. if (res.getString(6) != null) {
  1617. Class.forName(driver);
  1618. Connection kon1 = DriverManager.getConnection(database, user, pass);
  1619. Statement stt1 = kon1.createStatement();
  1620. String SQL1 = "SELECT penjualan.kode_pegawai, \n" +
  1621. " penjualan.kode_barang, \n" +
  1622. " penjualan.banyak_barang, \n" +
  1623. " penjualan.jumlah_harga, \n" +
  1624. " penjualan.member, \n" +
  1625. " penjualan.kode_member,\n" +
  1626. " penjualan.diskon,\n" +
  1627. " penjualan.total_harga,\n" +
  1628. " penjualan.uang_dibayar,\n" +
  1629. " penjualan.kembalian,\n" +
  1630. " pegawai.nama_pegawai,\n" +
  1631. " barang.nama_barang,\n" +
  1632. " barang.harga,\n" +
  1633. " member.jenis_member,\n" +
  1634. " member.nama_member\n" +
  1635. "FROM penjualan\n" +
  1636. "INNER JOIN pegawai\n" +
  1637. " on penjualan.kode_pegawai = pegawai.kode_pegawai\n" +
  1638. "INNER JOIN barang\n" +
  1639. " on penjualan.kode_barang = barang.kode_barang\n" +
  1640. "INNER JOIN member\n" +
  1641. " on penjualan.kode_member = member.kode_member\n" +
  1642. "WHERE penjualan.id ='" + txt_id_hapus.getText() + "'";
  1643. ResultSet res1 = stt.executeQuery(SQL1);
  1644. while (res1.next()) {
  1645. jLabel53.setText(res1.getString(1));
  1646. jLabel79.setText(res1.getString(11));
  1647. jLabel55.setText(res1.getString(2));
  1648. jLabel73.setText(res1.getString(12));
  1649. jLabel74.setText(res1.getString(13));
  1650. jLabel75.setText(res1.getString(3));
  1651. if (Integer.valueOf(res1.getString(5)) == 0) {
  1652. jLabel76.setText("Tidak");
  1653. jLabel77.setText("-");
  1654. jLabel80.setText("-");
  1655. jLabel81.setText("-");
  1656. jLabel82.setText("0");
  1657. } else {
  1658. jLabel76.setText("Ya");
  1659. jLabel77.setText(res1.getString(6));
  1660. jLabel80.setText(res1.getString(15));
  1661. if (Integer.valueOf(res1.getString(14)) == 0) {
  1662. jLabel81.setText("Pertamax");
  1663. } else {
  1664. jLabel81.setText("Pertalite");
  1665. }
  1666. jLabel82.setText(res1.getString(7));
  1667. }
  1668. jLabel83.setText(res1.getString(8));
  1669. jLabel84.setText(res1.getString(9));
  1670. jLabel85.setText(res1.getString(10));
  1671. }
  1672. res1.close();
  1673. stt1.close();
  1674. kon1.close();
  1675. } else {
  1676. jLabel53.setText(res.getString(1));
  1677. jLabel79.setText(res.getString(11));
  1678. jLabel55.setText(res.getString(2));
  1679. jLabel73.setText(res.getString(12));
  1680. jLabel74.setText(res.getString(13));
  1681. jLabel75.setText(res.getString(3));
  1682. if (Integer.valueOf(res.getString(5)) == 0) {
  1683. jLabel76.setText("Tidak");
  1684. jLabel77.setText("-");
  1685. jLabel80.setText("-");
  1686. jLabel81.setText("-");
  1687. jLabel82.setText("0");
  1688. } else {
  1689. jLabel76.setText("Ya");
  1690. jLabel77.setText(res.getString(6));
  1691. jLabel80.setText(res.getString(15));
  1692. if (Integer.valueOf(res.getString(14)) == 0) {
  1693. jLabel81.setText("Pertamax");
  1694. } else {
  1695. jLabel81.setText("Pertalite");
  1696. }
  1697. jLabel82.setText(res.getString(7));
  1698. }
  1699. jLabel83.setText(res.getString(8));
  1700. jLabel84.setText(res.getString(9));
  1701. jLabel85.setText(res.getString(10));
  1702. }
  1703. }
  1704. res.close();
  1705. stt.close();
  1706. kon.close();
  1707. }
  1708. catch (Exception ex)
  1709. {
  1710. System.err.println(ex.getMessage());
  1711. }
  1712. }
  1713.  
  1714. private void jButton9ActionPerformed(java.awt.event.ActionEvent evt) {
  1715. // TODO add your handling code here:
  1716. try
  1717. {
  1718. int konfirmasi = JOptionPane.showConfirmDialog(null, "Yakin Ingin Menghapus Data?", "Peringatan", JOptionPane.YES_NO_OPTION);
  1719. if (konfirmasi == JOptionPane.YES_OPTION) {
  1720. Class.forName(driver);
  1721. Connection kon = DriverManager.getConnection(database,user,pass);
  1722. Statement stt = kon.createStatement();
  1723. String SQL = "Delete From penjualan "
  1724. + "where "
  1725. +"id='"+txt_id_hapus.getText()+"'";
  1726. stt.executeUpdate(SQL);
  1727. stt.close();
  1728. kon.close();
  1729. jLabel53.setText("");
  1730. jLabel79.setText("");
  1731. jLabel55.setText("");
  1732. jLabel73.setText("");
  1733. jLabel74.setText("");
  1734. jLabel75.setText("");
  1735. jLabel80.setText("");
  1736. jLabel81.setText("");
  1737. jLabel82.setText("");
  1738. jLabel83.setText("");
  1739. jLabel84.setText("");
  1740. jLabel85.setText("");
  1741. JOptionPane.showMessageDialog(null, "Data telah terhapus");
  1742. tableModel.setRowCount(0);
  1743. settableload();
  1744. }
  1745. }
  1746. catch (Exception ex)
  1747. {
  1748. System.err.println(ex.getMessage());
  1749. }
  1750. }
  1751.  
  1752. private void jButton8ActionPerformed(java.awt.event.ActionEvent evt) {
  1753. // TODO add your handling code here:
  1754. String Jabatan;
  1755. try
  1756. {
  1757. Class.forName(driver);
  1758. Connection kon = DriverManager.getConnection(database, user, pass);
  1759. Statement stt = kon.createStatement();
  1760. String SQL = "SELECT penjualan.kode_pegawai, \n" +
  1761. " penjualan.kode_barang, \n" +
  1762. " penjualan.banyak_barang, \n" +
  1763. " penjualan.jumlah_harga, \n" +
  1764. " penjualan.member, \n" +
  1765. " penjualan.kode_member,\n" +
  1766. " penjualan.id,\n" +
  1767. " penjualan.total_harga,\n" +
  1768. " penjualan.uang_dibayar,\n" +
  1769. " penjualan.kembalian,\n" +
  1770. " pegawai.nama_pegawai,\n" +
  1771. " barang.nama_barang,\n" +
  1772. " barang.harga\n" +
  1773. "FROM penjualan\n" +
  1774. "INNER JOIN pegawai\n" +
  1775. " on penjualan.kode_pegawai = pegawai.kode_pegawai\n" +
  1776. "INNER JOIN barang\n" +
  1777. " on penjualan.kode_barang = barang.kode_barang\n" +
  1778. "WHERE penjualan.id ='" + jTextField12.getText() + "'";
  1779. ResultSet res = stt.executeQuery(SQL);
  1780. while (res.next()) {
  1781. if (res.getString(6) != null) {
  1782. Class.forName(driver);
  1783. Connection kon1 = DriverManager.getConnection(database, user, pass);
  1784. Statement stt1 = kon1.createStatement();
  1785. String SQL1 = "SELECT penjualan.kode_pegawai, \n" +
  1786. " penjualan.kode_barang, \n" +
  1787. " penjualan.banyak_barang, \n" +
  1788. " penjualan.jumlah_harga, \n" +
  1789. " penjualan.member, \n" +
  1790. " penjualan.kode_member,\n" +
  1791. " member.diskon,\n" +
  1792. " penjualan.total_harga,\n" +
  1793. " penjualan.uang_dibayar,\n" +
  1794. " penjualan.kembalian,\n" +
  1795. " pegawai.nama_pegawai,\n" +
  1796. " barang.nama_barang,\n" +
  1797. " barang.harga,\n" +
  1798. " member.jenis_member,\n" +
  1799. " member.nama_member\n" +
  1800. "FROM penjualan\n" +
  1801. "INNER JOIN pegawai\n" +
  1802. " on penjualan.kode_pegawai = pegawai.kode_pegawai\n" +
  1803. "INNER JOIN barang\n" +
  1804. " on penjualan.kode_barang = barang.kode_barang\n" +
  1805. "INNER JOIN member\n" +
  1806. " on penjualan.kode_member = member.kode_member\n" +
  1807. "WHERE penjualan.id ='" + jTextField12.getText() + "'";
  1808. ResultSet res1 = stt.executeQuery(SQL1);
  1809. while (res1.next()) {
  1810. jTextField7.setText(res1.getString(1));
  1811. jLabel86.setText(res1.getString(11));
  1812. jTextField8.setText(res1.getString(2));
  1813. jLabel87.setText(res1.getString(12));
  1814. jLabel88.setText(res1.getString(13));
  1815. jTextField11.setText(res1.getString(3));
  1816. if (Integer.valueOf(res1.getString(5)) == 0) {
  1817. jTextField10.setEnabled(false);
  1818. jLabel89.setText("-");
  1819. jLabel45.setText("-");
  1820. jLabel90.setText("-");
  1821. } else {
  1822. jTextField10.setEnabled(true);
  1823. jCheckBox2.setSelected(true);
  1824. jTextField10.setText(res1.getString(6));
  1825. jLabel89.setText(res1.getString(15));
  1826. if (Integer.valueOf(res1.getString(14)) == 0) {
  1827. jLabel45.setText("Pertamax");
  1828. } else {
  1829. jLabel45.setText("Pertalite");
  1830. }
  1831. jLabel90.setText(res1.getString(7));
  1832. }
  1833. jLabel96.setText(res1.getString(8));
  1834. jLabel91.setText(res1.getString(4));
  1835. jTextField9.setText(res1.getString(9));
  1836. jLabel92.setText(res1.getString(10));
  1837. }
  1838. res1.close();
  1839. stt1.close();
  1840. kon1.close();
  1841. } else {
  1842. jTextField7.setText(res.getString(1));
  1843. jLabel86.setText(res.getString(11));
  1844. jTextField8.setText(res.getString(2));
  1845. jLabel87.setText(res.getString(12));
  1846. jLabel88.setText(res.getString(13));
  1847. jTextField11.setText(res.getString(3));
  1848. if (Integer.valueOf(res.getString(5)) == 0) {
  1849. jTextField10.setEnabled(false);
  1850. jLabel89.setText("-");
  1851. jLabel45.setText("-");
  1852. jLabel90.setText("-");
  1853. } else {
  1854. jTextField10.setEnabled(true);
  1855. jCheckBox2.setSelected(true);
  1856. jTextField10.setText(res.getString(6));
  1857. jLabel89.setText(res.getString(15));
  1858. if (Integer.valueOf(res.getString(14)) == 0) {
  1859. jLabel45.setText("Pertamax");
  1860. } else {
  1861. jLabel45.setText("Pertalite");
  1862. }
  1863. jLabel90.setText(res.getString(7));
  1864. }
  1865. jLabel96.setText(res.getString(8));
  1866. jLabel91.setText(res.getString(4));
  1867. jTextField9.setText(res.getString(9));
  1868. jLabel92.setText(res.getString(10));
  1869. }
  1870. }
  1871. res.close();
  1872. stt.close();
  1873. kon.close();
  1874. }
  1875. catch (Exception ex)
  1876. {
  1877. System.err.println(ex.getMessage());
  1878. }
  1879. }
  1880.  
  1881. private void jTextField9ActionPerformed(java.awt.event.ActionEvent evt) {
  1882. // TODO add your handling code here:
  1883. }
  1884.  
  1885. private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {
  1886. // TODO add your handling code here:
  1887. try
  1888. {
  1889. Class.forName(driver);
  1890. Connection kon = DriverManager.getConnection(database,user,pass);
  1891. Statement stt = kon.createStatement();
  1892. String SQL = "SELECT * FROM pegawai WHERE kode_pegawai='"+jTextField7.getText()+"'";
  1893. ResultSet res = stt.executeQuery(SQL);
  1894. while(res.next())
  1895. {
  1896. jLabel86.setText(res.getString(2));
  1897. }
  1898. res.close();
  1899. stt.close();
  1900. kon.close();
  1901. }
  1902. catch (Exception ex)
  1903. {
  1904. System.err.println(ex.getMessage());
  1905. }
  1906. }
  1907.  
  1908. private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {
  1909. // TODO add your handling code here:
  1910. try
  1911. {
  1912.  
  1913. Class.forName(driver);
  1914. Connection kon = DriverManager.getConnection(database,user,pass);
  1915. Statement stt = kon.createStatement();
  1916. String SQL = "SELECT * FROM barang WHERE kode_barang='"+jTextField8.getText()+"'";
  1917. ResultSet res = stt.executeQuery(SQL);
  1918. while(res.next())
  1919. {
  1920. jLabel87.setText(res.getString(2));
  1921. jLabel88.setText(res.getString(3));
  1922. }
  1923. res.close();
  1924. stt.close();
  1925. kon.close();
  1926. }
  1927. catch (Exception ex)
  1928. {
  1929. System.err.println(ex.getMessage());
  1930. }
  1931. }
  1932.  
  1933. private void jTextField11FocusLost(java.awt.event.FocusEvent evt) {
  1934. // TODO add your handling code here:
  1935. jLabel96.setText(String.valueOf(Integer.valueOf(jTextField11.getText()) * Integer.valueOf(jLabel88.getText())));
  1936. jLabel91.setText(String.valueOf(Integer.valueOf(jTextField11.getText()) * Integer.valueOf(jLabel88.getText())));
  1937. }
  1938.  
  1939. private void jButton7ActionPerformed(java.awt.event.ActionEvent evt) {
  1940. // TODO add your handling code here:
  1941. try
  1942. {
  1943. Class.forName(driver);
  1944. Connection kon = DriverManager.getConnection(database,user,pass);
  1945. Statement stt = kon.createStatement();
  1946. String SQL = "SELECT * FROM member WHERE kode_member='"+jTextField10.getText()+"'";
  1947. ResultSet res = stt.executeQuery(SQL);
  1948. while(res.next())
  1949. {
  1950. data[1] = res.getString(2);
  1951. data[2] = res.getString(3);
  1952. data[3] = res.getString(4);
  1953. jLabel89.setText(data[1]);
  1954. if(Integer.valueOf(res.getString(3)) == 0){
  1955. jLabel45.setText("Pertamax");
  1956. } else {
  1957. jLabel45.setText("Pertalite");
  1958. }
  1959. //String.format("%.3f",hasilBagi)
  1960. jLabel94.setText(String.format("%.0f",Integer.valueOf(jLabel91.getText()) * Integer.valueOf(data[3]) * 0.01));
  1961. jLabel96.setText(String.format("%.0f",Integer.valueOf(jLabel91.getText()) - Integer.valueOf(jLabel91.getText()) * Integer.valueOf(data[3]) * 0.01));
  1962. }
  1963. res.close();
  1964. stt.close();
  1965. kon.close();
  1966. }
  1967. catch (Exception ex)
  1968. {
  1969. System.err.println(ex.getMessage());
  1970. }
  1971. }
  1972.  
  1973. private void jTextField9FocusLost(java.awt.event.FocusEvent evt) {
  1974. // TODO add your handling code here:
  1975. jLabel92.setText(String.valueOf(Integer.valueOf(jTextField9.getText()) - Integer.valueOf(jLabel96.getText())));
  1976. }
  1977.  
  1978. /**
  1979. * @param args the command line arguments
  1980. */
  1981. public static void main(String args[]) {
  1982. /* Set the Nimbus look and feel */
  1983. //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
  1984. /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
  1985. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
  1986. */
  1987. try {
  1988. for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
  1989. if ("Nimbus".equals(info.getName())) {
  1990. javax.swing.UIManager.setLookAndFeel(info.getClassName());
  1991. break;
  1992. }
  1993. }
  1994. } catch (ClassNotFoundException ex) {
  1995. java.util.logging.Logger.getLogger(FramePenjualan.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  1996. } catch (InstantiationException ex) {
  1997. java.util.logging.Logger.getLogger(FramePenjualan.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  1998. } catch (IllegalAccessException ex) {
  1999. java.util.logging.Logger.getLogger(FramePenjualan.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  2000. } catch (javax.swing.UnsupportedLookAndFeelException ex) {
  2001. java.util.logging.Logger.getLogger(FramePenjualan.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  2002. }
  2003. //</editor-fold>
  2004. //</editor-fold>
  2005.  
  2006. /* Create and display the form */
  2007. java.awt.EventQueue.invokeLater(new Runnable() {
  2008. public void run() {
  2009. new FramePenjualan().setVisible(true);
  2010. }
  2011. });
  2012. }
  2013.  
  2014. // Variables declaration - do not modify
  2015. private javax.swing.JButton btn_batal_tmbh;
  2016. private javax.swing.JButton btn_tmbh_penjualan;
  2017. private javax.swing.JButton cari_jual_kdbrg;
  2018. private javax.swing.JButton cari_jual_kdmem;
  2019. private javax.swing.JButton cari_jual_kdpeg;
  2020. private javax.swing.JButton jButton1;
  2021. private javax.swing.JButton jButton10;
  2022. private javax.swing.JButton jButton11;
  2023. private javax.swing.JButton jButton12;
  2024. private javax.swing.JButton jButton13;
  2025. private javax.swing.JButton jButton5;
  2026. private javax.swing.JButton jButton6;
  2027. private javax.swing.JButton jButton7;
  2028. private javax.swing.JButton jButton8;
  2029. private javax.swing.JButton jButton9;
  2030. private javax.swing.JCheckBox jCheckBox1;
  2031. private javax.swing.JCheckBox jCheckBox2;
  2032. private javax.swing.JLabel jLabel1;
  2033. private javax.swing.JLabel jLabel10;
  2034. private javax.swing.JLabel jLabel11;
  2035. private javax.swing.JLabel jLabel12;
  2036. private javax.swing.JLabel jLabel13;
  2037. private javax.swing.JLabel jLabel14;
  2038. private javax.swing.JLabel jLabel15;
  2039. private javax.swing.JLabel jLabel16;
  2040. private javax.swing.JLabel jLabel17;
  2041. private javax.swing.JLabel jLabel18;
  2042. private javax.swing.JLabel jLabel19;
  2043. private javax.swing.JLabel jLabel2;
  2044. private javax.swing.JLabel jLabel20;
  2045. private javax.swing.JLabel jLabel21;
  2046. private javax.swing.JLabel jLabel22;
  2047. private javax.swing.JLabel jLabel23;
  2048. private javax.swing.JLabel jLabel24;
  2049. private javax.swing.JLabel jLabel25;
  2050. private javax.swing.JLabel jLabel26;
  2051. private javax.swing.JLabel jLabel27;
  2052. private javax.swing.JLabel jLabel28;
  2053. private javax.swing.JLabel jLabel29;
  2054. private javax.swing.JLabel jLabel3;
  2055. private javax.swing.JLabel jLabel30;
  2056. private javax.swing.JLabel jLabel31;
  2057. private javax.swing.JLabel jLabel32;
  2058. private javax.swing.JLabel jLabel33;
  2059. private javax.swing.JLabel jLabel34;
  2060. private javax.swing.JLabel jLabel35;
  2061. private javax.swing.JLabel jLabel36;
  2062. private javax.swing.JLabel jLabel37;
  2063. private javax.swing.JLabel jLabel38;
  2064. private javax.swing.JLabel jLabel39;
  2065. private javax.swing.JLabel jLabel4;
  2066. private javax.swing.JLabel jLabel40;
  2067. private javax.swing.JLabel jLabel41;
  2068. private javax.swing.JLabel jLabel42;
  2069. private javax.swing.JLabel jLabel43;
  2070. private javax.swing.JLabel jLabel44;
  2071. private javax.swing.JLabel jLabel45;
  2072. private javax.swing.JLabel jLabel46;
  2073. private javax.swing.JLabel jLabel47;
  2074. private javax.swing.JLabel jLabel48;
  2075. private javax.swing.JLabel jLabel49;
  2076. private javax.swing.JLabel jLabel5;
  2077. private javax.swing.JLabel jLabel50;
  2078. private javax.swing.JLabel jLabel51;
  2079. private javax.swing.JLabel jLabel52;
  2080. private javax.swing.JLabel jLabel53;
  2081. private javax.swing.JLabel jLabel54;
  2082. private javax.swing.JLabel jLabel55;
  2083. private javax.swing.JLabel jLabel56;
  2084. private javax.swing.JLabel jLabel57;
  2085. private javax.swing.JLabel jLabel58;
  2086. private javax.swing.JLabel jLabel59;
  2087. private javax.swing.JLabel jLabel6;
  2088. private javax.swing.JLabel jLabel60;
  2089. private javax.swing.JLabel jLabel61;
  2090. private javax.swing.JLabel jLabel62;
  2091. private javax.swing.JLabel jLabel63;
  2092. private javax.swing.JLabel jLabel64;
  2093. private javax.swing.JLabel jLabel65;
  2094. private javax.swing.JLabel jLabel66;
  2095. private javax.swing.JLabel jLabel67;
  2096. private javax.swing.JLabel jLabel68;
  2097. private javax.swing.JLabel jLabel69;
  2098. private javax.swing.JLabel jLabel7;
  2099. private javax.swing.JLabel jLabel70;
  2100. private javax.swing.JLabel jLabel71;
  2101. private javax.swing.JLabel jLabel72;
  2102. private javax.swing.JLabel jLabel73;
  2103. private javax.swing.JLabel jLabel74;
  2104. private javax.swing.JLabel jLabel75;
  2105. private javax.swing.JLabel jLabel76;
  2106. private javax.swing.JLabel jLabel77;
  2107. private javax.swing.JLabel jLabel78;
  2108. private javax.swing.JLabel jLabel79;
  2109. private javax.swing.JLabel jLabel8;
  2110. private javax.swing.JLabel jLabel80;
  2111. private javax.swing.JLabel jLabel81;
  2112. private javax.swing.JLabel jLabel82;
  2113. private javax.swing.JLabel jLabel83;
  2114. private javax.swing.JLabel jLabel84;
  2115. private javax.swing.JLabel jLabel85;
  2116. private javax.swing.JLabel jLabel86;
  2117. private javax.swing.JLabel jLabel87;
  2118. private javax.swing.JLabel jLabel88;
  2119. private javax.swing.JLabel jLabel89;
  2120. private javax.swing.JLabel jLabel9;
  2121. private javax.swing.JLabel jLabel90;
  2122. private javax.swing.JLabel jLabel91;
  2123. private javax.swing.JLabel jLabel92;
  2124. private javax.swing.JLabel jLabel93;
  2125. private javax.swing.JLabel jLabel94;
  2126. private javax.swing.JLabel jLabel95;
  2127. private javax.swing.JLabel jLabel96;
  2128. private javax.swing.JLabel jLabel97;
  2129. private javax.swing.JPanel jPanel1;
  2130. private javax.swing.JPanel jPanel2;
  2131. private javax.swing.JPanel jPanel3;
  2132. private javax.swing.JPanel jPanel4;
  2133. private javax.swing.JScrollPane jScrollPane1;
  2134. private javax.swing.JTabbedPane jTabbedPane1;
  2135. private javax.swing.JTextField jTextField10;
  2136. private javax.swing.JTextField jTextField11;
  2137. private javax.swing.JTextField jTextField12;
  2138. private javax.swing.JTextField jTextField2;
  2139. private javax.swing.JTextField jTextField7;
  2140. private javax.swing.JTextField jTextField8;
  2141. private javax.swing.JTextField jTextField9;
  2142. private javax.swing.JTable tabel_penjualan;
  2143. private javax.swing.JTextField txt_id_hapus;
  2144. private javax.swing.JTextField txt_jual_bnyk_beli;
  2145. private javax.swing.JLabel txt_jual_diskmem;
  2146. private javax.swing.JLabel txt_jual_hrgbrg;
  2147. private javax.swing.JLabel txt_jual_hrgtot;
  2148. private javax.swing.JLabel txt_jual_jnsmem;
  2149. private javax.swing.JLabel txt_jual_nmbrg;
  2150. private javax.swing.JLabel txt_jual_nmmem;
  2151. private javax.swing.JLabel txt_jual_nmpeg;
  2152. private javax.swing.JTextField txt_tmbh_jual_kdbrg;
  2153. private javax.swing.JTextField txt_tmbh_jual_kdmem;
  2154. private javax.swing.JTextField txt_tmbh_jual_kdpeg;
  2155. private javax.swing.JLabel txt_tmbh_kembalian;
  2156. private javax.swing.JTextField txt_tmbh_uangbyr;
  2157. // End of variables declaration
  2158. }
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!