Java Jtable and Data base

Question

Hi guys kindly tell me how to show data from database in to table? and how to delete row from data base and table

Suthish Nair · Answer

Browse through articles availble here..

Hima Bindu · Answer

Follow these 3 steps Create Table DefaultTableModel model = new DefaultTableModel(new String[]{col1 col2 col3} 0); Load the data from the database String sql=SELECT * FROM table; ResultSet rs = st.executeQuery(sql); Add each row of data to the table model... while(rs.next()) { String d = rs.getString(col1); String e = rs.getString(col2); String f = rs.getString(col3); model.addRow(new Object[]{d e f}); } Apply the model to your JTable table.setModel(model);