22 0 484 KB
Membuat Form Nota
JSpinner Setting Properties -> Pilih Model (…)
1. Import dan Method Pop Up Pelanggan package penjualan; import java.sql.*; import java.text.SimpleDateFormat; import javax.swing.JOptionPane; import javax.swing.table.DefaultTableModel; import javax.swing.JSpinner; import koneksi.koneksi; public class Nota extends javax.swing.JFrame { public String id, nama, jenis, telp, almt; public String kdbrg, nmbrg, jenisbrg, hb, hj; private Connection conn = new koneksi().connect(); private DefaultTableModel tabmode; Object[] Baris ={"KD Barang","Nama","Harga Beli","Harga Jual","QTY","Total"}; public Nota() { initComponents(); kosong(); aktif(); autonumber(); }
2. Method Aktif protected void aktif(){ txtqty.requestFocus(); jtgl.setEditor(new JSpinner.DateEditor(jtgl,"yyyy/MM/dd")); tabmode = new DefaultTableModel(null, Baris); tbltransaksi.setModel(tabmode); } 3. Method Kosong protected void kosong(){ txtid.setText(""); txtnm.setText(""); txtalmt.setText(""); txtkdbrg.setText(""); txtnmbrg.setText(""); txthb.setText(""); txthj.setText(""); txtqty.setText(""); txttotal.setText(""); } 4. Method Auto Number protected void autonumber(){ String idnota=""; try{ String sql = "SELECT idnota FROM nota order by idnota asc"; PreparedStatement stat = conn.prepareStatement(sql); ResultSet rs=stat.executeQuery(sql); while(rs.next()){ idnota=rs.getString("idnota"); } }catch(SQLException sqle){idnota="";} if(idnota.length()