Nama : Sulistia Hapsari
Kelas : XII PPLG3
Mapel :PBO
Tugas : 12
I.PERANCANGAN INTERFACE
1)Jframe from
2)Jinternal frame
II. PENGATURAN PROPERTY
A.JFrame From
Pengaturan
No Nama Tool
Name Variabel
1 jButton1 Home btnhome
2 jButton2 Visi Misi Btnvisi
3 jButton3 Tentang btntentang
4 jButton4 Kontak Btnkontak
5 jButton5 Help Btnhelp
6 jButton6 Login Btnlogin
7 jButton7 Back
8 Jpanel1 - Desktop
B.Jinternal Frame
No Nama Tool Pengaturan
Nama Variabel
1 JTabel1 Jtabel1
2 Jlabel1 Nis -
3 Jlabel2 Nama -
4 Jlabel3 Kelas -
5 TextField1 - txtnis
6 TextField2 - txtnama
7 TextField3 - txtkelas
8 TextField4 Cari Txtcari
9 Jbutton1 Tambah btntambah
10 Jbutton2 Perbarui btnperbarui
11 Jbutton3 Batal btnbatal
12 Jbutton4 Hapus btnhapus
III.LISTING PROGRAM/CODING
1) public class formyg1 extends javax.swing.JFrame {
public formyg1() {
initComponents();
this.setExtendedState (MAXIMIZED_BOTH)
2)btnsiswa
private void btnsiswaActionPerformed(java.awt.event.ActionEvent evt) {
desktop.removeAll();
tampilsiswa siswa=new tampilsiswa();
desktop.add(siswa);
siswa.show();
4.Frame Siswa
package siswa;
import koneksi.koneksi;
import java.sql.Statement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
public class tampilsiswa extends javax.swing.JInternalFrame {
private DefaultTableModel model;
public void tambahdata(){
loaddata();
try{
Statement stat=(Statement) koneksi.getkoneksi().createStatement();
String sql = "INSERT INTO siswa (nis,nama,kelas)"+"VALUES ('"+nis+"','"+nama+"','"+kelas+"')";
PreparedStatement ps=(PreparedStatement) koneksi.getkoneksi().prepareStatement(sql);
ps.executeUpdate();
getdata();
}catch (SQLException err){
JOptionPane.showMessageDialog(null,err.getMessage());
public void getdata(){
model.getDataVector().removeAllElements();
model.fireTableDataChanged();
try{
Statement stat=(Statement) koneksi.getkoneksi().createStatement();
String sql="select * from siswa";
ResultSet res=stat.executeQuery(sql);
while(res.next()){
Object [] obj=new Object[3];
obj[0]=res.getString("nis");
obj[1]=res.getString("nama");
obj[2]=res.getString("kelas");
model.addRow(obj);
}catch(SQLException err){
JOptionPane.showMessageDialog(null, err.getMessage());
IV.OUTPUT
