bagaimana cara simpan data ditable A dan menambah data ditable B

Gan/sis mohon bantuan dan panduannya gimana ya caranya disourccode Jframe form(pasok) agar saya bisa menambah stock didatabasenya jika saya input form pasok  maka data akan tersimpan ditable pasok dan didatabase table barang kode barang tersebut bertambah, dari sourcecode yang saya buat ini pas kita save di form Pemasok data yang tersimpan adalah id_pasok, id_barang, jumlah dan tanggal didatabase sedangkan jumlah tidak bertambah ke database barang

Database yang saya buat

Table pasok terdiri dari id_pasok (Primary Key), id_barang (Foreign Key), jumlah, tanggal

Table barang terdiri dari id_barang(primary key), nama_barang, stock, harga_pokok, harga_jual

pasok.jpg

pasok2.jpg

Ini Sourcecodenya

Koneksi  è (Class koneksi dipaket controller)

package controller;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import javax.swing.JOptionPane;

/**

*

\* @author Meong

*/

public class koneksi {

private static Connection koneksi;

    public static Connection getKoneksi() {

     if(koneksi==null){

         try{

         String url;

         url="jdbc:mysql://localhost:3306/kucing";

         String username ="root";

         String password ="meong";

         DriverManager.registerDriver(new com.mysql.jdbc.Driver());

         koneksi = DriverManager.getConnection(url,username,password);

         }catch (SQLException t){

          JOptionPane.showMessageDialog(null, "KONEKSI GAGAL");

        }

    }return koneksi;

    }static Object getConnection(){

        throw new UnsupportedOperationException("Not yet implemented");

}

}

Classbarang  è (class barang dipaket controller)

package controller;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import javax.swing.JOptionPane;

import net.proteanit.sql.DbUtils;

/**

*

\* @author Meong

*/

public class classbarang {

    Connection conn = null;

    ResultSet rs = null;

    PreparedStatement pst = null;

    private String sql;

    public String id_barang;

    public String nama_barang;

    public String stock;

    public Double harga_pokok;

    public double harga_jual;

        public void simpan( )throws SQLException{

        conn = koneksi.getKoneksi();

        sql = "INSERT INTO barang(id_barang,nama_barang,stock,harga_pokok,harga_jual) VALUE(?,?,?,?,?)";

        pst = conn.prepareStatement(sql);

        pst.setString(1, id_barang);

        pst.setString(2, nama_barang);

        pst.setString(3, stock);

        pst.setDouble(4, harga_pokok);

        pst.setDouble(5, harga_jual);

        pst.execute();

        pst.close();

    }

}

Barang  è (Jframe Form Barang di paket home)

package home;

import com.sun.glass.events.KeyEvent;

import controller.classbarang;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

import javax.swing.JOptionPane;

/**

*

\* @author Meong

*/

public class barang extends javax.swing.JFrame {

    /**

     \* Creates new form barang

     */

    public barang() {

        initComponents();

    }

    private void exitActionPerformed(java.awt.event.ActionEvent evt) {

        // TODO add your handling code here:

        if(JOptionPane.showConfirmDialog(null, "Apakah Anda Yakin Mau Keluar?","Keluar",JOptionPane.YES_NO_OPTION)==JOptionPane.YES_NO_OPTION){

          System.exit(0)  ;

        }

    }

private void simpanActionPerformed(java.awt.event.ActionEvent evt) {

        // TODO add your handling code here:

            classbarang idm = new classbarang();

            idm.id_barang = txtidbarang.getText();

            idm.nama_barang = txtnamabarang.getText();

            idm.stock = txtstock.getText();

            idm.harga_pokok = Double.parseDouble(txthargapokok.getText());

            idm.harga_jual = Double.parseDouble(txthargajual.getText());

            //idm.tanggal = jDateChooser1.getDateFormatString();

            try{

                idm.simpan();

                //JOptionPane.showMessageDialog(null, "Berhasil");

                  javax.swing.JOptionPane.showMessageDialog(this, "Data Berhasil Tersimpan","Pesan", javax.swing.JOptionPane.INFORMATION_MESSAGE);

            }catch (Exception e){

                JOptionPane.showMessageDialog(null, e);

            }

    }

Classpasok è (class Pasok di paket controller)

package controller;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import javax.swing.JOptionPane;

import net.proteanit.sql.DbUtils;

/**

*

\* @author tania

*/

public class classpasok {

    Connection conn = null;

    ResultSet rs = null;

    PreparedStatement pst = null;

    private String sql;

    public String id_pasok;

    public String id_barang;

    public String jumlah;

    public String tanggal;

        public void simpan( )throws SQLException{

        conn = koneksi.getKoneksi();

        sql = "INSERT INTO pasok(id_pasok,id_barang,jumlah,tanggal) VALUE(?,?,?,?)";

        pst = conn.prepareStatement(sql);

        pst.setString(1, id_pasok);

        pst.setString(2, id_barang);

        pst.setString(3, jumlah);

        pst.setString(4, tanggal);

        pst.execute();

        pst.close();

    }

}

pasok  è (Jframe Form pasok di paket home)

package home;

import com.sun.glass.events.KeyEvent;

import controller.classbarang;

import controller.classpasok;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

import java.text.SimpleDateFormat;

import javax.swing.JOptionPane;

import java.util.Date;

/**

*

\* @author tania

*/

public class pasok extends javax.swing.JFrame {

    /**

     \* Creates new form pasok

     */

    public void waktu(){

    Date tgl=new Date();

    jDateChooser1.setDate(tgl);

    }

    public pasok() {

        initComponents();

        waktu();

    }

    private void exitActionPerformed(java.awt.event.ActionEvent evt) {

        // TODO add your handling code here:

          if(JOptionPane.showConfirmDialog(null, "Apakah Anda Yakin Mau Keluar?","Keluar",JOptionPane.YES_NO_OPTION)==JOptionPane.YES_NO_OPTION){

          System.exit(0)  ;

          }

    }

private void saveActionPerformed(java.awt.event.ActionEvent evt) {

        // TODO add your handling code here:

            String tampilan = "yyyy-MM-dd";

            SimpleDateFormat fm = new SimpleDateFormat(tampilan);

            String tanggal=String.valueOf(fm.format(jDateChooser1.getDate()));

            classpasok idm = new classpasok();

            //classbarang idm2 = new classbarang();

            idm.id_pasok = txtidpasok.getText();

            idm.id_barang = txtidbarang.getText();

            idm.jumlah = txtjumlah.getText();

            idm.tanggal = tanggal;

            //idm.tanggal = jDateChooser1.getDateFormatString();

            try{

                idm.simpan();

                //JOptionPane.showMessageDialog(null, "Berhasil");

                  javax.swing.JOptionPane.showMessageDialog(this, "Data Berhasil Tersimpan","Pesan", javax.swing.JOptionPane.INFORMATION_MESSAGE);

            }catch (Exception e){

                JOptionPane.showMessageDialog(null, e);

            }

    }

private void txtidbarangKeyPressed(java.awt.event.KeyEvent evt) {

        // TODO add your handling code here:

        classbarang idm = new classbarang();

        if(evt.getKeyCode()==KeyEvent.VK_ENTER){

           try{

               //Class.forName("com.mysql.jdbc.Driver");

               Class.forName("com.mysql.cj.jdbc.Driver");

               Connection cn = DriverManager.getConnection("jdbc:mysql:"+"///kucing","root","meong");

               Statement smt = cn.createStatement();

               ResultSet rs = smt.executeQuery("Select * from barang where id_barang ="+"'"+txtidbarang.getText()+"'");

               if(rs.next()){

                   javax.swing.JOptionPane.showMessageDialog(this, "Kode Tersebut Ada","Pesan", javax.swing.JOptionPane.INFORMATION_MESSAGE);

                   txtnamabarang.setText(rs.getString("nama_barang"));

                   txtnamabarang.setEnabled(false);

                   //tgllahir.setDate(rs.getDate("tgl"));

               }else{

                   javax.swing.JOptionPane.showMessageDialog(this, "Data Tidak Ada","Pesan", javax.swing.JOptionPane.INFORMATION_MESSAGE);

               }

           }catch (Exception e){

               e.printStackTrace();

           }

           txtjumlah.requestFocus();

        }

    }