API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 17th, 2016
69
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 29.13 KB | None | 0 0
raw download clone embed print report
  1. -Koneksi_database
  2. package Penjualan_Nama_Siswa_Rus;
  3.  
  4.  
  5. import java.sql.Connection;
  6. import java.sql.DriverManager;
  7. import java.sql.SQLException;
  8.  
  9. /*
  10. * To change this template, choose Tools | Templates
  11. * and open the template in the editor.
  12. */
  13.  
  14. /**
  15. *
  16. * @author SMK
  17. */
  18. public class koneksi_data_base {
  19. private Connection connect;
  20. private String driverName = "org.postgresql.Driver";
  21. private String jdbc = "jdbc:postgresql://";
  22. private String host = "localhost:";
  23. private String port ="5432/";
  24. private String database = "Transkasi_Rus";
  25. private String url = jdbc +host +port + database;
  26. private String username = "postgres";
  27. private String password = "123456";
  28.  
  29. public Connection getKoneksi() throws SQLException {
  30. if (connect==null){
  31. try {
  32. Class.forName(driverName);
  33. System.out.println("class Driver Ditemukan");
  34. try {
  35. connect = DriverManager.getConnection(url, username, password);
  36. System.out.println("Koneksi Database Sukses");
  37. }catch (SQLException se) {
  38. System.out.println("Koneksi Database Gagal :"+se);
  39. System.exit(0);
  40. }
  41. }catch (ClassNotFoundException cnfe){
  42. System.out.println("Class Driver Tidak Ditemukan, Terjadi Kesalahan Pada"+cnfe);
  43. System.exit(0);
  44. }
  45. }
  46. return connect;
  47. }
  48. }
  49.  
  50.  
  51.  
  52.  
  53. -Master
  54. /*
  55. * To change this template, choose Tools | Templates
  56. * and open the template in the editor.
  57. */
  58. package Penjualan_Nama_Siswa_Rus;
  59.  
  60. import java.sql.Connection;
  61. import java.sql.PreparedStatement;
  62. import java.sql.ResultSet;
  63. import java.sql.Statement;
  64. import javax.swing.JOptionPane;
  65.  
  66. /**
  67. *
  68. * @author SMK
  69. */
  70. public class Master_Transaksi {
  71. Connection cnn;
  72. koneksi_data_base getCnn = new koneksi_data_base ();
  73.  
  74. public String id_transaksi;
  75. public String nama;
  76. public Integer item;
  77. public Integer harga;
  78. public Integer total;
  79. public String Akses="";
  80.  
  81.  
  82. //untuk mencari data
  83. public void search (String id_transaksi) {
  84. try {
  85. Akses="";
  86. cnn = getCnn.getKoneksi();
  87. String SQL = "select * from transaksi where id_transaksi='"+id_transaksi+"'";
  88. Statement stat = cnn.createStatement();
  89. ResultSet res = stat.executeQuery(SQL);
  90. while (res.next())
  91. {
  92. Akses="-";
  93. this.id_transaksi = res.getString(1);
  94. this .nama = res.getString(2);
  95. this.item = res.getInt(3);
  96. this.harga = res.getInt(4);
  97. this.total = res.getInt(5);
  98. }
  99. stat.close();
  100. }
  101. catch (Exception ex)
  102. {
  103. JOptionPane.showMessageDialog(null, ex);
  104. }
  105. }
  106.  
  107. // Untuk simpan data dan update
  108. public void SaveOrUpdate()
  109. {
  110. try {
  111. String sql = "";
  112. cnn = getCnn.getKoneksi();
  113. if (Akses.equals(""))
  114. {
  115. sql = "insert into transaksi values (?,?,?,?,?,?,?)";
  116. }
  117. else
  118. {
  119. sql = "update transaksi set id_transaksi=?, nama=?, item=?, harga=?, total=? where id_transaksi='"+id_transaksi+"'";
  120. }
  121. PreparedStatement stat = cnn.prepareStatement(sql);
  122. stat.setString(1, this.id_transaksi);
  123. stat.setString(2, this.nama);
  124. stat.setInt(3, this.item);
  125. stat.setInt(4, this.harga);
  126. stat.setInt(5, this.total);
  127.  
  128. stat.executeUpdate();
  129. stat.close();
  130. }
  131. catch(Exception ex)
  132. {
  133. JOptionPane.showMessageDialog(null, "Terjadi Kesalahan" +ex);
  134. }
  135. }
  136. public void SaveData(){
  137. try {
  138. String sql = "";
  139. cnn = getCnn.getKoneksi();
  140. sql = "insert into transaksi values (?,?,?,?,?)";
  141.  
  142. PreparedStatement stat = cnn.prepareStatement(sql);
  143. stat.setString(1, this.id_transaksi);
  144. stat.setString(2, this.nama);
  145. stat.setInt(3, this.item);
  146. stat.setInt(4, this.harga);
  147. stat.setInt(5, this.total);
  148.  
  149. stat.executeUpdate();
  150. stat.close();
  151. }
  152. catch(Exception ex)
  153. {
  154. JOptionPane.showMessageDialog(null, "Terjadi Kesalahan" +ex);
  155. }
  156. }
  157. public void UpdateData(){
  158. try {
  159. String sql = "";
  160. cnn = getCnn.getKoneksi();
  161.  
  162. sql = "update transaksi set id_transaksi=?, nama=?, item=?, harga=?, total=? where id_transaksi='"+id_transaksi+"'";
  163.  
  164. PreparedStatement stat = cnn.prepareStatement(sql);
  165. stat.setString(1, this.id_transaksi);
  166. stat.setString(2, this.nama);
  167. stat.setInt(3, this.item);
  168. stat.setInt(4, this.harga);
  169. stat.setInt(5, this.total);
  170.  
  171. stat.executeUpdate();
  172. stat.close();
  173. }
  174. catch(Exception ex)
  175. {
  176. JOptionPane.showMessageDialog(null, "Terjadi Kesalahan" +ex);
  177. }
  178. }
  179. public void Delete (String id_transaksi) {
  180. try {
  181. cnn = getCnn.getKoneksi();
  182. String sql = "delete from transaksi where id_transaksi='"+id_transaksi+"'";
  183. PreparedStatement stat = cnn.prepareStatement(sql);
  184. stat.executeUpdate();
  185. stat.close();
  186. }
  187. catch(Exception ex)
  188. {
  189. JOptionPane.showMessageDialog(null, "Error" +ex);
  190. }
  191. }
  192. }
  193.  
  194.  
  195. -Penjualan
  196. /*
  197. * To change this template, choose Tools | Templates
  198. * and open the template in the editor.
  199. */
  200. package Penjualan_Nama_Siswa_Rus;
  201.  
  202. /**
  203. *
  204. * @author SMK
  205. */
  206. public class Penjualan_Rus {
  207.  
  208. /**
  209. * @param args the command line arguments
  210. */
  211. public static void main(String[] args) {
  212. // TODO code application logic here
  213. }
  214. }
  215.  
  216.  
  217. -Test
  218. package Penjualan_Nama_Siswa_Rus;
  219.  
  220.  
  221.  
  222.  
  223. import java.sql.SQLException;
  224.  
  225. /*
  226. * To change this template, choose Tools | Templates
  227. * and open the template in the editor.
  228. */
  229.  
  230. /**
  231. *
  232. * @author SMK
  233. */
  234. public class Test_Koneksi {
  235. public static void main(String[]args) throws SQLException {
  236. koneksi_data_base connection = new koneksi_data_base();
  237. connection.getKoneksi();
  238. }
  239. }
  240.  
  241.  
  242. -Transaksi
  243. /*
  244. * To change this template, choose Tools | Templates
  245. * and open the template in the editor.
  246. */
  247.  
  248. /*
  249. * Transaksi.java
  250. *
  251. * Created on Jan 7, 2016, 7:20:17 AM
  252. */
  253. package Penjualan_Nama_Siswa_Rus;
  254.  
  255. import java.awt.Dimension;
  256. import java.awt.Toolkit;
  257. import java.sql.Connection;
  258. import java.sql.ResultSet;
  259. import java.sql.Statement;
  260. import javax.swing.JOptionPane;
  261. import javax.swing.table.DefaultTableModel;
  262.  
  263. /**
  264. *
  265. * @author SMK
  266. */
  267. public class Transaksi extends javax.swing.JFrame {
  268. int itm,hrg,ttal;
  269.  
  270. private DefaultTableModel Tampung_Data_Sementara;
  271. Connection cnn;
  272. koneksi_data_base getCnn = new koneksi_data_base ();
  273.  
  274. private Dimension dimensi = Toolkit.getDefaultToolkit().getScreenSize();
  275. /** Creates new form Transaksi */
  276. public Transaksi() {
  277. initComponents();
  278. String [] kolom = {"id_transaksi","nama","item","harga","total"};
  279. Tampung_Data_Sementara = new DefaultTableModel (null, kolom){
  280. Class[] types = new Class []{
  281. java.lang.String.class,
  282. java.lang.String.class,
  283. java.lang.Integer.class,
  284. java.lang.Integer.class
  285. };
  286. public Class getColumnClass (int columnIndex){
  287. return types [columnIndex];
  288. }
  289. public boolean isCellEdittable (int row, int col){
  290. int cola = Tampung_Data_Sementara.getColumnCount();
  291. return (col < cola) ? false : true;
  292. }
  293. };
  294. tampildata.setModel (Tampung_Data_Sementara);
  295. }
  296. public void HapusTabel(){
  297. int row = Tampung_Data_Sementara.getColumnCount();
  298. for ( int i = 0 ; i < row ; i++) {
  299. Tampung_Data_Sementara.removeRow(row);
  300. }
  301. }
  302.  
  303. public void LoadData(){
  304. try {
  305. cnn = null;
  306. koneksi_data_base config = new koneksi_data_base();
  307. cnn = config.getKoneksi();
  308. HapusTabel();
  309. String sql = "Select id_transaksi,nama,item,harga,total"+
  310. "from transaksi"+
  311. "where id_transaksi like '%"+pencarian.getText()+"%'";
  312. Statement stat = cnn.createStatement();
  313. ResultSet res = stat.executeQuery(sql);
  314. while (res.next()){
  315. String id_transaksi = res.getString(2);
  316. String nama = res.getString(2);
  317. Integer item = res.getInt(3);
  318. Integer harga = res.getInt(4);
  319. Integer total = res.getInt(5);
  320. Object [] datatabel ={id_transaksi,nama,item,harga,total};
  321. Tampung_Data_Sementara.addRow(datatabel);
  322. }cnn.close();
  323. tampildata.getColumnModel().getColumn(0).setPreferredWidth(100);
  324. tampildata.getColumnModel().getColumn(1).setPreferredWidth(90);
  325. tampildata.getColumnModel().getColumn(2).setPreferredWidth(80);
  326. tampildata.getColumnModel().getColumn(3).setPreferredWidth(70);
  327. tampildata.getColumnModel().getColumn(4).setPreferredWidth(60);
  328. }catch (Exception ex){
  329. JOptionPane.showMessageDialog(this,"Error :" + ex);
  330. }
  331. }
  332.  
  333. /** This method is called from within the constructor to
  334. * initialize the form.
  335. * WARNING: Do NOT modify this code. The content of this method is
  336. * always regenerated by the Form Editor.
  337. */
  338. @SuppressWarnings("unchecked")
  339. // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
  340. private void initComponents() {
  341.  
  342. jLabel1 = new javax.swing.JLabel();
  343. jLabel2 = new javax.swing.JLabel();
  344. jLabel3 = new javax.swing.JLabel();
  345. jLabel4 = new javax.swing.JLabel();
  346. jLabel5 = new javax.swing.JLabel();
  347. jLabel6 = new javax.swing.JLabel();
  348. idtransaksi = new javax.swing.JTextField();
  349. namabarang = new javax.swing.JTextField();
  350. item = new javax.swing.JTextField();
  351. harga = new javax.swing.JTextField();
  352. total = new javax.swing.JTextField();
  353. jPanel1 = new javax.swing.JPanel();
  354. jLabel7 = new javax.swing.JLabel();
  355. pencarian = new javax.swing.JTextField();
  356. jScrollPane1 = new javax.swing.JScrollPane();
  357. tampildata = new javax.swing.JTable();
  358. cari = new javax.swing.JButton();
  359. jPanel2 = new javax.swing.JPanel();
  360. simpan = new javax.swing.JButton();
  361. hapus = new javax.swing.JButton();
  362. ubah = new javax.swing.JButton();
  363. keluar = new javax.swing.JButton();
  364. jLabel8 = new javax.swing.JLabel();
  365. jLabel9 = new javax.swing.JLabel();
  366.  
  367. setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  368.  
  369. jLabel1.setFont(new java.awt.Font("Comic Sans MS", 1, 18));
  370. jLabel1.setText("TRANSAKSI");
  371.  
  372. jLabel2.setText("ID Transaksi");
  373.  
  374. jLabel3.setText("Nama Barang");
  375.  
  376. jLabel4.setText("ITEM");
  377.  
  378. jLabel5.setText("Harga");
  379.  
  380. jLabel6.setText("Total");
  381.  
  382. idtransaksi.addActionListener(new java.awt.event.ActionListener() {
  383. public void actionPerformed(java.awt.event.ActionEvent evt) {
  384. idtransaksiActionPerformed(evt);
  385. }
  386. });
  387.  
  388. item.addActionListener(new java.awt.event.ActionListener() {
  389. public void actionPerformed(java.awt.event.ActionEvent evt) {
  390. itemActionPerformed(evt);
  391. }
  392. });
  393.  
  394. harga.addKeyListener(new java.awt.event.KeyAdapter() {
  395. public void keyReleased(java.awt.event.KeyEvent evt) {
  396. hargaKeyReleased(evt);
  397. }
  398. });
  399.  
  400. jLabel7.setText("Pencarian");
  401.  
  402. tampildata.setModel(new javax.swing.table.DefaultTableModel(
  403. new Object [][] {
  404. {null, null, null, null, null},
  405. {null, null, null, null, null},
  406. {null, null, null, null, null},
  407. {null, null, null, null, null}
  408. },
  409. new String [] {
  410. "ID Transaksi", "Nama Barang", "ITEM", "Harga", "Total"
  411. }
  412. ));
  413. jScrollPane1.setViewportView(tampildata);
  414.  
  415. cari.setText("Cari");
  416. cari.addActionListener(new java.awt.event.ActionListener() {
  417. public void actionPerformed(java.awt.event.ActionEvent evt) {
  418. cariActionPerformed(evt);
  419. }
  420. });
  421.  
  422. javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
  423. jPanel1.setLayout(jPanel1Layout);
  424. jPanel1Layout.setHorizontalGroup(
  425. jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  426. .addGroup(jPanel1Layout.createSequentialGroup()
  427. .addContainerGap()
  428. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  429. .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  430. .addGroup(jPanel1Layout.createSequentialGroup()
  431. .addComponent(jLabel7)
  432. .addGap(36, 36, 36)
  433. .addComponent(pencarian, javax.swing.GroupLayout.DEFAULT_SIZE, 292, Short.MAX_VALUE)
  434. .addGap(18, 18, 18)
  435. .addComponent(cari, javax.swing.GroupLayout.PREFERRED_SIZE, 61, javax.swing.GroupLayout.PREFERRED_SIZE)))
  436. .addContainerGap())
  437. );
  438. jPanel1Layout.setVerticalGroup(
  439. jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  440. .addGroup(jPanel1Layout.createSequentialGroup()
  441. .addContainerGap()
  442. .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  443. .addComponent(jLabel7)
  444. .addComponent(pencarian, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  445. .addComponent(cari))
  446. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  447. .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 212, Short.MAX_VALUE)
  448. .addContainerGap())
  449. );
  450.  
  451. simpan.setText("Simpan");
  452. simpan.addActionListener(new java.awt.event.ActionListener() {
  453. public void actionPerformed(java.awt.event.ActionEvent evt) {
  454. simpanActionPerformed(evt);
  455. }
  456. });
  457.  
  458. hapus.setText("Hapus");
  459.  
  460. ubah.setText("Ubah");
  461.  
  462. keluar.setText("Keluar");
  463. keluar.addActionListener(new java.awt.event.ActionListener() {
  464. public void actionPerformed(java.awt.event.ActionEvent evt) {
  465. keluarActionPerformed(evt);
  466. }
  467. });
  468.  
  469. javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
  470. jPanel2.setLayout(jPanel2Layout);
  471. jPanel2Layout.setHorizontalGroup(
  472. jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  473. .addGroup(jPanel2Layout.createSequentialGroup()
  474. .addContainerGap()
  475. .addComponent(simpan, javax.swing.GroupLayout.PREFERRED_SIZE, 115, javax.swing.GroupLayout.PREFERRED_SIZE)
  476. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  477. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  478. .addComponent(hapus, javax.swing.GroupLayout.DEFAULT_SIZE, 99, Short.MAX_VALUE)
  479. .addComponent(ubah, javax.swing.GroupLayout.DEFAULT_SIZE, 99, Short.MAX_VALUE)
  480. .addComponent(keluar, javax.swing.GroupLayout.DEFAULT_SIZE, 99, Short.MAX_VALUE))
  481. .addContainerGap())
  482. );
  483. jPanel2Layout.setVerticalGroup(
  484. jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  485. .addGroup(jPanel2Layout.createSequentialGroup()
  486. .addContainerGap()
  487. .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
  488. .addComponent(simpan, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  489. .addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel2Layout.createSequentialGroup()
  490. .addComponent(hapus)
  491. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  492. .addComponent(ubah)
  493. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  494. .addComponent(keluar)))
  495. .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  496. );
  497.  
  498. jLabel8.setText("Rp");
  499.  
  500. jLabel9.setText("Rp");
  501.  
  502. javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  503. getContentPane().setLayout(layout);
  504. layout.setHorizontalGroup(
  505. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  506. .addGroup(layout.createSequentialGroup()
  507. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  508. .addGroup(layout.createSequentialGroup()
  509. .addContainerGap()
  510. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  511. .addGroup(layout.createSequentialGroup()
  512. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  513. .addComponent(jLabel3)
  514. .addComponent(jLabel4)
  515. .addComponent(jLabel5)
  516. .addComponent(jLabel6)
  517. .addComponent(jLabel2))
  518. .addGap(18, 18, 18)
  519. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  520. .addComponent(idtransaksi, javax.swing.GroupLayout.DEFAULT_SIZE, 158, Short.MAX_VALUE)
  521. .addComponent(namabarang, javax.swing.GroupLayout.DEFAULT_SIZE, 158, Short.MAX_VALUE)
  522. .addComponent(item, javax.swing.GroupLayout.DEFAULT_SIZE, 158, Short.MAX_VALUE)
  523. .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
  524. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  525. .addComponent(jLabel9)
  526. .addComponent(jLabel8))
  527. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  528. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  529. .addComponent(total, javax.swing.GroupLayout.Alignment.TRAILING)
  530. .addComponent(harga, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 100, javax.swing.GroupLayout.PREFERRED_SIZE)))))
  531. .addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  532. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  533. .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  534. .addGroup(layout.createSequentialGroup()
  535. .addGap(245, 245, 245)
  536. .addComponent(jLabel1)))
  537. .addGap(32, 32, 32))
  538. );
  539. layout.setVerticalGroup(
  540. layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  541. .addGroup(layout.createSequentialGroup()
  542. .addContainerGap()
  543. .addComponent(jLabel1)
  544. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  545. .addGroup(layout.createSequentialGroup()
  546. .addGap(31, 31, 31)
  547. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  548. .addComponent(jLabel2)
  549. .addComponent(idtransaksi, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  550. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  551. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  552. .addComponent(jLabel3)
  553. .addComponent(namabarang, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  554. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  555. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  556. .addComponent(jLabel4)
  557. .addComponent(item, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  558. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  559. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  560. .addGroup(layout.createSequentialGroup()
  561. .addComponent(jLabel5)
  562. .addGap(18, 18, 18)
  563. .addComponent(jLabel6))
  564. .addGroup(layout.createSequentialGroup()
  565. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  566. .addComponent(harga, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  567. .addComponent(jLabel8))
  568. .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  569. .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  570. .addComponent(total, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  571. .addComponent(jLabel9))))
  572. .addGap(18, 18, 18)
  573. .addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  574. .addGroup(layout.createSequentialGroup()
  575. .addGap(18, 18, 18)
  576. .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))
  577. .addGap(26, 26, 26))
  578. );
  579.  
  580. pack();
  581. }// </editor-fold>//GEN-END:initComponents
  582.  
  583. private void idtransaksiActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_idtransaksiActionPerformed
  584. // TODO add your handling code here:
  585. }//GEN-LAST:event_idtransaksiActionPerformed
  586.  
  587. private void itemActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_itemActionPerformed
  588. // TODO add your handling code here:
  589. }//GEN-LAST:event_itemActionPerformed
  590.  
  591. private void keluarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_keluarActionPerformed
  592. // TODO add your handling code here:
  593. }//GEN-LAST:event_keluarActionPerformed
  594.  
  595. private void hargaKeyReleased(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_hargaKeyReleased
  596. // TODO add your handling code here:
  597. int itm,hrg,ttl;
  598. itm = Integer.parseInt(item.getText());
  599. hrg = Integer.parseInt(harga.getText());
  600. ttl = itm * hrg;
  601. total.setText(""+ttl);
  602. }//GEN-LAST:event_hargaKeyReleased
  603.  
  604. private void simpanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_simpanActionPerformed
  605. // TODO add your handling code here:
  606. try {
  607. Master_Transaksi x = new Master_Transaksi ();
  608. x.search(idtransaksi.getText());
  609. x.id_transaksi = idtransaksi.getText();
  610. x.nama = namabarang.getText();
  611. x.item = Integer.parseInt(item.getText().toString());
  612. x.harga = Integer.parseInt(harga.getText().toString());
  613. x.total = Integer.parseInt(total.getText().toString());
  614.  
  615. if (x.Akses.equals("-")){
  616. x.UpdateData();
  617. idtransaksi.setEditable(false);
  618. JOptionPane.showMessageDialog(null, "Data Berhasil Di Update");
  619. }
  620. else {
  621. x.SaveData();
  622. idtransaksi.setEditable(false);
  623. JOptionPane.showMessageDialog(null, "Data Berhasil Di Simpan");
  624. }
  625. } catch (Exception ex ) {
  626. JOptionPane.showMessageDialog(null, ex);
  627. }
  628. }//GEN-LAST:event_simpanActionPerformed
  629.  
  630. private void cariActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cariActionPerformed
  631. // TODO add your handling code here:.
  632. try {
  633. LoadData();
  634. }catch (Exception ex) {
  635. JOptionPane.showMessageDialog(this,ex);
  636. }
  637. }//GEN-LAST:event_cariActionPerformed
  638.  
  639. /**
  640. * @param args the command line arguments
  641. */
  642. public static void main(String args[]) {
  643. /* Set the Nimbus look and feel */
  644. //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
  645. /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
  646. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
  647. */
  648. try {
  649. for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
  650. if ("Nimbus".equals(info.getName())) {
  651. javax.swing.UIManager.setLookAndFeel(info.getClassName());
  652. break;
  653. }
  654. }
  655. } catch (ClassNotFoundException ex) {
  656. java.util.logging.Logger.getLogger(Transaksi.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  657. } catch (InstantiationException ex) {
  658. java.util.logging.Logger.getLogger(Transaksi.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  659. } catch (IllegalAccessException ex) {
  660. java.util.logging.Logger.getLogger(Transaksi.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  661. } catch (javax.swing.UnsupportedLookAndFeelException ex) {
  662. java.util.logging.Logger.getLogger(Transaksi.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  663. }
  664. //</editor-fold>
  665.  
  666. /* Create and display the form */
  667. java.awt.EventQueue.invokeLater(new Runnable() {
  668.  
  669. public void run() {
  670. new Transaksi().setVisible(true);
  671. }
  672. });
  673. }
  674. // Variables declaration - do not modify//GEN-BEGIN:variables
  675. private javax.swing.JButton cari;
  676. private javax.swing.JButton hapus;
  677. private javax.swing.JTextField harga;
  678. private javax.swing.JTextField idtransaksi;
  679. private javax.swing.JTextField item;
  680. private javax.swing.JLabel jLabel1;
  681. private javax.swing.JLabel jLabel2;
  682. private javax.swing.JLabel jLabel3;
  683. private javax.swing.JLabel jLabel4;
  684. private javax.swing.JLabel jLabel5;
  685. private javax.swing.JLabel jLabel6;
  686. private javax.swing.JLabel jLabel7;
  687. private javax.swing.JLabel jLabel8;
  688. private javax.swing.JLabel jLabel9;
  689. private javax.swing.JPanel jPanel1;
  690. private javax.swing.JPanel jPanel2;
  691. private javax.swing.JScrollPane jScrollPane1;
  692. private javax.swing.JButton keluar;
  693. private javax.swing.JTextField namabarang;
  694. private javax.swing.JTextField pencarian;
  695. private javax.swing.JButton simpan;
  696. private javax.swing.JTable tampildata;
  697. private javax.swing.JTextField total;
  698. private javax.swing.JButton ubah;
  699. // End of variables declaration//GEN-END:variables
  700. }
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!