Baron

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 14

6. Analisa code di atas dan tuliskan output yang dihasilkan potongan code tersebut!

Untuk menghasilkan informasi mengenai error exception maka dapat digunakan try catch

7. dnef

Menghapus elemen index ke 2 (inclusive) hingga index ke 4 (exclusive)

9.
import java.awt.Graphics;
import javax.swing.JFrame;

public class Tutorial extends JFrame


{
public Tutorial()
{
setTitle("Tutorial");
setSize(400, 400);
setVisible(true);
setDefaultCloseOperation(EXIT_ON_CLOSE);
}

public void paint(Graphics g)


{
g.drawRect(480, 480, 200, 100);
}

public static void main(String[] args)


{
Tutorial t = new Tutorial();
t.paint(null);
}
}

function drawRect untuk membuat objek rectangle, 480 = X, 480 = Y (position) sedangkan 200
adalah width dan 100 adalah height

10
Proses Update, delete

Proses Create
File Koneksi:

public class Koneksi {


Connection koneksi;

public static Connection Koneksi() {


try {
Class.forName("com.mysql.jdbc.Driver");
Connection koneksi =
DriverManager.getConnection("jdbc:mysql://localhost/tutorialjava", "root", "");

return koneksi;
} catch(Exception e) {
JOptionPane.showMessageDialog(null, e);

return null;
}
}
}

File Form Mahasiswa


/*
* 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 view;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
/**
*
* @author hilmibukhori
*/
public class FormSiswa extends javax.swing.JFrame {
public Statement st;
public ResultSet rs;
public DefaultTableModel tabModel;
Connection cn = koneksi.Koneksi.Koneksi();
/**
* Creates new form FormSiswa
*/
public FormSiswa() {
initComponents();
judul();
tampilData("");

buttonHapus.setEnabled(false);
buttonUpdate.setEnabled(false);
}

public void reset() {


inputNim.setText("");
inputNama.setText("");
inputJurusan.setSelectedItem("");
inputJK.setSelectedItem("");
inputAlamat.setText("");
}

public void judul() {


Object[] judul = {
"NIM", "Nama", "Jurusan", "JK", "Alamat"
};
tabModel = new DefaultTableModel(null, judul);
tableMahasiswa.setModel(tabModel);
}

public void tampilData(String where) {


try {
st = cn.createStatement();
tabModel.getDataVector().removeAllElements();
tabModel.fireTableDataChanged();
rs = st.executeQuery("SELECT * FROM students " + where);

while (rs.next()) {
Object[] data = {
rs.getString("nim"),
rs.getString("nama"),
rs.getString("jurusan"),
rs.getString("jk"),
rs.getString("alamat"),
};

tabModel.addRow(data);
}
} catch(Exception e) {
e.printStackTrace();
}
}

/**
* 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() {

jButton3 = new javax.swing.JButton();


jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
inputNim = new javax.swing.JTextField();
jLabel3 = new javax.swing.JLabel();
inputNama = new javax.swing.JTextField();
inputJurusan = new javax.swing.JComboBox<>();
jLabel4 = new javax.swing.JLabel();
jScrollPane1 = new javax.swing.JScrollPane();
inputAlamat = new javax.swing.JTextArea();
jLabel5 = new javax.swing.JLabel();
buttonSimpan = new javax.swing.JButton();
buttonHapus = new javax.swing.JButton();
buttonReset = new javax.swing.JButton();
buttonUpdate = new javax.swing.JButton();
jScrollPane2 = new javax.swing.JScrollPane();
tableMahasiswa = new javax.swing.JTable();
inputJK = new javax.swing.JComboBox<>();
jLabel6 = new javax.swing.JLabel();

jButton3.setText("jButton1");

setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

jLabel1.setText("Form Mahasiswa");

jLabel2.setText("NIM");

inputNim.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
inputNimActionPerformed(evt);
}
});

jLabel3.setText("Nama");

inputNama.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
inputNamaActionPerformed(evt);
}
});

inputJurusan.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "Teknik


Informatika", "Sistem Informasi" }));

jLabel4.setText("Jurusan");

inputAlamat.setColumns(20);
inputAlamat.setRows(5);
jScrollPane1.setViewportView(inputAlamat);

jLabel5.setText("Alamat");
buttonSimpan.setText("Simpan");
buttonSimpan.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
buttonSimpanActionPerformed(evt);
}
});

buttonHapus.setText("Hapus");

buttonReset.setText("Reset");

buttonUpdate.setText("Update");

tableMahasiswa.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"
}
));
tableMahasiswa.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
tableMahasiswaMouseClicked(evt);
}
});
jScrollPane2.setViewportView(tableMahasiswa);

inputJK.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "Laki-Laki",


"Perempuan" }));

jLabel6.setText("JK");

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(20, 20, 20)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILIN
G)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADI
NG)
.addComponent(jLabel1)
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel2)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED
)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LE
ADING)
.addComponent(inputNama, javax.swing.GroupLayout.PREFERRED_SIZE,
125, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(inputNim, javax.swing.GroupLayout.PREFERRED_SIZE, 115,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(inputJurusan, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))))
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRA
ILING)
.addComponent(jLabel4)
.addComponent(jLabel3)
.addComponent(jLabel6))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(inputJK, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(51, 51, 51)))
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel5)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(layout.createSequentialGroup()
.addGap(48, 48, 48)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILI
NG)
.addComponent(buttonSimpan)
.addComponent(buttonUpdate))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADI
NG, false)
.addComponent(buttonHapus, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(buttonReset, javax.swing.GroupLayout.PREFERRED_SIZE, 84,
javax.swing.GroupLayout.PREFERRED_SIZE))))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 47,
Short.MAX_VALUE)
.addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 375,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap())
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 327,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGroup(layout.createSequentialGroup()
.addGap(14, 14, 14)
.addComponent(jLabel1)
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel2)
.addComponent(inputNim, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel3)
.addComponent(inputNama, 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(inputJurusan, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel4))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 8,
Short.MAX_VALUE)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(inputJK, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel6))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel5))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(buttonSimpan)
.addComponent(buttonHapus))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(buttonReset)
.addComponent(buttonUpdate))
.addGap(38, 38, 38))
);

pack();
}// </editor-fold>

private void inputNimActionPerformed(java.awt.event.ActionEvent evt) {


// TODO add your handling code here:
}

private void inputNamaActionPerformed(java.awt.event.ActionEvent evt) {


// TODO add your handling code here:
}

private void buttonSimpanActionPerformed(java.awt.event.ActionEvent evt) {


try {
st = cn.createStatement();
st.executeUpdate("INSERT INTO students VALUES('" + inputNim.getText() + "','"
+ inputNama.getText() + "','"
+ inputJurusan.getSelectedItem() + "','"
+ inputJK.getSelectedItem() + "','"
+ inputAlamat.getText() + "')");
tampilData("");
JOptionPane.showMessageDialog(null, "Simpan Berhasil");
inputNim.setText("");
inputNama.setText("");
inputAlamat.setText("");
inputJurusan.setSelectedItem("");
} catch (Exception e) {
e.printStackTrace();
}
}

private void tableMahasiswaMouseClicked(java.awt.event.MouseEvent evt) {


inputNim.setText(tableMahasiswa.getValueAt(tableMahasiswa.getSelectedRow(),
0).toString());
inputNama.setText(tableMahasiswa.getValueAt(tableMahasiswa.getSelectedRow(),
1).toString());

inputJurusan.setSelectedItem(tableMahasiswa.getValueAt(tableMahasiswa.getSelectedRow(),
2).toString());
inputJK.setSelectedItem(tableMahasiswa.getValueAt(tableMahasiswa.getSelectedRow(),
3).toString());
inputAlamat.setText(tableMahasiswa.getValueAt(tableMahasiswa.getSelectedRow(),
4).toString());
buttonSimpan.setEnabled(false);
buttonUpdate.setEnabled(true);
buttonHapus.setEnabled(true);
}

private void buttonResetActionPerformed(java.awt.event.ActionEvent evt) {


reset();
}

private void buttonUpdateActionPerformed(java.awt.event.ActionEvent evt) {


try {
st = cn.createStatement();
st.executeUpdate("UPDATE students set "
+ "nim='" + inputNim.getText() + "', "
+ "nama='" + inputNama.getText() + "', "
+ "jurusan='" + inputJurusan.getSelectedItem() + "', "
+ "jk='" + inputJK.getSelectedItem() + "', "
+ "alamat='" + inputAlamat.getText() + "'");
tampilData("");
JOptionPane.showMessageDialog(null, "Update Berhasil");
reset();
} catch (Exception e) {
e.printStackTrace();
}
}

private void buttonHapusActionPerformed(java.awt.event.ActionEvent evt) {


try {
int jawab;

if ((jawab = JOptionPane.showConfirmDialog(null, "Ingin menghapus data?", "konfirmasi",


JOptionPane.YES_NO_OPTION)) == 0) {
st = cn.createStatement();
st.executeUpdate("DELETE FROM students WHERE nim='"
+ tabModel.getValueAt(tableMahasiswa.getSelectedRow(), 0) + "'");
tampilData("");
reset();
}
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* @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(FormSiswa.class.getName()).log(java.util.logging.Level.SEVER
E, null, ex);
} catch (InstantiationException ex) {

java.util.logging.Logger.getLogger(FormSiswa.class.getName()).log(java.util.logging.Level.SEVER
E, null, ex);
} catch (IllegalAccessException ex) {

java.util.logging.Logger.getLogger(FormSiswa.class.getName()).log(java.util.logging.Level.SEVER
E, null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {

java.util.logging.Logger.getLogger(FormSiswa.class.getName()).log(java.util.logging.Level.SEVER
E, null, ex);
}
//</editor-fold>
/* Create and display the form */
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new FormSiswa().setVisible(true);
}
});
}

// Variables declaration - do not modify


private javax.swing.JButton buttonHapus;
private javax.swing.JButton buttonReset;
private javax.swing.JButton buttonSimpan;
private javax.swing.JButton buttonUpdate;
private javax.swing.JTextArea inputAlamat;
private javax.swing.JComboBox<String> inputJK;
private javax.swing.JComboBox<String> inputJurusan;
private javax.swing.JTextField inputNama;
private javax.swing.JTextField inputNim;
private javax.swing.JButton jButton3;
private javax.swing.JLabel jLabel1;
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.JScrollPane jScrollPane1;
private javax.swing.JScrollPane jScrollPane2;
private javax.swing.JTable tableMahasiswa;
// End of variables declaration
}

You might also like