コード例 #1
0
  private void btnubahActionPerformed(
      java.awt.event.ActionEvent evt) { // GEN-FIRST:event_btnubahActionPerformed
    try {
      Class.forName("com.mysql.jdbc.Driver");

      // MENYIAPKAN KONEKSI DAN PARAMETERNYA
      String urldb = "jdbc:mysql://localhost:3306/hotel";
      String user = "******";
      String password = "";
      Connection koneksi = DriverManager.getConnection(urldb, user, password);
      // Query SQL dan Eksekuusinya

      Statement st = koneksi.createStatement();

      String jnsKelamin;
      if (rbtnlaki.isSelected()) {
        jnsKelamin = "laki-laki";
      } else {
        jnsKelamin = "perempuan";
      }

      String strSQL =
          "update master_costumer set id_ktp='"
              + txtid.getText()
              + "',nama='"
              + txtnama.getText()
              + "', alamat='"
              + txtalamat.getText()
              + "', jenis_kelamin='"
              + jnsKelamin
              + "' where id_ktp='"
              + txtid.getText()
              + "'";
      st.executeUpdate(strSQL);

      data[0] = txtid.getText();
      data[1] = txtnama.getText();
      data[2] = txtalamat.getText();
      data[3] = jnsKelamin;
      tblModel.removeRow(row);
      tblModel.insertRow(row, data);

      txtid.setText("");
      txtnama.setText("");
      txtalamat.setText("");

      st.close();
      koneksi.close();
    } catch (ClassNotFoundException cnfe) {
      System.out.println("KESALAHAN SAAT" + "ME-LOAD DRIVER JDBC \n" + cnfe.getMessage());
    } catch (SQLException sqle) {
      System.out.println(
          "KESALAHAN SAAT KONEKSI ATAU " + "KESALAHAN QUERY SQL \n" + sqle.getMessage());
    }
  } // GEN-LAST:event_btnubahActionPerformed
コード例 #2
0
 public void Tampil() {
   row = tblmaster.getSelectedRow();
   txtid.setText(tblModel.getValueAt(row, 0).toString());
   txtnama.setText(tblModel.getValueAt(row, 1).toString());
   txtalamat.setText(tblModel.getValueAt(row, 2).toString());
   if (tblModel.getValueAt(row, 3).toString().equals("Laki-laki")) {
     rbtnlaki.setSelected(true);
   } else {
     rbtnperempuan.setSelected(true);
   }
 }
コード例 #3
0
  private void jButton3ActionPerformed(
      java.awt.event.ActionEvent evt) { // GEN-FIRST:event_jButton3ActionPerformed
    // TODO add your handling code here:
    try {
      Class.forName("com.mysql.jdbc.Driver");

      // MENYIAPKAN KONEKSI DAN PARAMETERNYA
      String urldb = "jdbc:mysql://localhost:3306/hotel";
      String user = "******";
      String password = "";
      Connection koneksi = DriverManager.getConnection(urldb, user, password);
      // Query SQL dan Eksekuusinya

      Statement st = koneksi.createStatement();

      String strSQL = "delete from master_costumer where id_ktp='" + txtid.getText() + "'";
      st.executeUpdate(strSQL);
      tblModel.removeRow(row);

      txtid.setText("");
      txtnama.setText("");
      txtalamat.setText("");

      st.close();
      koneksi.close();
    } catch (ClassNotFoundException cnfe) {
      System.out.println("KESALAHAN SAAT" + "ME-LOAD DRIVER JDBC \n" + cnfe.getMessage());
    } catch (SQLException sqle) {
      System.out.println(
          "KESALAHAN SAAT KONEKSI ATAU " + "KESALAHAN QUERY SQL \n" + sqle.getMessage());
    }
  } // GEN-LAST:event_jButton3ActionPerformed