Java Update MySQL Data Using JTable - Hallo sahabat Dev-Create, Pada Artikel yang anda baca kali ini dengan judul Java Update MySQL Data Using JTable, kami telah mempersiapkan artikel ini dengan baik untuk anda baca dan ambil informasi didalamnya. mudah-mudahan isi postingan
Artikel Java,
Artikel java jtable,
Artikel jtable,
Artikel jtable row,
Artikel update,
Artikel Update All MySQL DataBase Values Using JTable In Java,
Artikel Update MySQL Data Using JTable In Java, yang kami tulis ini dapat anda pahami. baiklah, selamat membaca.
Judul : Java Update MySQL Data Using JTable
link : Java Update MySQL Data Using JTable
Anda sekarang membaca artikel Java Update MySQL Data Using JTable dengan alamat link https://dev-create.blogspot.com/2021/11/java-update-mysql-data-using-jtable.html
Judul : Java Update MySQL Data Using JTable
link : Java Update MySQL Data Using JTable
Java Update MySQL Data Using JTable
How To Update All MySQL DataBase Values Using JTable In Java NetBeans
In this Java Tutorial we will see How To UPDATE DataBase Data With JTable Rows Values Using For Loop And addBatch Function On Button Click In Java NetBeans .
Project Source Code:
// function to get the connection
public Connection getConnection()
{
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException ex) {
System.out.println(ex.getMessage());
}
Connection con = null;
try {
con = DriverManager.getConnection("jdbc:mysql://localhost/s_t_d", "root", "");
} catch (SQLException ex) {
System.out.println(ex.getMessage());
}
return con;
}
// function to display data from mysql to Jtable
public void fillTable(){
Connection con = getConnection();
Statement ps;
ResultSet rs;
DefaultTableModel model = (DefaultTableModel) jTable1.getModel();
try {
ps = con.createStatement();
rs = ps.executeQuery("SELECT * FROM `student`");
while(rs.next()){// Id`, `FullName`, `Address`, `BirthDate
Object[] row = new Object[jTable1.getColumnCount()];
row[0] = rs.getInt("Id");
row[1] = rs.getString("FullName");
row[2] = rs.getString("Address");
row[3] = rs.getString("BirthDate");
model.addRow(row);
}
} catch (SQLException ex) {
System.out.println(ex.getMessage());
}
}
// button update
private void jButtonUPdateAllActionPerformed(java.awt.event.ActionEvent evt) {
Connection con = getConnection();
Statement st;
DefaultTableModel model = (DefaultTableModel) jTable1.getModel();
try {
st = con.createStatement();
for(int i = 0; i < model.getRowCount(); i++){
int id = Integer.valueOf(model.getValueAt(i, 0).toString());
String fn = model.getValueAt(i,1).toString();
String adr = model.getValueAt(i,2).toString();
String bdate = model.getValueAt(i,3).toString();
String updateQuery = "UPDATE `student` SET `FullName`='"+fn+"',`Address`='"+adr+"',`BirthDate`='"+bdate+"' WHERE `Id` = " +id;
st.addBatch(updateQuery);
}
int[] updatedRow = st.executeBatch();
System.out.println(updatedRow.length);
} catch (SQLException ex) {
Logger.getLogger(Update_All_MySQL_Data_Using_JTable.class.getName()).log(Level.SEVERE, null, ex);
}
}
OutPut:
Demikianlah Artikel Java Update MySQL Data Using JTable
Sekianlah artikel Java Update MySQL Data Using JTable kali ini, mudah-mudahan bisa memberi manfaat untuk anda semua. baiklah, sampai jumpa di postingan artikel lainnya.
Anda sekarang membaca artikel Java Update MySQL Data Using JTable dengan alamat link https://dev-create.blogspot.com/2021/11/java-update-mysql-data-using-jtable.html