Data Supplier Barang

database access

tampilan awal program

package barang;
import java.sql.*;
import javax.swing.*;
/**
 *
 * @author Juli
 */
public class Nyebelin {
    void testNyebelin()
    {
        try
        {
            String dbname="jdbc:odbc:Supplier";
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con=DriverManager.getConnection(dbname,"admin","admin");



            JOptionPane.showMessageDialog(null, "Test euuyyyyy","Insert Data",JOptionPane.INFORMATION_MESSAGE);
            con.close();
        }
        catch (Exception e)
        {
            JOptionPane.showInternalMessageDialog(null, "error"+e,"Gagal",JOptionPane.WARNING_MESSAGE);
        }
    }
    public static void main(String args[])
    {
            Nyebelin test = new Nyebelin ();
            test.testNyebelin();
            System.exit(0);
    }
}

tampilan koneksi berhasil

package barang;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JOptionPane;

/**
 *
 * @author Juli
 */
public class data extends javax.swing.JFrame {

    /** Creates new form data */
    public data() {
        initComponents();
    }

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

// TODO add your handling code here:

    txtharga.setText("");

    txtjumbel.setText("");

    txtkode.setText("");

    txtnama.setText("");

    txtstok.setText("");

    txtsupplier.setText("");

    txttotal.setText("");

    txtharga.setEditable(true);

    txtjumbel.setEditable(true);

    txtkode.setEditable(true);

    txtnama.setEditable(true);

    txtstok.setEditable(true);

    txtsupplier.setEditable(true);

    txttotal.setEditable(true);

    txtkode.requestFocus();

}

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

// TODO add your handling code here:

    String HargaBarang=txtharga.getText();

    String JumlahBeli=txtjumbel.getText();

    String KodeBarang=txtkode.getText();

    String NamaBarang=txtnama.getText();

    String StokBarang=txtstok.getText();

    String SupplierBarang=txtsupplier.getText();

    String Total=txttotal.getText();

    

    try

    {

        String dbname="jdbc:odbc:Supplier";

        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

        Connection con=DriverManager.getConnection(dbname,"admin","admin");

        java.sql.Statement statement=con.createStatement();

        String sql="Insert into tb_barang values('"+KodeBarang+"','"+NamaBarang+"','"+HargaBarang+"','"+StokBarang+"','"+SupplierBarang+"','"+JumlahBeli+"','"+Total+"');";

        statement.executeUpdate(sql);

        statement.close();

        JOptionPane.showMessageDialog(null,"data berhasil dimasukan", "Insert data",JOptionPane.INFORMATION_MESSAGE);

        

        con.close();

    }

    catch (Exception e)

    {

        JOptionPane.showMessageDialog(null,"Error:"+e,"Gagal",JOptionPane.WARNING_MESSAGE);             

    }

}

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

// TODO add your handling code here:

    String KodeBarang=txtkode.getText();

    try

    {

        String dbname="jdcbc:odbc:Supplier";

        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

        Connection con=DriverManager.getConnection(dbname,"admin","admin");

        Statement statement=con.createStatement();

        String sql="SELECT* From tb_barang WHERE KODE like'"+KodeBarang+"'";

        ResultSet rs=statement.executeQuery(sql);

       

       if(rs.next())

       {

           txtharga.setText(rs.getString(2));

           txtjumbel.setText(rs.getString(3));

           txtnama.setText(rs.getString(4));

           txtstok.setText(rs.getString(5));

           txtsupplier.setText(rs.getString(6));

           txttotal.setText(rs.getString(7));

           

           JOptionPane.showMessageDialog(null, "Data Ditemukan","Insert Data",JOptionPane.INFORMATION_MESSAGE);

       }

       else

       {

           JOptionPane.showMessageDialog(null,"Data Tidak Ditemukan","Insert Data",JOptionPane.INFORMATION_MESSAGE);

       }

       statement.close();

       con.close();

    }

    catch(Exception e)

    {

        JOptionPane.showMessageDialog(null, "Error:"+e,"Gagal",JOptionPane.WARNING_MESSAGE);

    }

}

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

// TODO add your handling code here:

    String KodeBarang=txtkode.getText();

    try

    {

       String dbname="jdbc:odbc:Supplier";

       Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

       Connection con=DriverManager.getConnection(dbname,"admin","admin");

       Statement statement=con.createStatement();

       String sql="DELETE FROM tb_barang WHERE KODE LIKE'"+KodeBarang+"'";

       statement.executeUpdate(sql);

       

       statement.close();

       txtkode.setText("");

       txtnama.setText("");

       txtstok.setText("");

       txtharga.setText("");

       txtjumbel.setText("");

       txtsupplier.setText("");

       txttotal.setText("");

       

       JOptionPane.showMessageDialog(null,"Data berhasil diHapus..","Hapus Data",JOptionPane.INFORMATION_MESSAGE);

       con.close();

    }

    catch(Exception e){

    JOptionPane.showMessageDialog(null, "Error:"+e,"Gagal",JOptionPane.WARNING_MESSAGE);

    }            

}

tampilan program setelah running