Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- * To change this template, choose Tools | Templates
- * and open the template in the editor.
- */
- package dropdown;
- import com.mysql.jdbc.Statement;
- import com.sun.glass.events.KeyEvent;
- import java.awt.Dimension;
- import java.awt.Toolkit;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import javax.swing.JOptionPane;
- import javax.swing.JTable;
- import javax.swing.table.DefaultTableModel;
- import javax.swing.table.TableColumn;
- import java.sql.PreparedStatement;
- /**
- *
- * @author Administrator
- */
- public class TransPenjualan extends javax.swing.JInternalFrame {
- DefaultTableModel tabmode;
- int count=0, stok_awal;
- double total;
- float Harga;
- float jumlah;
- public TransPenjualan() {
- initComponents();
- nofaktur();
- String[] judul={"Kode Barang","Nama Barang","Harga","Jumlah","Total Harga"};
- Dimension screen=Toolkit.getDefaultToolkit().getScreenSize();
- this.setSize(screen.width,screen.height);
- tabmode=new DefaultTableModel(judul,0);
- TabItem.setModel(tabmode);
- tampil();
- //tblPetugas.setDefaultRenderer(Object.class, new WarnaTabel(jPanel1.getBackground(),tblPetugas.getBackground()));
- TabItem.setPreferredScrollableViewportSize(new Dimension(800,300));
- TabItem.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
- for (int i = 0; i < 5; i++) {
- TableColumn column = TabItem.getColumnModel().getColumn(i);
- if(i==0){
- column.setPreferredWidth(125);
- }else if(i==1){
- column.setPreferredWidth(225);
- }else if(i==2){
- column.setPreferredWidth(125);
- }else if(i==3){
- column.setPreferredWidth(75);
- }else if(i==4){
- column.setPreferredWidth(140);
- }
- }
- this.setLocation(15,15);
- setSize(760,550);
- }
- @SuppressWarnings("unchecked")
- // <editor-fold defaultstate="collapsed" desc="Generated Code">
- private void initComponents() {
- jScrollPane1 = new javax.swing.JScrollPane();
- TabItem = new javax.swing.JTable();
- jLabel4 = new javax.swing.JLabel();
- txtNP = new Cobaclass.textfield();
- cmbKasir = new javax.swing.JComboBox();
- jLabel6 = new javax.swing.JLabel();
- jLabel12 = new javax.swing.JLabel();
- dtpTgl = new uz.ncipro.calendar.JDateTimePicker();
- jPanel1 = new javax.swing.JPanel();
- jLabel2 = new javax.swing.JLabel();
- jLabel7 = new javax.swing.JLabel();
- jLabel13 = new javax.swing.JLabel();
- txtKode = new Cobaclass.textfield();
- txtNama = new Cobaclass.textfield();
- txtJml = new Cobaclass.textfield();
- jLabel8 = new javax.swing.JLabel();
- txtHarga = new Cobaclass.textfield();
- jLabel14 = new javax.swing.JLabel();
- txtTotal = new Cobaclass.textfield();
- jLabel3 = new javax.swing.JLabel();
- txtNIP3 = new Cobaclass.textfield();
- tbSimpan = new Cobaclass.button();
- tbBatal = new Cobaclass.button();
- txtNIP4 = new Cobaclass.textfield();
- jLabel9 = new javax.swing.JLabel();
- jLabel10 = new javax.swing.JLabel();
- txtNIP5 = new Cobaclass.textfield();
- jButton1 = new javax.swing.JButton();
- jButton2 = new javax.swing.JButton();
- setTitle("Form Transaksi Penjualan");
- setPreferredSize(new java.awt.Dimension(503, 565));
- getContentPane().setLayout(null);
- TabItem.setModel(new javax.swing.table.DefaultTableModel(
- new Object [][] {
- {null, null, null, null},
- {null, null, null, null},
- {null, null, null, null},
- {null, null, null, null}
- },
- new String [] {
- "Title 1", "Title 2", "Title 3", "Title 4"
- }
- ));
- jScrollPane1.setViewportView(TabItem);
- getContentPane().add(jScrollPane1);
- jScrollPane1.setBounds(10, 160, 690, 110);
- jLabel4.setFont(new java.awt.Font("Eras Medium ITC", 0, 12)); // NOI18N
- jLabel4.setForeground(new java.awt.Color(0, 153, 0));
- jLabel4.setText("Kasir");
- getContentPane().add(jLabel4);
- jLabel4.setBounds(550, 10, 40, 20);
- txtNP.setEditable(false);
- txtNP.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- txtNPActionPerformed(evt);
- }
- });
- txtNP.addKeyListener(new java.awt.event.KeyAdapter() {
- public void keyPressed(java.awt.event.KeyEvent evt) {
- txtNPKeyPressed(evt);
- }
- });
- getContentPane().add(txtNP);
- txtNP.setBounds(120, 10, 160, 20);
- cmbKasir.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Erna" }));
- getContentPane().add(cmbKasir);
- cmbKasir.setBounds(600, 10, 100, 20);
- jLabel6.setFont(new java.awt.Font("Eras Medium ITC", 0, 12)); // NOI18N
- jLabel6.setForeground(new java.awt.Color(0, 153, 0));
- jLabel6.setText("No Penjualan ");
- getContentPane().add(jLabel6);
- jLabel6.setBounds(10, 10, 80, 20);
- jLabel12.setFont(new java.awt.Font("Eras Medium ITC", 0, 12)); // NOI18N
- jLabel12.setForeground(new java.awt.Color(0, 153, 0));
- jLabel12.setText("Tanggal Penjualan");
- getContentPane().add(jLabel12);
- jLabel12.setBounds(300, 10, 100, 20);
- dtpTgl.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "06/01/2017 " }));
- dtpTgl.setDisplayFormat("dd/MM/yyyy ");
- dtpTgl.setEnabled(false);
- dtpTgl.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- dtpTglActionPerformed(evt);
- }
- });
- getContentPane().add(dtpTgl);
- dtpTgl.setBounds(410, 10, 110, 20);
- jPanel1.setBackground(new java.awt.Color(204, 204, 204));
- jPanel1.setBorder(new javax.swing.border.LineBorder(new java.awt.Color(102, 102, 102), 1, true));
- jPanel1.setPreferredSize(new java.awt.Dimension(800, 220));
- jLabel2.setFont(new java.awt.Font("Eras Medium ITC", 0, 12)); // NOI18N
- jLabel2.setForeground(new java.awt.Color(0, 153, 0));
- jLabel2.setText("Kode Barang");
- jLabel7.setFont(new java.awt.Font("Eras Medium ITC", 0, 12)); // NOI18N
- jLabel7.setForeground(new java.awt.Color(0, 153, 0));
- jLabel7.setText("Nama Barang");
- jLabel13.setFont(new java.awt.Font("Eras Medium ITC", 0, 12)); // NOI18N
- jLabel13.setForeground(new java.awt.Color(0, 153, 0));
- jLabel13.setText("Jumlah");
- txtKode.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- txtKodeActionPerformed(evt);
- }
- });
- txtKode.addKeyListener(new java.awt.event.KeyAdapter() {
- public void keyPressed(java.awt.event.KeyEvent evt) {
- txtKodeKeyPressed(evt);
- }
- });
- txtNama.setEditable(false);
- txtJml.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- txtJmlActionPerformed(evt);
- }
- });
- txtJml.addKeyListener(new java.awt.event.KeyAdapter() {
- public void keyPressed(java.awt.event.KeyEvent evt) {
- txtJmlKeyPressed(evt);
- }
- });
- jLabel8.setFont(new java.awt.Font("Eras Medium ITC", 0, 12)); // NOI18N
- jLabel8.setForeground(new java.awt.Color(0, 153, 0));
- jLabel8.setText("Harga ");
- txtHarga.setEditable(false);
- txtHarga.setBackground(new java.awt.Color(51, 255, 255));
- jLabel14.setFont(new java.awt.Font("Eras Medium ITC", 0, 12)); // NOI18N
- jLabel14.setForeground(new java.awt.Color(0, 153, 0));
- jLabel14.setText("TOTAL");
- txtTotal.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- txtTotalActionPerformed(evt);
- }
- });
- txtTotal.addKeyListener(new java.awt.event.KeyAdapter() {
- public void keyPressed(java.awt.event.KeyEvent evt) {
- txtTotalKeyPressed(evt);
- }
- });
- javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
- jPanel1.setLayout(jPanel1Layout);
- jPanel1Layout.setHorizontalGroup(
- jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(jPanel1Layout.createSequentialGroup()
- .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(jPanel1Layout.createSequentialGroup()
- .addGap(13, 13, 13)
- .addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 71, javax.swing.GroupLayout.PREFERRED_SIZE))
- .addGroup(jPanel1Layout.createSequentialGroup()
- .addGap(25, 25, 25)
- .addComponent(jLabel8)))
- .addGap(27, 27, 27)
- .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
- .addComponent(txtKode, javax.swing.GroupLayout.DEFAULT_SIZE, 156, Short.MAX_VALUE)
- .addComponent(txtHarga, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
- .addGap(21, 21, 21)
- .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(jLabel7)
- .addComponent(jLabel13))
- .addGap(18, 18, 18)
- .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
- .addGroup(jPanel1Layout.createSequentialGroup()
- .addComponent(txtJml, javax.swing.GroupLayout.PREFERRED_SIZE, 66, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
- .addComponent(jLabel14, javax.swing.GroupLayout.PREFERRED_SIZE, 39, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addComponent(txtTotal, javax.swing.GroupLayout.PREFERRED_SIZE, 123, javax.swing.GroupLayout.PREFERRED_SIZE))
- .addComponent(txtNama, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
- .addContainerGap(19, Short.MAX_VALUE))
- );
- jPanel1Layout.setVerticalGroup(
- jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(jPanel1Layout.createSequentialGroup()
- .addContainerGap()
- .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(jLabel2)
- .addComponent(txtKode, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addComponent(jLabel7)
- .addComponent(txtNama, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
- .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(jLabel8, javax.swing.GroupLayout.PREFERRED_SIZE, 22, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addComponent(txtHarga, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addComponent(jLabel13)
- .addComponent(txtJml, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addComponent(jLabel14)
- .addComponent(txtTotal, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
- .addContainerGap(18, Short.MAX_VALUE))
- );
- getContentPane().add(jPanel1);
- jPanel1.setBounds(10, 50, 640, 90);
- jLabel3.setFont(new java.awt.Font("Eras Medium ITC", 0, 12)); // NOI18N
- jLabel3.setForeground(new java.awt.Color(0, 153, 0));
- jLabel3.setText("Kembali");
- getContentPane().add(jLabel3);
- jLabel3.setBounds(460, 370, 80, 20);
- txtNIP3.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- txtNIP3ActionPerformed(evt);
- }
- });
- getContentPane().add(txtNIP3);
- txtNIP3.setBounds(550, 370, 150, 24);
- tbSimpan.setForeground(new java.awt.Color(51, 153, 0));
- tbSimpan.setIcon(new javax.swing.ImageIcon(getClass().getResource("/dropdown/icon/save-16x16i.png"))); // NOI18N
- tbSimpan.setText("Simpan");
- tbSimpan.setPressedIcon(new javax.swing.ImageIcon(getClass().getResource("/dropdown/icon/contreng.png"))); // NOI18N
- tbSimpan.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- tbSimpanActionPerformed(evt);
- }
- });
- getContentPane().add(tbSimpan);
- tbSimpan.setBounds(610, 420, 95, 25);
- tbBatal.setForeground(new java.awt.Color(51, 153, 0));
- tbBatal.setIcon(new javax.swing.ImageIcon(getClass().getResource("/dropdown/icon/cancel.png"))); // NOI18N
- tbBatal.setText("Hapus");
- tbBatal.setPressedIcon(new javax.swing.ImageIcon(getClass().getResource("/dropdown/icon/contreng.png"))); // NOI18N
- getContentPane().add(tbBatal);
- tbBatal.setBounds(460, 420, 87, 25);
- txtNIP4.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- txtNIP4ActionPerformed(evt);
- }
- });
- getContentPane().add(txtNIP4);
- txtNIP4.setBounds(550, 290, 150, 24);
- jLabel9.setFont(new java.awt.Font("Eras Medium ITC", 0, 12)); // NOI18N
- jLabel9.setForeground(new java.awt.Color(0, 153, 0));
- jLabel9.setText("Grand Total");
- getContentPane().add(jLabel9);
- jLabel9.setBounds(460, 290, 80, 20);
- jLabel10.setFont(new java.awt.Font("Eras Medium ITC", 0, 12)); // NOI18N
- jLabel10.setForeground(new java.awt.Color(0, 153, 0));
- jLabel10.setText("Bayar");
- getContentPane().add(jLabel10);
- jLabel10.setBounds(460, 330, 80, 20);
- txtNIP5.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- txtNIP5ActionPerformed(evt);
- }
- });
- getContentPane().add(txtNIP5);
- txtNIP5.setBounds(550, 330, 150, 24);
- jButton1.setIcon(new javax.swing.ImageIcon(getClass().getResource("/dropdown/icon/add.png"))); // NOI18N
- jButton1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton1ActionPerformed(evt);
- }
- });
- getContentPane().add(jButton1);
- jButton1.setBounds(660, 110, 40, 30);
- jButton2.setIcon(new javax.swing.ImageIcon(getClass().getResource("/dropdown/icon/Cancel-2-16x16.png"))); // NOI18N
- jButton2.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton2ActionPerformed(evt);
- }
- });
- getContentPane().add(jButton2);
- jButton2.setBounds(660, 50, 40, 25);
- pack();
- }// </editor-fold>
- public void tampil() {
- int row=tabmode.getRowCount();
- for (int i=0;i<row;i++){
- tabmode.removeRow(0);
- }
- try {
- Connection koneksi=DriverManager.getConnection("jdbc:mysql://localhost:3306/toko","root","");
- ResultSet rs=koneksi.createStatement().executeQuery("select * from itemjual");
- while(rs.next()){
- String[] data={rs.getString(4),rs.getString(5),rs.getString(6),rs.getString(7),rs.getString(8)};
- tabmode.addRow(data);
- }
- } catch (SQLException ex) {
- System.out.println(ex);
- }
- }
- private void btSimpanActionPerformed(java.awt.event.ActionEvent evt) {
- }
- private void btDeleteActionPerformed(java.awt.event.ActionEvent evt) {
- }
- private void btEditActionPerformed(java.awt.event.ActionEvent evt) {
- }
- private void btBatalActionPerformed(java.awt.event.ActionEvent evt) {
- //emptTeks();
- }
- private void txtNPActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void dtpTglActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void txtKodeActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void txtJmlActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void txtNIP3ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void tbSimpanActionPerformed(java.awt.event.ActionEvent evt) {
- }
- private void txtNIP4ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void txtNIP5ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void txtKodeKeyPressed(java.awt.event.KeyEvent evt) {
- if (evt.getKeyCode() == KeyEvent.VK_ENTER ){
- txtKode.requestFocus();}
- String Kd_brg = txtKode.getText();
- try {
- Connection koneksi=DriverManager.getConnection("jdbc:mysql://localhost:3306/toko","root","");
- Statement statement = (Statement) koneksi.createStatement();
- ResultSet rs=koneksi.createStatement().executeQuery("SELECT * FROM barang WHERE Kd_brg like '"+Kd_brg+"'");
- if (rs.next())
- txtNama.setText(rs.getString(2));
- txtHarga.setText(rs.getString(8));
- statement.close();
- koneksi.close();
- } catch (SQLException ex) {
- System.out.println(ex);
- } // TODO add your handling code here:
- }
- private void txtTotalActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
- if(txtKode.getText().trim().equals("")){
- JOptionPane.showMessageDialog(null,"Maaf, Kode Supplier harus di isi!");
- }else if(txtNama.getText().trim().equals("")){
- JOptionPane.showMessageDialog(null,"Maaf, Nama Supplier di isi!");
- }else{
- try {
- Connection koneksi=DriverManager.getConnection("jdbc:mysql://localhost:3306/toko","root","");
- dtpTgl.setDisplayFormat("yyyy-MM-dd");
- //----------------- SQL insert/simpan data -------------------------------
- koneksi.createStatement().executeUpdate("insert into itemjual values"+
- "('"+txtNP.getText()+
- "','"+dtpTgl.getSelectedItem()+
- "','"+cmbKasir.getSelectedItem()+
- "','"+txtKode.getText()+
- "','"+txtNama.getText()+
- "','"+txtHarga.getText()+
- "','"+txtJml.getText()+
- "','"+txtTotal.getText()+"')");
- dtpTgl.setDisplayFormat("dd-MM-yyyy");
- //------------------------------------------------------------------------
- emptTeks();
- tampil ();
- } catch (SQLException ex) {
- JOptionPane.showMessageDialog(null,"Data berhasil disimpan");
- }
- }
- // TODO add your handling code here:
- }
- private void txtJmlKeyPressed(java.awt.event.KeyEvent evt) {
- if (evt.getKeyCode() == KeyEvent.VK_ENTER ){
- txtTotal.requestFocus();}
- Harga = Float.parseFloat(txtHarga.getText());
- jumlah = Float.parseFloat(txtJml.getText());
- total = (float)jumlah*Harga;
- txtTotal.setText("" + total);
- /* double jumlah = Double.parseDouble(txtHarga.getText()) * Double.parseDouble(txtJml.getText());
- total = total + jumlah;
- if (txtJml.getText().equals("")){
- } else {
- txtTotal.setText(Double.toString(total));
- total = Double.parseDouble(txtTotal.getText());
- }*/
- }
- private void txtTotalKeyPressed(java.awt.event.KeyEvent evt) {
- if (evt.getKeyCode() == KeyEvent.VK_ENTER ){
- txtTotal.requestFocus();}
- try {
- Connection koneksi=DriverManager.getConnection("jdbc:mysql://localhost:3306/toko","root","");
- dtpTgl.setDisplayFormat("yyyy-MM-dd");
- //----------------- SQL insert/simpan data -------------------------------
- koneksi.createStatement().executeUpdate("insert into itemjual values"+
- "('"+txtNP.getText()+
- "','"+dtpTgl.getSelectedItem()+
- "','"+cmbKasir.getSelectedItem()+
- "','"+txtKode.getText()+
- "','"+txtNama.getText()+
- "','"+txtHarga.getText()+
- "','"+txtJml.getText()+
- "','"+txtTotal.getText()+"')");
- dtpTgl.setDisplayFormat("dd-MM-yyyy");
- //------------------------------------------------------------------------
- emptTeks();
- tampil ();
- } catch (SQLException ex) {
- JOptionPane.showMessageDialog(null,"Data berhasil disimpan");
- }
- // TODO add your handling code here:
- }
- private void txtNPKeyPressed(java.awt.event.KeyEvent evt) {
- if (evt.getKeyCode() == KeyEvent.VK_ENTER ){
- txtKode.requestFocus();}
- // TODO add your handling code here:
- }
- private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- String Kd_brg = txtKode.getText();
- try {
- Connection koneksi=DriverManager.getConnection("jdbc:mysql://localhost:3306/toko","root","");
- Statement statement = (Statement) koneksi.createStatement();
- String sql="DELETE FROM itemjual WHERE KodeBrg LIKE '"+Kd_brg+"'";
- statement.executeUpdate(sql);
- statement.close();
- emptTeks();
- tampil ();
- JOptionPane.showMessageDialog(null, "Data berhasil dihapus..","Informasi",JOptionPane.INFORMATION_MESSAGE);
- koneksi.close();
- } catch (SQLException ex) {
- JOptionPane.showMessageDialog(null,"Data berhasil dihapus");
- //System.err.println("Exception: "+e.getMessage());
- } // TODO add your handling code here:
- // TODO add your handling code here:
- }
- public void total(){
- }
- // Variables declaration - do not modify
- private javax.swing.JTable TabItem;
- private javax.swing.JComboBox cmbKasir;
- private uz.ncipro.calendar.JDateTimePicker dtpTgl;
- private javax.swing.JButton jButton1;
- private javax.swing.JButton jButton2;
- private javax.swing.JLabel jLabel10;
- private javax.swing.JLabel jLabel12;
- private javax.swing.JLabel jLabel13;
- private javax.swing.JLabel jLabel14;
- private javax.swing.JLabel jLabel2;
- private javax.swing.JLabel jLabel3;
- private javax.swing.JLabel jLabel4;
- private javax.swing.JLabel jLabel6;
- private javax.swing.JLabel jLabel7;
- private javax.swing.JLabel jLabel8;
- private javax.swing.JLabel jLabel9;
- private javax.swing.JPanel jPanel1;
- private javax.swing.JScrollPane jScrollPane1;
- private Cobaclass.button tbBatal;
- private Cobaclass.button tbSimpan;
- private Cobaclass.textfield txtHarga;
- private Cobaclass.textfield txtJml;
- private Cobaclass.textfield txtKode;
- private Cobaclass.textfield txtNIP3;
- private Cobaclass.textfield txtNIP4;
- private Cobaclass.textfield txtNIP5;
- private Cobaclass.textfield txtNP;
- private Cobaclass.textfield txtNama;
- private Cobaclass.textfield txtTotal;
- // End of variables declaration
- public void emptTeks() {
- txtKode.setText("");
- txtNama.setText("");
- txtHarga.setText("");
- txtJml.setText("");
- txtTotal.setText("");
- txtKode.requestFocus();
- }
- public void nofaktur(){
- /*try {
- Connection koneksi=DriverManager.getConnection("jdbc:mysql://localhost:3306/toko","root","");
- Statement statement = (Statement) koneksi.createStatement();
- ResultSet rs=koneksi.createStatement().executeQuery("select max(right(NoJual,5)) as no from itemjual");
- while(rs.next())
- {
- if(rs.first()==false)
- {
- txtNP.setText("ID-000001");
- }
- else
- {
- rs.last();
- int auto_id = rs.getInt(1)+1;
- String no = String.valueOf(auto_id);
- int noLong = no.length();
- for(int a=0;a<6-noLong;a++)
- {
- no="0"+no;
- }
- txtNP.setText("ID-"+no);
- }
- }
- rs.close();
- statement.close();
- }
- catch (SQLException ex) {
- JOptionPane.showMessageDialog(null,"Data berhasil disimpan");
- }
- */
- try {
- Connection koneksi=DriverManager.getConnection("jdbc:mysql://localhost:3306/toko","root","");
- Statement statement = (Statement) koneksi.createStatement();
- ResultSet rs=koneksi.createStatement().executeQuery("select * from itemjual order by NoJual desc");
- if(rs.next()){
- String nofak = rs.getString("NoJual").substring(1);
- String AN = "" + ((nofak)+1);
- String Nol ="" ;
- if(AN.length()==1)
- {Nol="000";}
- else if(AN.length()==2)
- {Nol="00";}
- else if(AN.length()==3)
- {Nol="0";}
- else if(AN.length()==4)
- {Nol="";}
- txtNP.setText("F"+Nol+AN);
- } else {
- txtNP.setText("F0001");
- }
- } catch (SQLException ex) {
- System.out.println(ex);
- }
- }
- private void cekStok(String ubah){
- int stok = 0;
- String total = "select stok from barang where kd_brg ='"+txtKode.getText()+"'";
- try {
- Connection koneksi=DriverManager.getConnection("jdbc:mysql://localhost:3306/toko","root","");
- ResultSet rs=koneksi.createStatement().executeQuery(total);
- Statement statement = (Statement) koneksi.createStatement();
- while(rs.next()) {
- stok = Integer.parseInt(rs.getString(5));
- }
- } catch (Exception e) {
- }
- }
- //return stok;
- /*
- public void UpdateStok(){
- try {
- if (ubah.equals("insert")) {
- stokBaru = cekStok() - Integer.parseInt(txtJml.getText());
- ....} else if (ubah.equals("delete")) {
- stokBaru = cekStok() + stok_awal;
- String total = "update barang set stok ='"+stokBaru+"' where kd_barang='"+kodebarang+"'";
- statement.executeUpdate(total);
- }
- }catch (Exception e) {
- JOptionPane.showMessageDialog(null,"Data berhasil disimpan");
- }
- } */
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement