/*
* 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 Modul6;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextField;

/**
 *
 * @author User
 */
public class Siswa extends JFrame implements ActionListener {
    private JPanel jpSiswa = new JPanel();
    private JLabel lblNis = new JLabel("Nis:"),lblNama = new JLabel("Nama:"),
            lblPassword = new JLabel("Password:"),lblAlamat = new JLabel("Alamat:"),
            lblEmail = new JLabel("Email:"),lblJenisKelamin = new JLabel("JenisKelamin:");
    private JTextField txtNis = new JTextField(),txtNama = new JTextField(),txtPassword
            = new JTextField(),txtAlamat = new JTextField(),txtEmail = new JTextField();
    private JComboBox cboJenisKelamin = new JComboBox();
    private JButton btnTambah = new JButton("Tambah"),btnUbah = new JButton("Ubah"),
            btnHapus = new JButton("Hapus"),btnBersih = new JButton("Bersih");

    Siswa (){
        super("Entri Data MHS");
        setSize(500,300);
        jpSiswa.setLayout(null);

        //mengatur letak objek pada container
        lblNis.setBounds(15, 20, 100, 25);
        lblNama.setBounds(15, 55, 100, 25);
        lblPassword.setBounds(15, 90, 100, 25);
        lblAlamat.setBounds(15, 125, 100, 25);
        lblEmail.setBounds(15,  160, 100, 25);
        lblJenisKelamin.setBounds(15, 195, 100, 25);

        txtNis.setBounds(115, 20, 100, 25);
        txtNama.setBounds(115, 55, 100, 25);
        txtPassword.setBounds(115, 90, 100, 25);
        txtAlamat.setBounds(115, 125, 150, 25);
        txtEmail.setBounds(115, 160, 100, 25);
        cboJenisKelamin.setBounds(115, 195, 50, 25);

        btnTambah.setBounds(340, 20, 85, 25);
        btnUbah.setBounds(340, 55, 85, 25);
        btnHapus.setBounds(340, 90, 85, 25);
        btnBersih.setBounds(340, 125, 85, 25);

        //mengatur/meletakkan objek pada objek panel
        jpSiswa.add(lblNis);
        jpSiswa.add(lblNama);
        jpSiswa.add(lblPassword);
        jpSiswa.add(lblAlamat);
        jpSiswa.add(lblEmail);
        jpSiswa.add(lblJenisKelamin);
        jpSiswa.add(txtNis);
        jpSiswa.add(txtNama);
        jpSiswa.add(txtPassword);
        jpSiswa.add(txtAlamat);
        jpSiswa.add(txtEmail);
        jpSiswa.add(cboJenisKelamin);

        jpSiswa.add(btnTambah);
        jpSiswa.add(btnUbah);
        jpSiswa.add(btnHapus);
        jpSiswa.add(btnBersih);

        //mengisi combo Jenis kelamin
        cboJenisKelamin.addItem("L");
        cboJenisKelamin.addItem("P");

        //mengatur objek agar dapat berinteraksi dengan user
        btnTambah.addActionListener(this);
        btnUbah.addActionListener(this);
        btnHapus.addActionListener(this);
        btnBersih.addActionListener(this);

        //menambahkan objek JPanel pada container frame
        getContentPane().add(jpSiswa);

        setVisible(true);
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    }
    public void actionPerformed(ActionEvent ae) {
        Object obj = ae.getSource();
        if (obj ==btnTambah){
            Tambah();
        }
        if (obj == btnUbah){
            Ubah();
        }
        if (obj == btnHapus){
            Hapus();
        }
        Bersih();
    }
    void Bersih(){
            txtNis.setText("");
    txtNama.setText("");
    txtPassword.setText("");
    txtAlamat.setText("");
    txtEmail.setText("");
    cboJenisKelamin.setSelectedIndex(0);
    }
    void Tambah(){
            try{
        Koneksi ObjKoneksi = new Koneksi();
        Connection con = ObjKoneksi.bukaKoneksi();
        Statement st = con.createStatement();
        String sql = "INSERT into siswa(nis,nama,password,alamat,email,jeniskelamin) values ('"+txtNis.getText()+"','"+txtNama.getText()
                    +"','"+txtPassword.getText()+"','"+txtAlamat.getText()+"'," +
                    "'"+txtEmail.getText()+"','"+cboJenisKelamin.getSelectedItem()+"')";
            int row = st.executeUpdate(sql);

            if (row ==1){
                JOptionPane.showMessageDialog(null,"Data sudah ditambahkan ke" +
                        " database","infomasi",JOptionPane.INFORMATION_MESSAGE);

               con.close();
                }
    }
    catch(SQLException e){
        JOptionPane.showMessageDialog(null,"Data tidak ditambahkan ke" +
                        " database","infomasi",JOptionPane.INFORMATION_MESSAGE);
    }
    }
    void Ubah(){
        try{
        Koneksi ObjKoneksi = new Koneksi();
        Connection con = ObjKoneksi.bukaKoneksi();
        Statement st = con.createStatement();

        String sql = "UPDATE siswa set nama ='"+txtNama.getText()+"'," +
                    "password ='"+txtPassword.getText()+"',alamat = '"+txtAlamat.getText()
                    +"',email='"+txtEmail.getText()+"',jeniskelamin = '"+cboJenisKelamin.getSelectedItem()+
                    "' where nis = '"+txtNis.getText()+"' ";

         int row = st.executeUpdate(sql);
         if (row ==1){
                JOptionPane.showMessageDialog(null,"Data sudah di update "
                        ,"infomasi",JOptionPane.INFORMATION_MESSAGE);
                 con.close();
                }
    }
    catch(SQLException e){
        JOptionPane.showMessageDialog(null,"Data tidak diUbah","infomasi",JOptionPane.
                INFORMATION_MESSAGE);
    }
    }
    void Hapus(){
        try{
        Koneksi ObjKoneksi = new Koneksi();
        Connection con = ObjKoneksi.bukaKoneksi();
        Statement st = con.createStatement();
        String sql = "DELETE from siswa where nis = '"+txtNis.getText()+"' ";
        int row = st.executeUpdate(sql);
        if (row ==1){
                JOptionPane.showMessageDialog(null,"Data sudah dihapus dari " +
                        " database","infomasi",JOptionPane.INFORMATION_MESSAGE);

                con.close();

                }

    }
        catch(SQLException e){
        JOptionPane.showMessageDialog(null,"Data tidak dihapus","infomasi",JOptionPane.
                INFORMATION_MESSAGE);
    }

}

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        // TODO code application logic here
        new Siswa();
    }

}