package database.mahasiswa;



import java.awt.BorderLayout;

import java.awt.EventQueue;



import javax.swing.JFrame;

import javax.swing.JPanel;

import javax.swing.border.EmptyBorder;

import javax.swing.JLabel;

import javax.swing.JTextField;

import java.awt.Font;

import javax.swing.JComboBox;

import javax.swing.JTextArea;

import java.awt.Color;



import javax.swing.JOptionPane;

import javax.swing.JScrollPane;

import javax.swing.JTabbedPane;

import javax.swing.JTable;

import javax.swing.UIManager;

import javax.swing.table.DefaultTableModel;

import javax.swing.JButton;

import java.awt.SystemColor;

import java.awt.event.ActionListener;

import java.awt.event.ActionEvent;

import java.sql.*;

import javax.swing.DefaultComboBoxModel;

import java.awt.event.MouseAdapter;

import java.awt.event.MouseEvent;



public class MenuMahasiswa extends JFrame {



 private JPanel contentPane;

 private JTextField textField;

 private JTextField textField_1;

 private JTable table;

 private JComboBox cbJurusan;

 private JTextArea textArea;

 String header[] = {"NIM","Nama","Jurusan","Alamat"};

 DefaultTableModel tabelModel;



 /**

 * Launch the application.

 */

 public static void main(String[] args) {

 EventQueue.invokeLater(new Runnable() {

 public void run() {

 try {

 UIManager.setLookAndFeel("com.sun.java.swing.plaf.nimbus.NimbusLookAndFeel");

 MenuMahasiswa frame = new MenuMahasiswa();

 frame.setVisible(true);

 frame.setLocationRelativeTo(null);

 } catch (Exception e) {

 e.printStackTrace();

 }

 }

 });

 }



 /**

 * Create the frame.

 */

 public MenuMahasiswa() {

 setResizable(false);

 setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

 setBounds(100, 100, 549, 444);

 contentPane = new JPanel();

 contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));

 setContentPane(contentPane);

 contentPane.setLayout(null);

 

 JLabel lblNim = new JLabel("Nim :");

 lblNim.setFont(new Font("Arial Black", Font.PLAIN, 11));

 lblNim.setBounds(10, 28, 60, 14);

 contentPane.add(lblNim);

 

 JLabel lblNama = new JLabel("Nama :");

 lblNama.setFont(new Font("Arial Black", Font.PLAIN, 11));

 lblNama.setBounds(10, 53, 80, 14);

 contentPane.add(lblNama);

 

 JLabel lblJurusan = new JLabel("Jurusan :");

 lblJurusan.setFont(new Font("Arial Black", Font.PLAIN, 11));

 lblJurusan.setBounds(10, 78, 60, 14);

 contentPane.add(lblJurusan);

 

 JLabel lblAlamat = new JLabel("Alamat :");

 lblAlamat.setFont(new Font("Arial Black", Font.PLAIN, 11));

 lblAlamat.setBounds(10, 103, 60, 14);

 contentPane.add(lblAlamat);

 

 textField = new JTextField();

 textField.setBounds(95, 19, 272, 23);

 contentPane.add(textField);

 textField.setColumns(10);

 

 textField_1 = new JTextField();

 textField_1.setBounds(95, 47, 272, 23);

 contentPane.add(textField_1);

 textField_1.setColumns(10);

 

 final JComboBox cbJurusan = new JComboBox();

 cbJurusan.setModel(new DefaultComboBoxModel(new String[] {"TI", "SI","Ekonomi"}));

 cbJurusan.setFont(new Font("Arial Black", Font.PLAIN, 11));

 cbJurusan.setBackground(SystemColor.text);

 cbJurusan.setBounds(95, 78, 73, 20);

 contentPane.add(cbJurusan);

 

 final JTextArea textArea = new JTextArea();

 textArea.setBounds(95, 114, 272, 115);

 contentPane.add(textArea);

 

 JScrollPane scrollPane = new JScrollPane();

 scrollPane.setBounds(95, 240, 272, 77);

 contentPane.add(scrollPane);

 

 tabelModel = new DefaultTableModel(null,header);

 table = new JTable(tabelModel);

 table.addMouseListener(new MouseAdapter() {

 @Override

 public void mouseClicked(MouseEvent arg0) {

 getData();

 }

 });

 scrollPane.setViewportView(table);

 

 JButton btnSimpan = new JButton("Simpan");

 btnSimpan.addActionListener(new ActionListener() {

 public void actionPerformed(ActionEvent arg0) {

 String jurusan = "";

 if(cbJurusan.getSelectedIndex() == 0){

 jurusan = "TI";

 } else if(cbJurusan.getSelectedIndex() == 1){

 jurusan = "SI";

 } else if(cbJurusan.getSelectedIndex() == 2){

 jurusan = "Ekonomi";

 }

 try{

 Connection konek = Koneksi.getKoneksi();

 String query = "INSERT INTO mahasiswa VALUES(?,?,?,?)";

 PreparedStatement prepare = konek.prepareStatement(query);

 prepare.setInt(1,Integer.parseInt(textField.getText()));

 prepare.setString(2, textField_1.getText());

 prepare.setString(3, jurusan);

 prepare.setString(4, textArea.getText());

 prepare.executeUpdate();

 JOptionPane.showMessageDialog(null,"Data berhasil ditambahkan ke database");

 } catch(Exception ex)

 {

 JOptionPane.showMessageDialog(null,"Data gagal ditambahkan ke database");

 System.out.print(ex);

 }

 finally

 { getDataTable();

 }

 

 }

 });

 btnSimpan.setBounds(95, 328, 89, 23);

 contentPane.add(btnSimpan);

 

 JButton btnUpdate = new JButton("Update");

 btnUpdate.addActionListener(new ActionListener() {

 public void actionPerformed(ActionEvent arg0) {

 String jurusan = "";

 if(cbJurusan.getSelectedIndex() == 0)

 {

 jurusan = "TI";

 } else if(cbJurusan.getSelectedIndex() == 1)

 {

 jurusan = "SI";

 } else if(cbJurusan.getSelectedIndex() == 2)

 {

 jurusan = "Ekonomi";

 } try

 {

 Connection konek = Koneksi.getKoneksi();

 String query = "UPDATE mahasiswa SET Nama = ?,Jurusan = ?, Alamat = ? WHERE NIM = ?";

 PreparedStatement prepare =

 konek.prepareStatement(query);

 prepare.setString(1, textField_1.getText());

 prepare.setString(2, jurusan);

 prepare.setString(3, textArea.getText());

 prepare.setInt(4,Integer.parseInt(textField.getText()));

 prepare.executeUpdate();

 JOptionPane.showMessageDialog(null,"Data berhasil diupdate");

 prepare.close();

 } catch(Exception ex)

 {

 JOptionPane.showMessageDialog(null,"Data gagal diupdate");

 System.out.println(ex);

 }

 finally

 { getDataTable();

 }

 }

 });

 btnUpdate.setBounds(192, 328, 89, 23);

 contentPane.add(btnUpdate);

 

 JButton btnNewButton = new JButton("Hapus");

 btnNewButton.addActionListener(new ActionListener() {

 public void actionPerformed(ActionEvent arg0) {

 try

 { Connection konek =

 Koneksi.getKoneksi();

 String query = "DELETE FROM mahasiswa WHERE NIM = ?";

 PreparedStatement prepare = konek.prepareStatement(query);

 prepare.setInt(1,Integer.parseInt(textField.getText()));

 prepare.executeUpdate();

 JOptionPane.showMessageDialog(null,"Data berhasil dihapus");

 prepare.close();

 } catch(Exception ex)

 {

 JOptionPane.showMessageDialog(null,"Data gagal dihapus");

 System.out.println(ex);

 } finally

 {

 getDataTable();

 }

 }

 });

 btnNewButton.setBounds(291, 328, 89, 23);

 contentPane.add(btnNewButton);

 getDataTable();

 

 }

 

 

 public void getDataTable(){

 tabelModel.getDataVector().removeAllElements();

 tabelModel.fireTableDataChanged();

 try{

 Connection konek = Koneksi.getKoneksi();

 Statement state = konek.createStatement();

 String query = "SELECT * FROM mahasiswa";

 ResultSet rs = state.executeQuery(query);

 while(rs.next()){

 Object obj[] = new Object[4];

 obj[0] = rs.getInt(1);

 obj[1] = rs.getString(2);

 obj[2] = rs.getString(3);

 obj[3] = rs.getString(4);

 tabelModel.addRow(obj);

 } rs.close();

 state.close();

 } catch(Exception ex){

 }

 }

 

 

 public void getData(){

 int pilih = table.getSelectedRow();

 if(pilih == -1){

 return;

 }

 int nim = (int) tabelModel.getValueAt(pilih, 0);

 textField.setText("" + nim);

 String nama = (String) tabelModel.getValueAt(pilih, 1);

 textField_1.setText(nama);

 String jurusan = (String) tabelModel.getValueAt(pilih, 2);

 cbJurusan.setSelectedItem("TI");

 String alamat = (String) tabelModel.getValueAt(pilih, 3);

 textArea.setText("test");

 }

}