Home Pemograman 2 UTS_MUHAMMAD DIMAS N_181011400883

UTS_MUHAMMAD DIMAS N_181011400883

By
November 05, 2020
Read
Add Comment

 

Tugas Pemograman 2 UTS

Program Pendaftaran Seminar






Nama : Muhammad Dimas N 
Nim : 181011400883 
Kelas : 05TPLP008


1. Jalankan Xampp dan aktifkan MySQL dan Apache 

2. Lalu klik Admin pada MySQL nanti akan masuk ke halaman phpMyAdmin





3. Buat database baru dengan nama database_kontak

4. Buat tabel dengan nama data_seminar dan buat Struktur seperti dibawah ini
    
    - nama varchar(30) Primary key
    - email varchar(30)
    - no_telp varchar(15)
    - alamat varchar(50)
    - jk varchar(15)
    - bayar varchar(15)
    - status varchar(15)


5. Buat tabel dengan nama data_verifikasi dan buat Struktur seperti dibawah ini
    
    - nama varchar(30) Primary key
    - email varchar(30)
    - bayar varchar(15)






6. Buka Netbeans lalu buat project baru dengan nama UTS_MuhammadDimasN_181011400883

7. Buat New Package dengan nama pendaftaran_seminar

8. Buat JFrame Form dengan nama daftar_seminar

9. Selanjutnya buat desain Aplikasi seperti dibawah ini, dengan ketentuan :

    (8 jLabel, 4 jTextField, 1 jComboBox, 7 jButton, 2 Table dan 6 jCheckBox)


    Variable Name :
  •      TextField 1 = nama_m_dimas
  •      TextField 2 = email_m_dimas
  •      TextField 3 = no_telp_m_dimas
  •      TextField 4 = alamat_m_dimas
  •      ComboBox = statusComboBox_m_dimas
  •      CheckBox 1 = laki_m_dimas
  •      CheckBox 2 = perempuan_m_dimas
  •      CheckBox 3 = bca_m_dimas
  •      CheckBox 4 = bri_m_dimas
  •      CheckBox 5 = mandiri_m_dimas
  •      CheckBox 6 = uang_tunai_m_dimas
  •      Button 1 = simpan_m_dimas 
  •      Button 2 = search_m_dimas
  •      Button 3 = clear_m_dimas
  •      Button 4 = hapus_m_dimas
  •      Button 5 = edit_m_dimas
  •      Button 6 = lihat_m_dimas
  •      Button 7 = refresh_m_dimas





10. Klik kanan pada ComboBox - Properties, lalu samakan model dan selectedIndex nya





11. Klik tab Source lalu tambahkan source pada package dan public




12. Jika muncul tanda seru berwarna merah, Kalian bisa klik tanda seru nya lalu Add Import - Pilih paling atas

13. Tambahkan source code berikut 

14. Buat private void koneksi(), kosongkan(), dan status()

private void koneksi(){
    try{
        Class.forName("com.mysql.jdbc.Driver");
        con = DriverManager.getConnection("jdbc:mysql://127.0.0.1/database_kontak", "root", "");
        stat = (Statement) con.createStatement();
    }catch (Exception e){
        JOptionPane.showMessageDialog(null, e);
        }
    }
   
    private void kosongkan(){
        nama_m_dimas.setText("");
        email_m_dimas.setText("");
        no_telp_m_dimas.setText("");
        alamat_m_dimas.setText("");
        nama_m_dimas.requestFocus();
        statusComboBox_m_dimas.setSelectedIndex(-1);
    }
    
    private void status(){
   
        statusComboBox_m_dimas.setSelectedIndex(-1);
    }




15 Buat private void tabel() dan tabel2()

private void tabel(){

    DefaultTableModel t= new DefaultTableModel();

    t.addColumn("Nama");

    t.addColumn("Email");

    t.addColumn("No telp");

    t.addColumn("Status");

    t.addColumn("Alamat");

    t.addColumn("JKelamin");

    t.addColumn("Pembayaran");

    Table_m_dimas.setModel(t); try{ res=stat.executeQuery("select * from data_seminar");

    while (res.next()){

        t.addRow(new Object[] { res.getString("nama"),

         res.getString("email"),

         res.getString("no_telp"),

         res.getString("status"),

         res.getString("alamat"),

         res.getString("jk"),

         res.getString("bayar")

        });

        

    }

    } catch (Exception e){

        JOptionPane.showMessageDialog(rootPane, e);

    }

    }

    

    private void tabel2(){

    DefaultTableModel t= new DefaultTableModel();

    t.addColumn("Nama");

    t.addColumn("Email");

    t.addColumn("Pembayaran");

    Table2_m_dimas.setModel(t); try{ res=stat.executeQuery("select * from data_seminar");

    while (res.next()){

        t.addRow(new Object[] { res.getString("nama"),

         res.getString("email"),

         res.getString("bayar")

        });

        

    }

    } catch (Exception e){

        JOptionPane.showMessageDialog(rootPane, e);

    }

    }



 


16. Tambahkan actionPerformed pada TextField 1 / nama_m_dimas

try{

            res=stat.executeQuery("Select  * from data_seminar where "+ "nama='" +nama_m_dimas.getText()

                +"'" ); while (res.next())

            { nama_m_dimas.setText(res.getString("nama"));

                email_m_dimas.setText(res.getString("email"));

                no_telp_m_dimas.setText(res.getString("no_kontak"));

                statusComboBox_m_dimas.setSelectedItem(res.getString("status"));

                laki_m_dimas.setText(res.getString("jk"));

                perempuan_m_dimas.setText(res.getString("jk"));

                bca_m_dimas.setText(res.getString("bayar"));

                bri_m_dimas.setText(res.getString("bayar"));

                mandiri_m_dimas.setText(res.getString("bayar"));

                uang_tunai_m_dimas.setText(res.getString("bayar"));

                alamat_m_dimas.setText(res.getString("alamat"));

            }

        } catch (Exception e){

            JOptionPane.showMessageDialog(rootPane, e);

        }

 


17. Lalu isikan perintah dibawah ini untuk Button Simpan 

18. Dengan cara actionPerformed, Klik kanan - Events - action - actionPerformed

try{

            stat.executeUpdate("insert into data_seminar values ("

                +"'" + nama_m_dimas.getText()+"',"

                +"'" + email_m_dimas.getText()+"',"

                +"'" + no_telp_m_dimas.getText()+"',"

                +"'" + alamat_m_dimas.getText()+"',"

                +"'" + jk+"',"

                +"'" + bayar+"',"

                +"'" + statusComboBox_m_dimas.getSelectedItem()+ "')");

            kosongkan();

            JOptionPane.showMessageDialog(null, "Berhasil Menyimpan Data");

        } catch (Exception e){

            JOptionPane.showMessageDialog(null, "Perintah Salah : "+e);

        }


19. Tambahkan juga actionPerformed untuk Button Search, Lihat, Edit data, Refresh, Clear, dan Hapus



try {

            res=stat.executeQuery("select * from data_seminar where "+ "nama='" +nama_m_dimas.getText()

            +"'" ); while (res.next())

            { nama_m_dimas.setText(res.getString("nama"));

            email_m_dimas.setText(res.getString("email"));

            no_telp_m_dimas.setText(res.getString("no_telp"));

            alamat_m_dimas.setText(res.getString("alamat"));

            statusComboBox_m_dimas.setSelectedItem(res.getString("status"));

            }

            }

            catch (Exception e) {

            JOptionPane.showMessageDialog(rootPane, e);

            }



try{

        Object [] rows={"Nama","Email","No telp","Status","Alamat","JKelamin","Pembayaran"};

        dtm=new DefaultTableModel(null,rows);

        Table_m_dimas.setModel(dtm);

        Table_m_dimas.setBorder(null);

        jScrollPane1.setVisible(true);

        jScrollPane1.setViewportView(Table_m_dimas);

        int no = 1;

        String nama="",email="",no_telp="",status="",alamat="",jk="",bayar="";

        try{

        String sql="select * from data_seminar";

        Statement st=con.createStatement();

        ResultSet rs=st.executeQuery(sql);

        while(rs.next()){

        nama=rs.getString("nama");

        email=rs.getString("email");

        no_telp=rs.getString("no_telp");

        status=rs.getString("status");

        alamat=rs.getString("alamat");

        jk=rs.getString("jk");

        bayar=rs.getString("bayar");

        String [] tampil={""+nama,email,no_telp,status,alamat,jk,bayar};

        dtm.addRow(tampil);

        }

        }catch(SQLException e){

        e.printStackTrace();

        JOptionPane.showMessageDialog(null,"Query Salah "+e);

        }

        }catch(Exception e){

        e.printStackTrace();

        }



 


int ok=JOptionPane.showConfirmDialog(null,"Apakah Yakin Untuk Update Record ini???","Confirmation",JOptionPane.YES_NO_OPTION);
        try
        {
        String sql="update data_seminar set nama=?,email=?,no_telp=?,status=?,alamat=? where "
                + "nama='"+nama_m_dimas.getText()+"'";
        PreparedStatement st=con.prepareStatement(sql);
        if(ok==0)
        {
        try
        {
        st.setString(1,nama_m_dimas.getText());
        st.setString(2,email_m_dimas.getText());
        st.setString(3,no_telp_m_dimas.getText());
        st.setString(5,alamat_m_dimas.getText());
        st.setString(4, (String) statusComboBox_m_dimas.getSelectedItem());
        st.executeUpdate();
        JOptionPane.showMessageDialog(null,"Update Data Sukses");
        }catch (Exception e)
        {
        JOptionPane.showMessageDialog(null, "Update Data Gagal");
        }
        }
        }catch (Exception e){}



DefaultTableModel model = (DefaultTableModel) Table_m_dimas.getModel();Table2_m_dimas.getModel();
        model.setRowCount(0);
        tabel();
        tabel2();



        nama_m_dimas.setText("");
        email_m_dimas.setText("");
        no_telp_m_dimas.setText("");
        alamat_m_dimas.setText("");
        statusComboBox_m_dimas.setSelectedItem(-1);





int ok=JOptionPane.showConfirmDialog(null,"Apakah Yakin Mendelete record ini???",
            "Confirmation",JOptionPane.YES_NO_CANCEL_OPTION);
        if (ok==0)
        {
            try
            {
                String sql="delete from data_seminar where nama='"+nama_m_dimas.getText()+"'";
                PreparedStatement st=con.prepareStatement(sql);
                st.executeUpdate();
                JOptionPane.showMessageDialog(null, "Delete Data Sukses");
            }
            catch (Exception e)
            {
                JOptionPane.showMessageDialog(null, "Delete Data Gagal");
            }
        }



20. Dan tambahkan fitur click Table ke Textfield

21. Klik kanan pada table - Events - Mouse - mouseClicked


int i = Table_m_dimas.getSelectedRow();

        if(i==-1){


            return;

        }

        String code = (String)Table_m_dimas.getValueAt(i,0);

        String code1 = (String)Table_m_dimas.getValueAt(i,1);

        String code2 = (String)Table_m_dimas.getValueAt(i,2);

        String code3 = (String)Table_m_dimas.getValueAt(i,3);

        String code4 = (String)Table_m_dimas.getValueAt(i,4);

        nama_m_dimas.setText(code);

        email_m_dimas.setText(code1);

        no_telp_m_dimas.setText(code2);

        alamat_m_dimas.setText(code4);

        statusComboBox_m_dimas.setSelectedItem(code3);


    }

22. Masukan action performed lagi untuk Checkbox laki, perempuan, bca, bri, mandiri dan uang tunai









23. Import MySQL Connector pada Libraries


24. Klik kanan pada Libraries - Add Library - pilih MySQL JDBC Driver





25. Lalu Run file tersebut

26. Nanti akan muncul tampilan seperti ini








27. Data juga langsung tersimpan kedalam database

28. selesai


 

Tags :

Tidak ada komentar:

Langganan: Posting Komentar ( Atom )
Diberdayakan oleh Blogger.

Created By Themexpose · Powered by Blogger
jgn lupa follow ig @dimsngrho