API tools faq
paste
Advertisement
VICTOW

SourceCode

VICTOW
May 19th, 2018
209
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 29.21 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 gui;
  7.  
  8. import java.awt.Dimension;
  9. import java.awt.Toolkit;
  10. import javax.swing.JOptionPane;
  11. import java.sql.*;
  12. import java.sql.Connection;
  13. import java.sql.DriverManager;
  14. import java.sql.ResultSet;
  15. import java.sql.SQLException;
  16. import javax.swing.JOptionPane;
  17. import java.sql.Statement;
  18. import java.util.logging.Level;
  19. import java.util.logging.Logger;
  20. import javax.swing.table.DefaultTableModel;
  21.  
  22. /**
  23.  *
  24.  * @author irkham
  25.  */
  26. public class hitungNilaiMhs extends javax.swing.JFrame {
  27.     public String sql = "";
  28.     private ResultSet res;
  29.     private Connection con;
  30.     private Statement stat;
  31.    
  32.     float absen,uts,uas,tugas,nilangka,nabsen;
  33.    
  34.     /**
  35.      * Creates new form hitungNilaiMhs
  36.      */
  37.     public hitungNilaiMhs() {
  38.         initComponents();
  39.         koneksi();
  40.         kosongkan();
  41.         mk();
  42.         tabel();
  43.  
  44.                 //rata kanan kiri
  45.         Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
  46.         Dimension frameSize = getSize();
  47.         setLocation ((screenSize.width - frameSize.width)/2,
  48.                 (screenSize.height - frameSize.height)/3);
  49.  
  50.        
  51.     }
  52.  
  53.     /**
  54.      * This method is called from within the constructor to initialize the form.
  55.      * WARNING: Do NOT modify this code. The content of this method is always
  56.      * regenerated by the Form Editor.
  57.      */
  58.     @SuppressWarnings("unchecked")
  59.     // <editor-fold defaultstate="collapsed" desc="Generated Code">                          
  60.     private void initComponents() {
  61.  
  62.         jButton1 = new javax.swing.JButton();
  63.         jPanel1 = new javax.swing.JPanel();
  64.         jLabel1 = new javax.swing.JLabel();
  65.         jPanel4 = new javax.swing.JPanel();
  66.         jLabel8 = new javax.swing.JLabel();
  67.         jLabel9 = new javax.swing.JLabel();
  68.         jLabel10 = new javax.swing.JLabel();
  69.         jLabel11 = new javax.swing.JLabel();
  70.         jLabel12 = new javax.swing.JLabel();
  71.         jLabel13 = new javax.swing.JLabel();
  72.         jLabel14 = new javax.swing.JLabel();
  73.         jLabel15 = new javax.swing.JLabel();
  74.         jLabel16 = new javax.swing.JLabel();
  75.         jLabel17 = new javax.swing.JLabel();
  76.         txtnim = new javax.swing.JTextField();
  77.         txtnama = new javax.swing.JTextField();
  78.         mkComboBox = new javax.swing.JComboBox();
  79.         txtabsen = new javax.swing.JTextField();
  80.         txttugas = new javax.swing.JTextField();
  81.         txtuts = new javax.swing.JTextField();
  82.         txtuas = new javax.swing.JTextField();
  83.         txtangka = new javax.swing.JTextField();
  84.         txthuruf = new javax.swing.JTextField();
  85.         txtket = new javax.swing.JTextField();
  86.         jButton2 = new javax.swing.JButton();
  87.         jButton3 = new javax.swing.JButton();
  88.         jLabel2 = new javax.swing.JLabel();
  89.         jLabel3 = new javax.swing.JLabel();
  90.         jLabel4 = new javax.swing.JLabel();
  91.         jLabel5 = new javax.swing.JLabel();
  92.         btnsimpan = new javax.swing.JButton();
  93.         lihatButton = new javax.swing.JButton();
  94.         jScrollPane1 = new javax.swing.JScrollPane();
  95.         Table = new javax.swing.JTable();
  96.  
  97.         jButton1.setText("jButton1");
  98.  
  99.         setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  100.  
  101.         jLabel1.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
  102.         jLabel1.setText("APLIKASI NILAI MAHASISWA");
  103.  
  104.         javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
  105.         jPanel1.setLayout(jPanel1Layout);
  106.         jPanel1Layout.setHorizontalGroup(
  107.             jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  108.             .addGroup(jPanel1Layout.createSequentialGroup()
  109.                 .addGap(22, 22, 22)
  110.                 .addComponent(jLabel1)
  111.                 .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  112.         );
  113.         jPanel1Layout.setVerticalGroup(
  114.             jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  115.             .addGroup(jPanel1Layout.createSequentialGroup()
  116.                 .addContainerGap()
  117.                 .addComponent(jLabel1)
  118.                 .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  119.         );
  120.  
  121.         jLabel8.setText("NIM");
  122.  
  123.         jLabel9.setText("Nama Mahasiswa");
  124.  
  125.         jLabel10.setText("Mata Kuliah");
  126.  
  127.         jLabel11.setText("Total Absen");
  128.  
  129.         jLabel12.setText("Nilai Tugas");
  130.  
  131.         jLabel13.setText("Nilai UTS");
  132.  
  133.         jLabel14.setText("Nilai UAS");
  134.  
  135.         jLabel15.setText("Nilai Angka");
  136.  
  137.         jLabel16.setText("Nilai Huruf");
  138.  
  139.         jLabel17.setText("Keterangan");
  140.  
  141.         mkComboBox.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Pemrograman 1", "Basis Data", "Kalkulus" }));
  142.         mkComboBox.setSelectedIndex(-1);
  143.         mkComboBox.addActionListener(new java.awt.event.ActionListener() {
  144.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  145.                 mkComboBoxActionPerformed(evt);
  146.             }
  147.         });
  148.  
  149.         txtangka.addActionListener(new java.awt.event.ActionListener() {
  150.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  151.                 txtangkaActionPerformed(evt);
  152.             }
  153.         });
  154.  
  155.         txthuruf.addActionListener(new java.awt.event.ActionListener() {
  156.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  157.                 txthurufActionPerformed(evt);
  158.             }
  159.         });
  160.  
  161.         txtket.addActionListener(new java.awt.event.ActionListener() {
  162.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  163.                 txtketActionPerformed(evt);
  164.             }
  165.         });
  166.  
  167.         jButton2.setText("HITUNG");
  168.         jButton2.addActionListener(new java.awt.event.ActionListener() {
  169.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  170.                 jButton2ActionPerformed(evt);
  171.             }
  172.         });
  173.  
  174.         jButton3.setText("CLEAR");
  175.         jButton3.addActionListener(new java.awt.event.ActionListener() {
  176.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  177.                 jButton3ActionPerformed(evt);
  178.             }
  179.         });
  180.  
  181.         jLabel2.setText("(Diisi 0-16)");
  182.  
  183.         jLabel3.setText("(Diisi 0-100)");
  184.  
  185.         jLabel4.setText("(Diisi 0-100)");
  186.  
  187.         jLabel5.setText("(Diisi 0-100)");
  188.  
  189.         btnsimpan.setText("SIMPAN");
  190.         btnsimpan.addActionListener(new java.awt.event.ActionListener() {
  191.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  192.                 btnsimpanActionPerformed(evt);
  193.             }
  194.         });
  195.  
  196.         lihatButton.setText("LIHAT NILAI");
  197.         lihatButton.addActionListener(new java.awt.event.ActionListener() {
  198.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  199.                 lihatButtonActionPerformed(evt);
  200.             }
  201.         });
  202.  
  203.         Table.setModel(new javax.swing.table.DefaultTableModel(
  204.             new Object [][] {
  205.                 {null, null, null, null},
  206.                 {null, null, null, null},
  207.                 {null, null, null, null},
  208.                 {null, null, null, null}
  209.             },
  210.             new String [] {
  211.                 "Title 1", "Title 2", "Title 3", "Title 4"
  212.             }
  213.         ));
  214.         jScrollPane1.setViewportView(Table);
  215.  
  216.         javax.swing.GroupLayout jPanel4Layout = new javax.swing.GroupLayout(jPanel4);
  217.         jPanel4.setLayout(jPanel4Layout);
  218.         jPanel4Layout.setHorizontalGroup(
  219.             jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  220.             .addGroup(jPanel4Layout.createSequentialGroup()
  221.                 .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  222.                     .addGroup(jPanel4Layout.createSequentialGroup()
  223.                         .addGap(51, 51, 51)
  224.                         .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  225.                             .addComponent(jLabel17, javax.swing.GroupLayout.DEFAULT_SIZE, 278, Short.MAX_VALUE)
  226.                             .addComponent(jLabel16, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  227.                             .addComponent(jLabel15, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  228.                             .addGroup(jPanel4Layout.createSequentialGroup()
  229.                                 .addComponent(btnsimpan)
  230.                                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
  231.                                 .addComponent(jButton3)
  232.                                 .addGap(18, 18, 18)
  233.                                 .addComponent(lihatButton))))
  234.                     .addGroup(jPanel4Layout.createSequentialGroup()
  235.                         .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  236.                             .addGroup(jPanel4Layout.createSequentialGroup()
  237.                                 .addGap(51, 51, 51)
  238.                                 .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
  239.                                     .addComponent(jLabel13, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  240.                                     .addComponent(jLabel12, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 82, Short.MAX_VALUE)
  241.                                     .addComponent(jLabel14, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  242.                                 .addGap(6, 6, 6))
  243.                             .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel4Layout.createSequentialGroup()
  244.                                 .addContainerGap()
  245.                                 .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  246.                                     .addComponent(jLabel9, javax.swing.GroupLayout.Alignment.TRAILING)
  247.                                     .addComponent(jLabel11, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 82, javax.swing.GroupLayout.PREFERRED_SIZE)
  248.                                     .addComponent(jLabel10, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 82, javax.swing.GroupLayout.PREFERRED_SIZE)
  249.                                     .addComponent(jLabel8, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 82, javax.swing.GroupLayout.PREFERRED_SIZE))
  250.                                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)))
  251.                         .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  252.                             .addComponent(jButton2)
  253.                             .addComponent(mkComboBox, javax.swing.GroupLayout.PREFERRED_SIZE, 131, javax.swing.GroupLayout.PREFERRED_SIZE)
  254.                             .addGroup(jPanel4Layout.createSequentialGroup()
  255.                                 .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
  256.                                     .addComponent(txtuas, javax.swing.GroupLayout.PREFERRED_SIZE, 67, javax.swing.GroupLayout.PREFERRED_SIZE)
  257.                                     .addComponent(txtuts, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.PREFERRED_SIZE, 67, javax.swing.GroupLayout.PREFERRED_SIZE)
  258.                                     .addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  259.                                         .addComponent(txttugas, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 67, javax.swing.GroupLayout.PREFERRED_SIZE)
  260.                                         .addComponent(txtabsen, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 67, javax.swing.GroupLayout.PREFERRED_SIZE)))
  261.                                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  262.                                 .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  263.                                     .addComponent(jLabel5)
  264.                                     .addComponent(jLabel3)
  265.                                     .addComponent(jLabel2)
  266.                                     .addComponent(jLabel4)))
  267.                             .addComponent(txtangka, javax.swing.GroupLayout.PREFERRED_SIZE, 65, javax.swing.GroupLayout.PREFERRED_SIZE)
  268.                             .addComponent(txthuruf, javax.swing.GroupLayout.PREFERRED_SIZE, 65, javax.swing.GroupLayout.PREFERRED_SIZE)
  269.                             .addComponent(txtket, javax.swing.GroupLayout.PREFERRED_SIZE, 178, javax.swing.GroupLayout.PREFERRED_SIZE)
  270.                             .addComponent(txtnim, javax.swing.GroupLayout.PREFERRED_SIZE, 130, javax.swing.GroupLayout.PREFERRED_SIZE)
  271.                             .addComponent(txtnama, javax.swing.GroupLayout.PREFERRED_SIZE, 130, javax.swing.GroupLayout.PREFERRED_SIZE))
  272.                         .addGap(0, 0, Short.MAX_VALUE)))
  273.                 .addGap(120, 120, 120))
  274.             .addGroup(jPanel4Layout.createSequentialGroup()
  275.                 .addContainerGap()
  276.                 .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE)
  277.                 .addContainerGap())
  278.         );
  279.         jPanel4Layout.setVerticalGroup(
  280.             jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  281.             .addGroup(jPanel4Layout.createSequentialGroup()
  282.                 .addContainerGap()
  283.                 .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  284.                     .addComponent(jLabel8)
  285.                     .addComponent(txtnim, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  286.                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  287.                 .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  288.                     .addComponent(jLabel9)
  289.                     .addComponent(txtnama, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  290.                 .addGap(9, 9, 9)
  291.                 .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  292.                     .addComponent(mkComboBox, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  293.                     .addComponent(jLabel10))
  294.                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  295.                 .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  296.                     .addComponent(txtabsen, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  297.                     .addComponent(jLabel2)
  298.                     .addComponent(jLabel11))
  299.                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  300.                 .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  301.                     .addComponent(txttugas, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  302.                     .addComponent(jLabel12)
  303.                     .addComponent(jLabel3))
  304.                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  305.                 .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  306.                     .addComponent(txtuts, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  307.                     .addComponent(jLabel13)
  308.                     .addComponent(jLabel4))
  309.                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  310.                 .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  311.                     .addComponent(txtuas, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  312.                     .addComponent(jLabel14)
  313.                     .addComponent(jLabel5))
  314.                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  315.                 .addComponent(jButton2)
  316.                 .addGap(18, 18, 18)
  317.                 .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  318.                     .addComponent(jLabel15)
  319.                     .addComponent(txtangka, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  320.                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  321.                 .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  322.                     .addComponent(jLabel16)
  323.                     .addComponent(txthuruf, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  324.                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  325.                 .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  326.                     .addComponent(jLabel17)
  327.                     .addComponent(txtket, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  328.                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  329.                 .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  330.                     .addComponent(jButton3)
  331.                     .addComponent(btnsimpan)
  332.                     .addComponent(lihatButton))
  333.                 .addGap(18, 18, 18)
  334.                 .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 133, javax.swing.GroupLayout.PREFERRED_SIZE)
  335.                 .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  336.         );
  337.  
  338.         javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  339.         getContentPane().setLayout(layout);
  340.         layout.setHorizontalGroup(
  341.             layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  342.             .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  343.             .addComponent(jPanel4, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  344.         );
  345.         layout.setVerticalGroup(
  346.             layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  347.             .addGroup(layout.createSequentialGroup()
  348.                 .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
  349.                 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
  350.                 .addComponent(jPanel4, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  351.         );
  352.  
  353.         pack();
  354.     }// </editor-fold>                        
  355.  
  356.     private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {                                        
  357.         // TODO add your handling code here:
  358.     txtnim.setText("");
  359.     txtnama.setText("");
  360.     txtangka.setText("");
  361.     txthuruf.setText("");
  362.     txtabsen.setText("");
  363.     txtket.setText("");
  364.     txttugas.setText("");
  365.     txtuts.setText("");
  366.     txtuas.setText("");
  367.     txtabsen.setText("");
  368.     }                                        
  369.  
  370.     private void koneksi(){
  371.      try {
  372.     Class.forName("com.mysql.jdbc.Driver");
  373.     con=DriverManager.getConnection("jdbc:mysql://127.0.0.1/db_mhs", "root", "");
  374.     stat=con.createStatement();
  375.      } catch (Exception e)
  376.      {
  377.          JOptionPane.showMessageDialog(null, e); }
  378.     }
  379.    
  380.     private void kosongkan(){
  381.     txtnim.setText("");
  382.     txtnama.setText("");
  383.     txtangka.setText("");
  384.     txthuruf.setText("");
  385.     txtabsen.setText("");
  386.     txtket.setText("");
  387.     txttugas.setText("");
  388.     txtuts.setText("");
  389.     txtuas.setText("");
  390.     txtabsen.setText("");
  391.     mkComboBox.setSelectedIndex(-1);
  392.    
  393.     }
  394.    
  395.     private void mk() {
  396.     mkComboBox.addItem("Pemograman 1");
  397.     mkComboBox.addItem("Basis data");
  398.     mkComboBox.addItem("Kalkulus");
  399.     mkComboBox.setSelectedIndex(-1);
  400.    
  401.     }
  402.    
  403.    
  404.     private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                        
  405.         // TODO add your handling code here:
  406.         absen = Float.parseFloat(txtabsen.getText());
  407. nabsen = ((absen/16)*100);
  408. tugas = Float.parseFloat(txttugas.getText());
  409. uas = Float.parseFloat(txtuas.getText());
  410. uts = Float.parseFloat(txtuts.getText());
  411. nilangka = ((nabsen*20/100)+(tugas*30/100)+(uts*20/100)+(uas*30/100));
  412. txtangka.setText(Float.toString(nilangka));
  413.  
  414. if (nilangka>= 80){
  415. txthuruf.setText("A");
  416. txtket.setText("Lulus");
  417. }else if (nilangka>= 70){
  418. txthuruf.setText("B");
  419. txtket.setText("Lulus");
  420. }else if (nilangka>= 60){
  421. txthuruf.setText("C");
  422. txtket.setText("Mengulang");
  423. }else if (nilangka>= 40){
  424. txthuruf.setText("D");
  425. txtket.setText("Mengulang");
  426. }else if (nilangka< 40){
  427. txthuruf.setText("E");
  428. txtket.setText("Tidak Lulus");
  429.         }
  430.     }                                        
  431.  
  432.     private void txtangkaActionPerformed(java.awt.event.ActionEvent evt) {                                        
  433.         // TODO add your handling code here:
  434.     }                                        
  435.  
  436.     private void mkComboBoxActionPerformed(java.awt.event.ActionEvent evt) {                                          
  437.         // TODO add your handling code here:
  438.     }                                          
  439.  
  440.     private void txthurufActionPerformed(java.awt.event.ActionEvent evt) {                                        
  441.         // TODO add your handling code here:
  442.     }                                        
  443.  
  444.     private void txtketActionPerformed(java.awt.event.ActionEvent evt) {                                      
  445.         // TODO add your handling code here:
  446.     }                                      
  447.  
  448.     private void btnsimpanActionPerformed(java.awt.event.ActionEvent evt) {                                          
  449. try {
  450. Class.forName("com.mysql.jdbc.Driver");
  451. con=DriverManager.getConnection("jdbc:mysql://localhost:3306/db_mhs", "root", "");
  452. sql = "insert into tb_nilai (nim,nama,matakuliah,absen,tugas,uts,uas,nilai,nilai_huruf,keterangan) values"
  453. + "('" + txtnim.getText() + "',"
  454. + "'" + txtnama.getText() + "',"
  455. + "'" + mkComboBox.getSelectedItem() + "',"
  456. + "'" + txtabsen.getText() + "',"
  457. + "'" + txttugas.getText() + "',"
  458. + "'" + txtuts.getText() + "',"
  459. + "'" + txtuas.getText() + "',"
  460. + "'" + txtangka.getText() + "',"
  461. + "'" + txthuruf.getText() + "',"
  462. + "'" + txtket.getText() + "')";                            
  463.  
  464.  
  465. stat = con.createStatement();
  466. stat.execute(sql);
  467. kosongkan();
  468. {
  469. javax.swing.JOptionPane.showMessageDialog(null, "Simpan Data Berhasil");
  470. }
  471.  
  472. } catch (Exception ex) {
  473. javax.swing.JOptionPane.showMessageDialog(null, "Gagal Proses Simpan Data "+ex);
  474. }
  475.         // TODO add your handling code here:
  476.     }                                        
  477.  
  478.     private void tabel(){
  479. DefaultTableModel
  480. t= new DefaultTableModel();
  481. t.addColumn("NIM");
  482. t.addColumn("Nama");
  483. t.addColumn("Mata Kuliah");
  484. t.addColumn("Nilai Absen");
  485. t.addColumn("Nilai Tugas");
  486. t.addColumn("Nilai UTS");
  487. t.addColumn("Nilai UAS");
  488. t.addColumn("Nilai Angka");
  489. t.addColumn("Nilai Huruf");
  490. t.addColumn("Nilai Keterangan");
  491. Table.setModel(t);
  492. try{
  493. res=stat.executeQuery("select * from tb_nilai");
  494. while (res.next()) {
  495. t.addRow(new Object[]{
  496. res.getString("nim"),
  497. res.getString("nama"),
  498. res.getString("matakuliah"),
  499. res.getString("absen"),
  500. res.getString("tugas"),
  501. res.getString("uts"),
  502. res.getString("uas"),
  503. res.getString("nilai"),
  504. res.getString("nilai_huruf"),
  505. res.getString("keterangan")
  506. });
  507. }
  508. }catch (Exception e) {
  509. JOptionPane.showMessageDialog(rootPane, e);
  510. }
  511. }
  512.    
  513.     private void lihatButtonActionPerformed(java.awt.event.ActionEvent evt) {                                            
  514.         // TODO add your handling code here:
  515.         DefaultTableModel
  516.         t= new DefaultTableModel();
  517.         t.addColumn("NIM");
  518.         t.addColumn("Nama");
  519.         t.addColumn("Mata Kuliah");
  520.         t.addColumn("Nilai Absen");
  521.         t.addColumn("Nilai Tugas");
  522.         t.addColumn("Nilai UTS");
  523.         t.addColumn("Nilai UAS");
  524.         t.addColumn("Nilai Angka");
  525.         t.addColumn("Nilai Huruf");
  526.         t.addColumn("Nilai Keterangan");
  527.         Table.setModel(t);
  528.         try{
  529.         res=stat.executeQuery("select * from tb_nilai");
  530.         while (res.next()) {
  531.         t.addRow(new Object[]{
  532.         res.getString("nim"),
  533.         res.getString("nama"),
  534.         res.getString("matakuliah"),
  535.         res.getString("absen"),
  536.         res.getString("tugas"),
  537.         res.getString("uts"),
  538.         res.getString("uas"),
  539.         res.getString("nilai"),
  540.         res.getString("nilai_huruf"),
  541.         res.getString("keterangan")
  542.         });
  543.         }
  544.         }catch (Exception e) {
  545.         JOptionPane.showMessageDialog(rootPane, e);
  546.         }
  547.  
  548.     }                                          
  549.  
  550.    
  551.     /**
  552.      * @param args the command line arguments
  553.      */
  554.     public static void main(String args[]) {
  555.         /* Set the Nimbus look and feel */
  556.         //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
  557.         /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
  558.          * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
  559.          */
  560.         try {
  561.             for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
  562.                 if ("Nimbus".equals(info.getName())) {
  563.                     javax.swing.UIManager.setLookAndFeel(info.getClassName());
  564.                     break;
  565.                 }
  566.             }
  567.         } catch (ClassNotFoundException ex) {
  568.             java.util.logging.Logger.getLogger(hitungNilaiMhs.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  569.         } catch (InstantiationException ex) {
  570.             java.util.logging.Logger.getLogger(hitungNilaiMhs.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  571.         } catch (IllegalAccessException ex) {
  572.             java.util.logging.Logger.getLogger(hitungNilaiMhs.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  573.         } catch (javax.swing.UnsupportedLookAndFeelException ex) {
  574.             java.util.logging.Logger.getLogger(hitungNilaiMhs.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  575.         }
  576.         //</editor-fold>
  577.  
  578.         /* Create and display the form */
  579.         java.awt.EventQueue.invokeLater(new Runnable() {
  580.             public void run() {
  581.                 new hitungNilaiMhs().setVisible(true);
  582.             }
  583.         });
  584.     }
  585.  
  586.     // Variables declaration - do not modify                    
  587.     private javax.swing.JTable Table;
  588.     private javax.swing.JButton btnsimpan;
  589.     private javax.swing.JButton jButton1;
  590.     private javax.swing.JButton jButton2;
  591.     private javax.swing.JButton jButton3;
  592.     private javax.swing.JLabel jLabel1;
  593.     private javax.swing.JLabel jLabel10;
  594.     private javax.swing.JLabel jLabel11;
  595.     private javax.swing.JLabel jLabel12;
  596.     private javax.swing.JLabel jLabel13;
  597.     private javax.swing.JLabel jLabel14;
  598.     private javax.swing.JLabel jLabel15;
  599.     private javax.swing.JLabel jLabel16;
  600.     private javax.swing.JLabel jLabel17;
  601.     private javax.swing.JLabel jLabel2;
  602.     private javax.swing.JLabel jLabel3;
  603.     private javax.swing.JLabel jLabel4;
  604.     private javax.swing.JLabel jLabel5;
  605.     private javax.swing.JLabel jLabel8;
  606.     private javax.swing.JLabel jLabel9;
  607.     private javax.swing.JPanel jPanel1;
  608.     private javax.swing.JPanel jPanel4;
  609.     private javax.swing.JScrollPane jScrollPane1;
  610.     private javax.swing.JButton lihatButton;
  611.     private javax.swing.JComboBox mkComboBox;
  612.     private javax.swing.JTextField txtabsen;
  613.     private javax.swing.JTextField txtangka;
  614.     private javax.swing.JTextField txthuruf;
  615.     private javax.swing.JTextField txtket;
  616.     private javax.swing.JTextField txtnama;
  617.     private javax.swing.JTextField txtnim;
  618.     private javax.swing.JTextField txttugas;
  619.     private javax.swing.JTextField txtuas;
  620.     private javax.swing.JTextField txtuts;
  621.     // End of variables declaration                  
  622. }
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!