package perpustakaan;
import javax.swing.JOptionPane;
import java.awt.event.*;
import java.sql.*;
import java.util.HashMap;
import java.util.Map;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JasperCompileManager;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.JasperReport;
import net.sf.jasperreports.view.JasperViewer;
/*
* 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.
*/
/**
*
* @author 840076
*/
public class PeminjamanBuku extends javax.swing.JFrame {
Connection koneksi;
/**
* Creates new form InputPengembalianBuku
*/
public PeminjamanBuku() {
initComponents();
}
/**
* 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() {
jDesktopPane2 = new javax.swing.JDesktopPane();
jPanel2 = new javax.swing.JPanel();
btnsave = new javax.swing.JButton();
BtnCetak = new javax.swing.JButton();
txttglk = new javax.swing.JTextField();
jLabel4 = new javax.swing.JLabel();
jLabel15 = new javax.swing.JLabel();
jLabel16 = new javax.swing.JLabel();
txttotalsewa = new javax.swing.JTextField();
txtsewa = new javax.swing.JTextField();
txtlamapinjam = new javax.swing.JTextField();
jLabel17 = new javax.swing.JLabel();
BtnExit = new javax.swing.JButton();
BtnProses = new javax.swing.JButton();
jLabel18 = new javax.swing.JLabel();
jLabel19 = new javax.swing.JLabel();
txtpenerbit = new javax.swing.JTextField();
jLabel20 = new javax.swing.JLabel();
txtjudul = new javax.swing.JTextField();
jLabel21 = new javax.swing.JLabel();
txtnama = new javax.swing.JTextField();
jLabel22 = new javax.swing.JLabel();
txtnim = new javax.swing.JTextField();
jLabel23 = new javax.swing.JLabel();
jLabel24 = new javax.swing.JLabel();
jLabel25 = new javax.swing.JLabel();
txttglp = new javax.swing.JTextField();
jPanel1 = new javax.swing.JPanel();
jButton1 = new javax.swing.JButton();
jLabel8 = new javax.swing.JLabel();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
addWindowListener(new java.awt.event.WindowAdapter() {
public void windowActivated(java.awt.event.WindowEvent evt) {
formWindowActivated(evt);
}
});
jDesktopPane2.setBackground(new java.awt.Color(153, 153, 153));
jPanel2.setBackground(new java.awt.Color(0, 153, 255));
btnsave.setBackground(new java.awt.Color(255, 102, 102));
btnsave.setFont(new java.awt.Font("DejaVu Sans Condensed", 1, 12)); // NOI18N
btnsave.setForeground(new java.awt.Color(0, 0, 102));
btnsave.setText("Save");
btnsave.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnsaveActionPerformed(evt);
}
});
BtnCetak.setBackground(new java.awt.Color(255, 102, 102));
BtnCetak.setFont(new java.awt.Font("DejaVu Sans Condensed", 1, 12)); // NOI18N
BtnCetak.setForeground(new java.awt.Color(0, 0, 102));
BtnCetak.setText("Report");
BtnCetak.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
BtnCetakActionPerformed(evt);
}
});
jLabel4.setFont(new java.awt.Font("DejaVu Sans Condensed", 1, 12)); // NOI18N
jLabel4.setForeground(new java.awt.Color(0, 0, 102));
jLabel4.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel4.setText("Lama Pinjam");
jLabel15.setFont(new java.awt.Font("DejaVu Sans Condensed", 1, 12)); // NOI18N
jLabel15.setForeground(new java.awt.Color(0, 0, 102));
jLabel15.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
jLabel15.setText("Total");
jLabel16.setFont(new java.awt.Font("DejaVu Sans Condensed", 1, 12)); // NOI18N
jLabel16.setForeground(new java.awt.Color(0, 0, 102));
jLabel16.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
jLabel16.setText("Sewa per hari");
txttotalsewa.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
txttotalsewa.setHorizontalAlignment(javax.swing.JTextField.LEFT);
txttotalsewa.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
txttotalsewaActionPerformed(evt);
}
});
txtsewa.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
txtsewa.setHorizontalAlignment(javax.swing.JTextField.LEFT);
txtsewa.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
txtsewaActionPerformed(evt);
}
});
txtlamapinjam.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
txtlamapinjam.setHorizontalAlignment(javax.swing.JTextField.LEFT);
jLabel17.setFont(new java.awt.Font("DejaVu Sans Condensed", 1, 12)); // NOI18N
jLabel17.setForeground(new java.awt.Color(0, 0, 102));
jLabel17.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel17.setText("Tgl Kembali");
BtnExit.setBackground(new java.awt.Color(255, 102, 102));
BtnExit.setFont(new java.awt.Font("DejaVu Sans Condensed", 1, 12)); // NOI18N
BtnExit.setForeground(new java.awt.Color(0, 0, 102));
BtnExit.setText("Exit");
BtnExit.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
BtnExitActionPerformed(evt);
}
});
BtnProses.setBackground(new java.awt.Color(255, 102, 102));
BtnProses.setFont(new java.awt.Font("DejaVu Sans Condensed", 1, 12)); // NOI18N
BtnProses.setForeground(new java.awt.Color(0, 0, 102));
BtnProses.setText("Proses");
BtnProses.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
BtnProsesActionPerformed(evt);
}
});
jLabel18.setFont(new java.awt.Font("DejaVu Sans Condensed", 1, 12)); // NOI18N
jLabel18.setForeground(new java.awt.Color(0, 0, 102));
jLabel18.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel18.setText("Tgl Pinjam");
jLabel19.setFont(new java.awt.Font("DejaVu Sans Condensed", 1, 12)); // NOI18N
jLabel19.setForeground(new java.awt.Color(0, 0, 102));
jLabel19.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel19.setText("Penerbit");
txtpenerbit.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
txtpenerbit.setHorizontalAlignment(javax.swing.JTextField.LEFT);
txtpenerbit.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
txtpenerbitActionPerformed(evt);
}
});
jLabel20.setFont(new java.awt.Font("DejaVu Sans Condensed", 1, 12)); // NOI18N
jLabel20.setForeground(new java.awt.Color(0, 0, 102));
jLabel20.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel20.setText("Judul Buku");
txtjudul.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
txtjudul.setHorizontalAlignment(javax.swing.JTextField.LEFT);
txtjudul.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
txtjudulActionPerformed(evt);
}
});
jLabel21.setFont(new java.awt.Font("DejaVu Sans Condensed", 1, 12)); // NOI18N
jLabel21.setForeground(new java.awt.Color(0, 0, 102));
jLabel21.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel21.setText("Nama Mahasiswa");
txtnama.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
txtnama.setHorizontalAlignment(javax.swing.JTextField.LEFT);
txtnama.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
txtnamaActionPerformed(evt);
}
});
jLabel22.setBackground(new java.awt.Color(255, 255, 255));
jLabel22.setFont(new java.awt.Font("DejaVu Sans Condensed", 1, 12)); // NOI18N
jLabel22.setForeground(new java.awt.Color(0, 0, 102));
jLabel22.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel22.setText("NIM");
txtnim.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
txtnim.setHorizontalAlignment(javax.swing.JTextField.LEFT);
txtnim.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
txtnimActionPerformed(evt);
}
});
jLabel23.setFont(new java.awt.Font("DejaVu Sans Condensed", 1, 12)); // NOI18N
jLabel23.setForeground(new java.awt.Color(0, 0, 102));
jLabel23.setText("dd/mm/yyyy");
jLabel24.setFont(new java.awt.Font("DejaVu Sans Condensed", 1, 12)); // NOI18N
jLabel24.setForeground(new java.awt.Color(0, 0, 102));
jLabel24.setText("dd/mm/yyyy");
jLabel25.setFont(new java.awt.Font("DejaVu Sans Condensed", 1, 12)); // NOI18N
jLabel25.setForeground(new java.awt.Color(0, 0, 102));
jLabel25.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
jLabel25.setText("Hari");
javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
jPanel2.setLayout(jPanel2Layout);
jPanel2Layout.setHorizontalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addGap(67, 67, 67)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addComponent(jLabel22)
.addGap(155, 155, 155)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(txtnama, javax.swing.GroupLayout.PREFERRED_SIZE, 181, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(txtnim, javax.swing.GroupLayout.PREFERRED_SIZE, 181, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(txtjudul, javax.swing.GroupLayout.PREFERRED_SIZE, 181, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(txtpenerbit, javax.swing.GroupLayout.PREFERRED_SIZE, 181, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(jPanel2Layout.createSequentialGroup()
.addComponent(txttglp, javax.swing.GroupLayout.PREFERRED_SIZE, 110, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jLabel23))
.addGroup(jPanel2Layout.createSequentialGroup()
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(txtlamapinjam, javax.swing.GroupLayout.PREFERRED_SIZE, 108, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(txttglk, javax.swing.GroupLayout.PREFERRED_SIZE, 110, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(txtsewa, javax.swing.GroupLayout.PREFERRED_SIZE, 108, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(txttotalsewa, javax.swing.GroupLayout.PREFERRED_SIZE, 108, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel24)
.addComponent(jLabel25, javax.swing.GroupLayout.PREFERRED_SIZE, 36, javax.swing.GroupLayout.PREFERRED_SIZE))))
.addGap(0, 170, Short.MAX_VALUE))
.addGroup(jPanel2Layout.createSequentialGroup()
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel21)
.addComponent(jLabel20)
.addComponent(jLabel19)
.addComponent(jLabel18)
.addComponent(jLabel17)
.addComponent(jLabel4)
.addComponent(jLabel16)
.addComponent(jLabel15)
.addGroup(jPanel2Layout.createSequentialGroup()
.addComponent(BtnProses, javax.swing.GroupLayout.PREFERRED_SIZE, 85, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(31, 31, 31)
.addComponent(btnsave, javax.swing.GroupLayout.PREFERRED_SIZE, 85, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(31, 31, 31)
.addComponent(BtnCetak, javax.swing.GroupLayout.PREFERRED_SIZE, 86, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(29, 29, 29)
.addComponent(BtnExit, javax.swing.GroupLayout.PREFERRED_SIZE, 86, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))))
);
jPanel2Layout.setVerticalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addGap(50, 50, 50)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(txtnim, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel22))
.addGap(18, 18, 18)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(txtnama, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel21))
.addGap(18, 18, 18)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(txtjudul, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel20))
.addGap(18, 18, 18)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(txtpenerbit, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel19))
.addGap(18, 18, 18)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(txttglp, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel23)
.addComponent(jLabel18))
.addGap(18, 18, 18)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(txttglk, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel24, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel17))
.addGap(18, 18, 18)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(txtlamapinjam, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel25)
.addComponent(jLabel4))
.addGap(18, 18, 18)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(txtsewa, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel16))
.addGap(18, 18, 18)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(txttotalsewa, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel15))
.addGap(55, 55, 55)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(BtnProses)
.addComponent(BtnCetak)
.addComponent(BtnExit)
.addComponent(btnsave))
.addGap(79, 79, 79))
);
jPanel1.setBackground(new java.awt.Color(204, 204, 255));
jPanel1.setForeground(new java.awt.Color(255, 255, 255));
jButton1.setBackground(new java.awt.Color(255, 255, 255));
jButton1.setFont(new java.awt.Font("Tahoma", 0, 24)); // NOI18N
jButton1.setIcon(new javax.swing.ImageIcon("C:\\Users\\840076\\Pictures\\2017-10-26\\library.png")); // NOI18N
jLabel8.setBackground(new java.awt.Color(255, 255, 255));
jLabel8.setFont(new java.awt.Font("DejaVu Sans Condensed", 3, 24)); // NOI18N
jLabel8.setForeground(new java.awt.Color(0, 0, 102));
jLabel8.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
jLabel8.setText("PEMINJAMAN BUKU PERPUSTAKAAN");
javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
jPanel1.setLayout(jPanel1Layout);
jPanel1Layout.setHorizontalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 87, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(26, 26, 26)
.addComponent(jLabel8)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jButton1)
.addGap(0, 0, Short.MAX_VALUE))
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(24, 24, 24)
.addComponent(jLabel8)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
jDesktopPane2.setLayer(jPanel2, javax.swing.JLayeredPane.DEFAULT_LAYER);
jDesktopPane2.setLayer(jPanel1, javax.swing.JLayeredPane.DEFAULT_LAYER);
javax.swing.GroupLayout jDesktopPane2Layout = new javax.swing.GroupLayout(jDesktopPane2);
jDesktopPane2.setLayout(jDesktopPane2Layout);
jDesktopPane2Layout.setHorizontalGroup(
jDesktopPane2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jDesktopPane2Layout.createSequentialGroup()
.addGap(0, 0, Short.MAX_VALUE)
.addGroup(jDesktopPane2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))
);
jDesktopPane2Layout.setVerticalGroup(
jDesktopPane2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jDesktopPane2Layout.createSequentialGroup()
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
);
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jDesktopPane2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jDesktopPane2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
);
pack();
}// </editor-fold>
public void buka_db() {
try {
Class.forName("com.mysql.jdbc.Driver");
koneksi = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/perpustakaan_buku", "root", "");
} catch (ClassNotFoundException e) {
System.out.println("Error #1 " + e.getMessage());
System.exit(0);
} catch (SQLException e) {
System.out.println("Error #2 : " + e.getMessage());
System.exit(0);
}
}
public void bersihkan(){
txtnim.setText("");
txtnama.setText("");
txtjudul.setText("");
txtpenerbit.setText("");
txttglp.setText("");
txttglk.setText("");
txtlamapinjam.setText("");
txtsewa.setText("");
txttotalsewa.setText("");
}
private void formWindowActivated(java.awt.event.WindowEvent evt) {
// TODO add your handling code here:
buka_db();
}
private void txtnimActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void txtnamaActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void txtjudulActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void txtpenerbitActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void BtnProsesActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
int i=Integer.parseInt(txtlamapinjam.getText());
int j=Integer.parseInt(txtsewa.getText());
int hasil=i*j;
txttotalsewa.setText(""+hasil);
}
private void BtnExitActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
if(JOptionPane.showConfirmDialog(null,"Yakin Keluar","Konfirmasi",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE)==JOptionPane.YES_OPTION){;
System.exit(0);
}
}
private void txtsewaActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void txttotalsewaActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void BtnCetakActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
buka_db();
try {
koneksi.createStatement();
Map<String, Object> maps = new HashMap<String, Object>();
JasperReport JRP;
JRP = JasperCompileManager.compileReport("src/perpustakaan/lap.peminjamanbuku.jrxml");
JasperPrint JFILL = JasperFillManager.fillReport(JRP, maps, koneksi);
JasperViewer.viewReport(JFILL, false);
} catch (SQLException rptexcpt) {
JOptionPane.showMessageDialog(this, rptexcpt.getMessage());
System.out.println(rptexcpt);
} catch (JRException rptexcpt) {
JOptionPane.showMessageDialog(this, rptexcpt.getMessage());
System.out.println(rptexcpt);
}
}
private void btnsaveActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try{
String host = "jdbc:mysql://localhost:3306/perpustakaan_buku",
user ="root",
pass ="";
Connection con = (Connection) DriverManager.getConnection(host, user, pass);
String Nim=txtnim.getText();
String Nama=txtnama.getText();
String Judul=txtjudul.getText();
String Penerbit=txtpenerbit.getText();
String TglPinjam=txttglp.getText();
String TglKembali=txttglk.getText();
int LamaPinjam=Integer.parseInt(txtlamapinjam.getText());
int Sewa=Integer.parseInt(txtsewa.getText());
int Total=Integer.parseInt(txttotalsewa.getText());
Statement st=con.createStatement();
st.executeUpdate("INSERT INTO peminjaman_buku ( NIM , Nama_Mahasiswa , Judul_Buku , Penerbit , Tgl_pinjam , Tgl_kembali , Lama_pinjam , Sewa_perhari , Total ) VALUES ( '"+Nim+"','"+Nama+"' ,'"+Judul+"' , '"+Penerbit+"' , '"+TglPinjam+"' , '"+TglKembali+"' , "+LamaPinjam+" , "+Sewa+" , "+Total+")");
st.close();
JOptionPane.showMessageDialog(null,"Berhasil");
bersihkan();
} catch (SQLException err){
JOptionPane.showMessageDialog(null,err.getMessage());
}
}
/**
* @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(PeminjamanBuku.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(PeminjamanBuku.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(PeminjamanBuku.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(PeminjamanBuku.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
}
//</editor-fold>
//</editor-fold>
/* Create and display the form */
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new PeminjamanBuku().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JButton BtnCetak;
private javax.swing.JButton BtnExit;
private javax.swing.JButton BtnProses;
private javax.swing.JButton btnsave;
private javax.swing.JButton jButton1;
private javax.swing.JDesktopPane jDesktopPane2;
private javax.swing.JLabel jLabel15;
private javax.swing.JLabel jLabel16;
private javax.swing.JLabel jLabel17;
private javax.swing.JLabel jLabel18;
private javax.swing.JLabel jLabel19;
private javax.swing.JLabel jLabel20;
private javax.swing.JLabel jLabel21;
private javax.swing.JLabel jLabel22;
private javax.swing.JLabel jLabel23;
private javax.swing.JLabel jLabel24;
private javax.swing.JLabel jLabel25;
private javax.swing.JLabel jLabel4;
private javax.swing.JLabel jLabel8;
private javax.swing.JPanel jPanel1;
private javax.swing.JPanel jPanel2;
private javax.swing.JTextField txtjudul;
private javax.swing.JTextField txtlamapinjam;
private javax.swing.JTextField txtnama;
private javax.swing.JTextField txtnim;
private javax.swing.JTextField txtpenerbit;
private javax.swing.JTextField txtsewa;
private javax.swing.JTextField txttglk;
private javax.swing.JTextField txttglp;
private javax.swing.JTextField txttotalsewa;
// End of variables declaration
}
Demikian penjelasan sederhana mengenai Program Algoritma saya, semoga bermanfaat dan mohon maaf jika banyak kekurangan didalamnya. Terimakasih. 😊
Wassalamu'alaikum Wr.Wb
Video Singkat Aplikasi "Perpustakaan"