Pemrograman Berbasis Java
“PERSEWAAN PELAMPUNG
Riska Nony Oktaviani 13111005 Kelas 21 Teknik Informatika Teknologi Informasi
UNIVERSITAS MERCU BUANA YOGYAKARTA 1
DAFTAR ISI
Pemrograman Berbasis Java ................................................................................................................... 1 DAFTAR ISI............................................................................................................................................... 2 BAB I - PENDAHULUAN ........................................................................................................................... 4 1.1
Latar Belakang......................................................................................................................... 4
1.2
Alasan Pemilihan Masalah ...................................................................................................... 4
BAB II - DATABASE................................................................................................................................... 5 2.1 Rancangan Tabel ........................................................................................................................... 5 2.2 Relasi Database ............................................................................................................................. 5 BAB III – JDBC .......................................................................................................................................... 6 3.1 Tabel Pelampung........................................................................................................................... 6 3.1.1 Save Pelampung ..................................................................................................................... 7 3.1.2 Search Pelampung.................................................................................................................. 8 3.1.3 Update Pelampung ................................................................................................................ 9 3.1.4 Delete Pelampung ................................................................................................................ 10 3.1.5 View Pelampung .................................................................................................................. 11 3.2 Tabel Peminjam/Penyewa .......................................................................................................... 13 3.2.1 Save Peminjam ..................................................................................................................... 14 3.2.2 Search Peminjam ................................................................................................................. 15 3.2.3 Update Peminjam ................................................................................................................ 16 3.2.4 Delete Peminjam .................................................................................................................. 17 3.2.5 View Peminjam .................................................................................................................... 18 3.3 Tabel Peminjaman ...................................................................................................................... 20 3.3.1 Save Peminjam ..................................................................................................................... 22 3.3.2 Search Peminjaman ............................................................................................................. 23 3.3.3 Update Peminjaman ............................................................................................................ 24 3.3.4 Delete Peminjaman.............................................................................................................. 25 3.3.5 View Peminjaman ................................................................................................................ 26 BAB IV - MENU ..................................................................................................................................... 28 4.1 MENU .......................................................................................................................................... 28 BAB V – PENUTUP ................................................................................................................................. 32 5.1 Kesimpulan.................................................................................................................................. 32 2
5.2 Kesulitan...................................................................................................................................... 32
3
BAB I - PENDAHULUAN 1.1
Latar Belakang
Dalam era yang semakin maju ini teknologi sangat banyak berkembang, maka dari itu dibutuhkan pembaruan dalam segala bidang . Untuk itu jika di dalam system perhotelan maka dibutuhkan juga cara transaksi yang mempermudah pemilik hotel untuk mengakses pelanggannya dalam system pembayaran dan penyewaannya , maka sekarang saya mencoba mengembangkannya.
1.2
Alasan Pemilihan Masalah
Alasan saya memilih tema ini adalah agar mempermudah transaksi sistem jasa sewa pelampung sehingga lebih mudah mengatur sistemnya.
4
BAB II - DATABASE 2.1 Rancangan Tabel
2.2 Relasi Database
5
BAB III – JDBC 3.1 Tabel Pelampung /* * Nony * 13111005 * */ import java.awt.*; import javax.swing.*; import java.awt.event.*; import java.io.*; import java.sql.*; class pelampunginput extends JFrame { JLabel labelid_pelampung=new JLabel("Id"); JTextField textid_pelampung=new JTextField(2); JLabel labeljenis_pelampung=new JLabel("Jenis Pelampung"); String [] Gjenis_pelampung={"Anak-Anak","Dewasa"}; JComboBox combojenis_pelampung=new JComboBox(Gjenis_pelampung); JLabel labeljumlah_pelampung=new JLabel("Jumlah Pelampung"); JTextField textjumlah_pelampung=new JTextField(30); JLabel labeltarif=new JLabel("Tarif"); JTextField texttarif=new JTextField(30); JButton buttonSearch=new JButton("Search"); JButton buttonUpdate=new JButton("Update"); JButton buttonSave=new JButton("Save"); JButton buttonDelete=new JButton("Delete"); JButton buttonExit=new JButton("Exit"); pelampunginput() { setTitle("Pelampung"); setLocation(300,100); setSize(400,250); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); } void Label() { getContentPane().setLayout(null); getContentPane().add(labelid_pelampung); labelid_pelampung.setBounds(10,10,110,20); getContentPane().add(textid_pelampung); textid_pelampung.setBounds(150,10,110,20); getContentPane().add(labeljenis_pelampung);labeljenis_pelampung.setBounds(10,30,110,2 0); getContentPane().add(combojenis_pelampung);combojenis_pelampung.setBounds(150,30,1 10,18);
6
getContentPane().add(labeljumlah_pelampung); labeljumlah_pelampung.setBounds(10,50,150,20); getContentPane().add(textjumlah_pelampung); textjumlah_pelampung.setBounds(150,50,110,20); getContentPane().add(labeltarif); labeltarif.setBounds(10,70,110,20); getContentPane().add(texttarif); texttarif.setBounds(150,70,110,20); getContentPane().add(buttonSearch); buttonSearch.setBounds(270,3,110,20); getContentPane().add(buttonUpdate); buttonUpdate.setBounds(10,120,80,20); getContentPane().add(buttonSave);buttonSave.setBounds(100,120,80,20); getContentPane().add(buttonDelete);buttonDelete.setBounds(200,120,80,20); getContentPane().add(buttonExit);buttonExit.setBounds(300,120,80,20); setVisible(true); } void Perintah() { // button exit buttonExit.addActionListener ( new ActionListener() { public void actionPerformed(ActionEvent e) { if (JOptionPane.showConfirmDialog( null, "Apakah Anda benar-benar akan keluar?","Konfirmasi", JOptionPane.OK_CANCEL_OPTION,JOptionPane.QUESTION_MESSAGE) == JOptionPane.OK_OPTION) { System.exit(0); } } } );
3.1.1 Save Pelampung //button save buttonSave.addActionListener ( new ActionListener() 7
{ public void actionPerformed (ActionEvent e) { String id_pelampung, jenis_pelampung, jumlah_pelampung, tarif; id_pelampung = textid_pelampung.getText(); jenis_pelampung = (String) combojenis_pelampung.getSelectedItem(); jumlah_pelampung = textjumlah_pelampung.getText(); tarif = texttarif.getText(); //input kedatabase Koneksi open = new Koneksi (); Connection mysql = open.getConnection(); try { Statement stmt = mysql.createStatement(); String sql = "INSERT INTO Pelampung VALUES ('"+id_pelampung+"','"+jenis_pelampung+"','"+jumlah_pelampung+"','"+tarif+"');"; int i = stmt.executeUpdate (sql); if (i == 1) { JOptionPane.showMessageDialog(null, "Tabel Pelampung Berhasil Disimpan"); } } catch (Exception ex) { JOptionPane.showMessageDialog(null, ex.getMessage()); } } });
3.1.2 Search Pelampung //button search buttonSearch.addActionListener ( new ActionListener() { public void actionPerformed (ActionEvent e) 8
{ String Search; String id_pelampung, jenis_pelampung, jumlah_pelampung, tarif; Koneksi open = new Koneksi (); Connection mysql = open.getConnection(); try { Search = textid_pelampung.getText(); Statement stmt = mysql.createStatement(); String sql = "SELECT * FROM pelampung WHERE id_pelampung like '"+Search+"'"; ResultSet i = stmt.executeQuery (sql); if(i.next()) { textid_pelampung.setText(i.getString(1)); combojenis_pelampung.setSelectedItem(i.getString(2)); textjumlah_pelampung.setText(i.getString(3)); texttarif.setText(i.getString(4)); } else { JOptionPane.showMessageDialog(null, "Tabel Pelampung Tidak Ada"); } } catch (Exception ex) { JOptionPane.showMessageDialog(null, ex.getMessage()); } } }); 3.1.3 Update Pelampung // button update buttonUpdate.addActionListener ( new ActionListener() { public void actionPerformed (ActionEvent e) { String id_pelampung, jenis_pelampung, jumlah_pelampung, tarif; id_pelampung = textid_pelampung.getText(); jenis_pelampung = (String) combojenis_pelampung.getSelectedItem(); jumlah_pelampung = textjumlah_pelampung.getText(); tarif = texttarif.getText(); //input ke database Koneksi open = new Koneksi (); Connection mysql = open.getConnection(); try { Statement stmt = mysql.createStatement(); 9
String sql = "Update pelampung SET id_pelampung='"+id_pelampung+ "',jenis_pelampung='"+jenis_pelampung+"',jumlah_pelampung='"+jumlah_pelampung+"',tar if='"+tarif+ "'WHERE id_pelampung='"+id_pelampung+"'"; int i = stmt.executeUpdate (sql); if (i == 1) JOptionPane.showMessageDialog(null, "Tabel Pelampung Berhasil Diupdate"); } catch (Exception ex) { JOptionPane.showMessageDialog(null, ex.getMessage()); } } });
3.1.4 Delete Pelampung // button delete buttonDelete.addActionListener ( new ActionListener() { public void actionPerformed (ActionEvent e) { String id_pelampung, jenis_pelampung, jumlah_pelampung, tarif; id_pelampung = textid_pelampung.getText(); jenis_pelampung = (String) combojenis_pelampung.getSelectedItem(); jumlah_pelampung = textjumlah_pelampung.getText(); tarif = texttarif.getText(); //input ke database Koneksi open = new Koneksi (); Connection mysql = open.getConnection(); try { 10
Statement stmt = mysql.createStatement(); String sql = "DELETE FROM pelampung WHERE id_pelampung='"+id_pelampung+"'"; int i = stmt.executeUpdate (sql); if (i == 1) { JOptionPane.showMessageDialog(null,"Tabel Pelampung Berhasil Dihapus"); } } catch (Exception ex) { JOptionPane.showMessageDialog(null, ex.getMessage()); } }}); }
3.1.5 View Pelampung /* * Nony * 13111005 * */ import java.awt.*; import java.sql.*; import javax.swing.*; import javax.swing.table.*; public class View_pelampung extends JPanel { String[] header = {"id_pelampung","jenis_pelampung","jumlah_pelampung","tarif"}; JTable table = new JTable(); JScrollPane scrollTable = new JScrollPane(); private Object[][] dataTable = null; View_pelampung() { Koneksi open = new Koneksi (); Connection mysql = open.getConnection(); 11
try { Statement stmt = mysql.createStatement(); String sql = "SELECT * FROM pelampung"; ResultSet rs = stmt.executeQuery(sql); ResultSetMetaData meta = rs.getMetaData(); int kolom = meta.getColumnCount(); int baris = 0; while(rs.next()) { baris = rs.getRow(); } dataTable = new Object[baris][kolom]; int x = 0; rs.beforeFirst(); while(rs.next()) { dataTable[x][0] = rs.getString("id_pelampung"); dataTable[x][1] = rs.getString("jenis_pelampung"); dataTable[x][2] = rs.getString("jumlah_pelampung"); dataTable[x][3] = rs.getString("tarif"); x++; } scrollTable.setViewportView(table); table.setModel(new DefaultTableModel(dataTable, header)); add(scrollTable, BorderLayout.NORTH); stmt.close(); rs.close(); } catch (Exception ex) { JOptionPane.showMessageDialog(null, "Data Pelampung Error"); } } void GUI() { JFrame frame = new JFrame("Data Pelampung"); frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); View_pelampung content = new View_pelampung(); content.setOpaque(true); frame.setContentPane(content); frame.pack(); frame.setLocationRelativeTo(null); frame.setVisible(true); } public static void main(String [] args) { 12
View_pelampung nony=new View_pelampung (); nony.GUI(); } }
3.2 Tabel Peminjam/Penyewa * * Nony * 13111005 * */ import java.awt.*; import javax.swing.*; import java.awt.event.*; import java.io.*; import java.sql.*; class penyewainput extends JFrame { JLabel labelno_iden=new JLabel("Nomor Identitas"); JTextField textno_iden=new JTextField(30); JLabel labelNama=new JLabel("Nama"); JTextField textNama=new JTextField(100); JLabel labelno_telp=new JLabel("Nomor Telepon"); JTextField textno_telp=new JTextField(12); JButton buttonSearch=new JButton("Search"); JButton buttonUpdate=new JButton("Update"); JButton buttonSave=new JButton("Save"); JButton buttonDelete=new JButton("Delete"); JButton buttonExit=new JButton("Exit"); penyewainput() { setTitle("Data Peminjam"); setLocation(300,150); setSize(400,200); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); } void Label() { 13
getContentPane().setLayout(null); getContentPane().add(labelno_iden); labelno_iden.setBounds(10,30,200,20); getContentPane().add(textno_iden); textno_iden.setBounds(150,30,200,20); getContentPane().add(labelNama); labelNama.setBounds(10,50,200,20); getContentPane().add(textNama); textNama.setBounds(150,50,200,20); getContentPane().add(labelno_telp); labelno_telp.setBounds(10,70,200,20); getContentPane().add(textno_telp); textno_telp.setBounds(150,70,200,20); getContentPane().add(buttonSearch); buttonSearch.setBounds(270,3,110,20); getContentPane().add(buttonUpdate); buttonUpdate.setBounds(10,130,80,20); getContentPane().add(buttonSave);buttonSave.setBounds(100,130,80,20); getContentPane().add(buttonDelete);buttonDelete.setBounds(200,130,80,20); getContentPane().add(buttonExit);buttonExit.setBounds(300,130,80,20); setVisible(true); } void Perintah() { // button exit buttonExit.addActionListener ( new ActionListener() { public void actionPerformed(ActionEvent e) { if (JOptionPane.showConfirmDialog( null, "Apakah Anda benar-benar akan keluar?","Konfirmasi", JOptionPane.OK_CANCEL_OPTION,JOptionPane.QUESTION_MESSAGE) == JOptionPane.OK_OPTION) { System.exit(0); } } } );
3.2.1 Save Peminjam //button save 14
buttonSave.addActionListener ( new ActionListener() { public void actionPerformed (ActionEvent e) { String no_iden, Nama, no_telp; no_iden = textno_iden.getText(); Nama = textNama.getText(); no_telp = textno_telp.getText(); //input ke database Koneksi open = new Koneksi (); Connection mysql = open.getConnection(); try { Statement stmt = mysql.createStatement(); String sql = "INSERT INTO penyewa VALUES ('"+no_iden+"','"+Nama+"','"+no_telp+"');"; int i = stmt.executeUpdate (sql); if (i == 1) { JOptionPane.showMessageDialog(null, "Tabel Penyewa Berhasil Disimpan"); } } catch (Exception ex) { JOptionPane.showMessageDialog(null, ex.getMessage()); } } });
3.2.2 Search Peminjam // button search buttonSearch.addActionListener ( new ActionListener() { public void actionPerformed (ActionEvent e) 15
{ String search; String no_iden, Nama, no_telp; Koneksi open = new Koneksi (); Connection mysql = open.getConnection(); try { search = textno_iden.getText(); Statement stmt = mysql.createStatement(); String sql = "SELECT * FROM penyewa WHERE no_iden like '"+search+"'"; ResultSet i = stmt.executeQuery (sql); if(i.next()) { textno_iden.setText(i.getString(1)); textNama.setText(i.getString(2)); textno_telp.setText(i.getString(3)); } else { JOptionPane.showMessageDialog(null, "Tabel Penyewa Tidak Ada"); } } catch (Exception ex) { JOptionPane.showMessageDialog(null, ex.getMessage()); } } }); 3.2.3 Update Peminjam // button update buttonUpdate.addActionListener ( new ActionListener() { public void actionPerformed (ActionEvent e) { String no_iden, Nama, no_telp; no_iden = textno_iden.getText(); Nama = textNama.getText(); no_telp = textno_telp.getText(); //input ke database Koneksi open = new Koneksi (); Connection mysql = open.getConnection(); try 16
{ Statement stmt = mysql.createStatement(); String sql = "Update penyewa SET no_iden='"+no_iden+ "',Nama='"+Nama+"',no_telp='"+no_telp+ "'WHERE no_iden='"+no_iden+"'"; int i = stmt.executeUpdate (sql); if (i == 1) JOptionPane.showMessageDialog(null, "Tabel Peminjam Berhasil Diupdate"); } catch (Exception ex) { JOptionPane.showMessageDialog(null, ex.getMessage()); } } });
3.2.4 Delete Peminjam // button delete buttonDelete.addActionListener ( new ActionListener() { public void actionPerformed (ActionEvent e) { String no_iden, Nama, no_telp; no_iden = textno_iden.getText(); Nama = textNama.getText(); no_telp = textno_telp.getText(); //input le database Koneksi open = new Koneksi (); Connection mysql = open.getConnection(); try { Statement stmt = mysql.createStatement(); String sql = "DELETE FROM penyewa WHERE no_iden='"+no_iden+"'"; int i = stmt.executeUpdate (sql); 17
if (i == 1) { JOptionPane.showMessageDialog(null,"Tabel Penyewa Berhasil Dihapus"); } } catch (Exception ex) { JOptionPane.showMessageDialog(null, ex.getMessage()); } }});
3.2.5 View Peminjam /* * Nony * 13111005 * */ import java.awt.*; import java.sql.*; import javax.swing.*; import javax.swing.table.*; public class View_penyewa extends JPanel { String[] header = {"No Identitas","Nama","No Telp"}; JTable table = new JTable(); JScrollPane scrollTable = new JScrollPane(); private Object[][] dataTable = null; View_penyewa() { Koneksi open = new Koneksi (); Connection mysql = open.getConnection(); try { Statement stmt = mysql.createStatement(); 18
String sql = "SELECT * FROM penyewa"; ResultSet rs = stmt.executeQuery(sql); ResultSetMetaData meta = rs.getMetaData(); int kolom = meta.getColumnCount(); int baris = 0; while(rs.next()) { baris = rs.getRow(); } dataTable = new Object[baris][kolom]; int x = 0; rs.beforeFirst(); while(rs.next()) { dataTable[x][0] = rs.getString("id_iden"); dataTable[x][1] = rs.getString("nama"); dataTable[x][2] = rs.getString("no_telp"); x++; } scrollTable.setViewportView(table); table.setModel(new DefaultTableModel(dataTable, header)); add(scrollTable, BorderLayout.NORTH); stmt.close(); rs.close(); } catch (Exception ex) { JOptionPane.showMessageDialog(null, "Data Peminjam Error"); } } void GUI() { JFrame frame = new JFrame("Data Peminjam"); frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); View_penyewa content = new View_penyewa(); content.setOpaque(true); frame.setContentPane(content); frame.pack(); frame.setLocationRelativeTo(null); frame.setVisible(true); }
19
public static void main(String [] args) { View_penyewa nony=new View_penyewa (); nony.GUI(); } }
3.3 Tabel Peminjaman /* * Nony * 13111005 * */ import java.awt.*; import javax.swing.*; import java.awt.event.*; import java.io.*; import java.sql.*; class peminjamaninput extends JFrame { JLabel labelid_peminjaman=new JLabel("Id Peminjam"); JTextField textid_peminjaman=new JTextField(30); JLabel labelno_iden=new JLabel("Nomor Identitas"); JTextField textno_iden=new JTextField(30); JLabel labelNama=new JLabel("Nama"); JTextField textNama=new JTextField(30); JLabel labelid_pelampung=new JLabel("Id Pelampung"); JTextField textid_pelampung=new JTextField(30); JLabel labeljenis_pelampung=new JLabel("Jenis Pelampung"); 20
String [] Gjenis_pelampung={"Anak-Anak","Dewasa"}; JComboBox combojenis_pelampung=new JComboBox(Gjenis_pelampung); JLabel labeljumlah_pinjam=new JLabel("Jumlah Pinjam"); JTextField textjumlah_pinjam=new JTextField(30); JLabel labeltarif=new JLabel("Tarif"); JTextField texttarif=new JTextField(30); JButton buttonSearch=new JButton("Search"); JButton buttonUpdate=new JButton("Update"); JButton buttonSave=new JButton("Save"); JButton buttonDelete=new JButton("Delete"); JButton buttonExit=new JButton("Exit"); peminjamaninput() { setTitle("Peminjaman"); setLocation(300,150); setSize(450,250); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); } void Label() { getContentPane().setLayout(null); getContentPane().add(labelid_peminjaman); labelid_peminjaman.setBounds(10,30,200,20); getContentPane().add(textid_peminjaman); textid_peminjaman.setBounds(150,30,200,20); getContentPane().add(labelno_iden); labelno_iden.setBounds(10,50,200,20); getContentPane().add(textno_iden); textno_iden.setBounds(150,50,200,20); getContentPane().add(labelNama); labelNama.setBounds(10,70,200,20); getContentPane().add(textNama); textNama.setBounds(150,70,200,20); getContentPane().add(labelid_pelampung); labelid_pelampung.setBounds(10,90,200,20); getContentPane().add(textid_pelampung); textid_pelampung.setBounds(150,90,200,20); getContentPane().add(labeljenis_pelampung);labeljenis_pelampung.setBounds(10,11 0,200,20); getContentPane().add(combojenis_pelampung);combojenis_pelampung.setBounds(15 0,110,200,18); getContentPane().add(labeljumlah_pinjam); labeljumlah_pinjam.setBounds(10,130,200,20); getContentPane().add(textjumlah_pinjam); textjumlah_pinjam.setBounds(150,130,200,20); getContentPane().add(labeltarif); labeltarif.setBounds(10,150,200,20); 21
getContentPane().add(texttarif); texttarif.setBounds(150,150,200,20); getContentPane().add(buttonSearch); buttonSearch.setBounds(300,3,110,20); getContentPane().add(buttonUpdate); buttonUpdate.setBounds(10,170,80,20); getContentPane().add(buttonSave);buttonSave.setBounds(100,170,80,20); getContentPane().add(buttonDelete);buttonDelete.setBounds(200,170,80,20); getContentPane().add(buttonExit);buttonExit.setBounds(300,170,80,20); setVisible(true); }
3.3.1 Save Peminjam //button save buttonSave.addActionListener ( new ActionListener() { public void actionPerformed (ActionEvent e) { String id_peminjaman, no_iden, Nama, id_pelampung, jenis_pelampung,jumlah_pinjam, tarif; id_peminjaman = textid_peminjaman.getText(); no_iden = textno_iden.getText(); Nama = textNama.getText(); id_pelampung = textid_pelampung.getText(); jenis_pelampung = (String) combojenis_pelampung.getSelectedItem(); jumlah_pinjam = textjumlah_pinjam.getText(); tarif = texttarif.getText(); //input ke database Koneksi open = new Koneksi (); Connection mysql = open.getConnection(); try 22
{ Statement stmt = mysql.createStatement(); String sql = "INSERT INTO peminjaman VALUES ('"+id_peminjaman+"','"+no_iden+"','"+Nama+"','"+id_pelampung+"','"+jenis_pelampung +"','"+jumlah_pinjam+"','"+tarif+"');"; int i = stmt.executeUpdate (sql); if (i == 1) { JOptionPane.showMessageDialog(null, "Tabel Peminjaman Berhasil Disimpan"); } } catch (Exception ex) { JOptionPane.showMessageDialog(null, ex.getMessage()); } } });
3.3.2 Search Peminjaman // button search buttonSearch.addActionListener ( new ActionListener() { public void actionPerformed (ActionEvent e) { String search; String id_peminjaman, no_iden, Nama, id_pelampung, jenis_pelampung, jumlah_pinjam, tarif; Koneksi open = new Koneksi (); Connection mysql = open.getConnection(); try { search=textid_peminjaman.getText(); 23
Statement stmt = mysql.createStatement(); String sql = "SELECT * FROM peminjaman WHERE id_peminjaman like '"+search+"'"; ResultSet i = stmt.executeQuery (sql); if(i.next()) { textid_peminjaman.setText(i.getString(1)); textno_iden.setText(i.getString(2)); textNama.setText(i.getString(3)); textid_pelampung.setText(i.getString(4)); combojenis_pelampung.setSelectedItem(i.getString(5)); textjumlah_pinjam.setText(i.getString(6)); texttarif.setText(i.getString(7)); } else { JOptionPane.showMessageDialog(null, "Tabel Peminjaman Tidak Ada"); } } catch (Exception ex) { JOptionPane.showMessageDialog(null, ex.getMessage()); } } }); 3.3.3 Update Peminjaman // button update buttonUpdate.addActionListener ( new ActionListener() { public void actionPerformed (ActionEvent e) { String id_peminjaman, no_iden, Nama, id_pelampung, jenis_pelampung, jumlah_pinjam, tarif; id_peminjaman = textid_peminjaman.getText(); no_iden = textno_iden.getText(); Nama = textNama.getText(); id_pelampung = textid_pelampung.getText(); jenis_pelampung = (String) combojenis_pelampung.getSelectedItem(); jumlah_pinjam = textjumlah_pinjam.getText(); tarif = texttarif.getText(); //input ke database Koneksi open = new Koneksi (); Connection mysql = open.getConnection(); try { Statement stmt = mysql.createStatement(); 24
String sql = "Update peminjaman SET id_peminjaman='"+id_peminjaman+"',no_iden='"+no_iden+"',Nama='"+Nama+"',id_pelamp ung='"+id_pelampung+"',jenis_pelampung='"+jenis_pelampung+"',jumlah_pinjam='"+jumlah _pinjam+"',tarif='"+tarif+ "'WHERE no_iden='"+no_iden+"'"; int i = stmt.executeUpdate (sql); if (i == 1) JOptionPane.showMessageDialog(null, "Tabel Peminjaman Berhasil Diupdate"); } catch (Exception ex)
{ JOptionPane.showMessageDialog(null, ex.getMessage()); } } });
3.3.4 Delete Peminjaman // button delete buttonDelete.addActionListener ( new ActionListener() { public void actionPerformed (ActionEvent e) { String id_peminjaman, no_iden, Nama, id_pelampung, jenis_pelampung, jumlah_pinjam, tarif; id_peminjaman = textid_peminjaman.getText(); no_iden = textno_iden.getText(); Nama = textNama.getText(); id_pelampung = textid_pelampung.getText(); jenis_pelampung = (String) combojenis_pelampung.getSelectedItem(); jumlah_pinjam = textjumlah_pinjam.getText(); 25
tarif = texttarif.getText(); //input ke database Koneksi open = new Koneksi (); Connection mysql = open.getConnection(); try { Statement stmt = mysql.createStatement(); String sql = "DELETE FROM peminjaman WHERE id_peminjaman='"+id_peminjaman+"'"; int i = stmt.executeUpdate (sql); if (i == 1) { JOptionPane.showMessageDialog(null,"Tabel Peminjaman Berhasil Dihapus"); } } catch (Exception ex) { JOptionPane.showMessageDialog(null, ex.getMessage()); } }}); 3.3.5 View Peminjaman /* * Nony * 13111005 * */ import java.awt.*; import java.sql.*; import javax.swing.*; import javax.swing.table.*; public class View_peminjaman extends JPanel { String[] header = {"id_peminajman","no_iden","nama","id_pelampung","jenis_pelampung","jumlah_pinjam", "tarif"}; JTable table = new JTable(); JScrollPane scrollTable = new JScrollPane(); private Object[][] dataTable = null; View_peminjaman() { Koneksi open = new Koneksi (); Connection mysql = open.getConnection(); try { Statement stmt = mysql.createStatement(); String sql = "SELECT * FROM peminjaman"; 26
ResultSet rs = stmt.executeQuery(sql); ResultSetMetaData meta = rs.getMetaData(); int kolom = meta.getColumnCount(); int baris = 0; while(rs.next()) { baris = rs.getRow(); } dataTable = new Object[baris][kolom]; int x = 0; rs.beforeFirst(); while(rs.next()) { dataTable[x][0] = rs.getString("id_peminjaman"); dataTable[x][1] = rs.getString("no_iden"); dataTable[x][2] = rs.getString("nama"); dataTable[x][3] = rs.getString("id_pelampung"); dataTable[x][4] = rs.getString("jenis_pelampung"); dataTable[x][5] = rs.getString("jumlah_pinjam"); dataTable[x][6] = rs.getString("tarif"); x++; } scrollTable.setViewportView(table); table.setModel(new DefaultTableModel(dataTable, header)); add(scrollTable, BorderLayout.NORTH); stmt.close(); rs.close(); } catch (Exception ex) { JOptionPane.showMessageDialog(null, "Data Peminjaman Error"); } } void GUI() { JFrame frame = new JFrame("Data Peminjaman"); frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); View_peminjaman content = new View_peminjaman(); content.setOpaque(true); frame.setContentPane(content); frame.pack(); 27
frame.setLocationRelativeTo(null); frame.setVisible(true); } public static void main(String [] args) { View_peminjaman nony=new View_peminjaman (); nony.GUI(); } }
BAB IV - MENU 4.1 MENU import javax.swing.*; import java.awt.event.*; public class Menu extends JFrame { JMenuBar menuContoh=new JMenuBar(); JMenu File=new JMenu("File"); JMenu OpenSubMenu=new JMenu("View"); JMenuItem View_pelampung=new JMenuItem("Data Pelampung"); JMenuItem View_penyewa=new JMenuItem("Data Peminjam"); JMenuItem View_peminjaman=new JMenuItem("Data Peminjaman"); JMenuItem Exit=new JMenuItem("Exit"); JMenu data=new JMenu("Data"); JMenuItem pelampunginput=new JMenuItem("Data Pelampung"); JMenuItem penyewainput=new JMenuItem("Data Peminjam"); JMenuItem peminjamaninput=new JMenuItem("Data Peminjaman"); JMenu About=new JMenu("About"); JMenuItem AboutDialog=new JMenuItem("About Us"); View_pelampung Inputpelampung=new View_pelampung(); View_penyewa InputPenyewa=new View_penyewa(); View_peminjaman InputPeminjaman=new View_peminjaman(); 28
Menu() { setTitle("Form Menu Utama"); setLocation(300,100); setSize(500,350); setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE); } void GUI() { setJMenuBar(menuContoh); menuContoh.add(File); File.add(OpenSubMenu); OpenSubMenu.add(View_pelampung); OpenSubMenu.add(View_penyewa); OpenSubMenu.add(View_peminjaman); File.add(Exit); menuContoh.add(data); data.add (pelampunginput); data.add(penyewainput); data.add(peminjamaninput); menuContoh.add(About); About.add(AboutDialog); setVisible(true); } void Perintahku() { //view View_pelampung.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { View_pelampung view = new View_pelampung(); view.GUI(); } }); View_penyewa.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { View_penyewa view = new View_penyewa(); view.GUI(); } 29
}); View_peminjaman.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { View_peminjaman view = new View_peminjaman(); view.GUI(); } }); //Exit Exit.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ System.exit(0); } }); //input pelampung pelampunginput.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ pelampunginput nony= new pelampunginput(); nony.Label(); nony.Perintah(); } }); //input penyewa penyewainput.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ penyewainput nony = new penyewainput(); nony.Label(); nony.Perintah(); } }); //input peminjaman peminjamaninput.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ peminjamaninput view = new peminjamaninput(); view.Label(); view.Perintah(); } }); //about 30
AboutDialog.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ JOptionPane.showMessageDialog(null,"Create By: Nony Oktavinai", "About", JOptionPane.INFORMATION_MESSAGE); } }); } public static void main(String[]nap) { Menu nony=new Menu(); nony.GUI(); nony.Perintahku(); } }
31
BAB V – PENUTUP 5.1 Kesimpulan Hasil program running semua.
5.2 Kesulitan Dalam menulis koding harus teliti , huruf besar dan kecil , dan kadang juga error terlalu banyak .
32
