Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- * To change this template, choose Tools | Templates
- * and open the template in the editor.
- */
- /*
- * Formkendaraanmasuk.java
- *
- * Created on 13 Mar 17, 15:31:15
- */
- package Aplikasi;
- import javax.swing.*;
- import java.sql.*;
- import java.util.Date;
- import java.text.SimpleDateFormat;
- import javax.swing.table.DefaultTableModel;
- import aplikasi.koneksi;
- /**
- *
- * @author Yahdi
- */
- public class Formkendaraanmasuk extends javax.swing.JFrame {
- String nik;
- String tglmasuk;
- String plat_no;
- String jns;
- String status;
- String id_parkir;
- DefaultTableModel Model;
- Connection koneksi;
- private void Reset(){
- nk.setText("");
- no.setText("");
- platNomor.setText("");
- nk.requestFocus();
- }
- //Tampilan TabelData
- public Formkendaraanmasuk() {
- initComponents();
- Object[] row= {"No Parkir","NIK","Tgl Masuk", "No Plat", "J.Kendaraan", "Status"};
- Model=new DefaultTableModel(null,row);
- tabel.setModel(Model);
- tglskrg();
- tampildataketabel();
- }
- // script untuk membuat action pada tabel sehingga jika di clik pada tabel akan muncul pada text field
- private void Click_Get_Data_Table(){
- int i = this.tabel.getSelectedRow();
- if(i == -1){
- return;
- }
- String id_parkir = (String) Model.getValueAt(i, 0);
- String nik = (String) Model.getValueAt(i, 1);
- String plat_no = (String) Model.getValueAt(i,3);
- String jns = (String) Model.getValueAt(i, 4);
- String tglmasuk = (String) Model.getValueAt(i,2);
- String status = (String) Model.getValueAt(i, 5);
- this.no.setText(id_parkir);
- this.nk.setText(nik);
- this.platNomor.setText(plat_no);
- this.jenis.setSelectedItem(jns);
- this.tftanggal.setText(tglmasuk);
- this.sts.setSelectedItem(status);
- }
- //Tampilan TabelData
- // script untuk membuat action pada tabel sehingga jika di clik pada tabel akan muncul pada text field
- public void tglskrg(){
- Date skrg= new Date();
- SimpleDateFormat format= new SimpleDateFormat("dd-MM-yyyy");
- String tgl = format.format(skrg);
- tftanggal.setText(format.format(skrg));
- }
- //mengkoneksikan ke database
- public void konekdatabase(){
- try{
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- koneksi =DriverManager.getConnection("jdbc:mysql://localhost:3306/datalogin","root","");
- }
- catch (Exception e)
- {
- System.err.println("Exception: "+e.getMessage());
- }
- }
- public void tampildataketabel(){
- Model.getDataVector().removeAllElements();
- Model.fireTableDataChanged();
- try {
- Statement stat= (Statement)DriverManager.getConnection("jdbc:mysql://localhost:3306/datalogin","root","").createStatement();
- String sql = "Select * From parkir_masuk";
- ResultSet res = stat.executeQuery(sql);
- while (res.next()){
- Object[] nilai = new Object[6];
- nilai[0] = res.getString("id_parkir");
- nilai[1] = res.getString("nik");
- nilai[2] = res.getString("tglmasuk");
- nilai[3] = res.getString("noplat");
- nilai[4] = res.getString("jns");
- nilai[5] = res.getString("status");
- Model.addRow(nilai);
- }
- }catch (SQLException ex){
- JOptionPane.showMessageDialog(null, ex.getMessage());
- }
- //Click_Get_Data_Table();
- }
- public void data(){
- id_parkir=no.getText();
- nik=nk.getText();
- tglmasuk=tftanggal.getText();
- plat_no=platNomor.getText();
- jns=(String)jenis.getSelectedItem();
- status=(String) sts.getSelectedItem();
- }
- /** Creates new form Formkendaraanmasuk */
- /** 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">
- private void initComponents() {
- jScrollPane1 = new javax.swing.JScrollPane();
- jTable1 = new javax.swing.JTable();
- jPanel1 = new javax.swing.JPanel();
- formparkir = new javax.swing.JLabel();
- jLabel2 = new javax.swing.JLabel();
- jLabel3 = new javax.swing.JLabel();
- jLabel4 = new javax.swing.JLabel();
- jLabel5 = new javax.swing.JLabel();
- jLabel6 = new javax.swing.JLabel();
- jLabel7 = new javax.swing.JLabel();
- no = new javax.swing.JTextField();
- nk = new javax.swing.JTextField();
- platNomor = new javax.swing.JTextField();
- jenis = new javax.swing.JComboBox();
- tftanggal = new javax.swing.JTextField();
- jButton1 = new javax.swing.JButton();
- jButton2 = new javax.swing.JButton();
- jButton3 = new javax.swing.JButton();
- jButton4 = new javax.swing.JButton();
- jButton5 = new javax.swing.JButton();
- jScrollPane2 = new javax.swing.JScrollPane();
- tabel = new javax.swing.JTable();
- sts = new javax.swing.JComboBox();
- jTable1.setModel(new javax.swing.table.DefaultTableModel(
- new Object [][] {
- {null, null, null, null},
- {null, null, null, null},
- {null, null, null, null},
- {null, null, null, null}
- },
- new String [] {
- "Title 1", "Title 2", "Title 3", "Title 4"
- }
- ));
- jScrollPane1.setViewportView(jTable1);
- setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
- formparkir.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
- formparkir.setText("FORM PARKIR");
- jLabel2.setText("No Parkir");
- jLabel3.setText("NIK");
- jLabel4.setText("No Polisi");
- jLabel5.setText("Jenis Kendaraan");
- jLabel6.setText("Tanggal");
- jLabel7.setText("Status");
- no.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- noActionPerformed(evt);
- }
- });
- platNomor.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- platNomorActionPerformed(evt);
- }
- });
- jenis.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Mobil", "Sepeda Motor" }));
- jenis.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jenisActionPerformed(evt);
- }
- });
- tftanggal.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- tftanggalActionPerformed(evt);
- }
- });
- jButton1.setText("Simpan");
- jButton1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton1ActionPerformed(evt);
- }
- });
- jButton2.setText("Cari");
- jButton2.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton2ActionPerformed(evt);
- }
- });
- jButton3.setText("Ubah");
- jButton3.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton3ActionPerformed(evt);
- }
- });
- jButton4.setText("Hapus");
- jButton4.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton4ActionPerformed(evt);
- }
- });
- jButton5.setText("Reset");
- jButton5.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton5ActionPerformed(evt);
- }
- });
- tabel.setModel(new javax.swing.table.DefaultTableModel(
- new Object [][] {
- {null, null, null, null},
- {null, null, null, null},
- {null, null, null, null},
- {null, null, null, null}
- },
- new String [] {
- "Title 1", "Title 2", "Title 3", "Title 4"
- }
- ));
- tabel.addMouseListener(new java.awt.event.MouseAdapter() {
- public void mouseClicked(java.awt.event.MouseEvent evt) {
- tabelMouseClicked(evt);
- }
- });
- jScrollPane2.setViewportView(tabel);
- sts.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Masuk", "Keluar" }));
- javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
- jPanel1.setLayout(jPanel1Layout);
- jPanel1Layout.setHorizontalGroup(
- jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(jPanel1Layout.createSequentialGroup()
- .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
- .addGroup(jPanel1Layout.createSequentialGroup()
- .addGap(159, 159, 159)
- .addComponent(formparkir))
- .addGroup(jPanel1Layout.createSequentialGroup()
- .addContainerGap()
- .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(jLabel2)
- .addComponent(jLabel3)
- .addComponent(jLabel4)
- .addComponent(jLabel5)
- .addComponent(jLabel6)
- .addComponent(jLabel7))
- .addGap(51, 51, 51)
- .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(no)
- .addComponent(sts, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- .addComponent(tftanggal)
- .addComponent(jenis, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- .addComponent(platNomor)
- .addComponent(nk)))
- .addGroup(jPanel1Layout.createSequentialGroup()
- .addGap(2, 2, 2)
- .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 425, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addGroup(jPanel1Layout.createSequentialGroup()
- .addComponent(jButton1)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addComponent(jButton2, javax.swing.GroupLayout.PREFERRED_SIZE, 63, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addComponent(jButton3, javax.swing.GroupLayout.PREFERRED_SIZE, 64, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addComponent(jButton4, javax.swing.GroupLayout.PREFERRED_SIZE, 73, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addComponent(jButton5, javax.swing.GroupLayout.PREFERRED_SIZE, 63, javax.swing.GroupLayout.PREFERRED_SIZE)))))
- .addContainerGap(79, Short.MAX_VALUE))
- );
- jPanel1Layout.setVerticalGroup(
- jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(jPanel1Layout.createSequentialGroup()
- .addComponent(formparkir)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
- .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
- .addComponent(jLabel2)
- .addComponent(no, 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(nk, 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(jLabel4)
- .addComponent(platNomor, 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(jLabel5)
- .addComponent(jenis, 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(jLabel6, javax.swing.GroupLayout.PREFERRED_SIZE, 14, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addComponent(tftanggal, 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(jLabel7)
- .addComponent(sts, 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(jButton1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- .addComponent(jButton2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- .addComponent(jButton3, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- .addComponent(jButton4, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- .addComponent(jButton5, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 17, Short.MAX_VALUE)
- .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 402, javax.swing.GroupLayout.PREFERRED_SIZE))
- );
- javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
- getContentPane().setLayout(layout);
- layout.setHorizontalGroup(
- layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- );
- layout.setVerticalGroup(
- layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- );
- pack();
- }// </editor-fold>
- private void noActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void platNomorActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void tabelMouseClicked(java.awt.event.MouseEvent evt) {
- // TODO add your handling code here:
- Click_Get_Data_Table();
- }
- private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- Reset();
- }
- private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- try{
- konekdatabase();
- koneksi.createStatement().executeUpdate("insert into parkir_masuk values('"+no.getText()+"','"+nk.getText()+"','"+platNomor.getText()+"',"+"'"+tftanggal.getText()+"','"+jenis.getSelectedItem()+"','"+sts.getSelectedItem()+"')");
- Reset();
- }
- catch(SQLException ex){
- JOptionPane.showMessageDialog(rootPane,"Gagal");
- }
- tampildataketabel();
- }
- private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- if(JOptionPane.showConfirmDialog(null, "Apakah Anda Yakin Ingin DiUbah..?","Warning",2) == JOptionPane.YES_OPTION)
- try{
- konekdatabase();
- String sql = "UPDATE parkir_masuk set noplat='"+platNomor.getText()+"',"+"tglmasuk='"+tftanggal.getText()+"',"+"jns='"+jenis.getSelectedItem()+"',"+"status='"+sts.getSelectedItem()+"'"+"WHERE nik='"+nk.getText()+"'";
- koneksi.createStatement().executeUpdate(sql);
- tampildataketabel();
- Reset();
- JOptionPane.showMessageDialog(null,"Proses Update Berhasil");
- }catch (Exception ex){
- JOptionPane.showMessageDialog(null,"Proses Update Gagal");
- System.out.println(ex.getMessage());
- }
- }
- private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- konekdatabase();
- try
- {
- String cari=nk.getText();
- Statement statement=koneksi.createStatement();
- String sql="select * from parkir_masuk where noplat like '"+cari+"%'";
- ResultSet rs=statement.executeQuery(sql);
- if(rs.next())
- {
- no.setText(rs.getString(1));
- nk.setText(rs.getString(2));
- platNomor.setText(rs.getString(3));
- jenis.setSelectedItem(rs.getString(4));
- tftanggal.setText(rs.getString(5));
- sts.setSelectedItem(rs.getString(6));
- }
- else{
- JOptionPane.showMessageDialog(null, "DATA TIDAK ADA DALAM DATABASE");
- }
- statement.close();
- koneksi.close();
- }
- catch (Exception ex)
- {
- System.out.println("Error: "+ex);
- }
- }
- private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- if(JOptionPane.showConfirmDialog(null, "Apakah Anda Yakin Ingin Hapus..?","Warning",2) == JOptionPane.YES_OPTION)
- try {
- konekdatabase();
- String sql = "DELETE FROM parkir_masuk WHERE id_parkir = '"+no.getText()+"'";
- koneksi.createStatement().executeUpdate(sql);
- tampildataketabel();
- Reset();
- JOptionPane.showMessageDialog(null,"Data Berhasil Di Hapus");
- }catch (Exception ex) {
- JOptionPane.showMessageDialog(null,"Data Gagal Dihapus");
- System.out.println(ex.getMessage());
- }
- }
- private void tftanggalActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void jenisActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- /**
- * @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(Formkendaraanmasuk.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- } catch (InstantiationException ex) {
- java.util.logging.Logger.getLogger(Formkendaraanmasuk.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- } catch (IllegalAccessException ex) {
- java.util.logging.Logger.getLogger(Formkendaraanmasuk.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- } catch (javax.swing.UnsupportedLookAndFeelException ex) {
- java.util.logging.Logger.getLogger(Formkendaraanmasuk.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 Formkendaraanmasuk().setVisible(true);
- }
- });
- }
- // Variables declaration - do not modify
- private javax.swing.JLabel formparkir;
- private javax.swing.JButton jButton1;
- private javax.swing.JButton jButton2;
- private javax.swing.JButton jButton3;
- private javax.swing.JButton jButton4;
- private javax.swing.JButton jButton5;
- private javax.swing.JLabel jLabel2;
- private javax.swing.JLabel jLabel3;
- private javax.swing.JLabel jLabel4;
- private javax.swing.JLabel jLabel5;
- private javax.swing.JLabel jLabel6;
- private javax.swing.JLabel jLabel7;
- private javax.swing.JPanel jPanel1;
- private javax.swing.JScrollPane jScrollPane1;
- private javax.swing.JScrollPane jScrollPane2;
- private javax.swing.JTable jTable1;
- private javax.swing.JComboBox jenis;
- private javax.swing.JTextField nk;
- private javax.swing.JTextField no;
- private javax.swing.JTextField platNomor;
- private javax.swing.JComboBox sts;
- private javax.swing.JTable tabel;
- private javax.swing.JTextField tftanggal;
- // End of variables declaration
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement