eg...when i enter product id in the first cell, the product name and its rate should come in the next two cells...it should take from the data base...
it's my code........
Expand|Select|Wrap|Line Numbers
- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
- "http://www.w3.org/TR/html4/loose.dtd" >
- <%@ page import="java.sql.*" %>
- <%@ page import="java.io.*" %>
- <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
- <head>
- <title></title>
- <script language="JavaScript" type="text/javascript">
- /*<![CDATA[*/
- var i=1,j=0,k=0,tot=0,vat=0,totrow=0;
- function Add(id){
- var id1='ta'+i;
- var id2='tb'+i;
- var id3='tc'+i;
- var id4='td'+i;
- var id5='te'+i;
- var table=document.getElementById(id);
- var tbody=table.getElementsByTagName('TBODY')[0];
- var newrow=tbody.appendChild(table.rows[0].cloneNode(true));
- // newrow.getElementsByTagName('SELECT')[0].selectedIndex=0; for combobox
- newrow.getElementsByTagName('INPUT')[0].value='';
- newrow.getElementsByTagName('INPUT')[0].id=id1;
- newrow.getElementsByTagName('INPUT')[0].name=id1;
- newrow.getElementsByTagName('INPUT')[1].value='';
- newrow.getElementsByTagName('INPUT')[1].id=id2;
- newrow.getElementsByTagName('INPUT')[1].name=id2;
- newrow.getElementsByTagName('INPUT')[2].value='';
- newrow.getElementsByTagName('INPUT')[2].id=id3;
- newrow.getElementsByTagName('INPUT')[2].name=id3;
- newrow.getElementsByTagName('INPUT')[3].value='';
- newrow.getElementsByTagName('INPUT')[3].id=id4;
- newrow.getElementsByTagName('INPUT')[3].name=id4;
- newrow.getElementsByTagName('INPUT')[4].value='';
- newrow.getElementsByTagName('INPUT')[4].id=id5;
- newrow.getElementsByTagName('INPUT')[4].name=id5;
- newrow.getElementsByTagName('INPUT')[5].checked=false;
- i++;
- }
- function Remove(id,nme){
- var table=document.getElementById(id);
- var rows=table.rows;
- for (var remove=[],zxc0=0;zxc0<rows.length;zxc0++){
- var cb=rows[zxc0].getElementsByTagName('INPUT')[5];
- if (cb&&cb.name==nme&&cb.checked){
- remove.push(rows[zxc0]);
- }
- }
- if (remove.length==rows.length) return alert('U cant remove all rows');
- for (var zxc1=0;zxc1<remove.length;zxc1++){
- remove[zxc1].parentNode.removeChild(remove[zxc1]);
- }
- }
- /*
- function Remove(id){
- var table=document.getElementById(id);
- var rows=table.rows;
- for (var zxc0=0;zxc0<rows.length;zxc0++){
- if (rows[zxc0].getElementsByTagName('INPUT')[5].checked){
- rows[zxc0].parentNode.removeChild(rows[zxc0]);
- zxc0--;
- }
- }
- }
- */
- function showText(tid,bid)
- {
- var txt=document.getElementById(tid);
- var but=document.getElementById(bid);
- txt.type="textbox";
- but.type="button";
- //but.onclick="hideText()";
- alert("Please Enter Purchase.Order.No and click OK");
- }
- function hideText(tid1,bid1)
- {
- var txt1=document.getElementById(tid1);
- var but1=document.getElementById(bid1);
- txt1.type="hidden";
- but1.type="hidden";
- }
- function test(tt0)
- {
- var dd='ta'+j;
- var ttxt0=document.getElementById(tt0);
- var ttxt1=document.getElementById(dd);
- var ppnam=ttxt1.value;
- //var ppnam=ttxt1.value;
- ttxt0.value=ppnam;
- j++;
- }
- function test5(tt5)
- {
- var dd3='tc'+k;
- var dd4='td'+k;
- var ttxt5=document.getElementById(tt5);
- var ttxt3=document.getElementById(dd3);
- var ttxt4=document.getElementById(dd4);
- var num2=ttxt4.value;
- var num1=ttxt3.value;
- var val=0;
- val=parseFloat(num1) * parseFloat(num2);
- ttxt5.value=val;
- k++;
- }
- function cal(id)
- {
- var table=document.getElementById(id);
- var rows=table.rows;
- for (var zxc0=0;zxc0<rows.length;zxc0++)
- {
- //tot=tot+5;
- tot=parseFloat(tot)+parseFloat((rows[zxc0].getElementsByTagName('INPUT')[4].value));
- totrow++;
- }
- vat=parseFloat(tot/12.5);
- document.product.vate.value=vat;
- document.product.total.value=parseFloat(vat+tot);
- document.product.rcount.value=totrow;
- vat=0;
- tot=0;
- totrow=0;
- }
- </script>
- <body>
- <form name="product" action="mynew.jsp" method="get">
- <table id="head" border="1">
- <tbody>
- <tr><td colspan="50"><b> Product Id </b></td><td colspan="50"><b> Product Name </b></td><td colspan="50"><b> Quantity </b></td><td colspan="30"><b> Rate </b></td><td colspan="30"><b> Value </font></b></td>
- </tr>
- </tbody>
- </table>
- <table id="tst" border="1">
- <tbody>
- <tr>
- <td>
- <input name="ta0" type="textbox" size="10" id="ta0"/>
- <input name="tb0" type="textbox" size="30" id="tb0" onfocus="test(id);"/>
- <input name="tc0" type="textbox" size="10" id="tc0"/>
- <input name="td0" type="textbox" size="10" id="td0"/>
- <input name="te0" type="textbox" size="10" id="te0" onfocus="test5(id);" readonly/>
- <input type="checkbox" name="bb[]" id="cbox"/></td>
- </tr>
- </tbody>
- </table>
- <input type="button" name="" value="Add" onclick="Add('tst');"/>
- <input type="button" name="" value="Remove" onclick="Remove('tst','bb[]');"/>
-
- <input name="txt1" type="hidden" id="textid" size="10"/>
- <input name="" value="OK" type="hidden" id="buttonid" size="10" onclick="hideText('textid','buttonid');"/>
-
-
-
-
-
-
- <input type="button" value="calculate" onclick="cal('tst');"/>
- <br>
- <br>
- Vat:
- <input type="textbox" name="vate"/>
- <br>
- <br>
- Total:
- <input type="textbox" name="total"/>
- <br>
- <br>
- <input type="button" name="" value="Edit" onclick="showText('textid','buttonid');"/>
- <input type="submit" name="" value="Save"/>
- <br>
- <br>
- <input type="textbox" name="rcount"/>
- <%
- %>
- <br>
- <%
- int count=0;
- try { count = Integer.parseInt(request.getParameter("rcount"));
- }
- catch (Throwable t) { }
- String pid[]=new String[count];
- String pnam[]=new String[count];
- String qtyt[]=new String[count];
- String rate[]=new String[count];
- String value[]=new String[count];
- String vatt=null,tot=null;
- %>
- <input type="textbox" name="rnum" value=<%=count%>>
- </form>
- </body>
- </head>
- </html>