Kamis, 26 April 2018

Program Penjualan Product Olahraga


untuk memenuhi kelengkapan nilai mata kuliah pemograman1 di STMIK ERESHA, sebelumnya saya sudah membuat perancangannya dipekan uts lalu. Program yg saya buat adalah aplikasi penjualan macam-macam product olahraga , mungkin ini hanya program sederhana saja atau bisa dibilang program untuk progamer pemula.
oke lanjut , untuk pengoprasianya :
-User hhanya memilih kode barang yang sudah dibuat, kode yg dipilih sudah mengautomatiskan nama dan harga .
-Harga yg dibeli oleh user dikalihkan dengan jumlah yg akan dibeli.
-Setiap total bayar akan dikenakan pajak
Nah jumlah uang tunai user yg dibelikan akan dikurangi dengan , jumlah total bayar yang sudah dikenakan pajak tadi.
-Data yg sudah dihitung tadi ,user bisa  menyimpan nya di Ms.Word atau Ms.Excel.


Yang akan saya berikan di Blog ini :
-Contoh Design
-Source code
-Hasil Run

Contoh Design


Source  code di ComboBox :

 If ComboBox1.Text = "NIKE" Then
            TextBox2.Text = "100.000"
            PictureBox1.Image = Image.FromFile("C:\picture program\nike.jpg")
        End If
        If ComboBox1.Text = "ADIDAS" Then
            TextBox2.Text = "150.000"
            PictureBox1.Image = Image.FromFile("C:\picture program\adidas.jpg")
        End If
        If ComboBox1.Text = "SPECS" Then
            TextBox2.Text = "200.000"
            PictureBox1.Image = Image.FromFile("C:\picture program\specs.jpg")
        End If
    End Sub


Source code Button Hitung :

Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
        TextBox4.Text = TextBox3.Text * TextBox2.Text
    End Sub

Source Button Keluar :

Private Sub Button4_Click(sender As Object, e As EventArgs) Handles Button4.Click
        Me.Close()

    End Sub

Source Button Bayar:
 Private Sub Btnbayar_Click(sender As Object, e As EventArgs) Handles Btnbayar.Click
        TextBox5.Text = TextBox1.Text - TextBox4.Text

    End Sub

Source code Ms.Word :

 Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click
        Dim Appnya As New Word.Application
        Dim Dokumennya As Word.Document

        Dokumennya = Appnya.Documents.Open("D:\toko\sport.docx")
        Dokumennya.Bookmarks("Barang").Select()
        Appnya.Selection.TypeText(ComboBox1.Text)

        Dokumennya.Bookmarks("Harga").Select()
        Appnya.Selection.TypeText(TextBox2.Text)

        Dokumennya.Bookmarks("Jumlah").Select()
        Appnya.Selection.TypeText(TextBox3.Text)

        Dokumennya.Bookmarks("totalharga").Select()
        Appnya.Selection.TypeText(TextBox4.Text)

        Dokumennya.Bookmarks("Pembayaran").Select()
        Appnya.Selection.TypeText(TextBox1.Text)

        Dokumennya.Bookmarks("kembalian").Select()
        Appnya.Selection.TypeText(TextBox5.Text)
        Dokumennya.SaveAs("D:\toko\sportNew.docx")

        Appnya.Visible = True


    End Sub

Source code Ms.Excel :

 Private Sub Button3_Click(sender As Object, e As EventArgs) Handles Button3.Click
        Dim AppExcelnya As New Excel.Application
        Dim ExcelWB As Excel.Workbook
        ExcelWB = AppExcelnya.Workbooks.Open("D:\toko\sport.xlsx")
        AppExcelnya.Range("A2").Value = ComboBox1.Text
        AppExcelnya.Range("B2").Value = TextBox2.Text
        AppExcelnya.Range("C2").Value = TextBox3.Text
        AppExcelnya.Range("D2").Value = TextBox4.Text
        AppExcelnya.Range("E2").Value = TextBox4.Text
        AppExcelnya.Range("F2").Value = TextBox4.Text
        ExcelWB.SaveAs("D:\toko\sportNew.xlsx")

        AppExcelnya.Visible = True

    End Sub

Hasil Run :

Hasil Data di Ms.Word:


Hasil Data di Ms.Excel:

Sekian dan mohon maaf apabila ada kata yang salah
Wassalamualaikum Wr.Wb
Diposting oleh di Tidak ada komentar:

Jumat, 21 Juli 2017



                                               Assalamualaikum wr wb.
Saya akan menjelaskan tentang program input data karyawan dan saya akan menjelaskan dibawah ini.

1.pertama buatlah data basenya

2.buka aplikasi netbeans lalu buat JFrame nya seperti dibawah ini
 







3.isi dan masukan plihan anda dengan benar seperti dibawah ini






4.inilah source code
/*
 * 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 donny;
import com.mysql.jdbc.Statement;
import java.sql.ResultSet;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.SQLException;
import javax.swing.table.DefaultTableModel;
import javax.swing.JOptionPane;
import koneksi.coken;

/**
 *
 * @author donnychand
 */
public class proses extends javax.swing.JFrame {
int gaji;
    /**
     * Creates new form proses
     */
    public proses() {
        initComponents();
        datatable();
    }

    /**
     * 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() {

        jScrollPane1 = new javax.swing.JScrollPane();
        jTable1 = new javax.swing.JTable();
        DATAKARYAWAN = new javax.swing.JLabel();
        NIK = new javax.swing.JLabel();
        NAMA = new javax.swing.JLabel();
        JABATAN = new javax.swing.JLabel();
        GAJIPOKOK = new javax.swing.JLabel();
        ALAMAT = new javax.swing.JLabel();
        Text1 = new javax.swing.JTextField();
        Text2 = new javax.swing.JTextField();
        CMB1 = new javax.swing.JComboBox<>();
        Text3 = new javax.swing.JTextField();
        SAVE = new javax.swing.JButton();
        REFRESH = new javax.swing.JButton();
        EXIT = new javax.swing.JButton();
        jScrollPane2 = new javax.swing.JScrollPane();
        table = new javax.swing.JTable();
        jScrollPane3 = new javax.swing.JScrollPane();
        Txt4 = new javax.swing.JTextArea();

        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}
            },
            new String [] {
                "Title 1", "Title 2", "Title 3", "Title 4"
            }
        ));
        jScrollPane1.setViewportView(jTable1);

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

        DATAKARYAWAN.setText("DATA KARYAWAN");

        NIK.setText("NIK");

        NAMA.setText("NAMA");

        JABATAN.setText("JABATAN");

        GAJIPOKOK.setText("GAJI KARYAWAN");

        ALAMAT.setText("ALAMAT");

        Text1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                Text1ActionPerformed(evt);
            }
        });

        CMB1.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "======", "DIREKTUR", "STAFF", "KARYAWAN", "ANGGOTA" }));
        CMB1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                CMB1ActionPerformed(evt);
            }
        });

        SAVE.setText("SAVE");
        SAVE.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                SAVEActionPerformed(evt);
            }
        });

        REFRESH.setText("REFRESH");
        REFRESH.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                REFRESHActionPerformed(evt);
            }
        });

        EXIT.setText("EXIT");

        table.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"
            }
        ));
        jScrollPane2.setViewportView(table);

        Txt4.setColumns(20);
        Txt4.setRows(5);
        jScrollPane3.setViewportView(Txt4);

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
                        .addGap(0, 0, Short.MAX_VALUE)
                        .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 754, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGroup(layout.createSequentialGroup()
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(layout.createSequentialGroup()
                                .addGap(159, 159, 159)
                                .addComponent(DATAKARYAWAN))
                            .addGroup(layout.createSequentialGroup()
                                .addGap(23, 23, 23)
                                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addComponent(NIK)
                                    .addComponent(NAMA)
                                    .addComponent(JABATAN)
                                    .addComponent(ALAMAT)
                                    .addComponent(GAJIPOKOK))
                                .addGap(74, 74, 74)
                                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                                    .addComponent(Text1)
                                    .addComponent(Text2)
                                    .addComponent(CMB1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                                    .addComponent(Text3)
                                    .addComponent(jScrollPane3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))))
                        .addGap(0, 0, Short.MAX_VALUE)))
                .addContainerGap())
            .addGroup(layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(SAVE)
                .addGap(103, 103, 103)
                .addComponent(REFRESH, javax.swing.GroupLayout.PREFERRED_SIZE, 78, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(130, 130, 130)
                .addComponent(EXIT)
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(DATAKARYAWAN)
                .addGap(18, 18, 18)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(NIK)
                    .addComponent(Text1, javax.swing.GroupLayout.PREFERRED_SIZE, 22, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(18, 18, 18)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(NAMA)
                    .addComponent(Text2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(22, 22, 22)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(JABATAN)
                    .addComponent(CMB1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(18, 18, 18)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(GAJIPOKOK)
                    .addComponent(Text3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(18, 18, 18)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(ALAMAT)
                    .addComponent(jScrollPane3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 48, Short.MAX_VALUE)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(SAVE)
                    .addComponent(REFRESH, javax.swing.GroupLayout.PREFERRED_SIZE, 23, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(EXIT))
                .addGap(52, 52, 52)
                .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 92, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(171, 171, 171))
        );

        pack();
    }// </editor-fold>                       

    private void SAVEActionPerformed(java.awt.event.ActionEvent evt) {                                    
        // TODO add your handling code here:
        String nik=Text1.getText();
        String nama=Text2.getText();
        String jabata=(String)CMB1.getSelectedItem();
        String gaji=Text3.getText();
        String alamat=Txt4.getText();
        try{
            Statement sta =(Statement) coken.GetConnection().createStatement();
            sta.executeUpdate("INSERT INTO tbdonny VALUES('"+nik+"','"+nama+"','"+jabata+"','"+gaji+"','"+alamat+"')");
            JOptionPane.showMessageDialog(null,"sukses");
           
        }catch(Exception e){
            JOptionPane.showMessageDialog(null,"Terjadi kesalahan");
        }
    }                                   

    private void REFRESHActionPerformed(java.awt.event.ActionEvent evt) {                                       
        // TODO add your handling code here:
        DefaultTableModel tbl = new DefaultTableModel();
        tbl.addColumn("NIK");
        tbl.addColumn("Nama");
        tbl.addColumn("Jabatan");
        tbl.addColumn("Gaji");
        tbl.addColumn("Alamat");
        table.setModel(tbl);
        try{
            Statement sta=(Statement) coken.GetConnection().createStatement();
            ResultSet res=sta.executeQuery("SELECT * FROM tbdonny");
            while(res.next())
            {
                tbl.addRow(new Object[]{
                   res.getString("nik"),
                    res.getString("nama"),
                    res.getString("jabata"),
                    res.getString("gaji"),
                    res.getString("alamat")
                });
            table.setModel(tbl);
            }
        }catch(Exception e){
            JOptionPane.showMessageDialog(null,"Terjadi Kesalahan saat menampilkan data");
        }
    }                                      

    private void CMB1ActionPerformed(java.awt.event.ActionEvent evt) {                                    
        // TODO add your handling code here:
        if(CMB1.getSelectedItem().equals("DIREKTUR")){
            gaji=5000000;
        Text3.setText(""+gaji);
        }
        else if(CMB1.getSelectedItem().equals("STAFF")){
            gaji=4000000;
        Text3.setText(""+gaji);
        }
        else if(CMB1.getSelectedItem().equals("KARYAWAN")){
            gaji=4000000;
        Text3.setText(""+gaji);
        }
        else if(CMB1.getSelectedItem().equals("ANGGOTA")){
            gaji=3000000;
        Text3.setText(""+gaji);
        }
    }                                   

    private void Text1ActionPerformed(java.awt.event.ActionEvent evt) {                                     
        // TODO add your handling code here:
    }                                    

    public void datatable(){
    DefaultTableModel tbl = new DefaultTableModel();
        tbl.addColumn("NIK");
        tbl.addColumn("Nama");
        tbl.addColumn("Jabatan");
        tbl.addColumn("Gaji");
        tbl.addColumn("Alamat");
        table.setModel(tbl);
        try{
            Statement sta=(Statement) coken.GetConnection().createStatement();
            ResultSet res=sta.executeQuery("SELECT * FROM tbdonny");
            while(res.next())
            {
                tbl.addRow(new Object[]{
                   res.getString("nik"),
                    res.getString("nama"),
                    res.getString("jabata"),
                    res.getString("gaji"),
                    res.getString("alamat")
                });
            table.setModel(tbl);
            }
        }catch(Exception e){
            JOptionPane.showMessageDialog(null,"Terjadi Kesalahan saat menampilkan data");
        }
    }
    /**
     * @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(proses.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(proses.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(proses.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (javax.swing.UnsupportedLookAndFeelException ex) {
            java.util.logging.Logger.getLogger(proses.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        }
        //</editor-fold>

        /* Create and display the form */
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new proses().setVisible(true);
            }
        });
    }

    // Variables declaration - do not modify                    
    private javax.swing.JLabel ALAMAT;
    private javax.swing.JComboBox<String> CMB1;
    private javax.swing.JLabel DATAKARYAWAN;
    private javax.swing.JButton EXIT;
    private javax.swing.JLabel GAJIPOKOK;
    private javax.swing.JLabel JABATAN;
    private javax.swing.JLabel NAMA;
    private javax.swing.JLabel NIK;
    private javax.swing.JButton REFRESH;
    private javax.swing.JButton SAVE;
    private javax.swing.JTextField Text1;
    private javax.swing.JTextField Text2;
    private javax.swing.JTextField Text3;
    private javax.swing.JTextArea Txt4;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JScrollPane jScrollPane3;
    private javax.swing.JTable jTable1;
    private javax.swing.JTable table;
    // End of variables declaration        



Berikut Sourcode koneksi dibawah ini

/*
 * 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 koneksi;
import com.mysql.jdbc.Driver;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

/**
 *
 * @author donnychand
 */
public class coken {
    public static Connection koneksi;
    public static Connection GetConnection()throws SQLException {
            if(koneksi==null){
                new Driver();
                koneksi=DriverManager.getConnection("jdbc:mysql://localhost/dbdonny","root","");
            }
            return koneksi;
    }
   
}

Sekian dan terimakasih semoga bermanfaat.

Dari saya Donny septiandi









Diposting oleh di Tidak ada komentar:
Langganan: Postingan (Atom)