Disini saya membuat program (Data Base) pembayaran angsuran (lising) pembalian kendaraan.
disini saya menggunakan:
-Label
-Tetx field
-Combo Box
-Botton
-Jframe
screenshoot design dan databaseny beserta sourch ny adalah sebagai berikut:
* 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 uts18july2017mitha;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;
/**
*
* @author Mitha
Sitanggang
*/
public class bayar extends javax.swing.JFrame {
Connection db;
Statement b;
ResultSet h;
String query;
String nama,ktp,alamat,jenis,tempo,bayar,sktp;
String nm, almt, nktp, tnr,dnd,tmp,knd;
int id;
/**
* Creates new
form bayar
*/
public bayar() {
initComponents();
}
void dataDaftar(){
nama =(String)
NAMABAYAR.getText();
ktp =(String)
KTPB.getText();
alamat =(String)
ALAMATB.getText();
tempo =(String)
TEMPOB.getText();
bayar =(String)
BAYARB.getText();
}
void koneksi()
throws SQLException{
dataDaftar();
db =
DriverManager.getConnection("jdbc:mysql://localhost/credit","root","");
Statement st =
db.createStatement();
sktp = (String) KTPBAYAR.getText();
h =
st.executeQuery("select nama,noktp,alamat,kendaraan,tempo,denda,tenor from
daftar where noktp='"+ sktp +"'");
while(h.next()){
nm =
h.getString("nama");
almt = h.getString("alamat");
nktp =
h.getString("noktp");
tnr =
h.getString("tenor");
// id =
h.getInt("id");
dnd =
h.getString("denda");
tmp =
h.getString("tempo");
knd =
h.getString("kendaraan");
}
NAMABAYAR.setText(nm);
KTPB.setText(nktp);
ALAMATB.setText(almt);
JENISB.setText(knd);
TENORB.setText(tnr);
TEMPOB.setText(tmp);
// PreparedStatement
d = db.prepareStatement(query);
// d.execute();
}
void bayar()
throws SQLException{
koneksi();
bayar =
BAYARB.getText();
query="insert into bayar(noktp,bayar)
values('"+nktp+"','"+ bayar +"')";
PreparedStatement d = db.prepareStatement(query);
d.execute();
}
/**
* 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() {
jLabel1 = new
javax.swing.JLabel();
jLabel2 = new
javax.swing.JLabel();
KTPBAYAR = new
javax.swing.JTextField();
jPanel1 = new
javax.swing.JPanel();
jLabel3 = new
javax.swing.JLabel();
jLabel4 = new
javax.swing.JLabel();
jLabel5 = new
javax.swing.JLabel();
jLabel6 = new
javax.swing.JLabel();
jLabel7 = new
javax.swing.JLabel();
jLabel8 = new
javax.swing.JLabel();
jLabel9 = new
javax.swing.JLabel();
NAMABAYAR =
new javax.swing.JTextField();
KTPB = new
javax.swing.JTextField();
jScrollPane1 =
new javax.swing.JScrollPane();
ALAMATB = new
javax.swing.JTextArea();
JENISB = new
javax.swing.JTextField();
TENORB = new javax.swing.JTextField();
TEMPOB = new
javax.swing.JTextField();
BAYARB = new
javax.swing.JTextField();
jButton1 = new
javax.swing.JButton();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
jLabel1.setText("PEMBAYARAN ANGSURAN");
jLabel2.setText("NO.KTP");
KTPBAYAR.addActionListener(new java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
KTPBAYARActionPerformed(evt);
}
});
jLabel3.setText("NAMA");
jLabel4.setText("NO.KTP");
jLabel5.setText("ALAMAT");
jLabel6.setText("JENIS KENDARAAN");
jLabel7.setText("TENOR");
jLabel8.setText("JATUH TEMPO");
jLabel9.setText("BAYAR");
NAMABAYAR.setEnabled(false);
KTPB.setEnabled(false);
KTPB.addActionListener(new java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
KTPBActionPerformed(evt);
}
});
ALAMATB.setColumns(20);
ALAMATB.setRows(5);
ALAMATB.setEnabled(false);
ALAMATB.setFocusCycleRoot(true);
ALAMATB.setFocusTraversalPolicyProvider(true);
jScrollPane1.setViewportView(ALAMATB);
JENISB.setEnabled(false);
JENISB.addActionListener(new java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
JENISBActionPerformed(evt);
}
});
TENORB.setEnabled(false);
TENORB.addActionListener(new java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
TENORBActionPerformed(evt);
}
});
TEMPOB.setEnabled(false);
jButton1.setText("Bayar");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public
void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
javax.swing.GroupLayout jPanel1Layout = new
javax.swing.GroupLayout(jPanel1);
jPanel1.setLayout(jPanel1Layout);
jPanel1Layout.setHorizontalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 62,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel4)
.addComponent(jLabel5)
.addComponent(jLabel6)
.addComponent(jLabel7)
.addComponent(jLabel8)
.addComponent(jLabel9))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jButton1)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING,
false)
.addComponent(NAMABAYAR)
.addComponent(KTPB)
.addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 173,
Short.MAX_VALUE)
.addComponent(JENISB)
.addComponent(BAYARB)
.addComponent(TENORB)
.addComponent(TEMPOB)))
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE,
Short.MAX_VALUE))
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel3)
.addComponent(NAMABAYAR, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel4)
.addComponent(KTPB, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 40,
Short.MAX_VALUE)
.addComponent(jLabel5)
.addGap(65, 65, 65)
.addComponent(jLabel6)
.addGap(18, 18, 18)
.addComponent(jLabel7)
.addGap(22, 22, 22))
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(30, 30, 30)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 86,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(JENISB, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(TENORB, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(4, 4, 4)
.addComponent(jLabel8))
.addComponent(TEMPOB, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(BAYARB, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel9))
.addGap(11, 11, 11)
.addComponent(jButton1))
);
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(130,
130, 130)
.addComponent(jLabel1))
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 61,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(40, 40,
40)
.addComponent(KTPBAYAR,
javax.swing.GroupLayout.PREFERRED_SIZE, 259,
javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGap(0, 17, Short.MAX_VALUE))
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))
.addContainerGap())
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jLabel1)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel2)
.addComponent(KTPBAYAR, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addGap(62, 62, 62))
);
pack();
}//
</editor-fold>
private void
KTPBActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add
your handling code here:
}
private void
TENORBActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add
your handling code here:
}
private void JENISBActionPerformed(java.awt.event.ActionEvent
evt) {
// TODO add
your handling code here:
}
private void
KTPBAYARActionPerformed(java.awt.event.ActionEvent evt) {
try {
// TODO
add your handling code here:
koneksi();
//
BAYARB.setText(bayar);
} catch
(SQLException ex) {
Logger.getLogger(bayar.class.getName()).log(Level.SEVERE, null, ex);
}
}
private void
jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
try {
// TODO
add your handling code here:
bayar();
} catch
(SQLException ex) {
Logger.getLogger(bayar.class.getName()).log(Level.SEVERE, null, ex);
}
}
/**
* @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(bayar.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
} catch
(InstantiationException ex) {
java.util.logging.Logger.getLogger(bayar.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
} catch
(IllegalAccessException ex) {
java.util.logging.Logger.getLogger(bayar.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
} catch
(javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(bayar.class.getName()).log(java.util.logging.Level.SEVERE,
null, ex);
}
//</editor-fold>
/* Create and
display the form */
java.awt.EventQueue.invokeLater(new
Runnable() {
public
void run() {
new
bayar().setVisible(true);
}
});
}
// Variables
declaration - do not modify
private
javax.swing.JTextArea ALAMATB;
private
javax.swing.JTextField BAYARB;
private
javax.swing.JTextField JENISB;
private
javax.swing.JTextField KTPB;
private
javax.swing.JTextField KTPBAYAR;
private
javax.swing.JTextField NAMABAYAR;
private
javax.swing.JTextField TEMPOB;
private
javax.swing.JTextField TENORB;
private
javax.swing.JButton jButton1;
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.JLabel jLabel7;
private
javax.swing.JLabel jLabel8;
private
javax.swing.JLabel jLabel9;
private
javax.swing.JPanel jPanel1;
private
javax.swing.JScrollPane jScrollPane1;
// End of
variables declaration
}
