Minggu, 12 Januari 2020

HAMIZUL FUAD / TUGAS UAS

NAMA : HAMIZUL FUAD
NIM      : 161011700058


STUDI KASUS PT. DISTRIBUTOR GADGET

1. Mencari kasus order hp samsung di kota surabaya
2. Mencari kasus order handphone vivo v11 
3. Mencari kasus order KODE A1
4. Mencari kasus order hp oppo nama dikota DEPOK
5. Mencari kasus KODE A4 HANPHONE SAMSUNG


1. Mencari kasus order hp samsung di kota surabaya



2. Mencari kasus order handphone vivo v11 


3. Mencari kasus order KODE A1



4. Mencari kasus order hp oppo nama dikota DEPOK



5. Mencari kasus KODE A4 HANPHONE SAMSUNG















Senin, 16 Desember 2019

Nama : HAMIZUL FUAD 
NIM : 161011700058
PRODI : SISTEM INFORMASI 

1. QUERY Pertama

Dalam gambar Query dibawah ini menunjukkan datasheet & design view hasil pencarian event
 ( Disarmed by User ) pada database tersebut . Berikut adalah SQLview & Designview dari Query1 






2. QUERY kedua 

Dalam gambar Query dibawah ini menunjukkan datasheet & design view hasil pencarian event types Alarm) pada database tersebut . Berikut adalah SQLview & Designview dari Query2








2. QUERY ketiga

Dalam gambar Query dibawah ini menunjukkan datasheet & design view hasil pencarian zona ( 0 ) pada database tersebut . Berikut adalah SQLview & Designview dari Query3









Senin, 19 November 2018

UAS( Rekayasa Perangkat Lunak )

APLIKASI TIKET KERETA API







#Source Code

Imports System.Data
Imports System.Data.OleDb

Public Class tiket
    Inherits System.Web.UI.Page
    Dim Koneksi As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\ASUS\Documents\Dbtiket.mdb"
    Dim objekKoneksi As New OleDb.OleDbConnection(Koneksi)

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

    End Sub

    Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles simpan.Click
        objekKoneksi.Open()
        Dim tambah As String = "INSERT INTO Dbtiket values('" & jeniskereta.Text & "','" & kelas.Text & "','" & hargatiket.Text & "','" & jumlah.Text & "') "
        Dim oCmd = New OleDbCommand(tambah, objekKoneksi)
        oCmd.ExecuteNonQuery()
        objekKoneksi.Close()
        MsgBox("Sukses")
    End Sub

    Protected Sub hapus_Click(sender As Object, e As EventArgs) Handles hapus.Click
        jeniskereta.Text = ""
        kelas.Text = ""
        hargatiket.Text = ""
        jumlah.Text = ""
        jeniskereta.Focus()
    End Sub

    Protected Sub data_Click(sender As Object, e As EventArgs) Handles data.Click
        Response.Redirect("krl.aspx")
    End Sub

    Protected Sub jeniskereta_TextChanged(sender As Object, e As EventArgs) Handles jeniskereta.TextChanged

    End Sub
End Class


Senin, 05 November 2018

Rekayasa perangkat lunak



package penjualan.tiket.bioskop;

/**
 *
 * @author hamizulfuad
 */
public class Frame_penjualan_tiket extends javax.swing.JFrame {

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

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

        jLabel1 = new javax.swing.JLabel();
        jLabel2 = new javax.swing.JLabel();
        jLabel3 = new javax.swing.JLabel();
        jLabel4 = new javax.swing.JLabel();
        jLabel5 = new javax.swing.JLabel();
        jLabel6 = new javax.swing.JLabel();
        NoTiket = new javax.swing.JTextField();
        hargaSatuan = new javax.swing.JTextField();
        jumlahBeli = new javax.swing.JTextField();
        totalBayar = new javax.swing.JTextField();
        reguler = new javax.swing.JRadioButton();
        btnProses = new javax.swing.JButton();
        btnHapus = new javax.swing.JButton();
        ultraXDAtmos = new javax.swing.JRadioButton();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
        setBackground(new java.awt.Color(255, 0, 0));

        jLabel1.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
        jLabel1.setText("Program Penjualan Tiket Bioskop");

        jLabel2.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
        jLabel2.setText("No Tiket");

        jLabel3.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
        jLabel3.setText("Jenis Tiket");

        jLabel4.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
        jLabel4.setText("Harga Satuan");

        jLabel5.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
        jLabel5.setText("Jumlah Beli");

        jLabel6.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
        jLabel6.setText("Total Bayar");

        NoTiket.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N

        hargaSatuan.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N

        jumlahBeli.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N

        totalBayar.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N

        reguler.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
        reguler.setText("Reguler");
        reguler.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                regulerActionPerformed(evt);
            }
        });

        btnProses.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
        btnProses.setText("Proses");
        btnProses.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnProsesActionPerformed(evt);
            }
        });

        btnHapus.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
        btnHapus.setText("Hapus");
        btnHapus.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnHapusActionPerformed(evt);
            }
        });

        ultraXDAtmos.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
        ultraXDAtmos.setText("Ultra XD Atmos");
        ultraXDAtmos.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                ultraXDAtmosActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jLabel4)
                    .addComponent(jLabel5)
                    .addComponent(jLabel6)
                    .addComponent(jLabel3)
                    .addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 92, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(48, 48, 48)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jumlahBeli)
                    .addComponent(hargaSatuan)
                    .addGroup(layout.createSequentialGroup()
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(layout.createSequentialGroup()
                                .addComponent(btnProses)
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                .addComponent(btnHapus))
                            .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                                .addComponent(NoTiket, javax.swing.GroupLayout.PREFERRED_SIZE, 247, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createSequentialGroup()
                                    .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                        .addComponent(reguler)
                                        .addComponent(ultraXDAtmos))
                                    .addGap(26, 26, 26))))
                        .addGap(0, 27, Short.MAX_VALUE))
                    .addComponent(totalBayar))
                .addContainerGap(42, javax.swing.GroupLayout.PREFERRED_SIZE))
            .addGroup(layout.createSequentialGroup()
                .addGap(61, 61, 61)
                .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 324, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addGap(41, 41, 41)
                .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 29, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(42, 42, 42)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel2)
                    .addComponent(NoTiket, 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(jLabel3)
                    .addComponent(reguler))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addComponent(ultraXDAtmos)
                .addGap(18, 18, 18)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel4)
                    .addComponent(hargaSatuan, 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(jLabel5)
                    .addComponent(jumlahBeli, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(32, 32, 32)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(btnProses)
                    .addComponent(btnHapus))
                .addGap(18, 18, 18)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel6)
                    .addComponent(totalBayar, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addContainerGap(23, Short.MAX_VALUE))
        );

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

    private void btnProsesActionPerformed(java.awt.event.ActionEvent evt) {                                       
        // TODO add your handling code here:
        int c = Integer.parseInt(hargaSatuan.getText());
        int d = Integer.parseInt(jumlahBeli.getText());
        int hasilnya = c*d;
        totalBayar.setText("Rp. "+hasilnya);
    }                                       

    private void btnHapusActionPerformed(java.awt.event.ActionEvent evt) {                                       
        // TODO add your handling code here:
        IdPembeli.setText("");
        jumlahBeli.setText("");
        hargaSatuan.setText("");
        totalBayar.setText("");
        reguler.setSelected(false);
        ultraXD.setSelected(false);
        reguler.setEnabled(true);
        ultraXD.setEnabled(true);
    }                                     

    private void ultraXDAtmosActionPerformed(java.awt.event.ActionEvent evt) {                                           
        // TODO add your handling code here:
        hargaSatuan.setText("60000");
    }                                         

    private void regulerActionPerformed(java.awt.event.ActionEvent evt) {                                     
        // TODO add your handling code here:
        hargaSatuan.setText("50000");
    }                                     

    /**
     * @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(Frame_penjualan_tiket.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(Frame_penjualan_tiket.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(Frame_penjualan_tiket.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (javax.swing.UnsupportedLookAndFeelException ex) {
            java.util.logging.Logger.getLogger(Frame_penjualan_tiket.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 Frame_penjualan_tiket().setVisible(true);
            }
        });
    }
    // Variables declaration - do not modify                   
    private javax.swing.JTextField NoTiket;
    private javax.swing.JButton btnHapus;
    private javax.swing.JButton btnProses;
    private javax.swing.JTextField hargaSatuan;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JTextField jumlahBeli;
    private javax.swing.JRadioButton reguler;
    private javax.swing.JTextField totalBayar;
    private javax.swing.JRadioButton ultraXDAtmos;
    // End of variables declaration                 
}

Jumat, 19 Mei 2017

tugas uas pak arya take home

Demikian penjelasan tentang mencari luas tabung dengan c++ ,




maaf jika ada kesalahan pak , mohon dimaklumi :) ,terimakasih !!