public void baru(){
Date date =new Date();
SimpleDateFormat sdf = new SimpleDateFormat("yyMM");
String time = sdf.format(date);
try{
Koneksi con = new Koneksi();
con.bukaKoneksi();
con.statement = con.dbKoneksi.createStatement();
ResultSet rs = con.statement.executeQuery("select right(id_jual,4) as kd from penjualan");
if (rs.first()==false){
txtNoJual.setText(time+"0001");
}else{
rs.last();
int no = rs.getInt(1)+1;
String cno = String.valueOf(no);
int pjg_cno = cno.length();
for (int i=0;i<4-pjg_cno;i++){
cno = "0"+cno;
}
txtNoJual.setText(time+cno);
}
}catch (Exception e){
JOptionPane.showMessageDialog(null, "Koneksi Database Gagal!");
}
}