package sim;

import java.sql.*;
import java.sql.Date.*;
import java.util.Calendar.*;
import javax.swing.JOptionPane;
public class Data_Mapel extends javax.swing.JFrame {
Connection con;
ResultSet Rsmapel;
Statement stm;
Boolean edit = false;

public Data_Mapel() {
initComponents();
opendb();
kosong();
setTeks(false);
settombol(true);
jbtcari.setEnabled(false);
}

private void opendb()
{
try {
koneksi kon = new koneksi("sim_sd");
con= kon.getConnection();
System.out.println("Berhasil. . .");
}catch (Exception e){
System.out.println("Koneksi Gagal. . ."+e);
}
}

private void kosong(){
txt_kdmapel.setText("");
txt_nmmapel.setText("");

}

private void setTeks(boolean t){
txt_kdmapel.setEditable(t);
txt_nmmapel.setEditable(t);

}

private void settombol(boolean t)
{

jbtadd.setEnabled(t);
jbtsave.setEnabled(!t);
jbtdelete.setEnabled(!t);
jbtcancel.setEnabled(!t);
jbtexit.setEnabled(t);
}

private void cari(){
opendb();
try {
String cari = txt_kdmapel.getText();
try (Statement statement = con.createStatement()) {
String sql1 = "select * from mapel where kd_mapel like '"+cari+"'";
ResultSet rs = statement.executeQuery(sql1);
if(rs.next()){
txt_kdmapel.setText(rs.getString(1));
txt_nmmapel.setText(rs.getString(2));
} else {
JOptionPane.showMessageDialog(null, "DATA TIDAK ADA");
}
}
con.close();
} catch (SQLException e) {
System.out.println("Error."+e);
}
}

@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {

jButton1 = new javax.swing.JButton();
panel2 = new java.awt.Panel();
label1 = new java.awt.Label();
panel3 = new java.awt.Panel();
jbtadd = new javax.swing.JButton();
jbtsave = new javax.swing.JButton();
jbtdelete = new javax.swing.JButton();
jbtcancel = new javax.swing.JButton();
jbtexit = new javax.swing.JButton();
panel5 = new java.awt.Panel();
txt_kdmapel = new javax.swing.JTextField();
txt_nmmapel = new javax.swing.JTextField();
jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
jbtcari = new javax.swing.JButton();

jButton1.setText("jButton1");

setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

label1.setFont(new java.awt.Font("Times New Roman", 1, 24)); // NOI18N
label1.setText("DAFTAR MATA PELAJARAN");

javax.swing.GroupLayout panel2Layout = new javax.swing.GroupLayout(panel2);
panel2.setLayout(panel2Layout);
panel2Layout.setHorizontalGroup(
panel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(panel2Layout.createSequentialGroup()
.addContainerGap()
.addComponent(label1, javax.swing.GroupLayout.PREFERRED_SIZE, 445, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
panel2Layout.setVerticalGroup(
panel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(panel2Layout.createSequentialGroup()
.addContainerGap()
.addComponent(label1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addContainerGap())
);

jbtadd.setText("ADD");
jbtadd.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
add(evt);
}
});

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

jbtdelete.setText("DELETE");
jbtdelete.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
delete(evt);
}
});

jbtcancel.setText("CANCEL");
jbtcancel.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
cancel(evt);
}
});

jbtexit.setText("EXIT");
jbtexit.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
exit(evt);
}
});

javax.swing.GroupLayout panel3Layout = new javax.swing.GroupLayout(panel3);
panel3.setLayout(panel3Layout);
panel3Layout.setHorizontalGroup(
panel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(panel3Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jbtadd, javax.swing.GroupLayout.PREFERRED_SIZE, 70, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jbtsave, javax.swing.GroupLayout.PREFERRED_SIZE, 70, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jbtdelete, javax.swing.GroupLayout.PREFERRED_SIZE, 86, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jbtcancel)
.addGap(18, 18, 18)
.addComponent(jbtexit, javax.swing.GroupLayout.PREFERRED_SIZE, 75, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
panel3Layout.setVerticalGroup(
panel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, panel3Layout.createSequentialGroup()
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addGroup(panel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jbtadd)
.addComponent(jbtdelete)
.addComponent(jbtcancel)
.addComponent(jbtexit)
.addComponent(jbtsave, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addContainerGap())
);

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

jLabel1.setText("Kode");

jLabel2.setText("Nama Mata Pelajaran");

jbtcari.setText("CARI");
jbtcari.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
jbtcariMouseClicked(evt);
}
});

javax.swing.GroupLayout panel5Layout = new javax.swing.GroupLayout(panel5);
panel5.setLayout(panel5Layout);
panel5Layout.setHorizontalGroup(
panel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(panel5Layout.createSequentialGroup()
.addContainerGap()
.addGroup(panel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
.addComponent(jLabel2, javax.swing.GroupLayout.DEFAULT_SIZE, 104, Short.MAX_VALUE)
.addComponent(jLabel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGap(18, 18, 18)
.addGroup(panel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(txt_nmmapel, javax.swing.GroupLayout.PREFERRED_SIZE, 227, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(panel5Layout.createSequentialGroup()
.addComponent(txt_kdmapel, javax.swing.GroupLayout.PREFERRED_SIZE, 120, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jbtcari)))
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
panel5Layout.setVerticalGroup(
panel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(panel5Layout.createSequentialGroup()
.addContainerGap()
.addGroup(panel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(txt_kdmapel, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel1)
.addComponent(jbtcari))
.addGap(13, 13, 13)
.addGroup(panel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(txt_nmmapel, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel2))
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);

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.TRAILING, false)
.addComponent(panel5, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(panel3, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(panel2, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE))
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(15, 15, 15)
.addComponent(panel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(15, 15, 15)
.addComponent(panel5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(15, 15, 15)
.addComponent(panel3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(15, Short.MAX_VALUE))
);

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

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

private void add(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
kosong();
setTeks(true);
settombol(false);
jbtcari.setEnabled(true);
}

private void save(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
//simpan_db();
String tkdmapel = txt_kdmapel.getText();
String tnmmapel = txt_nmmapel.getText();

try{
if(edit==true)
{
stm.executeUpdate("update mapel set nm_mapel='"+tnmmapel+"' where kd_mapel='"+tkdmapel+"'");
}
else
{
stm.executeUpdate("INSERT into mapel VALUES('"+tkdmapel+"','"+tnmmapel+"')");
}

}
catch(Exception e) {
JOptionPane.showMessageDialog(null, e);
}

kosong();
}

private void delete(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try{
String sql="delete from mapel where kd_mapel='"+txt_kdmapel.getText()+"'";
stm.executeUpdate(sql);
}
catch(Exception e){
JOptionPane.showMessageDialog(null, e);
}
}

private void cancel(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
kosong();
setTeks(false);
settombol(true);
jbtcari.setEnabled(false);
}

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

private void jbtcariMouseClicked(java.awt.event.MouseEvent evt) {
// TODO add your handling code here:
cari();
}

/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new Data_Mapel().setVisible(true);
}
});
}