private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
try{
if(!(cnama.getText()).trim().equals("")){
String SQL ="select count (*) from customer where nama_customer='" + cnama.getText()+"'";
int jmlRekord = getJumlahRekord(SQL);
if (jmlRekord == 0){
perintahSQL="insert into customer cr";
perintahSQL="INNER JOIN telpon tp ON tp.id_telpon = cr.id_telpon";
perintahSQL="INNER JOIN spedamotor sr ON sr.id_kendaraan = cr.id_kendaraan";
perintahSQL="(nama_customer,alamat,nomor_telpon"+"merek_kendaraan,jenis_kendaraan,no_pol,warna)";
perintahSQL +=" values (";
perintahSQL +=" '"+cnama.getText() + "'";
perintahSQL +=" ,'"+clamat.getText() + "'";
perintahSQL +=" ,'"+ctelp.getText() + "'";
perintahSQL +=" ,'"+cmerek.getText() + "'";
perintahSQL +=" ,'"+cjenisken.getText() + "'";
perintahSQL +=" ,'"+cnopol.getText() + "'";
perintahSQL +=" ,'"+cwarna.getText() + "'";
perintahSQL +=")";
ExecSQL(perintahSQL);
}
else {
pesan.showMessageDialog(this, " Data tersebut telah ada di dalam database");
bersihkanGrind();
}
}
}catch (Exception e){
System.err.println("SQL Exception : " + e.getMessage());
} // TODO add your h
}