[SOLVED] Libraries yang Tidak Muncul di Netbeans - Mata Kuliah : Desktop Programing
Hai saya Gatra Adi Wirya ; - Link drive ada di paling bawah ! ================================== Kodingan untuk class config.java : (kodingan ini sudah d...
🔥 Related Trending Topics
LIVE TRENDSThis video may be related to current global trending topics. Click any trend to explore more videos about what's hot right now!
THIS VIDEO IS TRENDING!
This video is currently trending in Bangladesh under the topic 's'.
About this video
Hai saya Gatra Adi Wirya ;
- Link drive ada di paling bawah !
==================================
Kodingan untuk class config.java :
(kodingan ini sudah dimodifikasi, apabila kalian copy maka tidak perlu diubah seperti pada video)
-------------------------------------------------------------------
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class config {
private static Connection mysqlconfig;
public static Connection configDB()throws SQLException{
try {
String url="jdbc:mysql://localhost:3306/aplikasi_pbo"; //url database
String user="root"; //user database
String pass=""; //password database
DriverManager.registerDriver(new com.mysql.cj.jdbc.Driver());
mysqlconfig=DriverManager.getConnection(url, user, pass);
} catch (Exception e) {
System.err.println("koneksi gagal "+e.getMessage()); //perintah menampilkan error pada koneksi
}
return mysqlconfig;
}
}
-------------------------------------------------------------------
==================================
Kodingan untuk button "save"
Koding 1 :
-------------------------------------------------------------------
import java.sql.Connection;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
-------------------------------------------------------------------
Koding 2 :
-------------------------------------------------------------------
//insert
try {
String sql = "INSERT INTO mahasiswa VALUES ('"+txt_npm.getText()+"','"+txt_nama.getText()+"','"+txt_prodi.getSelectedItem()+"','"+txt_semester.getText()+"','"+txt_angkatan.getText()+"')";
java.sql.Connection conn=(Connection)config.configDB();
java.sql.PreparedStatement pst=conn.prepareStatement(sql);
pst.execute();
JOptionPane.showMessageDialog(null, "Penyimpanan Data Berhasil");
} catch (Exception e) {
JOptionPane.showMessageDialog(this, e.getMessage());
}
// load_tabel();
// kosong();
//insert
-------------------------------------------------------------------
==================================
Link Drive untuk konektor MySQL :
https://drive.google.com/file/d/1BwUW3r-FXenyuulQg0nXG2wzzJ_G7FFd/view?usp=sharing
==================================
Video Information
Views
9.6K
Total views since publication
Likes
112
User likes and reactions
Duration
18:39
Video length
Published
Nov 17, 2022
Release date
Quality
hd
Video definition