API tools faq
paste
Guest User

Untitled

a guest
Aug 1st, 2018
111
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 25.78 KB | None | 0 0
raw download clone embed print report
  1. import java.sql.Connection;
  2. import java.sql.DriverManager;
  3. import java.sql.ResultSet;
  4. import java.sql.Statement;
  5. import javax.swing.JOptionPane;
  6. import javax.swing.JTextField;
  7.  
  8. /*
  9. * To change this license header, choose License Headers in Project Properties.
  10. * To change this template file, choose Tools | Templates
  11. * and open the template in the editor.
  12. */
  13.  
  14. /**
  15. *
  16. * @author DeathWish547
  17. */
  18. public class frm_matkul extends javax.swing.JFrame {
  19. koneksi dbsetting;
  20. String driver,database,user,pass;
  21. Object tabel;
  22. /**
  23. * Creates new form frm_matkul
  24. */
  25. public frm_matkul() {
  26. initComponents();
  27. dbsetting = new koneksi();
  28. driver = dbsetting.SettingPanel("DBDriver");
  29. database = dbsetting.SettingPanel("DBDatabase");
  30. user = dbsetting.SettingPanel("DBUsername");
  31. pass = dbsetting.SettingPanel("DBPassword");
  32.  
  33. tabel_matkul.setModel(tabelmodel);
  34. settableload();
  35. nonaktifkan_teks();
  36. btn_simpan.setEnabled(false);
  37. btn_ubah.setEnabled(false);
  38. btn_batal.setEnabled(false);
  39. btn_hapus.setEnabled(false);
  40. }
  41.  
  42. private javax.swing.table.DefaultTableModel tabelmodel = getDefaultTableModel();
  43. private javax.swing.table.DefaultTableModel getDefaultTableModel(){
  44. return new javax.swing.table.DefaultTableModel(
  45. new Object [][] {},
  46. new String[] {"Kode Matakuliah",
  47. "Nama Matakuliah"
  48. }
  49. )
  50. {
  51. boolean[] canEdit = new boolean[]{
  52. false,false,false,false,false
  53. };
  54. public boolean isCelEditable(int rowIndex, int columnIndex){
  55. return canEdit[columnIndex];
  56. }
  57. };
  58. }
  59. String data[] = new String[5];
  60. private void settableload(){
  61. String stat = "";
  62. try{
  63. Class.forName(driver);
  64. Connection conn = DriverManager.getConnection(database,user,pass);
  65. Statement stmt = conn.createStatement();
  66. String query = "select * from t_mata_kuliah";
  67. ResultSet rs = stmt.executeQuery(query);
  68. while(rs.next()){
  69. data[0] =rs.getString("kd_mk");
  70. data[1] =rs.getString("nama_mk");
  71.  
  72. tabelmodel.addRow(data);
  73. }
  74. rs.close();
  75. conn.close();
  76. stmt.close();
  77. }catch(Exception ex){
  78. System.err.println(ex.getMessage());
  79. JOptionPane.showMessageDialog(null, ex.getMessage(),"",JOptionPane.INFORMATION_MESSAGE);
  80.  
  81. System.exit(0);
  82. }
  83. }
  84.  
  85. public void membersihkan_teks(){
  86. txt_nomk.setText("");
  87. txt_namamk.setText("");
  88.  
  89.  
  90. }
  91.  
  92. public void nonaktifkan_teks(){
  93. txt_nomk.setEnabled(false);
  94. txt_namamk.setEnabled(false);
  95.  
  96. }
  97.  
  98. public void aktif_teks(){
  99. txt_nomk.setEnabled(true);
  100. txt_namamk.setEnabled(true);
  101. }
  102.  
  103. int row = 0;
  104. public void tampil_field(){
  105. // String tanggal = new SimpleDateFormat("yyyy-MM-dd").format(txt_tanggal_lahir.getDate());
  106. row = tabel_matkul.getSelectedRow();
  107. txt_nomk.setText(tabelmodel.getValueAt(row, 0).toString());
  108. txt_namamk.setText(tabelmodel.getValueAt(row, 1).toString());
  109.  
  110. btn_simpan.setEnabled(false);
  111. btn_ubah.setEnabled(true);
  112. btn_batal.setEnabled(false);
  113. btn_hapus.setEnabled(true);
  114. aktif_teks();
  115. }
  116.  
  117. /**
  118. * This method is called from within the constructor to initialize the form.
  119. * WARNING: Do NOT modify this code. The content of this method is always
  120. * regenerated by the Form Editor.
  121. */
  122. @SuppressWarnings("unchecked")
  123. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  124. private void initComponents() {
  125.  
  126. jPanel1 = new javax.swing.JPanel();
  127. jLabel1 = new javax.swing.JLabel();
  128. jLabel2 = new javax.swing.JLabel();
  129. jPanel2 = new javax.swing.JPanel();
  130. jLabel3 = new javax.swing.JLabel();
  131. txt_carimk = new javax.swing.JTextField();
  132. btn_cari = new javax.swing.JButton();
  133. jLabel4 = new javax.swing.JLabel();
  134. txt_nomk = new javax.swing.JTextField();
  135. jLabel5 = new javax.swing.JLabel();
  136. txt_namamk = new javax.swing.JTextField();
  137. jScrollPane1 = new javax.swing.JScrollPane();
  138. tabel_matkul = new javax.swing.JTable();
  139. btn_tambah = new javax.swing.JButton();
  140. btn_ubah = new javax.swing.JButton();
  141. btn_hapus = new javax.swing.JButton();
  142. btn_simpan = new javax.swing.JButton();
  143. btn_batal = new javax.swing.JButton();
  144. btn_keluar = new javax.swing.JButton();
  145.  
  146. setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
  147. addWindowListener(new java.awt.event.WindowAdapter() {
  148. public void windowClosed(java.awt.event.WindowEvent evt) {
  149. formWindowClosed(evt);
  150. }
  151. });
  152.  
  153. jPanel1.setBackground(new java.awt.Color(0, 102, 204));
  154. jPanel1.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
  155.  
  156. jLabel1.setFont(new java.awt.Font("Tahoma", 1, 24)); // NOI18N
  157. jLabel1.setForeground(new java.awt.Color(255, 255, 255));
  158. jLabel1.setText("FORM MATA KULIAH");
  159.  
  160. javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
  161. jPanel1.setLayout(jPanel1Layout);
  162. jPanel1Layout.setHorizontalGroup(
  163. jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  164. .addGroup(jPanel1Layout.createSequentialGroup()
  165. .addGap(147, 147, 147)
  166. .addComponent(jLabel1)
  167. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  168. );
  169. jPanel1Layout.setVerticalGroup(
  170. jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  171. .addGroup(jPanel1Layout.createSequentialGroup()
  172. .addGap(25, 25, 25)
  173. .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 29, javax.swing.GroupLayout.PREFERRED_SIZE)
  174. .addContainerGap(28, Short.MAX_VALUE))
  175. );
  176.  
  177. jLabel2.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  178. jLabel2.setText("Pencarian Data Mata Kuliah");
  179.  
  180. jPanel2.setBackground(new java.awt.Color(0, 102, 204));
  181. jPanel2.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
  182.  
  183. jLabel3.setForeground(new java.awt.Color(255, 255, 255));
  184. jLabel3.setText("Masukkan Data");
  185.  
  186. btn_cari.setText("CARI");
  187. btn_cari.addActionListener(new java.awt.event.ActionListener() {
  188. public void actionPerformed(java.awt.event.ActionEvent evt) {
  189. btn_cariActionPerformed(evt);
  190. }
  191. });
  192.  
  193. javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
  194. jPanel2.setLayout(jPanel2Layout);
  195. jPanel2Layout.setHorizontalGroup(
  196. jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  197. .addGroup(jPanel2Layout.createSequentialGroup()
  198. .addContainerGap()
  199. .addComponent(jLabel3)
  200. .addGap(18, 18, 18)
  201. .addComponent(txt_carimk, javax.swing.GroupLayout.PREFERRED_SIZE, 143, javax.swing.GroupLayout.PREFERRED_SIZE)
  202. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  203. .addComponent(btn_cari)
  204. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  205. );
  206. jPanel2Layout.setVerticalGroup(
  207. jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  208. .addGroup(jPanel2Layout.createSequentialGroup()
  209. .addGap(17, 17, 17)
  210. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  211. .addComponent(jLabel3)
  212. .addComponent(txt_carimk, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  213. .addComponent(btn_cari))
  214. .addContainerGap(23, Short.MAX_VALUE))
  215. );
  216.  
  217. jLabel4.setText("Nomor M.K");
  218.  
  219. jLabel5.setText("Nama M.K");
  220.  
  221. tabel_matkul.setModel(new javax.swing.table.DefaultTableModel(
  222. new Object [][] {
  223. {null, null, null, null},
  224. {null, null, null, null},
  225. {null, null, null, null},
  226. {null, null, null, null}
  227. },
  228. new String [] {
  229. "Title 1", "Title 2", "Title 3", "Title 4"
  230. }
  231. ));
  232. tabel_matkul.addMouseListener(new java.awt.event.MouseAdapter() {
  233. public void mouseClicked(java.awt.event.MouseEvent evt) {
  234. tabel_matkulMouseClicked(evt);
  235. }
  236. });
  237. jScrollPane1.setViewportView(tabel_matkul);
  238.  
  239. btn_tambah.setBackground(new java.awt.Color(0, 102, 204));
  240. btn_tambah.setForeground(new java.awt.Color(255, 255, 255));
  241. btn_tambah.setText("TAMBAH");
  242. btn_tambah.addActionListener(new java.awt.event.ActionListener() {
  243. public void actionPerformed(java.awt.event.ActionEvent evt) {
  244. btn_tambahActionPerformed(evt);
  245. }
  246. });
  247.  
  248. btn_ubah.setBackground(new java.awt.Color(0, 102, 204));
  249. btn_ubah.setForeground(new java.awt.Color(255, 255, 255));
  250. btn_ubah.setText("UBAH");
  251. btn_ubah.addActionListener(new java.awt.event.ActionListener() {
  252. public void actionPerformed(java.awt.event.ActionEvent evt) {
  253. btn_ubahActionPerformed(evt);
  254. }
  255. });
  256.  
  257. btn_hapus.setBackground(new java.awt.Color(0, 102, 204));
  258. btn_hapus.setForeground(new java.awt.Color(255, 255, 255));
  259. btn_hapus.setText("HAPUS");
  260. btn_hapus.addActionListener(new java.awt.event.ActionListener() {
  261. public void actionPerformed(java.awt.event.ActionEvent evt) {
  262. btn_hapusActionPerformed(evt);
  263. }
  264. });
  265.  
  266. btn_simpan.setBackground(new java.awt.Color(0, 102, 204));
  267. btn_simpan.setForeground(new java.awt.Color(255, 255, 255));
  268. btn_simpan.setText("SIMPAN");
  269. btn_simpan.addActionListener(new java.awt.event.ActionListener() {
  270. public void actionPerformed(java.awt.event.ActionEvent evt) {
  271. btn_simpanActionPerformed(evt);
  272. }
  273. });
  274.  
  275. btn_batal.setBackground(new java.awt.Color(0, 102, 204));
  276. btn_batal.setForeground(new java.awt.Color(255, 255, 255));
  277. btn_batal.setText("BATAL");
  278. btn_batal.addActionListener(new java.awt.event.ActionListener() {
  279. public void actionPerformed(java.awt.event.ActionEvent evt) {
  280. btn_batalActionPerformed(evt);
  281. }
  282. });
  283.  
  284. btn_keluar.setBackground(new java.awt.Color(0, 102, 204));
  285. btn_keluar.setForeground(new java.awt.Color(255, 255, 255));
  286. btn_keluar.setText("KELUAR");
  287. btn_keluar.addActionListener(new java.awt.event.ActionListener() {
  288. public void actionPerformed(java.awt.event.ActionEvent evt) {
  289. btn_keluarActionPerformed(evt);
  290. }
  291. });
  292.  
  293. javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  294. getContentPane().setLayout(layout);
  295. layout.setHorizontalGroup(
  296. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  297. .addGroup(layout.createSequentialGroup()
  298. .addGap(21, 21, 21)
  299. .addComponent(btn_tambah)
  300. .addGap(18, 18, 18)
  301. .addComponent(btn_ubah)
  302. .addGap(18, 18, 18)
  303. .addComponent(btn_hapus)
  304. .addGap(18, 18, 18)
  305. .addComponent(btn_simpan)
  306. .addGap(18, 18, 18)
  307. .addComponent(btn_batal)
  308. .addGap(18, 18, 18)
  309. .addComponent(btn_keluar)
  310. .addContainerGap(36, Short.MAX_VALUE))
  311. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
  312. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  313. .addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createSequentialGroup()
  314. .addContainerGap()
  315. .addComponent(jScrollPane1))
  316. .addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createSequentialGroup()
  317. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  318. .addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createSequentialGroup()
  319. .addGap(20, 20, 20)
  320. .addComponent(jLabel4)
  321. .addGap(40, 40, 40)
  322. .addComponent(txt_nomk, javax.swing.GroupLayout.PREFERRED_SIZE, 143, javax.swing.GroupLayout.PREFERRED_SIZE)
  323. .addGap(18, 18, 18)
  324. .addComponent(jLabel5)
  325. .addGap(18, 18, 18)
  326. .addComponent(txt_namamk, javax.swing.GroupLayout.PREFERRED_SIZE, 163, javax.swing.GroupLayout.PREFERRED_SIZE))
  327. .addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createSequentialGroup()
  328. .addContainerGap()
  329. .addComponent(jLabel2)))
  330. .addGap(0, 0, Short.MAX_VALUE)))
  331. .addContainerGap())
  332. .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  333. .addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  334. );
  335. layout.setVerticalGroup(
  336. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  337. .addGroup(layout.createSequentialGroup()
  338. .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  339. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  340. .addComponent(jLabel2)
  341. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  342. .addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  343. .addGap(9, 9, 9)
  344. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  345. .addComponent(txt_nomk, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  346. .addComponent(jLabel4)
  347. .addComponent(jLabel5)
  348. .addComponent(txt_namamk, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  349. .addGap(15, 15, 15)
  350. .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 106, javax.swing.GroupLayout.PREFERRED_SIZE)
  351. .addGap(18, 18, 18)
  352. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  353. .addComponent(btn_tambah)
  354. .addComponent(btn_ubah)
  355. .addComponent(btn_hapus)
  356. .addComponent(btn_simpan)
  357. .addComponent(btn_batal)
  358. .addComponent(btn_keluar))
  359. .addContainerGap(13, Short.MAX_VALUE))
  360. );
  361.  
  362. pack();
  363. }// </editor-fold>
  364.  
  365. private void formWindowClosed(java.awt.event.WindowEvent evt) {
  366. // TODO add your handling code here:
  367. System.exit(0);
  368. }
  369.  
  370. private void btn_ubahActionPerformed(java.awt.event.ActionEvent evt) {
  371. // TODO add your handling code here:
  372. // String data[] = new String[5];
  373. int selectedOption = JOptionPane.showConfirmDialog(null,
  374. "Apakah Data Sudah Benar?",
  375. "Konfirmasi",
  376. JOptionPane.YES_NO_OPTION);
  377. if (selectedOption == JOptionPane.YES_OPTION) {
  378. String kd_mk = txt_nomk.getText();
  379. String nama_mk = txt_namamk.getText();
  380.  
  381. if(kd_mk.isEmpty() || nama_mk.isEmpty() ){
  382. JOptionPane.showMessageDialog(null, "Data Tidak Boleh Kosong, Silahkan Dilengkapi");
  383. txt_nomk.requestFocus();
  384. }else{
  385. try{
  386. Class.forName(driver);
  387. Connection conn = DriverManager.getConnection(database,user,pass);
  388. Statement stmt = conn.createStatement();
  389. // String sql = "insert into t_mata_kuliah VALUES("
  390. // + "'"+kd_mk+"',"
  391. // + "'"+nama_mk+"')";
  392. //
  393. String sql= "UPDATE t_mata_kuliah "
  394. + "SET nama_mk='"+nama_mk+"'"
  395. + "WHERE "
  396. + "kd_mk='"+tabelmodel.getValueAt(row, 0).toString()+"'";
  397. stmt.executeUpdate(sql);
  398. tabelmodel.insertRow(0,data);
  399. stmt.close();
  400. conn.close();
  401. membersihkan_teks();
  402. btn_simpan.setEnabled(false);
  403. btn_hapus.setEnabled(false);
  404. btn_ubah.setEnabled(false);
  405. nonaktifkan_teks();
  406. //refresh table
  407. tabelmodel.setRowCount(0);
  408. settableload();
  409. JOptionPane.showMessageDialog(this, "DATA BERHASIL DIUBAH!","SUKSES",
  410. +JOptionPane.INFORMATION_MESSAGE);
  411. }catch(Exception ex){
  412. JOptionPane.showMessageDialog(null, ex.getMessage(),"ERROR",JOptionPane.ERROR_MESSAGE);
  413. }
  414. }
  415. }
  416. }
  417.  
  418. private void btn_simpanActionPerformed(java.awt.event.ActionEvent evt) {
  419. // TODO add your handling code here:
  420. int selectedOption = JOptionPane.showConfirmDialog(null,
  421. "Apakah Data Sudah Benar?",
  422. "Konfirmasi",
  423. JOptionPane.YES_NO_OPTION);
  424. if (selectedOption == JOptionPane.YES_OPTION) {
  425. String data[] = new String[5];
  426. String kd_mk = txt_nomk.getText();
  427. String nama_mk = txt_namamk.getText();
  428.  
  429. if(kd_mk.isEmpty() || nama_mk.isEmpty() ){
  430. JOptionPane.showMessageDialog(null, "Data Tidak Boleh Kosong, Silahkan Dilengkapi");
  431. txt_nomk.requestFocus();
  432. }else{
  433. try{
  434. Class.forName(driver);
  435. Connection conn = DriverManager.getConnection(database,user,pass);
  436. Statement stmt = conn.createStatement();
  437. String sql = "insert into t_mata_kuliah VALUES("
  438. + "'"+kd_mk+"',"
  439. + "'"+nama_mk+"')";
  440. stmt.executeUpdate(sql);
  441. tabelmodel.insertRow(0,data);
  442. stmt.close();
  443. conn.close();
  444. membersihkan_teks();
  445. btn_simpan.setEnabled(false);
  446. btn_batal.setEnabled(false);
  447. btn_tambah.setEnabled(true);
  448. btn_keluar.setEnabled(true);
  449. nonaktifkan_teks();
  450. //refresh table
  451. tabelmodel.setRowCount(0);
  452. settableload();
  453. JOptionPane.showMessageDialog(this, "DATA BERHASIL DITAMBAH!","SUKSES",
  454. +JOptionPane.INFORMATION_MESSAGE);
  455. }catch(Exception ex){
  456. JOptionPane.showMessageDialog(null, ex.getMessage(),"ERROR",JOptionPane.ERROR_MESSAGE);
  457. }
  458. }
  459. }
  460. }
  461.  
  462. private void tabel_matkulMouseClicked(java.awt.event.MouseEvent evt) {
  463. // TODO add your handling code here:
  464. tampil_field();
  465. txt_nomk.setEnabled(false);
  466. }
  467.  
  468. private void btn_tambahActionPerformed(java.awt.event.ActionEvent evt) {
  469. // TODO add your handling code here:
  470. membersihkan_teks();
  471. txt_nomk.requestFocus();
  472. btn_simpan.setEnabled(true);
  473. btn_ubah.setEnabled(false);
  474. btn_hapus.setEnabled(false);
  475. btn_keluar.setEnabled(false);
  476. btn_batal.setEnabled(true);
  477. btn_tambah.setEnabled(false);
  478. aktif_teks();
  479. }
  480.  
  481. private void btn_hapusActionPerformed(java.awt.event.ActionEvent evt) {
  482. // TODO add your handling code here:
  483. try{
  484. Class.forName(driver);
  485. Connection kon = DriverManager.getConnection(database,user,pass);
  486. Statement stt = kon.createStatement();
  487. String SQL = "DELETE FROM t_mata_kuliah "
  488. + "WHERE "
  489. + "kd_mk='"+tabelmodel.getValueAt(row, 0).toString()+"'";
  490. int selectedOption = JOptionPane.showConfirmDialog(null,
  491. "Apakah anda yakin ingin menghapus ??",
  492. "Hapus",
  493. JOptionPane.YES_NO_OPTION);
  494. if (selectedOption == JOptionPane.YES_OPTION) {
  495. stt.executeUpdate(SQL);
  496. tabelmodel.removeRow(row);
  497. stt.close();
  498. kon.close();
  499. btn_ubah.setEnabled(false);
  500. btn_hapus.setEnabled(false);
  501. btn_tambah.setEnabled(true);
  502. btn_keluar.setEnabled(true);
  503. membersihkan_teks();
  504. nonaktifkan_teks();
  505. JOptionPane.showMessageDialog(this, "DATA BERHASIL DIHAPUS!","SUKSES",
  506. +JOptionPane.INFORMATION_MESSAGE);
  507. //refresh table
  508. tabelmodel.setRowCount(0);
  509. settableload();
  510. }
  511.  
  512. }catch(Exception ex){
  513. System.err.println(ex.getMessage());
  514. }
  515. }
  516.  
  517. private void btn_cariActionPerformed(java.awt.event.ActionEvent evt) {
  518. // TODO add your handling code here:
  519. //menghapus seluruh isi data pada JTable
  520. tabelmodel.setRowCount(0);
  521. //gunakan query untuk mencari
  522. try{
  523. Class.forName(driver);
  524. Connection kon = DriverManager.getConnection(database,user,pass);
  525. Statement stt = kon.createStatement();
  526. String SQL = "SELECT* FROM t_mata_kuliah WHERE kd_mk LIKE"
  527. + "'%"+txt_carimk.getText()+"%'";
  528.  
  529. ResultSet res = stt.executeQuery(SQL);
  530. while(res.next()){
  531. data[0] = res.getString(1);
  532. data[1] = res.getString(2);
  533. tabelmodel.addRow(data);
  534. }
  535. res.close();
  536.  
  537. stt.close();
  538. kon.close();
  539. }catch(Exception ex){
  540. System.err.println(ex.getMessage());
  541. JOptionPane.showMessageDialog(null,
  542. ex.getMessage(),
  543. "Error",
  544. JOptionPane.INFORMATION_MESSAGE);
  545. System.exit(0);
  546. }
  547. }
  548.  
  549. private void btn_batalActionPerformed(java.awt.event.ActionEvent evt) {
  550. // TODO add your handling code here:
  551. nonaktifkan_teks();
  552. membersihkan_teks();
  553. btn_simpan.setEnabled(false);
  554. btn_ubah.setEnabled(true);
  555. btn_hapus.setEnabled(true);
  556. btn_keluar.setEnabled(true);
  557. btn_batal.setEnabled(false);
  558. btn_tambah.setEnabled(true);
  559. }
  560.  
  561. private void btn_keluarActionPerformed(java.awt.event.ActionEvent evt) {
  562. // TODO add your handling code here:
  563. int selectedOption = JOptionPane.showConfirmDialog(null,
  564. "Apakah anda ingin kembali ke menu?",
  565. "Kembali Ke Menu",
  566. JOptionPane.YES_NO_OPTION);
  567. if (selectedOption == JOptionPane.YES_OPTION) {
  568. frm_utama utama = new frm_utama();
  569. utama.setVisible(true);
  570.  
  571. this.setVisible(false);
  572. }
  573. }
  574.  
  575. // Variables declaration - do not modify
  576. private javax.swing.JButton btn_batal;
  577. private javax.swing.JButton btn_cari;
  578. private javax.swing.JButton btn_hapus;
  579. private javax.swing.JButton btn_keluar;
  580. private javax.swing.JButton btn_simpan;
  581. private javax.swing.JButton btn_tambah;
  582. private javax.swing.JButton btn_ubah;
  583. private javax.swing.JLabel jLabel1;
  584. private javax.swing.JLabel jLabel2;
  585. private javax.swing.JLabel jLabel3;
  586. private javax.swing.JLabel jLabel4;
  587. private javax.swing.JLabel jLabel5;
  588. private javax.swing.JPanel jPanel1;
  589. private javax.swing.JPanel jPanel2;
  590. private javax.swing.JScrollPane jScrollPane1;
  591. private javax.swing.JTable tabel_matkul;
  592. private javax.swing.JTextField txt_carimk;
  593. private javax.swing.JTextField txt_namamk;
  594. private javax.swing.JTextField txt_nomk;
  595. // End of variables declaration
  596. }
Add Comment
Please, Sign In to add comment
Public Pastes
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!