I assume you want to do this using AJAX. Post what code you have so far.
I'm not aware of AJAX. I'm sending you the code i have so far.. Please help me
Thank you in advance
[HTML]<%@ page contentType="text/html;charset=windows-1252"%>
<%@ page import="java.sql.*" %>
<%@ page import="javax.sql.*" %>
<%@ page import="java.lang.*" %>
<%@ page import="java.lang.Object.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<html><head>
<script language="JAVASCRIPT">
function save()
{
document.timesheetform.action = "Hide5.jsp?a=t";
document.timesheetform.submit();
}
function commit()
{
document.timesheetform.action = "Hide5.jsp?a=p";
document.timesheetform.submit();
}
</script>
</head>
<body>
[/html]
- <Script>
-
-
var INPUT_NAME_PREFIX = 'inputName';
-
var TABLE_NAME = 'tblSample';
-
var headerRows;
-
var i=0;
-
window.onload=fillInRows;
-
-
function fillInRows()
-
{
-
//timesheetform.entrydate.focus();
-
headerRows = document.getElementById(TABLE_NAME).rows.length;
-
addRowToTable();
-
}
-
-
function myRowObject(one, two, three, four,five,six,seven,eight)
-
{
-
this.one = one; // text object
-
this.two = two; // input text object
-
this.three = three; // input checkbox object
-
this.four = four;
-
this.five = five;
-
this.six = six;
-
this.seven = seven;
-
this.eight = eight;
-
}
-
-
function addRowToTable(val)
-
{
-
-
i++;
-
var tbl = document.getElementById(TABLE_NAME);
-
var nextRow = tbl.rows.length;
-
var iteration = nextRow - parseInt(headerRows) + parseInt(1);
-
-
// add the row
-
var row = tbl.insertRow(nextRow);
-
-
-
// cell 0 - check box select delete
-
var cell0 = row.insertCell(0);
-
var cb = document.createElement('input');
-
cb.setAttribute('type', 'checkbox');
-
cb.setAttribute('name', INPUT_NAME_PREFIX + iteration);
-
cell0.appendChild(cb);
-
-
// cell 1 - select WBS code
-
-
var test = new Array();
-
var cell1 = row.insertCell(1);
-
for(var ii=0; ii<document.timesheetform.l.value; ii++)
-
{
-
test[ii]=document.getElementById("wbsname"+ii).value;
-
}
-
var opt;
-
var txt;
-
var sel = document.createElement('select');
-
sel.setAttribute("name","wbscode"+i);
-
for(var ii=0; ii<document.timesheetform.l.value; ii++)
-
{
-
opt = document.createElement("option");
-
opt.setAttribute("value",test[ii]);
-
txt = document.createTextNode(test[ii]);
-
opt.appendChild(txt);
-
sel.appendChild(opt);
-
}
-
cell1.appendChild(sel);
-
-
/* var abc="<select name='wbscode"+i+"'>";
-
for(var ii=0; ii<document.timesheetform.l.value; ii++)
-
{
-
abc+="<option value='"+ii+"'>"+test[ii]+"</option>";
-
}
-
abc+="</select>";
-
cell1.innerHTML = abc; */
-
-
// cell 2 - input text Start Time
-
var cell2 = row.insertCell(2);
-
var txtInp = document.createElement('input');
-
txtInp.setAttribute('type', 'text');
-
txtInp.setAttribute("name","stime"+i);
-
txtInp.setAttribute('size', '10');
-
cell2.appendChild(txtInp);
-
/* txtInp.onactivate = function() {
-
hrs.disabled=false;
-
hrs.value="";
-
-
} ;*/
-
txtInp.onchange = function() {
-
hrs.disabled=false;
-
//hrs.value=((Number(ehr)*60+Number(emn))-((Number(shr)*60)+Number(smn)));
-
-
}
-
-
-
// cell 3 - Text End time
-
var cell3 = row.insertCell(3);
-
var btn = document.createElement('input');
-
btn.setAttribute('type', 'text');
-
btn.setAttribute('name', 'etime'+i);
-
btn.setAttribute('size', '10');
-
cell3.appendChild(btn);
-
btn.onactivate = function() {
-
// hrs.disabled=false;
-
// hrs.value="";
-
if(txtInp.value=="")
-
{ alert("Enter Start Date");txtInp.focus();return false; }
-
else if(txtInp.value.length>5 || txtInp.value.length<5)
-
{alert("Please follow the format hr:mn");txtInp.focus();return false;}
-
return false;
-
} ;
-
btn.onchange = function() {
-
hrs.focus();return false;
-
//hrs.value=((Number(ehr)*60+Number(emn))-((Number(shr)*60)+Number(smn)));
-
-
}
-
-
-
// cell 4- text hrs worked
-
var cell4 = row.insertCell(4);
-
var hrs = document.createElement('input');
-
hrs.setAttribute('type', 'text');
-
hrs.setAttribute('name', 'hrswkd'+i);
-
hrs.setAttribute('size', '10');
-
hrs.setAttribute('readOnly', 'true');
-
cell4.appendChild(hrs);
-
hrs.onactivate = function() {
-
-
if(btn.value=="")
-
{ alert("Enter End Date");btn.focus();return false; }
-
else if(btn.value.length>5 || btn.value.length<5)
-
{alert("Please follow the format hr:mn");btn.focus();return false;}
-
else{
-
var ehr=btn.value.substring(0,2);var emn=btn.value.substring(3,5);
-
var shr=txtInp.value.substring(0,2);var smn=txtInp.value.substring(3,5);
-
if(smn>59)
-
{alert("Error in minutes entered");txtInp.focus();return false;}
-
else if(emn>59)
-
{alert("Error in minutes entered");btn.focus();return false;}
-
if(shr>23)
-
{alert("Error in hours entered");txtInp.focus();return false;}
-
else if(ehr>23)
-
{alert("Error in hours entered");btn.focus();return false;}
-
if(shr>ehr)
-
{alert("Start time cannot be greater than end time");btn.focus();return false;}
-
-
else if(ehr==shr)
-
{ if(emn<smn){alert("Start time cannot be greater than end time");btn.focus();return false;} }
-
}
-
var xx=((Number(ehr)*60+Number(emn))-((Number(shr)*60)+Number(smn)));
-
if(xx%15>0)
-
hrs.value=xx+(15-(xx%15));
-
else hrs.value=xx;
-
//hrs.disabled=true;
-
return false;
-
}
-
;
-
-
// cell 5 -select activity
-
var cell5 = row.insertCell(5);
-
var cb2 = document.createElement('select');
-
cb2.setAttribute("name","activity"+i);
-
secondOpt1=document.createElement("option");
-
secondOpt1.setAttribute("id","design");
-
secondOpt1.setAttribute("value","Design");
-
secondOpt1.appendChild(document.createTextNode("Design"));
-
secondOpt2=document.createElement("option");
-
secondOpt2.setAttribute("id","implementation");
-
secondOpt2.setAttribute("value","Implementation");
-
secondOpt2.appendChild(document.createTextNode("Implementation"));
-
secondOpt3=document.createElement("option");
-
secondOpt3.setAttribute("id","testing");
-
secondOpt3.setAttribute("value","Testing");
-
secondOpt3.appendChild(document.createTextNode("Testing"));
-
cb2.appendChild(secondOpt1);
-
cb2.appendChild(secondOpt2);
-
cb2.appendChild(secondOpt3);
-
cell5.appendChild(cb2);
-
-
// cell 6 - select activity type
-
var cell6 = row.insertCell(6);
-
var cb3 = document.createElement('select');
-
cb3.setAttribute("name","activitytype"+i);
-
Opt1=document.createElement("option");
-
Opt1.setAttribute("id","f");
-
Opt1.setAttribute("value","f");
-
Opt1.appendChild(document.createTextNode("Fresh"));
-
Opt2=document.createElement("option");
-
Opt2.setAttribute("id","r");
-
Opt2.setAttribute("value","r");
-
Opt2.appendChild(document.createTextNode("Rework"));
-
Opt3=document.createElement("option");
-
Opt3.setAttribute("id","R");
-
Opt3.setAttribute("value","R");
-
Opt3.appendChild(document.createTextNode("Review"));
-
Opt4=document.createElement("option");
-
Opt4.setAttribute("id","c");
-
Opt4.setAttribute("value","c");
-
Opt4.appendChild(document.createTextNode("Change Request"));
-
cb3.appendChild(Opt1);
-
cb3.appendChild(Opt2);
-
cb3.appendChild(Opt3);
-
cb3.appendChild(Opt4);
-
cell6.appendChild(cb3);
-
-
// cell 7 - textarea work details
-
var cell7 = row.insertCell(7);
-
var cb4 = document.createElement('textarea');
-
//cb2.setAttribute('type', 'textarea');
-
cb4.setAttribute('cols', '20');
-
cb4.setAttribute('name', 'wdetails'+i);
-
//cb.setAttribute('option', 'def');
-
cell7.appendChild(cb4);
-
-
var cell8 = row.insertCell(8);
-
var cb5 = document.createElement('select');
-
cb5.setAttribute("name","status"+i);
-
Opt11=document.createElement("option");
-
Opt11.setAttribute("id","f");
-
Opt11.setAttribute("value","C");
-
Opt11.appendChild(document.createTextNode("Completed"));
-
Opt12=document.createElement("option");
-
Opt12.setAttribute("id","r");
-
Opt12.setAttribute("value","P");
-
Opt12.appendChild(document.createTextNode("Pending"));
-
Opt13=document.createElement("option");
-
Opt13.setAttribute("id","R");
-
Opt13.setAttribute("value","I");
-
Opt13.appendChild(document.createTextNode("In Progress"));
-
cb5.appendChild(Opt11);
-
cb5.appendChild(Opt12);
-
cb5.appendChild(Opt13);
-
cell8.appendChild(cb5);
-
-
row.myRow = new myRowObject(cb,txtInp,btn,hrs,cb2,cb3,cb4,cb5);
-
document.timesheetform.iii.value=i;
-
}
-
-
// CONFIG: this entire function is affected by myRowObject settings // If there isn't a checkbox in your row, then this function can't be used.
-
function deleteChecked()
-
{
-
var checkedObjArray = new Array();
-
var cCount = 0;
-
-
var tbl = document.getElementById(TABLE_NAME);
-
for (var i=0; i<tbl.rows.length; i++) {
-
if (tbl.rows[i].myRow && tbl.rows[i].myRow.one.getAttribute('type') == 'checkbox' && tbl.rows[i].myRow.one.checked) {
-
checkedObjArray[cCount] = tbl.rows[i];
-
cCount++;
-
}
-
}
-
if (checkedObjArray.length > 0 ) {
-
var rIndex = checkedObjArray[0].rowIndex;
-
deleteRows(checkedObjArray);
-
reorderRows(tbl, rIndex);
-
}
-
}
-
-
function reorderRows(tbl, startingIndex) {
-
if (tbl.rows[startingIndex]) {
-
var count = startingIndex;
-
for (var i=startingIndex; i<tbl.rows.length; i++) {
-
-
// CONFIG: next line is affected by myRowObject settings
-
tbl.rows[i].myRow.one.data = count; // text
-
-
// CONFIG: next line is affected by myRowObject settings
-
tbl.rows[i].myRow.two.name = INPUT_NAME_PREFIX + count; // input text
-
-
// CONFIG: next line is affected by myRowObject settings
-
//var tempVal = tbl.rows[i].myRow.two.value.split(' '); // for debug purposes
-
//tbl.rows[i].myRow.two.value = count + ' was' + tempVal[0]; // for debug purposes
-
count++;
-
}
-
}
-
}
-
-
function deleteRows(rowObjArray)
-
{
-
for (var i=0; i<rowObjArray.length; i++) {
-
var rIndex = rowObjArray[i].rowIndex;
-
rowObjArray[i].parentNode.deleteRow(rIndex);
-
}
-
}
-
-
function openInNewWindow(frm)
-
{
-
// open a blank window
-
var aWindow = window.open('', 'TableAddRow2NewWindow',
-
'scrollbars=yes,menubar=yes,resizable=yes,toolbar=no,width=400,height=400');
-
-
// set the target to the blank window
-
frm.target = 'TableAddRow2NewWindow';
-
-
// submit
-
frm.submit();
-
}
-
</Script>
[html]<script src="Timesheetvalidate.js">
</script>
<script src="Editdata.js">
</script>
</head><body>
<center><h2>Time Sheet Details </h2></center>
<%if(session.getAttribute ("emp_name").equals("admini"))
{ %>
<div style="padding-left:600;font-size=10pt; FONT-FAMILY:arial;">
<a href="EmpCreate.jsp">Create User</a>
<a href="ProjectDetails.jsp">Project Details</a>
<a href="ChangePass.jsp">Change Password</a>
<a href="Logout.jsp">Logout</a>
</div>
<% }
else
{%>
<div style="padding-left:800;font-size=10pt; FONT-FAMILY:arial;">
<a href="ChangePass.jsp">Change Password</a>
<a href="Logout.jsp">Logout</a>
</div>
<div style="padding-left:800;font-size=10pt; FONT-FAMILY:arial;">
<a href="#" onclick="javascript
:edit()">Edit Temporararily Saved</a>
</div>
<% }%>
<form action="#" method="post" name="timesheetform" onSubmit="return checkDate(this);">
<table class="noborder" align="center">
<tr>
<td >Name</td>
<td >
<input type="text" name="T1" readonly size="25" value="<%=session.getAttribute("emp_name")%>">
</td>
</tr>
<%
Vector prjname=new Vector();
Vector prjid=new Vector();
Vector wbss=new Vector();
int i=0;
int vari=0;
String empid=(String)session.getAttribute("emp_ID");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con1 = DriverManager.getConnection("jdbc:odbc:sujay","tim esheet","timesheet");
Statement st= con1.createStatement();
ResultSet rs = st.executeQuery("select ts_project.prj_name,ts_project.prj_id from TS_PROJECT,ts_projectteam where ts_project.prj_id=ts_projectteam.prj_id and ts_projectteam.emp_id='"+empid+"'");
while(rs.next())
{
prjname.add(vari,rs.getString("prj_name"));
prjid.add(vari,rs.getString("prj_id"));
}
session.setAttribute("prj_ID",prjid);
ResultSet rs1 = st.executeQuery("select wbs_id from ts_wbs where prj_id='"+prjid+"'");
while(rs1.next())
{
wbss.add(i,rs1.getString(1));
i++;
}
int len=wbss.size();
%><input type="hidden" name = l size="25" value=<%=len%> >
<tr>
<td>Project</td>
<td> <select>
<% for(int varj=0; varj<=vari; varj++){%>
<option><%=prjname.elementAt(varj)%></option>
<%}%><option selected>Default</option></select>
</td>
</tr>
</table>
<% for(int k=0;k<len;k++){ %>
<input type="hidden" name = "wbsname<%=k%>" size="20" value=<%=wbss.elementAt(k)%> disabled>
<%}%><br><br><br>
<center>
<table border="1" id="tblSample" class="sample">
<tr>
<th >Select</th>
<th >WBS</th>
<th >Start Time</th>
<th >End Time</th>
<th >Mins Worked</th>
<th >Activity</th>
<th >Activity Type</th>
<th >Detail of Work</th>
<th >Status</th>
</tr>
</table><br><br><br><br>
<input type="hidden" name="iii">
<input type="button" value="Add" onclick="addRowToTable();" class="button" />
<input type="button" value="Save" class="button" onClick="save()"/>
<input type="button" value="Commit" class="button" onClick="commit()"/>
<input type="button" value="Delete Selected" onclick="deleteChecked();" />
<input type="button" value="Exit" onclick="window.close();" class="button"/>
</center> </form> </html>[/HTML]