nasoa

Untitled

Jan 3rd, 2017
140
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 20.07 KB | None | 0 0
  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 cabang;
  7. import java.awt.*;
  8. import java.awt.event.ActionEvent;
  9. import java.awt.event.ActionListener;
  10. import javax.swing.*;
  11. import java.sql.*;
  12. import java.text.SimpleDateFormat;
  13. import java.util.Locale;
  14. import javax.swing.Timer;
  15. import javax.swing.JTextField;
  16. import java.sql.ResultSet;
  17. import java.sql.SQLException;
  18. import java.sql.Statement;
  19. import net.proteanit.sql.DbUtils;
  20.  
  21.  
  22. /**
  23. *
  24. * @author riyan
  25. */
  26. public class addbarang extends javax.swing.JFrame {
  27. private Connection koneksi;
  28. private msyqlconn db = new msyqlconn();
  29.  
  30. public boolean databaru;
  31.  
  32.  
  33.  
  34. JTextField jt = new JTextField(100);
  35. java.util.Date tglsekarang = new java.util.Date();
  36. private SimpleDateFormat smpdtfmt = new SimpleDateFormat("dd MMMMMMMMM yyyy", Locale.getDefault());
  37. //diatas adalah pengaturan format penulisan, bisa diubah sesuai keinginan.
  38. private String tanggal = smpdtfmt.format(tglsekarang);
  39.  
  40.  
  41. /**
  42. * Creates new form jamku
  43. */
  44. public addbarang() {
  45. initComponents();
  46. JTextField1.setText(tanggal);
  47. JTextField1.setEditable(true);
  48. datacombo1();
  49. datacombo2();
  50. GetData();
  51. databaru=true;
  52. nofaktur();
  53. /**
  54. * Creates new form cabang
  55. */
  56. this.setLocationRelativeTo(null);
  57.  
  58. }
  59. public void datacombo1(){
  60. db.ConnectDb();
  61. try {
  62. String query = "SELECT * FROM estimasi";
  63. Statement st = db.ConnectDb().createStatement();
  64. ResultSet rs = st.executeQuery(query);
  65.  
  66. while (rs.next()) {
  67. es1.addItem(rs.getString("harga"));
  68. }
  69.  
  70. rs.last();
  71. int jumlahdata = rs.getRow();
  72. rs.first();
  73.  
  74. } catch (SQLException e) {
  75. }
  76. }
  77. public void datacombo2(){
  78. db.ConnectDb();
  79. try {
  80. String query = "SELECT * FROM cabang";
  81. Statement st = db.ConnectDb().createStatement();
  82. ResultSet rs = st.executeQuery(query);
  83.  
  84. while (rs.next()) {
  85. cb1.addItem(rs.getString("cabang"));
  86. }
  87.  
  88. rs.last();
  89. int jumlahdata = rs.getRow();
  90. rs.first();
  91.  
  92. } catch (SQLException e) {
  93. }
  94. }
  95. private void GetData(){
  96. try {
  97. Connection conn =(Connection)cabang.msyqlconn.ConnectDb();
  98. java.sql.Statement stm = conn.createStatement();
  99. java.sql.ResultSet sql = stm.executeQuery("select * from barang");
  100. jTable1.setModel(DbUtils.resultSetToTableModel(sql));
  101. }
  102. catch (SQLException | HeadlessException e)
  103. {}
  104.  
  105. }
  106. private void nofaktur()
  107. {
  108. msyqlconn.ConnectDb();
  109. try {
  110. String sql= "SELECT MAX(right(id_barang,2)) AS no FROM barang";
  111. Statement st = msyqlconn.ConnectDb().createStatement();
  112. ResultSet rs = st.executeQuery(sql);
  113. if (rs.next()) {
  114. {
  115. if(rs.first() == false)
  116. {
  117. auto.setText("ID-000001");
  118.  
  119. }
  120. else
  121. {
  122. rs.last();
  123. int auto_id = rs.getInt(1) + 1;
  124. String no = String.valueOf(auto_id);
  125. int noLong = no.length();
  126. //MENGATUR jumlah 0
  127. for(int a=0;a<6-noLong;a++)
  128. {
  129. no = "0" + no;
  130. }
  131. auto.setText("ID-" + no);
  132.  
  133. rs.close();
  134. st.close();
  135. }
  136. }
  137. }
  138. } catch (Exception e){
  139. JOptionPane.showMessageDialog(this, "ERROR: \n" + e.toString(),
  140. "Kesalahan", JOptionPane.WARNING_MESSAGE);
  141.  
  142. }
  143. }
  144.  
  145. /**
  146. * This method is called from within the constructor to initialize the form.
  147. * WARNING: Do NOT modify this code. The content of this method is always
  148. * regenerated by the Form Editor.
  149. */
  150. @SuppressWarnings("unchecked")
  151. // <editor-fold defaultstate="collapsed" desc="Generated Code">
  152. private void initComponents() {
  153.  
  154. nmt = new javax.swing.JTextField();
  155. nbr = new javax.swing.JTextField();
  156. jScrollPane1 = new javax.swing.JScrollPane();
  157. jTable1 = new javax.swing.JTable();
  158. enter = new javax.swing.JButton();
  159. save = new javax.swing.JButton();
  160. hapus = new javax.swing.JButton();
  161. almtj = new javax.swing.JTextField();
  162. es2 = new javax.swing.JTextField();
  163. es1 = new javax.swing.JComboBox<>();
  164. cb1 = new javax.swing.JComboBox<>();
  165. cb2 = new javax.swing.JTextField();
  166. JTextField1 = new javax.swing.JTextField();
  167. lbhwaktu = new javax.swing.JTextField();
  168. ok1 = new javax.swing.JButton();
  169. jButton2 = new javax.swing.JButton();
  170. jScrollPane2 = new javax.swing.JScrollPane();
  171. almt1 = new javax.swing.JTextArea();
  172. jPanel2 = new javax.swing.JPanel();
  173. auto = new javax.swing.JTextField();
  174.  
  175. setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  176. setUndecorated(true);
  177. getContentPane().setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());
  178.  
  179. nmt.setText("nama tujuan");
  180. getContentPane().add(nmt, new org.netbeans.lib.awtextra.AbsoluteConstraints(220, 160, 210, -1));
  181.  
  182. nbr.setText("nama barang");
  183. getContentPane().add(nbr, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 250, 190, -1));
  184.  
  185. jTable1.setModel(new javax.swing.table.DefaultTableModel(
  186. new Object [][] {
  187. {null, null, null, null, null, null, null, null, null},
  188. {null, null, null, null, null, null, null, null, null},
  189. {null, null, null, null, null, null, null, null, null},
  190. {null, null, null, null, null, null, null, null, null}
  191. },
  192. new String [] {
  193. "nama_barang", "alamat_barang", "nama_tujuan", "alamat_tujuan", "tanggal", "waktu", "estimasi", "cabang", "id barang"
  194. }
  195. ));
  196. jTable1.addMouseListener(new java.awt.event.MouseAdapter() {
  197. public void mouseClicked(java.awt.event.MouseEvent evt) {
  198. jTable1MouseClicked(evt);
  199. }
  200. });
  201. jScrollPane1.setViewportView(jTable1);
  202.  
  203. getContentPane().add(jScrollPane1, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 680, 140));
  204.  
  205. enter.setText("clear");
  206. enter.addActionListener(new java.awt.event.ActionListener() {
  207. public void actionPerformed(java.awt.event.ActionEvent evt) {
  208. enterActionPerformed(evt);
  209. }
  210. });
  211. getContentPane().add(enter, new org.netbeans.lib.awtextra.AbsoluteConstraints(450, 220, -1, -1));
  212.  
  213. save.setText("save");
  214. save.addActionListener(new java.awt.event.ActionListener() {
  215. public void actionPerformed(java.awt.event.ActionEvent evt) {
  216. saveActionPerformed(evt);
  217. }
  218. });
  219. getContentPane().add(save, new org.netbeans.lib.awtextra.AbsoluteConstraints(540, 220, -1, -1));
  220.  
  221. hapus.setText("hapus");
  222. hapus.addActionListener(new java.awt.event.ActionListener() {
  223. public void actionPerformed(java.awt.event.ActionEvent evt) {
  224. hapusActionPerformed(evt);
  225. }
  226. });
  227. getContentPane().add(hapus, new org.netbeans.lib.awtextra.AbsoluteConstraints(600, 220, -1, -1));
  228.  
  229. almtj.setText("alamat tujuan");
  230. getContentPane().add(almtj, new org.netbeans.lib.awtextra.AbsoluteConstraints(220, 190, 210, -1));
  231.  
  232. es2.setText("estimasi");
  233. getContentPane().add(es2, new org.netbeans.lib.awtextra.AbsoluteConstraints(220, 250, 150, -1));
  234.  
  235. es1.addActionListener(new java.awt.event.ActionListener() {
  236. public void actionPerformed(java.awt.event.ActionEvent evt) {
  237. es1ActionPerformed(evt);
  238. }
  239. });
  240. getContentPane().add(es1, new org.netbeans.lib.awtextra.AbsoluteConstraints(220, 220, 210, -1));
  241.  
  242. getContentPane().add(cb1, new org.netbeans.lib.awtextra.AbsoluteConstraints(450, 160, 210, -1));
  243.  
  244. cb2.setText("cabang");
  245. cb2.addActionListener(new java.awt.event.ActionListener() {
  246. public void actionPerformed(java.awt.event.ActionEvent evt) {
  247. cb2ActionPerformed(evt);
  248. }
  249. });
  250. getContentPane().add(cb2, new org.netbeans.lib.awtextra.AbsoluteConstraints(450, 190, 150, -1));
  251.  
  252. JTextField1.addActionListener(new java.awt.event.ActionListener() {
  253. public void actionPerformed(java.awt.event.ActionEvent evt) {
  254. JTextField1ActionPerformed(evt);
  255. }
  256. });
  257. getContentPane().add(JTextField1, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 190, 190, -1));
  258. getContentPane().add(lbhwaktu, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 220, 190, -1));
  259.  
  260. ok1.setText("OK");
  261. ok1.addActionListener(new java.awt.event.ActionListener() {
  262. public void actionPerformed(java.awt.event.ActionEvent evt) {
  263. ok1ActionPerformed(evt);
  264. }
  265. });
  266. getContentPane().add(ok1, new org.netbeans.lib.awtextra.AbsoluteConstraints(380, 250, 50, -1));
  267.  
  268. jButton2.setText("OK");
  269. jButton2.addActionListener(new java.awt.event.ActionListener() {
  270. public void actionPerformed(java.awt.event.ActionEvent evt) {
  271. jButton2ActionPerformed(evt);
  272. }
  273. });
  274. getContentPane().add(jButton2, new org.netbeans.lib.awtextra.AbsoluteConstraints(610, 190, 50, -1));
  275.  
  276. almt1.setColumns(20);
  277. almt1.setRows(5);
  278. jScrollPane2.setViewportView(almt1);
  279.  
  280. getContentPane().add(jScrollPane2, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 280, 190, 140));
  281.  
  282. jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder("pembayaran"));
  283.  
  284. javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
  285. jPanel2.setLayout(jPanel2Layout);
  286. jPanel2Layout.setHorizontalGroup(
  287. jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  288. .addGap(0, 198, Short.MAX_VALUE)
  289. );
  290. jPanel2Layout.setVerticalGroup(
  291. jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  292. .addGap(0, 67, Short.MAX_VALUE)
  293. );
  294.  
  295. getContentPane().add(jPanel2, new org.netbeans.lib.awtextra.AbsoluteConstraints(450, 250, 210, 90));
  296. getContentPane().add(auto, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 160, 190, -1));
  297.  
  298. pack();
  299. }// </editor-fold>
  300.  
  301. private void enterActionPerformed(java.awt.event.ActionEvent evt) {
  302. databaru=true;
  303. auto.setText("");
  304. JTextField1.setText("");
  305. lbhwaktu.setText("");
  306. nbr.setText("");
  307. almt1.setText("");
  308. nmt.setText("");
  309. almtj.setText("");
  310. es2.setText("");
  311. cb2.setText("");
  312.  
  313. }
  314.  
  315. private void saveActionPerformed(java.awt.event.ActionEvent evt) {
  316. if (databaru == true) {
  317. try {
  318. String sql = "insert into barang values('"+auto.getText()+"',"+JTextField1.getText()+"','"+lbhwaktu.getText()+"','"+nbr.getText()+"','"+almt1.getText()+"','"+nmt.getText()+"','"+almtj.getText()+"','"+es2.getText()+"','"+cb2.getText()+"')";
  319. java.sql.Connection conn = (java.sql.Connection)cabang.msyqlconn.ConnectDb();
  320. java.sql.PreparedStatement pst = conn.prepareStatement(sql);
  321. pst.execute();
  322. JOptionPane.showMessageDialog(null, "berhasil disimpan");
  323. }
  324. catch (SQLException | HeadlessException e)
  325. { JOptionPane.showMessageDialog(null, e); }
  326. nofaktur();
  327. } else{
  328. try {
  329. String sql = "update barang SET nama_barang='"+nbr.getText()+"',alamat_pengirim='"+almt1.getText()+"',nama_tujuan='"+nmt.getText()+"',alamat_tujuan='"+almtj.getText()+"',jam='"+lbhwaktu.getText()+"',tgl='"+JTextField1.getText()+"',estimasi='"+es2.getText()+"',cabang='"+cb2.getText()+"',id_barang='"+auto.getText()+"'";
  330. java.sql.Connection conn = (java.sql.Connection)cabang.msyqlconn.ConnectDb();
  331. java.sql.PreparedStatement pst = conn.prepareStatement(sql);
  332. pst.execute();
  333. JOptionPane.showMessageDialog(null, "berhasil disimpan");
  334. }
  335. catch (SQLException | HeadlessException e)
  336. {
  337. JOptionPane.showMessageDialog(null, e);
  338. }
  339. }
  340.  
  341. GetData();
  342. nofaktur();
  343. }
  344.  
  345. private void hapusActionPerformed(java.awt.event.ActionEvent evt) {
  346. try {
  347. // hapus data
  348. String sql ="delete from barang where nama_barang='"+JTextField1.getText()+"'";
  349. java.sql.Connection conn = (java.sql.Connection)cabang.msyqlconn.ConnectDb();
  350. java.sql.PreparedStatement pst = conn.prepareStatement(sql);
  351. pst.execute();
  352. JOptionPane.showMessageDialog(null, "Data akan dihapus?");
  353. databaru=true;
  354. JTextField1.setText("");
  355. lbhwaktu.setText("");
  356. nbr.setText("");
  357. almt1.setText("");
  358. nmt.setText("");
  359. almtj.setText("");
  360. es2.setText("");
  361. cb2.setText("");
  362.  
  363. } catch (SQLException | HeadlessException e)
  364. {}
  365. GetData();
  366.  
  367. }
  368.  
  369. private void jTable1MouseClicked(java.awt.event.MouseEvent evt) {
  370. databaru = false;
  371. try
  372. {
  373. int row =jTable1.getSelectedRow();
  374. String tabel_klik=(jTable1.getModel().getValueAt(row, 0).toString());
  375. java.sql.Connection conn =(java.sql.Connection)cabang.msyqlconn.ConnectDb();
  376. java.sql.Statement stm = conn.createStatement();
  377. java.sql.ResultSet sql = stm.executeQuery("select * from barang where nama_barang='"+tabel_klik+"'");
  378. if(sql.next())
  379. {
  380. String nama_barang = sql.getString("nama_barang");nbr.setText(nama_barang);
  381. String alamat_barang = sql.getString("alamat_pengirim");almt1.setText(alamat_barang);
  382. String nama_tujuan = sql.getString("nama_tujuan");nmt.setText(nama_tujuan);
  383. String alamat_tujuan = sql.getString("alamat_tujuan");almtj.setText(alamat_tujuan);
  384. String tan = sql.getString("tgl");JTextField1.setText(tan);
  385. String waktu = sql.getString("jam");lbhwaktu.setText(waktu);
  386. String estimasi = sql.getString("estimasi");
  387. es2.setText(estimasi);
  388. String cabang = sql.getString("cabang");
  389. cb2.setText(cabang);
  390. String id_barang = sql.getString("id_barang");
  391. auto.setText(id_barang);
  392. }
  393. } catch (Exception e) {
  394. }
  395. GetData();
  396. }
  397.  
  398. private void JTextField1ActionPerformed(java.awt.event.ActionEvent evt) {
  399. String nol_jam = "", nol_menit = "",nol_detik = "";
  400.  
  401. java.util.Date dateTime = new java.util.Date();
  402. int nilai_jam = dateTime.getHours();
  403. int nilai_menit = dateTime.getMinutes();
  404. int nilai_detik = dateTime.getSeconds();
  405.  
  406. if(nilai_jam <= 9) nol_jam= "0";
  407. if(nilai_menit <= 9) nol_menit= "0";
  408. if(nilai_detik <= 9) nol_detik= "0";
  409.  
  410. String jam = nol_jam + Integer.toString(nilai_jam);
  411. String menit = nol_menit + Integer.toString(nilai_menit);
  412. String detik = nol_detik + Integer.toString(nilai_detik);
  413.  
  414. lbhwaktu.setText(jam+":"+menit+":"+detik+"");
  415.  
  416.  
  417. // TODO add your handling code here:
  418. }
  419.  
  420. private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
  421. String choice = cb1.getSelectedItem() + "";
  422. cb2.setText(choice); // TODO add your handling code here:
  423. }
  424.  
  425. private void cb2ActionPerformed(java.awt.event.ActionEvent evt) {
  426. // TODO add your handling code here:
  427. }
  428.  
  429. private void ok1ActionPerformed(java.awt.event.ActionEvent evt) {
  430. String choice = es1.getSelectedItem() + "";
  431. es2.setText(choice);// TODO add your handling code here:
  432. }
  433.  
  434. private void es1ActionPerformed(java.awt.event.ActionEvent evt) {
  435. // TODO add your handling code here:
  436. }
  437.  
  438.  
  439.  
  440.  
  441.  
  442.  
  443. /**
  444. * @param args the command line arguments
  445. */
  446. public static void main(String args[]) {
  447.  
  448.  
  449. /* Set the Nimbus look and feel */
  450. //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
  451. /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
  452. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
  453. */
  454. try {
  455. for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
  456. if ("Nimbus".equals(info.getName())) {
  457. javax.swing.UIManager.setLookAndFeel(info.getClassName());
  458. break;
  459. }
  460. }
  461. } catch (ClassNotFoundException ex) {
  462. java.util.logging.Logger.getLogger(addbarang.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  463. } catch (InstantiationException ex) {
  464. java.util.logging.Logger.getLogger(addbarang.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  465. } catch (IllegalAccessException ex) {
  466. java.util.logging.Logger.getLogger(addbarang.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  467. } catch (javax.swing.UnsupportedLookAndFeelException ex) {
  468. java.util.logging.Logger.getLogger(addbarang.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  469. }
  470. //</editor-fold>
  471. //</editor-fold>
  472. //</editor-fold>
  473. //</editor-fold>
  474.  
  475. /* Create and display the form */
  476. java.awt.EventQueue.invokeLater(new Runnable() {
  477. public void run() {
  478. new addbarang().setVisible(true);
  479. }
  480. }
  481. );
  482. }
  483.  
  484. // Variables declaration - do not modify
  485. private javax.swing.JTextField JTextField1;
  486. private javax.swing.JTextArea almt1;
  487. private javax.swing.JTextField almtj;
  488. private javax.swing.JTextField auto;
  489. private javax.swing.JComboBox<String> cb1;
  490. private javax.swing.JTextField cb2;
  491. private javax.swing.JButton enter;
  492. private javax.swing.JComboBox<String> es1;
  493. private javax.swing.JTextField es2;
  494. private javax.swing.JButton hapus;
  495. private javax.swing.JButton jButton2;
  496. private javax.swing.JPanel jPanel2;
  497. private javax.swing.JScrollPane jScrollPane1;
  498. private javax.swing.JScrollPane jScrollPane2;
  499. private javax.swing.JTable jTable1;
  500. private javax.swing.JTextField lbhwaktu;
  501. private javax.swing.JTextField nbr;
  502. private javax.swing.JTextField nmt;
  503. private javax.swing.JButton ok1;
  504. private javax.swing.JButton save;
  505. // End of variables declaration
  506. }
Advertisement
Add Comment
Please, Sign In to add comment