API tools faq
paste
Guest User

PBO

a guest
Dec 21st, 2018
46
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 26.73 KB | None | 0 0
raw download clone embed print report
  1. /*
  2. * To change this template, choose Tools | Templates
  3. * and open the template in the editor.
  4. */
  5. package input.data.Studio.Musik;
  6.  
  7. import java.sql.DriverManager;
  8. import java.sql.ResultSet;
  9. import java.sql.Statement;
  10. import javax.swing.JOptionPane;
  11. import javax.swing.table.DefaultTableModel;
  12.  
  13. /**
  14. *
  15. * @author
  16. */
  17. public class Frame_booking_studio extends javax.swing.JFrame {
  18. private DefaultTableModel Datta;
  19. java.sql.Connection Con;
  20.  
  21. private void LoadData(){
  22. Object Kolom[] = {"kode","tanggal","bulan","tahun","mulai","akhir","nama","band","nohp"};
  23. Datta = new DefaultTableModel(null,Kolom);
  24. tblBarang.setModel(Datta);
  25. jScrollPane2.getViewport().add(tblBarang,null);
  26. try{
  27. Con = null;
  28. Class.forName("com.mysql.jdbc.Driver");
  29. java.sql.Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/studio","root","");
  30. String sql = ""+"SELECT * from std";
  31. Statement stat = con.createStatement();
  32. ResultSet res = stat.executeQuery(sql);
  33. while (res.next()){
  34. String kode = res.getString("kode");
  35. String tanggal = res.getString("tanggal");
  36. String bulan = res.getString("bulan");
  37. String tahun = res.getString("tahun");
  38. String mulai = res.getString("mulai");
  39. String akhir = res.getString("akhir");
  40. String Nama = res.getString("nama");
  41. String band = res.getString("band");
  42. String nohp = res.getString("nohp");
  43. Object[] data = {kode, tanggal, bulan, tahun, mulai, akhir, Nama, band, nohp, };
  44. Datta.addRow(data);
  45. }
  46.  
  47. tblBarang.getColumnModel().getColumn(0).setPreferredWidth(100);
  48. tblBarang.getColumnModel().getColumn(1).setPreferredWidth(50);
  49. tblBarang.getColumnModel().getColumn(2).setPreferredWidth(100);
  50. tblBarang.getColumnModel().getColumn(3).setPreferredWidth(80);
  51. tblBarang.getColumnModel().getColumn(4).setPreferredWidth(80);
  52. tblBarang.getColumnModel().getColumn(5).setPreferredWidth(80);
  53. tblBarang.getColumnModel().getColumn(6).setPreferredWidth(200);
  54. tblBarang.getColumnModel().getColumn(7).setPreferredWidth(80);
  55. tblBarang.getColumnModel().getColumn(8).setPreferredWidth(200);
  56.  
  57. } catch(Exception ex) {
  58. JOptionPane.showMessageDialog(this,"Error: " + ex);
  59.  
  60. }
  61. }
  62. //double nama,harga,jmlhjual,total;
  63. // Model_booking penjualan = new Model_booking();
  64.  
  65.  
  66. public Frame_booking_studio() {
  67. initComponents();
  68. // tblBarang.setModel(penjualan.getTabel());
  69.  
  70. Kode.addItem("STUDIO 01");
  71. Kode.addItem("STUDIO 02");
  72. Kode.addItem("STUDIO 03");
  73. Kode.addItem("STUDIO 04");
  74. Kode.addItem("STUDIO 05");
  75.  
  76.  
  77.  
  78. for (int a=1; a<=31; a++){
  79. Tgl.addItem(a);
  80. }
  81.  
  82. Bln.addItem("Januari");
  83. Bln.addItem("Februari");
  84. Bln.addItem("Maret");
  85. Bln.addItem("April");
  86. Bln.addItem("Mei");
  87. Bln.addItem("Juni");
  88. Bln.addItem("Juli");
  89. Bln.addItem("Agustus");
  90. Bln.addItem("September");
  91. Bln.addItem("Oktober");
  92. Bln.addItem("November");
  93. Bln.addItem("Desember");
  94.  
  95. for (int b=2000; b<=2020; b++){
  96. Thn.addItem(b);
  97. }
  98.  
  99. Jam1.addItem("08.00");
  100. Jam1.addItem("09.00");
  101. Jam1.addItem("10.00");
  102. Jam1.addItem("11.00");
  103. Jam1.addItem("12.00");
  104. Jam1.addItem("13.00");
  105. Jam1.addItem("14.00");
  106. Jam1.addItem("15.00");
  107. Jam1.addItem("16.00");
  108. Jam1.addItem("17.00");
  109. Jam1.addItem("18.00");
  110. Jam1.addItem("19.00");
  111. Jam1.addItem("20.00");
  112. Jam1.addItem("21.00");
  113. Jam1.addItem("22.00");
  114. Jam1.addItem("23.00");
  115. Jam1.addItem("24.00");
  116.  
  117. Jam2.addItem("08.00");
  118. Jam2.addItem("09.00");
  119. Jam2.addItem("10.00");
  120. Jam2.addItem("11.00");
  121. Jam2.addItem("12.00");
  122. Jam2.addItem("13.00");
  123. Jam2.addItem("14.00");
  124. Jam2.addItem("15.00");
  125. Jam2.addItem("16.00");
  126. Jam2.addItem("17.00");
  127. Jam2.addItem("18.00");
  128. Jam2.addItem("19.00");
  129. Jam2.addItem("20.00");
  130. Jam2.addItem("21.00");
  131. Jam2.addItem("22.00");
  132. Jam2.addItem("23.00");
  133. Jam2.addItem("24.00");
  134.  
  135. }
  136.  
  137. /**
  138. * This method is called from within the constructor to initialize the form.
  139. * WARNING: Do NOT modify this code. The content of this method is always
  140. * regenerated by the Form Editor.
  141. */
  142. @SuppressWarnings("unchecked")
  143. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  144. private void initComponents() {
  145.  
  146. jLabel2 = new javax.swing.JLabel();
  147. jLabel1 = new javax.swing.JLabel();
  148. jLabel3 = new javax.swing.JLabel();
  149. jScrollPane2 = new javax.swing.JScrollPane();
  150. tblBarang = new javax.swing.JTable();
  151. btnPesan = new javax.swing.JButton();
  152. jLabel5 = new javax.swing.JLabel();
  153. txtNama = new javax.swing.JTextField();
  154. btnHapus = new javax.swing.JButton();
  155. jLabel6 = new javax.swing.JLabel();
  156. txtTeam = new javax.swing.JTextField();
  157. jLabel7 = new javax.swing.JLabel();
  158. txtNo = new javax.swing.JTextField();
  159. jLabel4 = new javax.swing.JLabel();
  160. Tgl = new javax.swing.JComboBox();
  161. Bln = new javax.swing.JComboBox();
  162. Thn = new javax.swing.JComboBox();
  163. Jam1 = new javax.swing.JComboBox();
  164. Jam2 = new javax.swing.JComboBox();
  165. jLabel8 = new javax.swing.JLabel();
  166. Kode = new javax.swing.JComboBox();
  167. cari = new javax.swing.JButton();
  168.  
  169. setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  170.  
  171. jLabel2.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  172. jLabel2.setText("Kode Booking");
  173.  
  174. jLabel1.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
  175. jLabel1.setText("Studio Musik Universitas Gunadarma");
  176.  
  177. jLabel3.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  178. jLabel3.setText("Tanggal Pemesanan");
  179.  
  180. tblBarang.setModel(new javax.swing.table.DefaultTableModel(
  181. new Object [][] {
  182. {null, null, null, null},
  183. {null, null, null, null},
  184. {null, null, null, null},
  185. {null, null, null, null}
  186. },
  187. new String [] {
  188. "Title 1", "Title 2", "Title 3", "Title 4"
  189. }
  190. ));
  191. jScrollPane2.setViewportView(tblBarang);
  192.  
  193. btnPesan.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  194. btnPesan.setText("Pesan");
  195. btnPesan.addActionListener(new java.awt.event.ActionListener() {
  196. public void actionPerformed(java.awt.event.ActionEvent evt) {
  197. btnPesanActionPerformed(evt);
  198. }
  199. });
  200.  
  201. jLabel5.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  202. jLabel5.setText("Nama Pemesan");
  203.  
  204. txtNama.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  205. txtNama.addKeyListener(new java.awt.event.KeyAdapter() {
  206. public void keyPressed(java.awt.event.KeyEvent evt) {
  207. txtNamaKeyPressed(evt);
  208. }
  209. });
  210.  
  211. btnHapus.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  212. btnHapus.setText("Hapus");
  213. btnHapus.addActionListener(new java.awt.event.ActionListener() {
  214. public void actionPerformed(java.awt.event.ActionEvent evt) {
  215. btnHapusActionPerformed(evt);
  216. }
  217. });
  218.  
  219. jLabel6.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  220. jLabel6.setText("No Handphone");
  221.  
  222. txtTeam.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  223. txtTeam.addKeyListener(new java.awt.event.KeyAdapter() {
  224. public void keyPressed(java.awt.event.KeyEvent evt) {
  225. txtTeamKeyPressed(evt);
  226. }
  227. });
  228.  
  229. jLabel7.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  230. jLabel7.setText("Nama Band");
  231.  
  232. txtNo.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  233. txtNo.addActionListener(new java.awt.event.ActionListener() {
  234. public void actionPerformed(java.awt.event.ActionEvent evt) {
  235. txtNoActionPerformed(evt);
  236. }
  237. });
  238. txtNo.addKeyListener(new java.awt.event.KeyAdapter() {
  239. public void keyPressed(java.awt.event.KeyEvent evt) {
  240. txtNoKeyPressed(evt);
  241. }
  242. });
  243.  
  244. jLabel4.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  245. jLabel4.setText("Waktu");
  246.  
  247. Tgl.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Tanggal" }));
  248. Tgl.addActionListener(new java.awt.event.ActionListener() {
  249. public void actionPerformed(java.awt.event.ActionEvent evt) {
  250. TglActionPerformed(evt);
  251. }
  252. });
  253.  
  254. Bln.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Bulan" }));
  255.  
  256. Thn.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Tahun" }));
  257.  
  258. Jam1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Mulai" }));
  259. Jam1.addActionListener(new java.awt.event.ActionListener() {
  260. public void actionPerformed(java.awt.event.ActionEvent evt) {
  261. Jam1ActionPerformed(evt);
  262. }
  263. });
  264.  
  265. Jam2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Selesai" }));
  266.  
  267. jLabel8.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  268. jLabel8.setText("Sampai");
  269.  
  270. Kode.addActionListener(new java.awt.event.ActionListener() {
  271. public void actionPerformed(java.awt.event.ActionEvent evt) {
  272. KodeActionPerformed(evt);
  273. }
  274. });
  275.  
  276. cari.setText("Cari");
  277. cari.addActionListener(new java.awt.event.ActionListener() {
  278. public void actionPerformed(java.awt.event.ActionEvent evt) {
  279. cariActionPerformed(evt);
  280. }
  281. });
  282.  
  283. javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  284. getContentPane().setLayout(layout);
  285. layout.setHorizontalGroup(
  286. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  287. .addGroup(layout.createSequentialGroup()
  288. .addGap(26, 26, 26)
  289. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  290. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  291. .addGroup(layout.createSequentialGroup()
  292. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  293. .addComponent(jLabel3)
  294. .addComponent(jLabel2))
  295. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  296. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  297. .addComponent(Kode, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 242, javax.swing.GroupLayout.PREFERRED_SIZE)
  298. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  299. .addGroup(layout.createSequentialGroup()
  300. .addComponent(Jam1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  301. .addGap(18, 18, 18)
  302. .addComponent(jLabel8))
  303. .addGroup(layout.createSequentialGroup()
  304. .addComponent(Tgl, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  305. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  306. .addComponent(Bln, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  307. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  308. .addComponent(Thn, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))))
  309. .addGroup(layout.createSequentialGroup()
  310. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  311. .addComponent(jLabel6)
  312. .addComponent(jLabel5)
  313. .addComponent(jLabel7)
  314. .addComponent(jLabel4))
  315. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  316. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
  317. .addGroup(layout.createSequentialGroup()
  318. .addComponent(btnPesan)
  319. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  320. .addComponent(cari)
  321. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  322. .addComponent(btnHapus))
  323. .addComponent(Jam2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  324. .addComponent(txtNama)
  325. .addComponent(txtNo)
  326. .addComponent(txtTeam))))
  327. .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 561, javax.swing.GroupLayout.PREFERRED_SIZE))
  328. .addGap(18, 18, 18))
  329. .addGroup(layout.createSequentialGroup()
  330. .addGap(140, 140, 140)
  331. .addComponent(jLabel1)
  332. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  333. );
  334. layout.setVerticalGroup(
  335. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  336. .addGroup(layout.createSequentialGroup()
  337. .addGap(30, 30, 30)
  338. .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 30, javax.swing.GroupLayout.PREFERRED_SIZE)
  339. .addGap(46, 46, 46)
  340. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  341. .addComponent(jLabel2)
  342. .addComponent(Kode, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  343. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  344. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  345. .addComponent(jLabel3)
  346. .addComponent(Tgl, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  347. .addComponent(Bln, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  348. .addComponent(Thn, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  349. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  350. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  351. .addComponent(jLabel4)
  352. .addComponent(Jam1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  353. .addComponent(Jam2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  354. .addComponent(jLabel8))
  355. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  356. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  357. .addComponent(txtNama, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  358. .addComponent(jLabel5, javax.swing.GroupLayout.PREFERRED_SIZE, 23, javax.swing.GroupLayout.PREFERRED_SIZE))
  359. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  360. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  361. .addComponent(txtTeam, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  362. .addComponent(jLabel7))
  363. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  364. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  365. .addComponent(txtNo, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  366. .addComponent(jLabel6, javax.swing.GroupLayout.PREFERRED_SIZE, 23, javax.swing.GroupLayout.PREFERRED_SIZE))
  367. .addGap(18, 18, 18)
  368. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  369. .addComponent(btnHapus)
  370. .addComponent(btnPesan)
  371. .addComponent(cari))
  372. .addGap(18, 18, 18)
  373. .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 153, javax.swing.GroupLayout.PREFERRED_SIZE)
  374. .addContainerGap(52, Short.MAX_VALUE))
  375. );
  376.  
  377. pack();
  378. }// </editor-fold>
  379.  
  380. private void btnPesanActionPerformed(java.awt.event.ActionEvent evt) {
  381.  
  382. try{
  383. Class.forName("com.mysql.jdbc.Driver");
  384. java.sql.Connection Connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/studio","root","");
  385. Statement Stat = Connection.createStatement();
  386. String sqlnya =("insert into std value ('"+Kode.getSelectedItem()+"','"+Tgl.getSelectedItem()+"',"
  387. + "'"+Bln.getSelectedItem()+"','"+Thn.getSelectedItem()+"','"+Jam1.getSelectedItem()+"','"
  388. +Jam2.getSelectedItem()+"','"+txtNama.getText()+"','"+txtTeam.getText()+"','"+txtNo.getText()+"')");
  389. Stat.executeUpdate(sqlnya);
  390. JOptionPane.showMessageDialog(null,"Data Tersimpan");
  391. LoadData();
  392. }
  393. catch(Exception e){
  394. System.out.print(e);
  395. JOptionPane.showMessageDialog(null,"Koneksi Gagal");
  396. }
  397.  
  398. }
  399.  
  400. private void txtNamaKeyPressed(java.awt.event.KeyEvent evt) {
  401. // TODO add your handling code here:
  402. }
  403.  
  404. private void btnHapusActionPerformed(java.awt.event.ActionEvent evt) {
  405. // penjualan.getTabel().removeRow(tblBarang.getSelectedRow());
  406. String x = txtNama.getText();
  407. try{
  408. Class.forName("com.mysql.jdbc.Driver");
  409. java.sql.Connection Connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/studio","root","");
  410. Statement stat=Connection.createStatement();
  411. String sql="DELETE FROM std WHERE nama='"+x+"'";
  412. stat.executeUpdate(sql);
  413. JOptionPane.showMessageDialog(null,"Data Telah Dihapus");
  414. LoadData();
  415. Kode.setSelectedItem(null);
  416. Tgl.setSelectedItem(null);
  417. Bln.setSelectedItem(null);
  418. Thn.setSelectedItem(null);
  419. Jam1.setSelectedItem(null);
  420. Jam2.setSelectedItem(null);
  421. txtNama.setText(null);
  422. txtTeam.setText(null);
  423. txtNo.setText(null);
  424. }catch (Exception e) {
  425. System.out.print(e);
  426. JOptionPane.showMessageDialog(null,"Koneksi Gagal");
  427. }
  428. }
  429.  
  430. private void txtTeamKeyPressed(java.awt.event.KeyEvent evt) {
  431. // TODO add your handling code here:
  432. }
  433.  
  434. private void txtNoKeyPressed(java.awt.event.KeyEvent evt) {
  435. // TODO add your handling code here:
  436. }
  437.  
  438. private void TglActionPerformed(java.awt.event.ActionEvent evt) {
  439. // TODO add your handling code here:
  440. }
  441.  
  442. private void txtNoActionPerformed(java.awt.event.ActionEvent evt) {
  443. // TODO add your handling code here:
  444. }
  445.  
  446. private void KodeActionPerformed(java.awt.event.ActionEvent evt) {
  447. // TODO add your handling code here:
  448. }
  449.  
  450. private void Jam1ActionPerformed(java.awt.event.ActionEvent evt) {
  451. // TODO add your handling code here:
  452. }
  453.  
  454. private void cariActionPerformed(java.awt.event.ActionEvent evt) {
  455. // TODO add your handling code here:
  456. String x = JOptionPane.showInputDialog(null,"Masukkan Nama Anda");
  457. try{
  458. Class.forName("com.mysql.jdbc.Driver");
  459. java.sql.Connection Connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/studio","root","");
  460. Statement Stat=Connection.createStatement();
  461. String Cari= "SELECT * FROM std WHERE nama='"+x+"'";
  462. ResultSet rsnya = Stat.executeQuery(Cari);
  463. if(rsnya.next()){
  464. System.out.print (rsnya.getString(1));
  465. JOptionPane.showMessageDialog(null,"Data Ditemukan");
  466. LoadData();
  467. Kode.setSelectedItem(rsnya.getString(1));
  468. Tgl.setSelectedItem(rsnya.getString(2));
  469. Bln.setSelectedItem(rsnya.getString(3));
  470. Thn.setSelectedItem(rsnya.getString(4));
  471. Jam1.setSelectedItem(rsnya.getString(5));
  472. Jam2.setSelectedItem(rsnya.getString(6));
  473. txtNama.setText(rsnya.getString(7));
  474. txtTeam.setText(rsnya.getString(8));
  475. txtNo.setText(rsnya.getString(9));
  476. }
  477. else {
  478. JOptionPane.showMessageDialog(null,"Data tidak ada");
  479. }
  480. }catch(Exception e){
  481. System.out.print(e);
  482. JOptionPane.showMessageDialog (null,"Koneksi Gagal");
  483. }
  484. }
  485.  
  486. /**
  487. * @param args the command line arguments
  488. */
  489. public static void main(String args[]) {
  490. /*
  491. * Set the Nimbus look and feel
  492. */
  493. //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
  494. /*
  495. * If Nimbus (introduced in Java SE 6) is not available, stay with the
  496. * default look and feel. For details see
  497. * http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
  498. */
  499. try {
  500. for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
  501. if ("Nimbus".equals(info.getName())) {
  502. javax.swing.UIManager.setLookAndFeel(info.getClassName());
  503. break;
  504. }
  505. }
  506. } catch (ClassNotFoundException ex) {
  507. java.util.logging.Logger.getLogger(Frame_booking_studio.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  508. } catch (InstantiationException ex) {
  509. java.util.logging.Logger.getLogger(Frame_booking_studio.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  510. } catch (IllegalAccessException ex) {
  511. java.util.logging.Logger.getLogger(Frame_booking_studio.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  512. } catch (javax.swing.UnsupportedLookAndFeelException ex) {
  513. java.util.logging.Logger.getLogger(Frame_booking_studio.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  514. }
  515. //</editor-fold>
  516. //</editor-fold>
  517.  
  518. /*
  519. * Create and display the form
  520. */
  521. java.awt.EventQueue.invokeLater(new Runnable() {
  522.  
  523. public void run() {
  524. new Frame_booking_studio().setVisible(true);
  525. }
  526. });
  527. }
  528. // Variables declaration - do not modify
  529. private javax.swing.JComboBox Bln;
  530. private javax.swing.JComboBox Jam1;
  531. private javax.swing.JComboBox Jam2;
  532. private javax.swing.JComboBox Kode;
  533. private javax.swing.JComboBox Tgl;
  534. private javax.swing.JComboBox Thn;
  535. private javax.swing.JButton btnHapus;
  536. private javax.swing.JButton btnPesan;
  537. private javax.swing.JButton cari;
  538. private javax.swing.JLabel jLabel1;
  539. private javax.swing.JLabel jLabel2;
  540. private javax.swing.JLabel jLabel3;
  541. private javax.swing.JLabel jLabel4;
  542. private javax.swing.JLabel jLabel5;
  543. private javax.swing.JLabel jLabel6;
  544. private javax.swing.JLabel jLabel7;
  545. private javax.swing.JLabel jLabel8;
  546. private javax.swing.JScrollPane jScrollPane2;
  547. private javax.swing.JTable tblBarang;
  548. private javax.swing.JTextField txtNama;
  549. private javax.swing.JTextField txtNo;
  550. private javax.swing.JTextField txtTeam;
  551. // End of variables declaration
  552. }
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!