API tools faq
paste
Advertisement
Guest User

CRUD nilai

a guest
Jun 18th, 2018
91
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 18.06 KB | None | 0 0
raw download clone embed print report
  1. /*
  2.  * To change this license header, choose License Headers in Project Properties.
  3.  * To change this template file, choose Tools | Templates
  4.  * and open the template in the editor.
  5.  */
  6. package CRUD;
  7. import java.sql.Connection;
  8. import java.sql.DriverManager;
  9. import java.sql.ResultSet;
  10. import java.sql.Statement;
  11. import java.util.ArrayList;
  12. import javax.swing.JOptionPane;
  13. import javax.swing.table.DefaultTableModel;
  14. import javax.swing.table.TableModel;
  15. /**
  16.  *
  17.  * @author Jack
  18.  */
  19. public class spp extends javax.swing.JFrame {
  20.  
  21.     /**
  22.      * Creates new form spp
  23.      */
  24.     public spp() {
  25.         initComponents();
  26.         Show_Users_In_JTable();
  27.     }
  28.     public Connection getConnection()
  29.     {
  30.         Connection con;
  31.         try{
  32.             con = DriverManager.getConnection("jdbc:mysql://localhost/akademik", "praktikum7", "admin123");
  33.             return con;
  34.         }
  35.         catch (Exception e) {
  36.             e.printStackTrace();
  37.             return null;
  38.         }
  39.     }
  40.     public ArrayList<admin3> getUsersList()
  41.    {
  42.        ArrayList<admin3> usersList = new ArrayList<admin3>();
  43.        Connection connection = getConnection();
  44.        
  45.        String query ="select * from spp";
  46.        Statement st;
  47.        ResultSet rs;
  48.        
  49.        try {
  50.            st = connection.createStatement();
  51.            rs = st.executeQuery(query);
  52.  
  53.            admin3 user;
  54.  
  55.            while(rs.next())
  56.            {
  57. user = new admin3(rs.getString("nomor_transaksi"),rs.getString("tanggal_bayar"),rs.getString("nim"),rs.getString("kelas"),rs.getString("bulan"),rs.getString("semester"),rs.getString("jumlah_bayar"));
  58.                usersList.add(user);
  59.            }
  60.  
  61.        }
  62.       catch (Exception e) {
  63.            e.printStackTrace();
  64.        }
  65.        return usersList;
  66.    }
  67.    
  68.     //Show data to table
  69.    
  70.     public void Show_Users_In_JTable()
  71.    {
  72.        ArrayList<admin3> list = getUsersList();
  73.        DefaultTableModel model = (DefaultTableModel)jTable_Display_Users.getModel();
  74.        Object[] row = new Object[7];
  75.        for(int i = 0; i < list.size(); i++)
  76.        {
  77.            row[0] = list.get(i).getNomor();
  78.            row[1] = list.get(i).getTanggal();
  79.            row[2] = list.get(i).getNIM();
  80.            row[3] = list.get(i).getKelas();
  81.            row[4] = list.get(i).getBulan();
  82.            row[5] = list.get(i).getSemester();
  83.            row[6] = list.get(i).getJumlah();
  84.                              
  85.            model.addRow(row);
  86.        }
  87.     }
  88.    
  89.     //Exequte SQL query
  90.    
  91.     public void executeSQlQuery(String query, String message)
  92.    {
  93.        Connection con = getConnection();
  94.        Statement st;
  95.        try{
  96.            st = con.createStatement();
  97.            if((st.executeUpdate(query)) == 1)
  98.            {
  99.                // refresh jtable data
  100.                DefaultTableModel model = (DefaultTableModel)jTable_Display_Users.getModel();
  101.                model.setRowCount(0);
  102.                Show_Users_In_JTable();
  103.                
  104.                JOptionPane.showMessageDialog(null, "Data Telah di"+message+"");
  105.            }else{
  106.                JOptionPane.showMessageDialog(null, "Data Gagal "+message);
  107.            }
  108.        }catch(Exception ex){
  109.            ex.printStackTrace();
  110.        }
  111.    }
  112.  
  113.     /**
  114.      * This method is called from within the constructor to initialize the form.
  115.      * WARNING: Do NOT modify this code. The content of this method is always
  116.      * regenerated by the Form Editor.
  117.      */
  118.     @SuppressWarnings("unchecked")
  119.     // <editor-fold defaultstate="collapsed" desc="Generated Code">                          
  120.     private void initComponents() {
  121.  
  122.         jLabel1 = new javax.swing.JLabel();
  123.         jLabel2 = new javax.swing.JLabel();
  124.         jLabel3 = new javax.swing.JLabel();
  125.         jLabel4 = new javax.swing.JLabel();
  126.         jLabel5 = new javax.swing.JLabel();
  127.         jLabel6 = new javax.swing.JLabel();
  128.         jLabel7 = new javax.swing.JLabel();
  129.         jLabel8 = new javax.swing.JLabel();
  130.         jNomor = new javax.swing.JTextField();
  131.         jTanggal = new javax.swing.JTextField();
  132.         jNIM = new javax.swing.JTextField();
  133.         jKelas = new javax.swing.JTextField();
  134.         jBulan = new javax.swing.JTextField();
  135.         jSemester = new javax.swing.JTextField();
  136.         jJumlah = new javax.swing.JTextField();
  137.         jScrollPane1 = new javax.swing.JScrollPane();
  138.         jTable_Display_Users = new javax.swing.JTable();
  139.         jSave = new javax.swing.JButton();
  140.         jUpdate = new javax.swing.JButton();
  141.         jDelete = new javax.swing.JButton();
  142.         jReset = new javax.swing.JButton();
  143.  
  144.         setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  145.  
  146.         jLabel1.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  147.         jLabel1.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
  148.         jLabel1.setText("Pembayaran SPP");
  149.  
  150.         jLabel2.setText("Nomor Transaksi");
  151.  
  152.         jLabel3.setText("Tanggal Bayar");
  153.  
  154.         jLabel4.setText("NIM");
  155.  
  156.         jLabel5.setText("Kelas");
  157.  
  158.         jLabel6.setText("Bulan");
  159.  
  160.         jLabel7.setText("Semester");
  161.  
  162.         jLabel8.setText("Jumlah Bayar");
  163.  
  164.         jTable_Display_Users.setModel(new javax.swing.table.DefaultTableModel(
  165.             new Object [][] {
  166.  
  167.             },
  168.             new String [] {
  169.                 "No Transaksi", "Tanggal Bayar", "NIM", "Kelas", "Bulan", "Semester", "Jumlah Bayar"
  170.             }
  171.         ));
  172.         jTable_Display_Users.addMouseListener(new java.awt.event.MouseAdapter() {
  173.             public void mouseClicked(java.awt.event.MouseEvent evt) {
  174.                 jTable_Display_UsersMouseClicked(evt);
  175.             }
  176.         });
  177.         jScrollPane1.setViewportView(jTable_Display_Users);
  178.  
  179.         jSave.setText("Save");
  180.         jSave.addActionListener(new java.awt.event.ActionListener() {
  181.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  182.                 jSaveActionPerformed(evt);
  183.             }
  184.         });
  185.  
  186.         jUpdate.setText("Update");
  187.         jUpdate.addActionListener(new java.awt.event.ActionListener() {
  188.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  189.                 jUpdateActionPerformed(evt);
  190.             }
  191.         });
  192.  
  193.         jDelete.setText("Delete");
  194.         jDelete.addActionListener(new java.awt.event.ActionListener() {
  195.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  196.                 jDeleteActionPerformed(evt);
  197.             }
  198.         });
  199.  
  200.         jReset.setText("Reset");
  201.  
  202.         javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  203.         getContentPane().setLayout(layout);
  204.         layout.setHorizontalGroup(
  205.             layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  206.             .addGroup(layout.createSequentialGroup()
  207.                 .addContainerGap()
  208.                 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  209.                     .addComponent(jLabel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  210.                     .addGroup(layout.createSequentialGroup()
  211.                         .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  212.                             .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
  213.                                 .addComponent(jLabel7, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  214.                                 .addComponent(jLabel6, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  215.                                 .addComponent(jLabel5, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  216.                                 .addComponent(jLabel4, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  217.                                 .addComponent(jLabel3, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  218.                                 .addComponent(jLabel2, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 87, Short.MAX_VALUE)
  219.                                 .addComponent(jLabel8, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  220.                             .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  221.                                 .addComponent(jSave, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  222.                                 .addComponent(jDelete, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))
  223.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  224.                         .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  225.                             .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  226.                                 .addComponent(jNomor, javax.swing.GroupLayout.DEFAULT_SIZE, 85, Short.MAX_VALUE)
  227.                                 .addComponent(jTanggal)
  228.                                 .addComponent(jNIM)
  229.                                 .addComponent(jKelas)
  230.                                 .addComponent(jBulan)
  231.                                 .addComponent(jSemester)
  232.                                 .addComponent(jJumlah))
  233.                             .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  234.                                 .addComponent(jUpdate, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  235.                                 .addComponent(jReset, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))
  236.                         .addGap(18, 18, 18)
  237.                         .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 619, Short.MAX_VALUE)))
  238.                 .addContainerGap())
  239.         );
  240.         layout.setVerticalGroup(
  241.             layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  242.             .addGroup(layout.createSequentialGroup()
  243.                 .addContainerGap()
  244.                 .addComponent(jLabel1)
  245.                 .addGap(18, 18, 18)
  246.                 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  247.                     .addGroup(layout.createSequentialGroup()
  248.                         .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  249.                             .addComponent(jLabel2)
  250.                             .addComponent(jNomor, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  251.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  252.                         .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  253.                             .addComponent(jLabel3)
  254.                             .addComponent(jTanggal, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  255.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  256.                         .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  257.                             .addComponent(jLabel4)
  258.                             .addComponent(jNIM, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  259.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  260.                         .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  261.                             .addComponent(jLabel5)
  262.                             .addComponent(jKelas, javax.swing.GroupLayout.PREFERRED_SIZE, 20, javax.swing.GroupLayout.PREFERRED_SIZE))
  263.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  264.                         .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  265.                             .addComponent(jLabel6)
  266.                             .addComponent(jBulan, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  267.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  268.                         .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  269.                             .addComponent(jLabel7)
  270.                             .addComponent(jSemester, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  271.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  272.                         .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  273.                             .addComponent(jLabel8)
  274.                             .addComponent(jJumlah, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  275.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  276.                         .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  277.                             .addComponent(jSave)
  278.                             .addComponent(jUpdate))
  279.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  280.                         .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  281.                             .addComponent(jDelete)
  282.                             .addComponent(jReset)))
  283.                     .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE))
  284.                 .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  285.         );
  286.  
  287.         pack();
  288.     }// </editor-fold>                        
  289.  
  290.     private void jSaveActionPerformed(java.awt.event.ActionEvent evt) {                                      
  291.         // TODO add your handling code here:
  292.     }                                    
  293.  
  294.     private void jUpdateActionPerformed(java.awt.event.ActionEvent evt) {                                        
  295.         // TODO add your handling code here:
  296.     }                                      
  297.  
  298.     private void jDeleteActionPerformed(java.awt.event.ActionEvent evt) {                                        
  299.         // TODO add your handling code here:
  300.     }                                      
  301.  
  302.     private void jTable_Display_UsersMouseClicked(java.awt.event.MouseEvent evt) {                                                  
  303.        
  304.         // TODO add your handling code here:
  305.     }                                                
  306.  
  307.     /**
  308.      * @param args the command line arguments
  309.      */
  310.     public static void main(String args[]) {
  311.         /* Set the Nimbus look and feel */
  312.         //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
  313.         /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
  314.          * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
  315.          */
  316.         try {
  317.             for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
  318.                 if ("Nimbus".equals(info.getName())) {
  319.                     javax.swing.UIManager.setLookAndFeel(info.getClassName());
  320.                     break;
  321.                 }
  322.             }
  323.         } catch (ClassNotFoundException ex) {
  324.             java.util.logging.Logger.getLogger(spp.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  325.         } catch (InstantiationException ex) {
  326.             java.util.logging.Logger.getLogger(spp.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  327.         } catch (IllegalAccessException ex) {
  328.             java.util.logging.Logger.getLogger(spp.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  329.         } catch (javax.swing.UnsupportedLookAndFeelException ex) {
  330.             java.util.logging.Logger.getLogger(spp.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  331.         }
  332.         //</editor-fold>
  333.  
  334.         /* Create and display the form */
  335.         java.awt.EventQueue.invokeLater(new Runnable() {
  336.             public void run() {
  337.                 new spp().setVisible(true);
  338.             }
  339.         });
  340.     }
  341.  
  342.     // Variables declaration - do not modify                    
  343.     private javax.swing.JTextField jBulan;
  344.     private javax.swing.JButton jDelete;
  345.     private javax.swing.JTextField jJumlah;
  346.     private javax.swing.JTextField jKelas;
  347.     private javax.swing.JLabel jLabel1;
  348.     private javax.swing.JLabel jLabel2;
  349.     private javax.swing.JLabel jLabel3;
  350.     private javax.swing.JLabel jLabel4;
  351.     private javax.swing.JLabel jLabel5;
  352.     private javax.swing.JLabel jLabel6;
  353.     private javax.swing.JLabel jLabel7;
  354.     private javax.swing.JLabel jLabel8;
  355.     private javax.swing.JTextField jNIM;
  356.     private javax.swing.JTextField jNomor;
  357.     private javax.swing.JButton jReset;
  358.     private javax.swing.JButton jSave;
  359.     private javax.swing.JScrollPane jScrollPane1;
  360.     private javax.swing.JTextField jSemester;
  361.     private javax.swing.JTable jTable_Display_Users;
  362.     private javax.swing.JTextField jTanggal;
  363.     private javax.swing.JButton jUpdate;
  364.     // End of variables declaration                  
  365. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!