Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- * To change this license header, choose License Headers in Project Properties.
- * To change this template file, choose Tools | Templates
- * and open the template in the editor.
- */
- package cabang;
- import java.awt.*;
- import java.awt.event.ActionEvent;
- import java.awt.event.ActionListener;
- import javax.swing.*;
- import java.sql.*;
- import java.text.SimpleDateFormat;
- import java.util.Locale;
- import javax.swing.Timer;
- import javax.swing.JTextField;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- import net.proteanit.sql.DbUtils;
- /**
- *
- * @author riyan
- */
- public class addbarang extends javax.swing.JFrame {
- private Connection koneksi;
- private msyqlconn db = new msyqlconn();
- public boolean databaru;
- JTextField jt = new JTextField(100);
- java.util.Date tglsekarang = new java.util.Date();
- private SimpleDateFormat smpdtfmt = new SimpleDateFormat("dd MMMMMMMMM yyyy", Locale.getDefault());
- //diatas adalah pengaturan format penulisan, bisa diubah sesuai keinginan.
- private String tanggal = smpdtfmt.format(tglsekarang);
- /**
- * Creates new form jamku
- */
- public addbarang() {
- initComponents();
- JTextField1.setText(tanggal);
- JTextField1.setEditable(true);
- datacombo1();
- datacombo2();
- GetData();
- databaru=true;
- nofaktur();
- /**
- * Creates new form cabang
- */
- this.setLocationRelativeTo(null);
- }
- public void datacombo1(){
- db.ConnectDb();
- try {
- String query = "SELECT * FROM estimasi";
- Statement st = db.ConnectDb().createStatement();
- ResultSet rs = st.executeQuery(query);
- while (rs.next()) {
- es1.addItem(rs.getString("harga"));
- }
- rs.last();
- int jumlahdata = rs.getRow();
- rs.first();
- } catch (SQLException e) {
- }
- }
- public void datacombo2(){
- db.ConnectDb();
- try {
- String query = "SELECT * FROM cabang";
- Statement st = db.ConnectDb().createStatement();
- ResultSet rs = st.executeQuery(query);
- while (rs.next()) {
- cb1.addItem(rs.getString("cabang"));
- }
- rs.last();
- int jumlahdata = rs.getRow();
- rs.first();
- } catch (SQLException e) {
- }
- }
- private void GetData(){
- try {
- Connection conn =(Connection)cabang.msyqlconn.ConnectDb();
- java.sql.Statement stm = conn.createStatement();
- java.sql.ResultSet sql = stm.executeQuery("select * from barang");
- jTable1.setModel(DbUtils.resultSetToTableModel(sql));
- }
- catch (SQLException | HeadlessException e)
- {}
- }
- private void nofaktur()
- {
- msyqlconn.ConnectDb();
- try {
- String sql= "SELECT MAX(right(id_barang,2)) AS no FROM barang";
- Statement st = msyqlconn.ConnectDb().createStatement();
- ResultSet rs = st.executeQuery(sql);
- if (rs.next()) {
- {
- if(rs.first() == false)
- {
- auto.setText("ID-000001");
- }
- else
- {
- rs.last();
- int auto_id = rs.getInt(1) + 1;
- String no = String.valueOf(auto_id);
- int noLong = no.length();
- //MENGATUR jumlah 0
- for(int a=0;a<6-noLong;a++)
- {
- no = "0" + no;
- }
- auto.setText("ID-" + no);
- rs.close();
- st.close();
- }
- }
- }
- } catch (Exception e){
- JOptionPane.showMessageDialog(this, "ERROR: \n" + e.toString(),
- "Kesalahan", JOptionPane.WARNING_MESSAGE);
- }
- }
- /**
- * This method is called from within the constructor to initialize the form.
- * WARNING: Do NOT modify this code. The content of this method is always
- * regenerated by the Form Editor.
- */
- @SuppressWarnings("unchecked")
- // <editor-fold defaultstate="collapsed" desc="Generated Code">
- private void initComponents() {
- nmt = new javax.swing.JTextField();
- nbr = new javax.swing.JTextField();
- jScrollPane1 = new javax.swing.JScrollPane();
- jTable1 = new javax.swing.JTable();
- enter = new javax.swing.JButton();
- save = new javax.swing.JButton();
- hapus = new javax.swing.JButton();
- almtj = new javax.swing.JTextField();
- es2 = new javax.swing.JTextField();
- es1 = new javax.swing.JComboBox<>();
- cb1 = new javax.swing.JComboBox<>();
- cb2 = new javax.swing.JTextField();
- JTextField1 = new javax.swing.JTextField();
- lbhwaktu = new javax.swing.JTextField();
- ok1 = new javax.swing.JButton();
- jButton2 = new javax.swing.JButton();
- jScrollPane2 = new javax.swing.JScrollPane();
- almt1 = new javax.swing.JTextArea();
- jPanel2 = new javax.swing.JPanel();
- auto = new javax.swing.JTextField();
- setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
- setUndecorated(true);
- getContentPane().setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());
- nmt.setText("nama tujuan");
- getContentPane().add(nmt, new org.netbeans.lib.awtextra.AbsoluteConstraints(220, 160, 210, -1));
- nbr.setText("nama barang");
- getContentPane().add(nbr, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 250, 190, -1));
- jTable1.setModel(new javax.swing.table.DefaultTableModel(
- new Object [][] {
- {null, null, null, null, null, null, null, null, null},
- {null, null, null, null, null, null, null, null, null},
- {null, null, null, null, null, null, null, null, null},
- {null, null, null, null, null, null, null, null, null}
- },
- new String [] {
- "nama_barang", "alamat_barang", "nama_tujuan", "alamat_tujuan", "tanggal", "waktu", "estimasi", "cabang", "id barang"
- }
- ));
- jTable1.addMouseListener(new java.awt.event.MouseAdapter() {
- public void mouseClicked(java.awt.event.MouseEvent evt) {
- jTable1MouseClicked(evt);
- }
- });
- jScrollPane1.setViewportView(jTable1);
- getContentPane().add(jScrollPane1, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 680, 140));
- enter.setText("clear");
- enter.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- enterActionPerformed(evt);
- }
- });
- getContentPane().add(enter, new org.netbeans.lib.awtextra.AbsoluteConstraints(450, 220, -1, -1));
- save.setText("save");
- save.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- saveActionPerformed(evt);
- }
- });
- getContentPane().add(save, new org.netbeans.lib.awtextra.AbsoluteConstraints(540, 220, -1, -1));
- hapus.setText("hapus");
- hapus.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- hapusActionPerformed(evt);
- }
- });
- getContentPane().add(hapus, new org.netbeans.lib.awtextra.AbsoluteConstraints(600, 220, -1, -1));
- almtj.setText("alamat tujuan");
- getContentPane().add(almtj, new org.netbeans.lib.awtextra.AbsoluteConstraints(220, 190, 210, -1));
- es2.setText("estimasi");
- getContentPane().add(es2, new org.netbeans.lib.awtextra.AbsoluteConstraints(220, 250, 150, -1));
- es1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- es1ActionPerformed(evt);
- }
- });
- getContentPane().add(es1, new org.netbeans.lib.awtextra.AbsoluteConstraints(220, 220, 210, -1));
- getContentPane().add(cb1, new org.netbeans.lib.awtextra.AbsoluteConstraints(450, 160, 210, -1));
- cb2.setText("cabang");
- cb2.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- cb2ActionPerformed(evt);
- }
- });
- getContentPane().add(cb2, new org.netbeans.lib.awtextra.AbsoluteConstraints(450, 190, 150, -1));
- JTextField1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- JTextField1ActionPerformed(evt);
- }
- });
- getContentPane().add(JTextField1, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 190, 190, -1));
- getContentPane().add(lbhwaktu, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 220, 190, -1));
- ok1.setText("OK");
- ok1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- ok1ActionPerformed(evt);
- }
- });
- getContentPane().add(ok1, new org.netbeans.lib.awtextra.AbsoluteConstraints(380, 250, 50, -1));
- jButton2.setText("OK");
- jButton2.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton2ActionPerformed(evt);
- }
- });
- getContentPane().add(jButton2, new org.netbeans.lib.awtextra.AbsoluteConstraints(610, 190, 50, -1));
- almt1.setColumns(20);
- almt1.setRows(5);
- jScrollPane2.setViewportView(almt1);
- getContentPane().add(jScrollPane2, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 280, 190, 140));
- jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder("pembayaran"));
- javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
- jPanel2.setLayout(jPanel2Layout);
- jPanel2Layout.setHorizontalGroup(
- jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGap(0, 198, Short.MAX_VALUE)
- );
- jPanel2Layout.setVerticalGroup(
- jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGap(0, 67, Short.MAX_VALUE)
- );
- getContentPane().add(jPanel2, new org.netbeans.lib.awtextra.AbsoluteConstraints(450, 250, 210, 90));
- getContentPane().add(auto, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 160, 190, -1));
- pack();
- }// </editor-fold>
- private void enterActionPerformed(java.awt.event.ActionEvent evt) {
- databaru=true;
- auto.setText("");
- JTextField1.setText("");
- lbhwaktu.setText("");
- nbr.setText("");
- almt1.setText("");
- nmt.setText("");
- almtj.setText("");
- es2.setText("");
- cb2.setText("");
- }
- private void saveActionPerformed(java.awt.event.ActionEvent evt) {
- if (databaru == true) {
- try {
- String sql = "insert into barang values('"+auto.getText()+"',"+JTextField1.getText()+"','"+lbhwaktu.getText()+"','"+nbr.getText()+"','"+almt1.getText()+"','"+nmt.getText()+"','"+almtj.getText()+"','"+es2.getText()+"','"+cb2.getText()+"')";
- java.sql.Connection conn = (java.sql.Connection)cabang.msyqlconn.ConnectDb();
- java.sql.PreparedStatement pst = conn.prepareStatement(sql);
- pst.execute();
- JOptionPane.showMessageDialog(null, "berhasil disimpan");
- }
- catch (SQLException | HeadlessException e)
- { JOptionPane.showMessageDialog(null, e); }
- nofaktur();
- } else{
- try {
- 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()+"'";
- java.sql.Connection conn = (java.sql.Connection)cabang.msyqlconn.ConnectDb();
- java.sql.PreparedStatement pst = conn.prepareStatement(sql);
- pst.execute();
- JOptionPane.showMessageDialog(null, "berhasil disimpan");
- }
- catch (SQLException | HeadlessException e)
- {
- JOptionPane.showMessageDialog(null, e);
- }
- }
- GetData();
- nofaktur();
- }
- private void hapusActionPerformed(java.awt.event.ActionEvent evt) {
- try {
- // hapus data
- String sql ="delete from barang where nama_barang='"+JTextField1.getText()+"'";
- java.sql.Connection conn = (java.sql.Connection)cabang.msyqlconn.ConnectDb();
- java.sql.PreparedStatement pst = conn.prepareStatement(sql);
- pst.execute();
- JOptionPane.showMessageDialog(null, "Data akan dihapus?");
- databaru=true;
- JTextField1.setText("");
- lbhwaktu.setText("");
- nbr.setText("");
- almt1.setText("");
- nmt.setText("");
- almtj.setText("");
- es2.setText("");
- cb2.setText("");
- } catch (SQLException | HeadlessException e)
- {}
- GetData();
- }
- private void jTable1MouseClicked(java.awt.event.MouseEvent evt) {
- databaru = false;
- try
- {
- int row =jTable1.getSelectedRow();
- String tabel_klik=(jTable1.getModel().getValueAt(row, 0).toString());
- java.sql.Connection conn =(java.sql.Connection)cabang.msyqlconn.ConnectDb();
- java.sql.Statement stm = conn.createStatement();
- java.sql.ResultSet sql = stm.executeQuery("select * from barang where nama_barang='"+tabel_klik+"'");
- if(sql.next())
- {
- String nama_barang = sql.getString("nama_barang");nbr.setText(nama_barang);
- String alamat_barang = sql.getString("alamat_pengirim");almt1.setText(alamat_barang);
- String nama_tujuan = sql.getString("nama_tujuan");nmt.setText(nama_tujuan);
- String alamat_tujuan = sql.getString("alamat_tujuan");almtj.setText(alamat_tujuan);
- String tan = sql.getString("tgl");JTextField1.setText(tan);
- String waktu = sql.getString("jam");lbhwaktu.setText(waktu);
- String estimasi = sql.getString("estimasi");
- es2.setText(estimasi);
- String cabang = sql.getString("cabang");
- cb2.setText(cabang);
- String id_barang = sql.getString("id_barang");
- auto.setText(id_barang);
- }
- } catch (Exception e) {
- }
- GetData();
- }
- private void JTextField1ActionPerformed(java.awt.event.ActionEvent evt) {
- String nol_jam = "", nol_menit = "",nol_detik = "";
- java.util.Date dateTime = new java.util.Date();
- int nilai_jam = dateTime.getHours();
- int nilai_menit = dateTime.getMinutes();
- int nilai_detik = dateTime.getSeconds();
- if(nilai_jam <= 9) nol_jam= "0";
- if(nilai_menit <= 9) nol_menit= "0";
- if(nilai_detik <= 9) nol_detik= "0";
- String jam = nol_jam + Integer.toString(nilai_jam);
- String menit = nol_menit + Integer.toString(nilai_menit);
- String detik = nol_detik + Integer.toString(nilai_detik);
- lbhwaktu.setText(jam+":"+menit+":"+detik+"");
- // TODO add your handling code here:
- }
- private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
- String choice = cb1.getSelectedItem() + "";
- cb2.setText(choice); // TODO add your handling code here:
- }
- private void cb2ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void ok1ActionPerformed(java.awt.event.ActionEvent evt) {
- String choice = es1.getSelectedItem() + "";
- es2.setText(choice);// TODO add your handling code here:
- }
- private void es1ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- /**
- * @param args the command line arguments
- */
- public static void main(String args[]) {
- /* Set the Nimbus look and feel */
- //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
- /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
- * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
- */
- try {
- for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
- if ("Nimbus".equals(info.getName())) {
- javax.swing.UIManager.setLookAndFeel(info.getClassName());
- break;
- }
- }
- } catch (ClassNotFoundException ex) {
- java.util.logging.Logger.getLogger(addbarang.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- } catch (InstantiationException ex) {
- java.util.logging.Logger.getLogger(addbarang.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- } catch (IllegalAccessException ex) {
- java.util.logging.Logger.getLogger(addbarang.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- } catch (javax.swing.UnsupportedLookAndFeelException ex) {
- java.util.logging.Logger.getLogger(addbarang.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- }
- //</editor-fold>
- //</editor-fold>
- //</editor-fold>
- //</editor-fold>
- /* Create and display the form */
- java.awt.EventQueue.invokeLater(new Runnable() {
- public void run() {
- new addbarang().setVisible(true);
- }
- }
- );
- }
- // Variables declaration - do not modify
- private javax.swing.JTextField JTextField1;
- private javax.swing.JTextArea almt1;
- private javax.swing.JTextField almtj;
- private javax.swing.JTextField auto;
- private javax.swing.JComboBox<String> cb1;
- private javax.swing.JTextField cb2;
- private javax.swing.JButton enter;
- private javax.swing.JComboBox<String> es1;
- private javax.swing.JTextField es2;
- private javax.swing.JButton hapus;
- private javax.swing.JButton jButton2;
- private javax.swing.JPanel jPanel2;
- private javax.swing.JScrollPane jScrollPane1;
- private javax.swing.JScrollPane jScrollPane2;
- private javax.swing.JTable jTable1;
- private javax.swing.JTextField lbhwaktu;
- private javax.swing.JTextField nbr;
- private javax.swing.JTextField nmt;
- private javax.swing.JButton ok1;
- private javax.swing.JButton save;
- // End of variables declaration
- }
Advertisement
Add Comment
Please, Sign In to add comment