Java tutorial
/* * 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 si_piket_smkn3; import java.io.File; import java.io.FileInputStream; import java.sql.Connection; import java.sql.DriverManager; import java.sql.Statement; import java.util.ArrayList; import java.util.Iterator; import java.util.List; import java.util.Vector; import javax.swing.JOptionPane; import org.apache.poi.xssf.usermodel.XSSFCell; import org.apache.poi.xssf.usermodel.XSSFRow; import org.apache.poi.xssf.usermodel.XSSFSheet; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import javax.swing.JFileChooser; /** * * @author tawakida */ public class frm_tambah_guru extends javax.swing.JFrame { /** * Creates new form frm_tambah_guru */ //deklarasi variabel koneksi dbsetting; String driver, database, user, pass; Object tabel; Vector dataholder; String nama_file; String nip, nama, mata_pelajaran; public static int status; public frm_tambah_guru() { initComponents(); dbsetting = new koneksi(); driver = dbsetting.SettingPanel("DBDriver"); database = dbsetting.SettingPanel("DBDatabase"); user = dbsetting.SettingPanel("DBUsername"); pass = dbsetting.SettingPanel("DBPassword"); } public static Vector read(String fileName) { Vector cellVectorHolder = new Vector(); try { FileInputStream myInput = new FileInputStream(fileName); //POIFSFileSystem myFileSystem = new POIFSFileSystem(myInput); XSSFWorkbook myWorkBook = new XSSFWorkbook(myInput); XSSFSheet mySheet = myWorkBook.getSheetAt(0); Iterator rowIter = mySheet.rowIterator(); while (rowIter.hasNext()) { XSSFRow myRow = (XSSFRow) rowIter.next(); Iterator cellIter = myRow.cellIterator(); //Vector cellStoreVector=new Vector(); List list = new ArrayList(); while (cellIter.hasNext()) { XSSFCell myCell = (XSSFCell) cellIter.next(); list.add(myCell); } cellVectorHolder.addElement(list); } } catch (Exception e) { e.printStackTrace(); } return cellVectorHolder; } private void saveToDatabase(Vector dataHolder) { nip = ""; nama = ""; mata_pelajaran = ""; System.out.println(dataHolder); for (Iterator iterator = dataHolder.iterator(); iterator.hasNext();) { List list = (List) iterator.next(); nip = list.get(0).toString(); nama = list.get(1).toString(); mata_pelajaran = list.get(2).toString(); try { Class.forName(driver); Connection kon = DriverManager.getConnection(database, user, pass); Statement stt = kon.createStatement(); String SQL = "insert into guru (id," + "nip," + "nama," + "mata_pelajaran)" + "values" + "( NULL," + " '" + nip + "'," + " '" + nama + "'," + " '" + mata_pelajaran + "')"; stt.executeUpdate(SQL); stt.close(); kon.close(); status = 2; } catch (Exception ex) { status = 3; JOptionPane.showMessageDialog(null, ex.getMessage(), "Error", JOptionPane.INFORMATION_MESSAGE); } } if (status == 2) { JOptionPane.showMessageDialog(null, "Data Siswa Telah Berhasil Diimpor"); } } /** * 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">//GEN-BEGIN:initComponents private void initComponents() { btn_batal = new javax.swing.JButton(); btn_tambah1 = new javax.swing.JButton(); jLabel2 = new javax.swing.JLabel(); jPanel1 = new javax.swing.JPanel(); jLabel1 = new javax.swing.JLabel(); jLabel3 = new javax.swing.JLabel(); jLabel5 = new javax.swing.JLabel(); txt_nip = new javax.swing.JTextField(); txt_nama = new javax.swing.JTextField(); txt_mata_pelajaran = new javax.swing.JTextField(); btn_import_guru = new javax.swing.JButton(); btn_kembali = new javax.swing.JButton(); setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE); setTitle("Tambah Data Guru"); setResizable(false); addWindowListener(new java.awt.event.WindowAdapter() { public void windowClosing(java.awt.event.WindowEvent evt) { formWindowClosing(evt); } }); btn_batal.setText("Batal"); btn_batal.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { btn_batalActionPerformed(evt); } }); btn_tambah1.setText("Tambah"); btn_tambah1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { btn_tambah1ActionPerformed(evt); } }); jLabel2.setFont(new java.awt.Font("Lucida Grande", 1, 14)); // NOI18N jLabel2.setHorizontalAlignment(javax.swing.SwingConstants.CENTER); jLabel2.setText("Tambah Data Guru"); jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder("Isi Data Guru")); jLabel1.setText("NIP"); jLabel3.setText("Nama Lengkap"); jLabel5.setText("Mata Pelajaran"); javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1); jPanel1.setLayout(jPanel1Layout); jPanel1Layout.setHorizontalGroup(jPanel1Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel1Layout.createSequentialGroup().addGap(35, 35, 35) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel3) .addComponent(jLabel1, javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(jLabel5, javax.swing.GroupLayout.Alignment.TRAILING)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addGroup(jPanel1Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(txt_nama, javax.swing.GroupLayout.DEFAULT_SIZE, 189, Short.MAX_VALUE) .addComponent(txt_nip).addComponent(txt_mata_pelajaran)) .addContainerGap(39, Short.MAX_VALUE))); jPanel1Layout.setVerticalGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel1Layout.createSequentialGroup().addGap(9, 9, 9) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel1).addComponent(txt_nip, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel3).addComponent(txt_nama, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel5).addComponent(txt_mata_pelajaran, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))); btn_import_guru.setText("Import Dari Excel"); btn_import_guru.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { btn_import_guruActionPerformed(evt); } }); btn_kembali.setBackground(new java.awt.Color(255, 204, 255)); btn_kembali.setText("Kembali Ke Menu Utama"); btn_kembali.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { btn_kembaliActionPerformed(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().addGap(50, 50, 50).addComponent(btn_tambah1) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(btn_batal, javax.swing.GroupLayout.PREFERRED_SIZE, 73, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(btn_import_guru) .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addContainerGap() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jPanel1, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addComponent(jLabel2, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addGap(0, 0, Short.MAX_VALUE).addComponent(btn_kembali))) .addContainerGap())); layout.setVerticalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup().addGap(5, 5, 5) .addComponent(btn_kembali, javax.swing.GroupLayout.PREFERRED_SIZE, 18, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED).addComponent(jLabel2) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(btn_batal).addComponent(btn_tambah1).addComponent(btn_import_guru)) .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))); pack(); setLocationRelativeTo(null); }// </editor-fold>//GEN-END:initComponents private void btn_batalActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btn_batalActionPerformed // TODO add your handling code here: txt_nama.setText(""); txt_nip.setText(""); txt_mata_pelajaran.setText(""); txt_nip.requestFocusInWindow(); }//GEN-LAST:event_btn_batalActionPerformed private void btn_tambah1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btn_tambah1ActionPerformed // TODO add your handling code here: String data[] = new String[4]; String nip = txt_nip.getText(); if (nip.isEmpty()) { nip = "Kosong"; } if (txt_nama.getText().isEmpty() || txt_mata_pelajaran.getText().isEmpty()) { JOptionPane.showMessageDialog(null, "Data Tidak Boleh Kosong, Silahkan Dilengkapi"); } else { try { Class.forName(driver); Connection kon = DriverManager.getConnection(database, user, pass); Statement stt = kon.createStatement(); String SQL = "insert into guru (id," + "nip," + "nama," + "mata_pelajaran)" + "values" + "( NULL," + " '" + nip + "'," + " '" + txt_nama.getText() + "'," + " '" + txt_mata_pelajaran.getText() + "')"; stt.executeUpdate(SQL); stt.close(); kon.close(); JOptionPane.showMessageDialog(null, "Data Guru Telah Berhasil Ditambah"); /* data[0] = txt_nis.getText(); data[1] = txt_nama.getText(); data[2] = txt_tempat_lahir.getText(); data[3] = txt_tgl_lahir.getText(); tableModel.insertRow(0, data); membersihkan_teks(); btn_simpan.setEnabled(false); nonaktif_teks(); */ } catch (Exception ex) { JOptionPane.showMessageDialog(null, ex.getMessage(), "Error", JOptionPane.INFORMATION_MESSAGE); } } /* frm_utama utama = new frm_utama(); utama.setVisible(true); //menutup frame tambah siswa this.setVisible(false); */ txt_nip.setText(""); txt_nama.setText(""); txt_mata_pelajaran.setText(""); }//GEN-LAST:event_btn_tambah1ActionPerformed private void btn_import_guruActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btn_import_guruActionPerformed // TODO add your handling code here: JFileChooser filechooser = new JFileChooser(); filechooser.showOpenDialog(null); File x_file = filechooser.getSelectedFile(); nama_file = x_file.getAbsolutePath(); dataholder = read(nama_file); saveToDatabase(dataholder); }//GEN-LAST:event_btn_import_guruActionPerformed private void btn_kembaliActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btn_kembaliActionPerformed // TODO add your handling code here: frm_utama utama = new frm_utama(); utama.setVisible(true); this.setVisible(false); }//GEN-LAST:event_btn_kembaliActionPerformed private void formWindowClosing(java.awt.event.WindowEvent evt) {//GEN-FIRST:event_formWindowClosing // TODO add your handling code here: int selectedOption = JOptionPane.showConfirmDialog(null, "Apakah anda yakin ingin Logout dan Keluar ?", "Konfirmasi Logout dan Keluar", JOptionPane.YES_NO_OPTION); if (selectedOption == JOptionPane.YES_OPTION) { System.exit(0); } else { setDefaultCloseOperation(DO_NOTHING_ON_CLOSE); } }//GEN-LAST:event_formWindowClosing /** * @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(frm_tambah_guru.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(frm_tambah_guru.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(frm_tambah_guru.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(frm_tambah_guru.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 frm_tambah_guru().setVisible(true); } }); } // Variables declaration - do not modify//GEN-BEGIN:variables private javax.swing.JButton btn_batal; private javax.swing.JButton btn_import_guru; private javax.swing.JButton btn_kembali; private javax.swing.JButton btn_tambah1; private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel2; private javax.swing.JLabel jLabel3; private javax.swing.JLabel jLabel5; private javax.swing.JPanel jPanel1; private javax.swing.JTextField txt_mata_pelajaran; private javax.swing.JTextField txt_nama; private javax.swing.JTextField txt_nip; // End of variables declaration//GEN-END:variables }