Tugas 14 Pemograman Java

 Nama    : Hanif

Nim    : 3420200002

Prodi    :  Teknik Informatika (Reguler)

public class Latihan 6 extends javax.swing.jframe {
    // Nama    : Hanif
    // Nim    : 3420200002
    private Final String DB_Username = "root";
    private Final String DB_Password = " ";
    private Final String DB_Koneksi = "jdbc :mysql ://local host:3306/dbjual";
    
 Public Latihan6() {
    inicomponents();
    Atur_combo();
    Bersih();
 } 

private void Tombol_CariActionPerformed (java.awt.event.ActionEvent evt) {
// Nama: Hanif
// NIM #3420200002
if (Cek Kode() false) (
return;
String Kode Barang txt Kdbar.getText().trim():
String SQL = "SELECT FROM barang WHERE kabig = " +  kode Barang "" Connection Conn(Connection) DriverManager.getConnection (DB Konek,
DB Username, DB Fassword);
Statement Stat Conn.createStatementResultSet RS Stmt.executeQuery(SQL):
if(RS.next()) {
JOptionPane.showMessageDialog(rootPane, "Kode Barang tidak ditemukan!",
*Informani", JOptionPane. INFORMATION MESSAGE):
txt_dbar.setText("");
txt_dbaz.requestFocus():
return;
1
JOptionPane.showMessageDialog(rootPane, "Kode Barang ditemukan!",
"Informasi", JOptionPane. INFORMATION MESSAGE); txt_Nambar.setText (RS.getString("bro_nama"));
txt_Harga.setText (RS.getString("brg_harga"));
txt_Stok.setText (RS.getString("brg_atok")); ComboBox Kategori.setSelectedItem(RS.getString("brg_kategori")):
if (RS.getString("bro_garansi").equals("1")) {
RadioButton Ya.setSelected(true);
RadioButton_Tidak.setSelected(true);
Stmt.close();
Conn.close():
catch (SQLException e) {
e.printStackTrace(); 

private void Tombol UpdateActionPerformed (java.awt.event.ActionEvent evt) {

// Nama : Hanif

// NIM

: 3420200002

if (Cek Kode () false) {

return;

}

try{

String Kode Barang = txt_Rdbar.getText().trim();

String Nama_Barang txt Nambar.getText().trim();

=

String Harga = txt_Harga.getText().trim();

String Stok = txt_Stok.getText().trim();

String Kategori = ComboBox Kategori.getSelectedItem().toString();

String Garansi = "0";

if (RadioButton_Ya.isSelected()) {

Garansi = "1";

}

Calendar Cal Calendar.getInstance(); SimpleDateFormat SDF = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); String Tanggal Jam = SDF. format (Cal.getTime()); SQL UPDATE=

String SQL = "UPDATE barang SET";

SQL += "brg_nama = + Nama Barang +

SQL += "brg_harga = "" + Harga + ",

SQL += "brg stok = '" + Stok + "

SQL += "brg_kategori = !" + Kategori + "'

SQL += "brg_garansi = "+Garansi + ??

SQL += "brg_update = "TanggalJam +

SQL += "WHERE kdbrg "+ Kode Barang + "'";

=

Connection Conn = (Connection) DriverManager.getConnection (DB_Koneksi,

DB_Username, DB_Password); Statement Stmt = Conn.createStatement();

Stmt.executeUpdate (SQL);

Stmt.close();

Conn.close();

JOptionPane.showMessageDialog(rootPane, "Data Berhasil diUpdate!",

"Informasi", JOptionPane. INFORMATION_MESSAGE);

Bersih ();

txt_Kabar.requestFocus();

} catch (SQLException e) {

e.printStackTrace();