• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

inserting Jtable cell values

 
dev
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all..
here i want to insert Jtable cell values into database...plz can any one help me out with code..
thanks in advance
dev
 
Jagan Reddy
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I think this code might help u out.
for(int i=0;i<table.getRowCount();i++) { //table is the name of ur JTable

String sbValues = "insert into table values(";//table is the name of the table in the database where data is to be inserted
String sbData = "";

for(int j=0;j<table.getColumnCount();j++) {
String s2 =(String)table.getValueAt(i,j);
if(s2==null)
s2 = "";
sbValues+=s2+",";
}
sbData+=sbValues.substring(0,sbValues.length()-1)+")";
statement.executeUpdate(sbData); //statement is ur statement object.
}
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic