how to get values from jtable and save in database ?
Insert JTable data to database
Here is an example that reads the jtable data and insert it to database.
import javax.swing.*; import javax.swing.table.*; import java.sql.*; import java.awt.*; import java.awt.event.*; public class InsertJTableDatabase{ JTable table; JButton button; public static void main(String[] args) { new InsertJTableDatabase(); } public InsertJTableDatabase(){ JFrame frame = new JFrame("Getting Cell Values in JTable"); JPanel panel = new JPanel(); String data[][] = {{"Angelina","Mumbai"},{"Martina","Delhi"}}; String col[] = {"Name","Address"}; DefaultTableModel model = new DefaultTableModel(data, col); table = new JTable(model); JScrollPane pane = new JScrollPane(table); button=new JButton("Submit"); button.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent ae){ PreparedStatement pstm; ResultSet rs; int index=1; int count=table.getRowCount(); try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection connect =DriverManager.getConnection("jdbc:odbc:access"); for(int i=0;i<count;i++){ Object obj1 = GetData(table, i, 0); Object obj2 = GetData(table, i, 1); String value1=obj1.toString(); String value2=obj2.toString(); System.out.println(value1); System.out.println(value2); pstm=connect.prepareStatement("insert into data values(?,?)"); pstm.setString(1,value1); pstm.setString(2,value2); index++; } pstm.executeUpdate(); } catch(Exception e){} } }); panel.add(pane); panel.add(button); frame.add(panel); frame.setSize(500,250); frame.setUndecorated(true); frame.getRootPane().setWindowDecorationStyle(JRootPane.PLAIN_DIALOG); frame.setVisible(true); frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); } public Object GetData(JTable table, int row_index, int col_index){ return table.getModel().getValueAt(row_index, col_index); } }
Thank You Very Much For Helping Me . . :)
jScrollPane1 = new javax.swing.JScrollPane();
jTable1 = new javax.swing.JTable();
Button1 = new javax.swing.JButton();
jTable1.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] { {null, null}, {null, null}, {null, null}, {null, null} }, new String [] { "val", "val1" } ));
try { Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/a","root","");
Statement st=con.createStatement();
ResultSet rs;
int rows = jTable1.getRowCount();
Object data1[][];
data1=new Object[rows][2];
for(int i=0;i
data1[i][j]=jTable1.getValueAt(i,j); }
}
for(int i=0;i
String qq="insert into instab (val,val1) values('"+data1[i][0]+"','"+data1[i][1]+"')";
st.executeUpdate(qq);
}
} catch (Exception e) {
System.out.print(e);
}
Ads