Aplikasi Penjualan Komputer Sederhana Menggunakan GUI Java Netbeans dan CRUD
- Foto Lembar Jawaban
 |
| Lembar Jawaban |
- Deskripsi
Aplikasi ini adalah sebuah program yang menggunakan bahasa pemrograman java dan tempilan menggunan Netbean, data user terhubung kedalam database MySQL. Mula-mula ketika program di jalankan user harus menginput user_name dan password untuk login, jika user tidak ada maka user dapan membuat data user baru. Setelah user berhasil ligin, user akan melihat menu penjualan komputer. Terdapat 2 pilihan menu untuk membeli komputer, pertama menu paket yang berisi spesifikasi perangkat beserta harganya dan bisa juga user memilih upgrade beberapa komponen, kedua menu cutom yang berarti user memilih beberapa komponen hardware atau merakit komputer sesuai spesifikasi yang di inginkan. Setelah komponen terpilih maka harga akan muncul...
- Screen Shoot Desain Jframe & Source Code
 |
| Database MySQL |
Koneksi.java
Script Java
|
|---|
package koneksi;
import java.sql.*; import javax.swing.JOptionPane; import static javax.swing.JOptionPane.ERROR_MESSAGE; /* * @author User */ public class jaringan { public static Connection cek; public static Statement stt; public static ResultSet re; public static Connection cek() { try { Class.forName("com.mysql.jdbc.Driver"); cek = DriverManager.getConnection("jdbc:mysql://localhost/db_uas","root",""); stt = cek.createStatement(); } catch (ClassNotFoundException | SQLException e){ JOptionPane.showMessageDialog(null, "Database Error", "Periksa Koneksi Database", ERROR_MESSAGE); } catch (Exception ex) { JOptionPane.showMessageDialog(null, "Error : "+ex, "Error!", ERROR_MESSAGE); } return cek; } public static void main (String [] args){ System.out.println(jaringan.cek()); } public static Connection getConnection() { throw new UnsupportedOperationException("Not supported yet."); } } |
cek koneksi ke database ;
 |
| JFram Login |
Script Java
|
|---|
public Flogin() {
initComponents(); jaringan.cek(); //form berada di tengah dan ti dak bisa d ubah ukurannya this.setLocationRelativeTo(null); this.setVisible(true); this.setResizable(false); } private void login() { try { String user = txt_user.getText(); String pass = new String (txt_pass.getPassword()); jaringan.stt = jaringan.cek.createStatement(); String sql = "Select * From user_data Where user = '"+user+"' And password = '"+pass+"' "; jaringan.re = jaringan.stt.executeQuery(sql); //proses login if (jaringan.re.next()) { if (txt_user.getText().equalsIgnoreCase(jaringan.re.getString("user")) && txt_pass.getText().equals(jaringan.re.getString("password"))){ this.setVisible(false); new Fhome().show(); this.dispose(); } else { JOptionPane.showMessageDialog(null, "Password Salah..!!!"); txt_pass.setText(""); txt_pass.requestFocus(); } } else { JOptionPane.showMessageDialog(rootPane, "User tidak terdaftar, Silahkan coba lagi...!!!"); txt_user.setText(""); txt_pass.setText(""); txt_user.requestFocus(); } } catch (SQLException e){ JOptionPane.showMessageDialog(null, e); } } |
Script Java
|
|---|
private void keluarMouseClicked(java.awt.event.MouseEvent evt) {
//muncul notif konfirmasi keluar int pesan = JOptionPane.showConfirmDialog(null, "Yakin ?", "Konformasi", JOptionPane.YES_NO_OPTION, JOptionPane.QUESTION_MESSAGE); //jika pilih yes maka akan keluar aplikasi if (pesan == JOptionPane.YES_OPTION) { System.exit(0); } } private void btn_daftarActionPerformed(java.awt.event.ActionEvent evt) { Fdaftar reg = new Fdaftar(); reg.setVisible(true); this.setVisible(false); } private void btn_masukActionPerformed(java.awt.event.ActionEvent evt) { login(); } private void txt_userKeyPressed(java.awt.event.KeyEvent evt) { // TODO add your handling code here: if (evt.getKeyCode()== KeyEvent.VK_ENTER && evt.getKeyCode()== KeyEvent.VK_TAB) txt_pass.requestFocus(); } private void txt_passKeyPressed(java.awt.event.KeyEvent evt) { // TODO add your handling code here: if (evt.getKeyCode()== KeyEvent.VK_ENTER) btn_masuk.doClick(); } private void jLabel1MouseClicked(java.awt.event.MouseEvent evt) { // TODO add your handling code here: Fhome hm = new Fhome(); hm.setVisible(true); hm.setLocationRelativeTo(null); hm.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); } |
 |
| JFrame Daftar |
Fdaftar.java
Script Java
|
|---|
public class Fdaftar extends javax.swing.JFrame {
jaringan set; //Creates new form Fdaftar public Fdaftar() { initComponents(); set = new jaringan(); set.cek(); setExtendedState(JFrame.MAXIMIZED_HORIZ); setVisible(true); this.setLocationRelativeTo(null); } public void daftar() { //deklarasi variabel String nama = txt_nama.getText(); String user = txt_user.getText(); String pass = new String(txt_pass.getPassword()); String mail = txt_email.getText(); Object gen = rg_gen.getSelection(); Object tgl = datep.getDate(); String hp = txt_phone.getText(); Object kota = cb_kota.getSelectedIndex(); String alamat = txt_alamat.getSelectedText(); //proses daftar try { //statement query set.stt = set.cek.createStatement(); String sql = "Insert Into user_data Values ('"+user+"', '"+pass+"', '"+mail+"', '"+nama+"', '"+alamat+"', '"+kota+"', '"+tgl+"', '"+hp+"', '"+kota+"', '"+gen+"')"; if (nama.equals("")) { JOptionPane.showMessageDialog(null, "Nama harus di isi"); txt_nama.requestFocus(); } else if (user.equals("")) { JOptionPane.showMessageDialog(null, "User_name harus di isi"); txt_user.requestFocus(); } else if (pass.equals("")) { JOptionPane.showMessageDialog(null, "Password harus di isi"); txt_pass.requestFocus(); } else if (txt_pass1.equals("") && txt_pass1.equals(txt_pass)) { JOptionPane.showMessageDialog(null, "Masukan ulang password"); txt_pass1.requestFocus(); } else if (mail.equals("")) { JOptionPane.showMessageDialog(null, "E-mail harus di isi"); txt_email.requestFocus(); } else if (gen.equals("")) { JOptionPane.showMessageDialog(null, "Jenis kelamin harus di isi"); r_lk.setSelected(true); r_lk.requestFocus(); } else if (tgl.equals("")) { JOptionPane.showMessageDialog(null, "Tanggal lahir harus di isi"); datep.openPopup(); } else if (hp.equals("")) { JOptionPane.showMessageDialog(null, "No.tlpn harus di isi"); txt_phone.requestFocus(); } else if (kota == cb_kota.getItemAt(0)) { JOptionPane.showMessageDialog(null, "domisili harus di isi"); txt_phone.isShowing(); } else { set.stt.executeUpdate(sql); JOptionPane.showMessageDialog(null, "Registrasi berhasil"); b_reset.doClick(); } } catch (SQLException e) { JOptionPane.showMessageDialog(null, e); } } |
Script Java
|
|---|
private void txt_namaKeyPressed(java.awt.event.KeyEvent evt) {
// TODO add your handling code here: if (evt.getKeyCode()== KeyEvent.VK_ENTER && evt.getKeyCode()== KeyEvent.VK_TAB) txt_user.requestFocus(); } private void txt_userKeyPressed(java.awt.event.KeyEvent evt) { // TODO add your handling code here: if (evt.getKeyCode()== KeyEvent.VK_ENTER && evt.getKeyCode()== KeyEvent.VK_TAB) txt_pass.requestFocus(); } private void txt_passKeyPressed(java.awt.event.KeyEvent evt) { // TODO add your handling code here: if (evt.getKeyCode()== KeyEvent.VK_ENTER && evt.getKeyCode()== KeyEvent.VK_TAB) txt_pass1.requestFocus(); } private void txt_pass1KeyPressed(java.awt.event.KeyEvent evt) { // TODO add your handling code here: if (evt.getKeyCode()== KeyEvent.VK_ENTER && evt.getKeyCode()== KeyEvent.VK_TAB) txt_email.requestFocus(); } private void txt_emailKeyPressed(java.awt.event.KeyEvent evt) { // TODO add your handling code here: if (evt.getKeyCode()== KeyEvent.VK_ENTER && evt.getKeyCode()== KeyEvent.VK_TAB) r_lk.setSelected(true); } private void r_lkKeyPressed(java.awt.event.KeyEvent evt) { // TODO add your handling code here: if (evt.getKeyCode()== KeyEvent.VK_TAB) r_pr.setSelected(true); } private void r_prKeyPressed(java.awt.event.KeyEvent evt) { // TODO add your handling code here: if (evt.getKeyCode()== KeyEvent.VK_ENTER && evt.getKeyCode()== KeyEvent.VK_TAB) datep.openPopup(); } private void datepKeyPressed(java.awt.event.KeyEvent evt) { // TODO add your handling code here: if (evt.getKeyCode()== KeyEvent.VK_ENTER && evt.getKeyCode()== KeyEvent.VK_TAB) txt_phone.requestFocus(); } private void txt_phoneKeyPressed(java.awt.event.KeyEvent evt) { // TODO add your handling code here: if (evt.getKeyCode()== KeyEvent.VK_ENTER && evt.getKeyCode()== KeyEvent.VK_TAB) cb_kota.setSelectedIndex(1); } private void cb_kotaKeyPressed(java.awt.event.KeyEvent evt) { // TODO add your handling code here: if (evt.getKeyCode()== KeyEvent.VK_ENTER && evt.getKeyCode()== KeyEvent.VK_TAB) txt_alamat.requestFocus(); } private void txt_alamatKeyPressed(java.awt.event.KeyEvent evt) { // TODO add your handling code here: if (evt.getKeyCode()== KeyEvent.VK_ENTER && evt.getKeyCode()== KeyEvent.VK_TAB) b_buat.doLayout(); } private void b_buatKeyPressed(java.awt.event.KeyEvent evt) { // TODO add your handling code here: if (evt.getKeyCode()== KeyEvent.VK_TAB) b_reset.doLayout(); } private void b_resetKeyPressed(java.awt.event.KeyEvent evt) { // TODO add your handling code here: if (evt.getKeyCode()== KeyEvent.VK_TAB) { b_home.doLayout(); }else if (evt.getKeyCode()== KeyEvent.VK_ENTER) { txt_nama.setText(null); txt_user.setText(null); txt_pass.setText(null); txt_pass1.setText(null); txt_email.setText(null); r_lk.setSelected(false); r_pr.setSelected(false); datep.clear(); txt_phone.setText(null); cb_kota.setSelectedIndex(0); txt_alamat.setText(null); txt_nama.requestFocus(); } } private void b_homeKeyPressed(java.awt.event.KeyEvent evt) { // TODO add your handling code here: if (evt.getKeyCode()== KeyEvent.VK_ENTER){ int pesan = JOptionPane.showConfirmDialog(null, "apakah anda ingin login ?", "Konformasi", JOptionPane.YES_NO_OPTION, JOptionPane.QUESTION_MESSAGE); //jika pilih yes maka akan keluar aplikasi if (pesan == JOptionPane.YES_OPTION) { Flogin log = new Flogin(); log.setVisible(true); log.setLocationRelativeTo(null); log.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); this.dispose(); } else { Fhome hm = new Fhome(); hm.setVisible(true); hm.setLocationRelativeTo(null); hm.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); this.dispose(); } } } private void r_lkActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: r_lk.getText(); } private void r_prActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: r_pr.getText(); } private void b_buatActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: daftar(); } private void b_resetActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: txt_nama.setText(null); txt_user.setText(null); txt_pass.setText(null); txt_pass1.setText(null); txt_email.setText(null); r_lk.setSelected(false); r_pr.setSelected(false); datep.clear(); txt_phone.setText(null); cb_kota.setSelectedIndex(0); txt_alamat.setText(null); txt_nama.requestFocus(); } private void b_homeActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: int pesan = JOptionPane.showConfirmDialog(null, "apakah anda ingin login ?", "Konformasi", JOptionPane.YES_NO_OPTION, JOptionPane.QUESTION_MESSAGE); //jika pilih yes maka akan keluar aplikasi if (pesan == JOptionPane.YES_OPTION) { Flogin log = new Flogin(); log.setVisible(true); log.setLocationRelativeTo(null); log.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); this.dispose(); } else { Fhome hm = new Fhome(); hm.setVisible(true); hm.setLocationRelativeTo(null); hm.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); this.dispose(); } } |
 |
| Main Menu Etalase |
Script Java
| |
|---|---|
private void bEtalaseActionPerformed(java.awt.event.ActionEvent evt) { //remove panel PnlMenu.removeAll(); PnlMenu.repaint(); PnlMenu.revalidate(); //add panel\ PnlMenu.add(MenuEtalase); PnlMenu.repaint(); PnlMenu.revalidate(); } private void bTravelActionPerformed(java.awt.event.ActionEvent evt) { //remove panel PnlMenu.removeAll(); PnlMenu.repaint(); PnlMenu.revalidate(); //add panel\ PnlMenu.add(MenuTravel); PnlMenu.repaint(); PnlMenu.revalidate(); } private void bCompActionPerformed(java.awt.event.ActionEvent evt) { //remove panel PnlMenu.removeAll(); PnlMenu.repaint(); PnlMenu.revalidate(); //add panel\ PnlMenu.add(MenuComp); PnlMenu.repaint(); PnlMenu.revalidate(); } private void bKeranjangActionPerformed(java.awt.event.ActionEvent evt) { //remove panel PnlMenu.removeAll(); PnlMenu.repaint(); PnlMenu.revalidate(); //add panel\ PnlMenu.add(MenuKeranjang); PnlMenu.repaint(); PnlMenu.revalidate(); } private void bAkunActionPerformed(java.awt.event.ActionEvent evt) { Fakun log = new Fakun(); this.setVisible(false); log.setVisible(true); } private void bKeluarActionPerformed(java.awt.event.ActionEvent evt) { int dialogBtn = JOptionPane.YES_NO_OPTION; int dialogResult = JOptionPane.showConfirmDialog(this, "Yakin keluar...???", "PERINGATAN", dialogBtn); if (dialogResult == 0){ //true condition System.exit(0); //flase condition } } private void bTentangActionPerformed(java.awt.event.ActionEvent evt) { aboutview n = new aboutview(); n.setVisible(true); } private void HomeMouseClicked(java.awt.event.MouseEvent evt) { // TODO add your handling code here: //remove panel PnlMenu.removeAll(); PnlMenu.repaint(); PnlMenu.revalidate(); //add panel\ PnlMenu.add(MenuHome); PnlMenu.repaint(); PnlMenu.revalidate(); } /** * @param args the command line arguments */ public static void main(String args[]) { /* Set the Nimbus look and feel */ // /* 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(Fhome.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(Fhome.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(Fhome.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(Fhome.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } // /* Create and display the form */ java.awt.EventQueue.invokeLater(new Runnable() { public void run() { new Fhome().setVisible(true); } }); } // Variables declaration - do not modify private javax.swing.JLabel Home; private javax.swing.JPanel MenuComp; private javax.swing.JPanel MenuEtalase; private javax.swing.JPanel MenuHome; private javax.swing.JPanel MenuKeranjang; private javax.swing.JPanel MenuTravel; private javax.swing.JPanel PnlMenu; private javax.swing.JButton bAkun; private javax.swing.JButton bComp; private javax.swing.JButton bEtalase; private javax.swing.JButton bKeluar; private javax.swing.JButton bKeranjang; private javax.swing.JButton bTentang; private javax.swing.JButton bTravel; private javax.swing.ButtonGroup buttonGroup1; private com.github.lgooddatepicker.components.DatePicker datePicker1; private com.github.lgooddatepicker.components.DatePicker datePicker2; private javax.swing.JButton jButton1; private javax.swing.JButton jButton10; private javax.swing.JButton jButton11; private javax.swing.JButton jButton12; private javax.swing.JButton jButton2; private javax.swing.JButton jButton3; private javax.swing.JButton jButton4; private javax.swing.JButton jButton5; private javax.swing.JButton jButton6; private javax.swing.JButton jButton7; private javax.swing.JButton jButton8; private javax.swing.JButton jButton9; private javax.swing.JComboBox private javax.swing.JComboBox private javax.swing.JComboBox private javax.swing.JComboBox private javax.swing.JComboBox private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel10; private javax.swing.JLabel jLabel11; private javax.swing.JLabel jLabel12; private javax.swing.JLabel jLabel13; private javax.swing.JLabel jLabel14; private javax.swing.JLabel jLabel15; private javax.swing.JLabel jLabel16; private javax.swing.JLabel jLabel17; 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.JPanel jPanel2; private javax.swing.JPanel jPanel3; private javax.swing.JPanel jPanel4; private javax.swing.JPanel jPanel5; private javax.swing.JPanel jPanel6; private javax.swing.JPanel jPanel7; private javax.swing.JRadioButton jRadioButton1; private javax.swing.JRadioButton jRadioButton2; private javax.swing.JScrollPane jScrollPane1; private javax.swing.JScrollPane jScrollPane2; private javax.swing.JScrollPane jScrollPane3; private javax.swing.JTable jTable1; private javax.swing.JTextArea jTextArea1; private javax.swing.JTextArea jTextArea2; private javax.swing.JTextField jTextField1; private javax.swing.JTextField jTextField2; private javax.swing.JTextField jTextField3; private javax.swing.JTextField jTextField6; private javax.swing.JTextField jTextField7; private javax.swing.JPanel pnlHome; private javax.swing.JPanel pnlMain; // End of variables declaration } |
- Screen Shoot Hasil Running
 |
| Notifikasi user tidak terdapat dalam database, |
