Aplikasi Rental PS

Aplikasi Rental Mobil

Deskripsi 

-Start

-Login 

-Masukkan nama, jenis mobil, harga, dan waktu pinjam lalu click daftar

-Click cari maka langsung akan muncul di keterangan table yang ada di bawah

-Finish

Form Login

Form Menu 

Form Akhir

Form mysql menu

Form mysql Akhir 

Scrip Program

LOGIN

String user = "Tedi";
        String pass = "123456789";
        if (user.equalsIgnoreCase(txt1.getText()) && pass.equalsIgnoreCase(txt2.getText())){
        this.setVisible(false);
        new JualMobil().setVisible(true);
        }
        else {
        javax.swing.JOptionPane.showMessageDialog(null,"kombinasi nama dan password salah");
        txt1.setText("");
        txt1.requestFocus();
        txt2.setText("");
    }


\\ KONEKSI

package Tedi;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
import java.awt.Dimension;
import java.awt.HeadlessException;
import java.awt.Toolkit;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
/**
 *
 * @author NCIaja
 */
public class JualMobil extends javax.swing.JFrame {
private Connection con;
private Statement stat;
private ResultSet res;
private String t;
private void koneksi(){
try {
Class.forName("com.mysql.jdbc.Driver");
con=(Connection) DriverManager.getConnection("jdbc:mysql://127.0.0.1/dbtedi", "root", "");
stat=(Statement) con.createStatement();
} catch (ClassNotFoundException | SQLException e) {
JOptionPane.showMessageDialog(null, e);
}
}
private void kosongkan()
{
txt1.setText("");
txt2.setText("");
txt3.setText("");
txt4.setText("");
txt1.requestFocus();
 }
    /**
     * Creates new form MenuUtama
     */
    public JualMobil() {
        initComponents();
        koneksi();
        kosongkan();
        tabel();
       
        Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
        Dimension frameSize = getSize();
        setLocation(
        (screenSize.width - frameSize.width) / 2,
        (screenSize.height - frameSize.height) / 2);
    }
    private void tabel(){
DefaultTableModel t= new DefaultTableModel();
 t.addColumn("Nama");
 t.addColumn("Jenis Kendaraan");
 t.addColumn("Harga");
 t.addColumn("Waktu Peminjaman");
 tbl.setModel(t); try{ res=stat.executeQuery("select * from tbltedi");
 while (res.next()) {
 t.addRow(new Object[]{ res.getString("nama"),
 res.getString("jenis"), 
  res.getString("harga"),
 res.getString("waktu")
 });
 }
 }catch (Exception e) {
 JOptionPane.showMessageDialog(rootPane, e);
 }


SIMPAN

try {
 stat.executeUpdate("insert into tbltedi values ("
+ "'" + txt1.getText()+"',"
+ "'" + txt2.getText()+"',"
+ "'" + txt3.getText()+"',"
+ "'" + txt4.getText()+ "')");
kosongkan();
JOptionPane.showMessageDialog(null, "Berhasil Menyimpan Data");
} catch (SQLException | HeadlessException e) {
JOptionPane.showMessageDialog(null, "Perintah Salah : "+e);
 }finally{
         tabel();
    }             


HAPUS


ry {
stat.executeUpdate("delete from tbltedi where "
+ "nama='"+txt1.getText()
+"'" );
kosongkan();
JOptionPane.showMessageDialog(null, "Berhasil");
 } catch (SQLException | HeadlessException e) {
JOptionPane.showMessageDialog(null, "pesan salah : "+e);
 } finally{
         tabel();
          }


try {
res=stat.executeQuery("select * from tbltedi where "+ "nama='" +txt1.getText()
+"'" ); while (res.next())
{ txt1.setText(res.getString("nama"));
txt2.setText(res.getString("jenis"));
txt3.setText(res.getString("harga"));
txt4.setText(res.getString("waktu"));
}                                       
 }     
catch (Exception e) {
JOptionPane.showMessageDialog(rootPane, e);
}


\\ KEMBALI

new Daftar().setVisible(true);