Forum:

JDBC and Relational Databases

need help :: multiple rows update without primary key

Ranch Hand

Posts: 52

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi guys,
My requirement is i have to update the table where there is no primary key. the user enters the kitnumber, so we are pulling all the rows for that particular kit number.i have checkboxes for all the rows, and the value for the checkbox is the row id.

when we display the results in a grid, we have to show all the existing data in a text field below each row.

upto this part i am done. i am able to pull the data from table and display in a table and display a textbox below each row with existing data.

my question i have to display the textboxes only when the user clicks on checkboxes.. i have used the <DIV> some how it is not working.

the user clicks on checkboxes we will display the textboxes with existing data...the user can update the checboxes data and clicks on update we need to update the db with new vales..

here my question is how do we pass theses values to DB... i am totally confused.. any help would be greatly appreciated..

here is my jsp

</script> 
<script language="JavaScript" src="js/editableDropDown.js" type="text/javascript"></script>
</head>
<script language="JavaScript">

javascript:window.history.forward(1);

</script> 
<script type="text/ecmascript" src="js/syncscroll.js"></script>

<jsp:useBean id="sessionForm" scope="request" class="com.mot.programming.forms.ProgrammingUpdateForm"/>
<jsp:useBean id="resultsExtra" scope="request" class="java.util.ArrayList"/>

<font size="5" color='#2B60DE'><h3><u>Update Optional Configuration</u></h3>
</font>
</br><br/><br/>

<table>
<tr><td>
<h3>SVNKIT</h3>
</td><td>
<html:text name="ProgrammingUpdateForm" property="svnkit" tabindex="8" style="text-transform:uppercase" disabled="true">
</html:text>
<br/><br/><br/>
</td></tr>
</table>
</br>

<div id="div1">
<table width=1500  border="2">
<TR>
<th width=100/>UPDATE
<th width=100/>SVNKIT
<th width=100 />TYPE
<th width=130 />CATEGORY
<th width=100  />XCVR_NO

<th width=150 />FILE_PATH
<th width=200 />FILE_NAME
<th width=150 />FILE VERSION
<th width=100 />COMMENTS
<th width=100 />CREATE_DT
<th width=100 />CREATED_BY
<th width=100 />UPDATED_DATE
<th width=100 />UPDATED_BY

</tr>
</table>
</div>

<input type= "checkbox" name="ProgrammingUpdateForm" property="rowId"  value='<c:out value="${log.rowid}"/>' onklick="showData('div3', this)" />
</td>
<td width=100>
<c:out value="${log.progKit}"/>

</td> 
<td width=100>
 <c:out value="${log.type}"/>
 </td>
 <td width=130>
 <c:out value="${log.category}"/>
 </td>
 <td width=100>
 <c:out value="${log.xcvrNO}"/>
 </td>
 <td width=150>
 <c:out value="${log.filePath}"/>
 </td>
 <td width=200>
 <c:out value="${log.fileName}"/>
 </td>
 <td width=150>
 <c:out value="${log.version}"/>
 </td>
 <td width=100>
 <c:out value="${log.comment}"/>
 </td>
 <td width=100>
 <c:out value="${log.creationDateExtra}"/>
 </td>
 <td width=100>
 <c:out value="${log.createdBy}"/>
 </td>
 <td width=100>
 <c:out value="${log.updatedDate}"/>
 </td>
 <td width=100>
 <c:out value="${log.updatedBy}"/>
 </td

</td>

<td><h3>CATEGORY</h3></td><td>
<input tyepe= text name="category"  value=<c:out value="${log.category}"/>  >

</td><td><h3>XCVR_NO</h3></td><td>
<input type = text name="xcvrNO"  value= <c:out value="${log.xcvrNO}"/> >

</td>

</td><td><h3>FILE NAME</h3></td><td>
<input type = text name="fileName"  value= <c:out value="${log.fileName}"/>>

</td>

<td><h3>VERSION</h3></td><td>
<input type= text name="version"  value=  <c:out value="${log.version}"/>  >

</td><td><h3>COMMENT</h3></td>
<td><input type= text name="comment"  value= <c:out value="${log.comment}"/> >

</td>

</tr>
</tr>

</logic:iterate>
</table>
</div>
</table>
</form>

</div>
   <br/></br>
   <html:form action="/ProgrammingUpdate.do?method=updateOptional">
   <html:submit value="UPDATE"></html:submit>
   </html:form>

Jeanne Boyarsky

author & internet detective

Posts: 42056

926

I like...

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Kumar,
The first step is to figure how to uniquely identify a row in the table. You say you don't have a primary key. Do you have any unique combination of columns? (At a minimum, all the columns combined should be unique)

[OCP 21 book] | [OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2

Java 8 (verified skill)
Skill verified by Jeanne Boyarsky

JUnit 5 (verified skill)
Skill verified by Jeanne Boyarsky

Bauke Scholtz

Ranch Hand

Posts: 2458

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Originally posted by kumar kosaraju:
My requirement is i have to update the table where there is no primary key. the user enters the kitnumber, so we are pulling all the rows for that particular kit number.i have checkboxes for all the rows, and the value for the checkbox is the row id.

when we display the results in a grid, we have to show all the existing data in a text field below each row.

upto this part i am done. i am able to pull the data from table and display in a table and display a textbox below each row with existing data.

Fine. Although a PK-less table indicates a bad datamodel.

my question i have to display the textboxes only when the user clicks on checkboxes.. i have used the <DIV> some how it is not working.

That sounds like if the HTML <div> element has some magical working. But it's just a simple block element. Can you please elaborate in detail what you expected of it?

the user clicks on checkboxes we will display the textboxes with existing data...

If you want to do this synchronously, just submit the form and let JSP render the input fields conditionally based on the checkbox value. You can perfectly use JSTL/EL for this. If you want to do this asynchronously, then use Javascript+DOM (DHTML) to display/hide elements during the onclick event of the checkbox.

the user can update the checboxes data and clicks on update we need to update the db with new vales..

here my question is how do we pass theses values to DB... i am totally confused.. any help would be greatly appreciated..

Just by submitting the form to the server and processing the parameters the usual way?

At which step exactly are you stucking while implementing it accordingly? You only stated some functional requirements and said that the <div> "doesn't work". You didn't elaborate in detail about the question/problem with which you're actually struggling. What is the coding problem you're struggling with?
[ December 22, 2008: Message edited by: Bauke Scholtz ]

Revanth reddy

Ranch Hand

Posts: 52

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Originally posted by Bauke Scholtz:
Just by submitting the form to the server and processing the parameters the usual way?

At which step exactly are you stucking while implementing it accordingly? You only stated some functional requirements and said that the <div> "doesn't work". You didn't elaborate in detail about the question/problem with which you're actually struggling. What is the coding problem you're struggling with?

[ December 22, 2008: Message edited by: Bauke Scholtz ]

Thankyou so much for your reply.my problem here is the onklick() method is not working. when the page loads i am able to pull the data to grid and showing the values in the textboxes. my requirement is we need to show the textboxes,only when the user clicks on checkbox.

Revanth reddy

Ranch Hand

Posts: 52

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Originally posted by Jeanne Boyarsky:
Kumar,
The first step is to figure how to uniquely identify a row in the table. You say you don't have a primary key. Do you have any unique combination of columns? (At a minimum, all the columns combined should be unique)

Unfortunatly none of the combination is unique, so i am using rowid. i want to update the row based on rowid.

Paul Sturrock

Bartender

Posts: 10336

I like...

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Unfortunatly none of the combination is unique, so i am using rowid. i want to update the row based on rowid.

rowid is not a dependable mechanism - it will change as the data is changed (and its database dependent).

Trying to work with an entity that has no unique identifier is doomed to failure. Make things easy on yourself and add a surrogate key to the table.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch

Jeanne Boyarsky

author & internet detective

Posts: 42056

926

I like...

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Originally posted by kumar kosaraju:
Unfortunatly none of the combination is unique, so i am using rowid. i want to update the row based on rowid.

Are you saying that you have multiple rows with exactly the same values? If so, why would the user care which one gets updated?

Warning! Way too comfortable! Do not sit! Try reading this tiny ad instead:

Smokeless wood heat with a rocket mass heater

https://woodheat.net