File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Swing / AWT / SWT and the fly likes inserting Jtable cell values Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Java » Swing / AWT / SWT
Bookmark "inserting Jtable cell values" Watch "inserting Jtable cell values" New topic
Author

inserting Jtable cell values

dev
Greenhorn

Joined: Jan 14, 2002
Posts: 2
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

Joined: Nov 11, 2001
Posts: 7
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.
}
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: inserting Jtable cell values
 
Similar Threads
JTable
JTable
JTable
JTable
JTABLE