want data base connection in focus lost of a textbox in the table

i wrote a code in jsp to create dynamic table..the problem is i need data base connection when cursor moves from one cell to other...
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>&nbsp;Product Id&nbsp;&nbsp;&nbsp;</b></td><td colspan="50"><b>&nbsp;Product Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</b></td><td colspan="50"><b>&nbsp;Quantity&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</b></td><td colspan="30"><b>&nbsp;Rate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</b></td><td colspan="30"><b>&nbsp;Value&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</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[]');"/>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

<input name="txt1" type="hidden" id="textid" size="10"/>
 
<input name="" value="OK" type="hidden" id="buttonid" size="10" onclick="hideText('textid','buttonid');"/>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
<input type="button" value="calculate" onclick="cal('tst');"/>

<br>

<br>

Vat:&nbsp;&nbsp;

<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>

Sep 22 '08 #1

Subscribe Post Reply

2361

r035198x

13,262

8TB

Please use code tags when posting code.
What you need is usually done using AJAX these days.

Sep 23 '08 #2

Similar topics

Data Grid Problem

by: Qumer Mumtaz | last post by:

h I am using a datagrid control. I am displaying some controls like Date Time picker, combo boxes, ect in some cells.When a particuler cell is got...

C# / C Sharp

bind data to textboxes

by: Mike | last post by:

I'm calling a component to get my data. The component is returning a dataset. I need to populate text boxes on my aspx page with the data within...

ASP.NET

open of /usr/lib/pgsql/data/pg_clog/0F3E failed

by: ruben | last post by:

Hi: I'm running a large database on PostgreSQL 7.1.3. 20 days ago the database failed with a threatening and not too descriptive error like: ...

PostgreSQL Database

Inserting data from web form not working?

by: pd123 | last post by:

I'm new to C# and .net and I'm trying to create a form that will register users in a sql server database. I have the following code but when I run...

General

setting focus to a tabe cell.

by: Praveena.Alapati | last post by:

Hi, There is a tab control on a page with multiple tabs and handful of controls in each tab. The way it's rendered in html (like grid etc..) is...

Javascript

Problem in inserting data in sql server 2005 using asp.net

by: itsnidhu | last post by:

Hi this is nidhi from india, Since last 2 days i am facing a problem in asp.net code. The data base connection is done correctly as i can select...

.NET Framework

TextBox Focus Lost when using AJAX UpdatePanel

by: =?Utf-8?B?Qw==?= | last post by:

Hi, I have a series of textboxes on an aspx page. These textboxes are within an UpdatePanel. On the OnTextChanged Event of each textbox I do...

ASP.NET

adding rich text editor made me lose focus

by: karen987 | last post by:

I have a web page which used to work fine until i added a rich text editor. the pages are in ASP and it is a news weblog, with a comments section...

Javascript

Not calling Lost Focus event handler when I call Focus() method for a text box in C#

by: ravikumar2007 | last post by:

I am working with .NET 3.5 framework within an WPF application. I have a windows application where for a textbox, I have defined the lost focus...

.NET Framework

Basic concepts of WebLogic Admin training?

by: Naresh1 | last post by:

What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...

Oracle Database

https redirect with reverse proxy

by: jalbright99669 | last post by:

Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...

IIS / Internet Information Server

How to layout php header location with a variable as the location?

by: Matthew3360 | last post by:

Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...

PHP

How to use http requests (Get function) to get variable value?

by: Matthew3360 | last post by:

Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...

Python

How do I view Redshift db tables in Alteryx

by: Arjunsri | last post by:

I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...

General

PHP Curl Not wanting to connect to localhost.

by: Matthew3360 | last post by:

Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...

PHP

FPGA Question

by: Oralloy | last post by:

Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...

General

Join our open community on Discord to learn programming, SEO, and marketing

by: BLUEPANDA | last post by:

At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...

General

Mastering Python: A Versatile Programming Language for All

by: Rahul1995seven | last post by:

Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python...

General