JAVA: Question lang po about JTable

[mysteltaine]

Mga Sir patulong lang Student here. Possible po ba na Mag edit ng Contents sa JTable and ung changes na ginawa ay automatically na masesave sa Database?

example ung Quantity ay iibahin ko para maging 6. then automatic masasave nya on runtime or pag may save button.


View attachment 290857

Maraming Salamat po.

 

[mishelann1305]

possible po

 

[Android 20]

yes possible naman po

 

[mysteltaine]

Talaga po? Pwede po makahingi kahit line of code lang? Medyo kinulang kasi ung turo samin so kailangan tlga mag self study... So far eto lang po pinoproblema namin.

Salamat ng marami

 

[calbee]

What I would suggest is to create a class that extends the AbstractTableModel then override these methods:
getColumnCount(), getRowCount(), getValueAt(), getColumnClass(), and setValueAt().

The setValueAt method is where you will put the code to save the data to the database.

If you want more info you should post your code first so we can have a look at it.

 

[mysteltaine]

"public void ShowTable()
{
tblModel = (DefaultTableModel)tblBNew.getModel();
try
{
rs = s.executeQuery("Select VIN,VehicleName,VehicleModel,VehicleYear,Manufacturer,SellingPrice,Quantity from tblVehicleInfo where VehicleType='Brand New'");
ResultSetMetaData md = rs.getMetaData();

int row = tblModel.getRowCount();

while(row>0)
{
row--;
tblModel.removeRow(row);
}
int colcount = md.getColumnCount();
Object[] data = new Object[colcount];
while(rs.next())
{

for(int i=1;i<=colcount;i++)
{
data[i-1] = rs.getString(i);
}
tblModel.addRow(data);
}
tblModel.fireTableDataChanged();
}
catch(Exception e) {System.out.println("Error: "+e);}

}




Eto po ung Code to for viewing the Table. ang Plan po sana is dun sa table mismo mag iinput ng values or mag edit. and masesave using a button.
Ang naturo lang po kasi samin ay Table Viewing.

Maraming salamat!

 

[calbee]

"public void ShowTable()
{
tblModel = (DefaultTableModel)tblBNew.getModel();
try
{
rs = s.executeQuery("Select VIN,VehicleName,VehicleModel,VehicleYear,Manufacturer,SellingPrice,Quantity from tblVehicleInfo where VehicleType='Brand New'");
ResultSetMetaData md = rs.getMetaData();

int row = tblModel.getRowCount();

while(row>0)
{
row--;
tblModel.removeRow(row);
}
int colcount = md.getColumnCount();
Object[] data = new Object[colcount];
while(rs.next())
{

for(int i=1;i<=colcount;i++)
{
data[i-1] = rs.getString(i);
}
tblModel.addRow(data);
}
tblModel.fireTableDataChanged();
}
catch(Exception e) {System.out.println("Error: "+e);}

}




Eto po ung Code to for viewing the Table. ang Plan po sana is dun sa table mismo mag iinput ng values or mag edit. and masesave using a button.
Ang naturo lang po kasi samin ay Table Viewing.

Maraming salamat!

Adding new and/or editing existing records require a lot more code than you posted. Ideally, you will have multiple classes, each with specific purpose. For this project, you should have a class for the table model, utility class where the sql connection and queries will be handled, and another class for the main user interface.

See this example Using JDBC with GUI API. You can download the code here.

Another example that allows you to edit the table cells.

Good luck.