Add JTable Value to Database in Java Swing

August 20, 2023

Add JTable Value to Database in Java Swing

Add JTable Value to Database in Java Swing:

Add JTable Value to Database in Java Swing - YouTube

________________________________________________

1.Make this figure in NetBeans

JTable: table

JTextField: txtID

JTextField: txtFName

JTextField: txtLName

JButton: btnAdd

JButton: btnUpdate

JButton: btnDelete

Imported Packages

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.logging.Level;

import java.util.logging.Logger;

import javax.swing.JOptionPane;

import javax.swing.table.DefaultTableModel;

Connect Database

Connection con; PreparedStatement pst; ResultSet rs; public AddUpdateDelete() { initComponents(); table.setShowGrid(true); try{ Class.forName("com.mysql.cj.jdbc.Driver"); con = DriverManager.getConnection("jdbc:mysql://localhost:3306/userrdata", "root", ""); pst = con.prepareStatement("select * from userrtable"); rs = pst.executeQuery(); }catch(ClassNotFoundException ex){ Logger.getLogger(AddUpdateDelete.class.getName()).log(Level.SEVERE, null, ex); }catch(SQLException ex){ Logger.getLogger(AddUpdateDelete.class.getName()).log(Level.SEVERE, null, ex); } }

Add button Action

private void btnAddActionPerformed(java.awt.event.ActionEvent evt) { DefaultTableModel model = (DefaultTableModel) table.getModel(); model.addRow(new Object[] {txtID.getText(), txtFName.getText(), txtLName.getText()}); try{ pst = con.prepareStatement("insert into userrtable(id, fname, lname)values(?,?,?)"); pst.setString(1, txtID.getText()); pst.setString(2, txtFName.getText()); pst.setString(3, txtLName.getText()); pst.executeUpdate(); JOptionPane.showMessageDialog(this, "Successfull!"); }catch(SQLException ex){ JOptionPane.showMessageDialog(null, ex); } txtID.setText(""); txtFName.setText(""); txtLName.setText(""); }

_____________________________________________

Dark Hers

https://darkhers.blogspot.com

YouTube

https://youtube.com/@darkhers

Instagram

https://instagram.com/darkhers

Facebook

https://www.facebook.com/darkhers

TikTok

https://www.tiktok.com/@darkhers

Pinterest