Tugas Uas Algoritma

1. Deskripsi

Project Toko Brownies dengan menggunakan Java Database Connection.
pengembangan menggunakan Java Database Connection ini supaya data penjualan bisa tersimpan datanya.

Screenshoot Design Toko Brownies.

Screenshoot Program di Run.

Screenshoot data yang sudah masuk ke database.

2. Source Code

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                       
        // TODO add your handling code here:
        try {
            String host = "jdbc:mysql://localhost:3306/02tplp001",
                    user = "root",
                    pass = "";
            Connection con = (Connection) DriverManager.getConnection(host, user, pass);

           
            String RasaBrownies = txtrasa.getText();
            int Jumlah = Integer.parseInt(txtjumlah.getText());
            int Harga = Integer.parseInt(txtharga.getText());
            int Total = Integer.parseInt(txttotal.getText());

           
            Statement st = (Statement) con.createStatement();
            st.executeUpdate("INSERT INTO toko_brownies ( Rasa_Brownies, Jumlah, Harga, Total) VALUES ('"+RasaBrownies+"', "+Jumlah+", "+Harga+", "+Total+")");

           
            JOptionPane.showMessageDialog(null, "BERHASIL");
        }
        catch (SQLException err) {
        JOptionPane.showMessageDialog(null, err.getMessage()); }
    }