How to store HTML table values in DB

[Raveesh Lawrance]

I am new to struts. i am having one jsp file that contains datas with table. i want to collect all the table data values and stroe it in DB while clicking the submit button. how to do that... please help me.... Thanks in advance....

[Sagar Rohankar]

This is a basic things which could be done, if you have some experience in JSP/Servlets[This is prerequisite for Struts]

Ok, still this will be a good start !

[Raveesh Lawrance]

ok Thanks. Please help me how to store table values in DB

[Sagar Rohankar]

Raveesh Lawrance wrote:ok Thanks. Please help me how to store table values in DB

I provided a link in my first reply to your first thread, Still I'm giving some more,
http://wiki.apache.org/struts/StrutsArticles
You have to learn this basics first, then If you were stuck between implementing, then you post here about where you stuck, What you did and what you expect ??

[Raveesh Lawrance]

jsp file - That contains table with 3 Row values and one submit button, while clicking the submit button all the table values should pass to java class file using server.

[Sagar Rohankar]

Raveesh Lawrance wrote:jsp file - That contains table with 3 Row values and one submit button, while clicking the submit button all the table values should pass to java class file using server.

Ok, here is what you required,

1. ActionForm(bean, with getter/setter property) : This holds you FORM/Table values
2. ActionClass (servlet): Called upon when you click "Submit", Process your requests
3. JSP page, (View), <table></table>
4. A java class with DB connection object and method which inserts data into DB

Can you get this ??

[Raveesh Lawrance]

no. i just created all the files(Action, Class, Form and DB) I need the procedure how to pass the all table values into javaclass file while clicking submit button.

[Sagar Rohankar]

Ok,
struts-config.xml

<action-mappings>
    <!-- Attributes of the <action> element -->
<!-
type - Fully qualified Java class name of the Action
    implementation class used by this mapping.
name - The name of the form bean defined in the config
    file that this action will use
path - The request URI path that is matched to select this
    mapping unknown - Set to true if this action should be
    configured as the default for this application to
    handle all requests not handled by another action.
    Only one action can be defined as a default within
    a single application.
validate - Set to true if the validate() method of the
    action associated with this mapping should be called.
-->
    <!-- ~~~~~~~~~~~~~~~~~~~~~ -->
    <!-- O'Reilly Main Actions    -->
    <!-- ~~~~~~~~~~~~~~~~~~~~~ -->
    <action path="/SubmitTable"
           type="MyAction">
      <forward name="success" path="/DisplayMainPage.action"/>
      <forward name="failure" path="/Fail.jsp"/>
    </action>
  </action-mappings>

JSP

<html:form action="MyAction">// Action which is mapped in struts-config.xml
Name: <html:text property="name"/>
<html:submit value="Submit"/> 
</html:form>

Action, MyAction.java

execute(mapping, form, req, resp)
{
      MyForm myForm = (MyForm)form; // Have to declare this 'MyForm' bean
      String name = myForm.getName(); // Here u got tble value, insrt it into db
      
}

HTH

[Raveesh Lawrance]

Sorry i think you are misunderstood wht im trying to say.
Here is my coding.
<table>
<tr align="center">
<td align="center" style="width:300px;"> Flag Name_1 </td>
<td align="center" style="width:300px;"> 1 </td>
<td align="center" style="width:300px;"> Flag Notes_1 </td>

</tr>

<tr align="center">
<td align="center" style="width:300px;"> Flag Name_2 </td>
<td align="center" style="width:300px;"> 2 </td>
<td align="center" style="width:300px;"> Flag Notes_2 </td>

</tr>
</table>
<input style="background-color:010280; color:white" type="Submit" name="commit" value="Commit">

I want to pass all these table datas into java class while clicking the commit button

[Sagar Rohankar]

Use Code Tags

 <tr >
<td  > <html:itext property="flagNameOne"/>Flag Name_1</td>
<td  > <html:itext property="flagNameValue"/>1 </td>
<td  > <html:itext property="flagNameNotes"/>Flag Notes_1 </td>
</tr> 
<!-- Similar for Flag Name 2 -->

A point to remember, you must declare 'bean', like

class MyBean extends ActionForm
{
          String flagNameOne;
          String flagNameValue;
           .
           .
           // other properties

          // getter/setter here
}

And its mapping in correct action tag

[Dhruva Mistry]

Raveesh Lawrance wrote:Sorry i think you are misunderstood wht im trying to say.
Here is my coding.
<table>
<tr align="center">
<td align="center" style="width:300px;"> Flag Name_1 </td>
<td align="center" style="width:300px;"> 1 </td>
<td align="center" style="width:300px;"> Flag Notes_1 </td>

</tr>

<tr align="center">
<td align="center" style="width:300px;"> Flag Name_2 </td>
<td align="center" style="width:300px;"> 2 </td>
<td align="center" style="width:300px;"> Flag Notes_2 </td>

</tr>
</table>
<input style="background-color:010280; color:white" type="Submit" name="commit" value="Commit">

I want to pass all these table datas into java class while clicking the commit button

you can put javascript for onSubmit event besides the <form> just call a method to take the value of needed fields and
in java class you can set the values

[Sagar Rohankar]

dhruva mistry wrote:
you can put javascript for onSubmit event besides the <form> just call a method to take the value of needed fields and
in java class you can set the values

How?

[Dhruva Mistry]

Sagar Rohankar wrote:

dhruva mistry wrote:
you can put javascript for onSubmit event besides the &amp;lt;form&amp;gt; just call a method to take the value of needed fields and
in java class you can set the values

How?

likewise:

<script>
function takeVal(form f) {

var flagNameOne_js = document.f.flagNameOne;

return flagNameOne_js;
}
</script>

<form onSubmit="takeVal(this.form);">
<!--  here put the original code that is in tabular format-->

<tr >  
<td> <html:text property="flagNameOne"/>Flag Name_1</td>  
<td> <html:text property="flagNameValue"/>1 </td>  
<td> <html:text property="flagNameNotes"/>Flag Notes_1 </td>  
</tr>  

</form>

with the class:

class MyBean extends ActionForm
{
String flagNameOne;
String flagNameValue;
.
.
// other properties

// getter/setter here
}

[Sagar Rohankar]

dhruva mistry wrote:

<script>
function takeVal(form f) {

var flagNameOne_js = document.f.flagNameOne;

return flagNameOne_js;
}
</script>
<!-- "Which Action gets called here ??" -->
<form onSubmit="takeVal(this.form);">

Have you read from start, what are we trying to do here, simple GET and INSERT data..