USING TABLE TO INPUT DATA INTO DATABASE TABLE: P'SE HELP

[rrugemalira]

USING TABLE TO INPUT DATA INTO DATABASE TABLE: P'SE HELP

I have a table named toolsTable which has three columns as follows:
Column1: tableRowGroup1SelectionColumn (check boxes)
Column2: toolNameColumn (tool names for this column are obtained from a database table)
Column3: itemCountColumn (is a textfield column)

When the table is rendered as a JSP, I can select multiple rows from the table.
For each selected row, I enter a number in Column3 - giving the amount of selected tool (e.g. 5 tractors)

I have a submit button on the JSP.
Kindly give me some tips on how to write code for the public String submitButton_action() method
so I may input toolName and the number entered in column 3 into a database table.

something like: toolsTable.getTableRowGroupChild() ....

[Rick Fincher]

Hi You may want to check out the tutorial for creating CRUD (Create,
Replace, Update, Delete) database apps.

Not quite sure what you want to do.  Is the table connected to the
database already?  Are you trying to update just the rows with the check
box selected?

If you are using a DataProvider you can just call the commitChanges()
method on the data provider.

Rick


rrugemalira wrote:

> USING TABLE TO INPUT DATA INTO DATABASE TABLE: P'SE HELP
>
> I have a table named toolsTable which has three columns as follows:
> Column1: tableRowGroup1SelectionColumn (check boxes)
> Column2: toolNameColumn (tool names for this column are obtained from a
> database table)
> Column3: itemCountColumn (is a textfield column)
>
> When the table is rendered as a JSP, I can select multiple rows from the
> table.
> For each selected row, I enter a number in Column3 - giving the amount of
> selected tool (e.g. 5 tractors)
>
> I have a submit button on the JSP.
> Kindly give me some tips on how to write code for the public String
> submitButton_action() method
> so I may input toolName and the number entered in column 3 into a database
> table.
>
> something like: toolsTable.getTableRowGroupChild() ....
>  

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[HandyGeek]

rrugemalira,
The tutorials listed under Visual Web Application Development will answer your questions:
http://www.netbeans.org/kb/trails/web.html

HTH /David

 -------------- Original message ----------------------
From: rrugemalira <mambo-ruge@...>

>
> USING TABLE TO INPUT DATA INTO DATABASE TABLE: P'SE HELP
>
> I have a table named toolsTable which has three columns as follows:
> Column1: tableRowGroup1SelectionColumn (check boxes)
> Column2: toolNameColumn (tool names for this column are obtained from a
> database table)
> Column3: itemCountColumn (is a textfield column)
>
> When the table is rendered as a JSP, I can select multiple rows from the
> table.
> For each selected row, I enter a number in Column3 - giving the amount of
> selected tool (e.g. 5 tractors)
>
> I have a submit button on the JSP.
> Kindly give me some tips on how to write code for the public String
> submitButton_action() method
> so I may input toolName and the number entered in column 3 into a database
> table.
>
> something like: toolsTable.getTableRowGroupChild() ....
> --
> View this message in context:
> http://www.nabble.com/USING-TABLE-TO-INPUT-DATA-INTO-DATABASE-TABLE%3A-P%27SE-HE
> LP-tp17090811p17090811.html
> Sent from the Visual Web - Users mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@...
> For additional commands, e-mail: users-help@...
>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[rrugemalira]

One column of the table is connected to a database table (Say table A). The other two are not.
Of the two columns that are not connected to the database, one column is a checkbox column that enables me to select multiple rows of the table. The other column has text fields where I can enter values.
I'd like to deposit the selected rows into a database table B different from aforementioned table A.

Rick Fincher wrote:

Hi You may want to check out the tutorial for creating CRUD (Create,
Replace, Update, Delete) database apps.

Not quite sure what you want to do.  Is the table connected to the
database already?  Are you trying to update just the rows with the check
box selected?

If you are using a DataProvider you can just call the commitChanges()
method on the data provider.

Rick


rrugemalira wrote:
> USING TABLE TO INPUT DATA INTO DATABASE TABLE: P'SE HELP
>
> I have a table named toolsTable which has three columns as follows:
> Column1: tableRowGroup1SelectionColumn (check boxes)
> Column2: toolNameColumn (tool names for this column are obtained from a
> database table)
> Column3: itemCountColumn (is a textfield column)
>
> When the table is rendered as a JSP, I can select multiple rows from the
> table.
> For each selected row, I enter a number in Column3 - giving the amount of
> selected tool (e.g. 5 tractors)
>
> I have a submit button on the JSP.
> Kindly give me some tips on how to write code for the public String
> submitButton_action() method
> so I may input toolName and the number entered in column 3 into a database
> table.
>
> something like: toolsTable.getTableRowGroupChild() ....
>  


---------------------------------------------------------------------
To unsubscribe, e-mail: [e-mail]
For additional commands, e-mail: [e-mail]