DBconn.java 中:String name1 = new String(request.getParameter("oCell.innerText").getBytes("ISO-8859-1")).trim();
String name2 = new String(request.getParameter("oCell1.innerText").getBytes("ISO-8859-1")).trim();
String sql="insert into ticket_sell (clientType,sellpp,keyuanpp,zhandian,client,piaoxing,price,ticketnumber,yhprice,bdate,ddate,sell_code)";
sql+="values('"+name1+"','"+name2+"','"+name3+"','"+name4+"','"+name5+"','"+name6+"','"+name7+"','"+name8+"','"+name9+"','"+name10+"','"+name11+"','"+name12+"')";
db.update(sql);
这样直接获取 不行啊
你看看该怎么办啊
String name2 = new String(request.getParameter("oCell1.innerText").getBytes("ISO-8859-1")).trim();
String sql="insert into ticket_sell (clientType,sellpp,keyuanpp,zhandian,client,piaoxing,price,ticketnumber,yhprice,bdate,ddate,sell_code)";
sql+="values('"+name1+"','"+name2+"','"+name3+"','"+name4+"','"+name5+"','"+name6+"','"+name7+"','"+name8+"','"+name9+"','"+name10+"','"+name11+"','"+name12+"')";
db.update(sql);
这样直接获取 不行啊
你看看该怎么办啊
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<SCRIPT LANGUAGE="JavaScript">
<!--
function $(sId){return document.getElementById(sId);}
var num = 0; function sub(){
var oTbl = $('otbl');
//alert(oTbl.rows.length)
if(num < oTbl.rows.length){
oTbl.rows(num).cells(0).innerText = $('oname').value;
oTbl.rows(num).cells(1).innerText = $('oage').value;
}else{
alert(num)
var oRow = oTbl.insertRow(num);
var oCell = oRow.insertCell(0);
var oCell1 = oRow.insertCell(1);
oCell.innerText += $('oname').value;
oCell1.innerText += $('oage').value;
}
num++; }
var arrDb = new Array();
function Dbclick(){
var oTbl = $('otbl');
for(var i=0;i<oTbl.rows.length;i++){
for(var j=0;j<oTbl.rows(i).cells.length;j++){
arrDb.push(oTbl.rows(i).cells(j).innerText);
}
}
alert(arrDb.length);
alert(arrDb.toString())//arrDb就保存了所有数据,你把它放到隐藏控件中,然后request.getParameter('隐藏控件name')
}
//-->
</SCRIPT>
</HEAD> <BODY>
<INPUT TYPE="text" id='oname' value='小王'>
<INPUT TYPE="text" id='oage' value = '22'>
<INPUT TYPE="button" value='提交' onclick="sub()">
<INPUT TYPE="button" value="更新到数据库" onclick='Dbclick()'>
<TABLE border='1'id='otbl'>
<TR>
<TD> </TD>
<TD> </TD>
</TR>
<TR>
<TD> </TD>
<TD> </TD>
</TR>
<TR>
<TD> </TD>
<TD> </TD>
</TR>
<TR>
<TD> </TD>
<TD> </TD>
</TR>
</TABLE>
</BODY>
</HTML>
中
“你把它放到隐藏控件中”
是什么意思啊?
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<SCRIPT LANGUAGE="JavaScript">
<!--
function $(sId){return document.getElementById(sId);}
var num = 0; function sub(){
var oTbl = $('otbl');
//alert(oTbl.rows.length)
if(num < oTbl.rows.length){
oTbl.rows(num).cells(0).innerText = $('oname').value;
oTbl.rows(num).cells(1).innerText = $('oage').value;
}else{
alert(num)
var oRow = oTbl.insertRow(num);
var oCell = oRow.insertCell(0);
var oCell1 = oRow.insertCell(1);
oCell.innerText += $('oname').value;
oCell1.innerText += $('oage').value;
}
num++; }
var arrDb = new Array();
function Dbclick(){
var oTbl = $('otbl');
for(var i=0;i<oTbl.rows.length;i++){
for(var j=0;j<oTbl.rows(i).cells.length;j++){
arrDb.push(oTbl.rows(i).cells(j).innerText);
}
}
document.getElementById('hid').value = arrDb;//request.getParameter('hid')即可
alert(arrDb.length);
alert(arrDb.toString())//
}
//-->
</SCRIPT>
</HEAD> <BODY>
<INPUT TYPE="text" id='oname' value='小王'>
<INPUT TYPE="text" id='oage' value = '22'>
<INPUT TYPE="hidden" id="hid">//这是一个隐藏字段
<INPUT TYPE="button" value='提交' onclick="sub()">
<INPUT TYPE="button" value="更新到数据库" onclick='Dbclick()'>
<TABLE border='1'id='otbl'>
<TR>
<TD> </TD>
<TD> </TD>
</TR>
<TR>
<TD> </TD>
<TD> </TD>
</TR>
<TR>
<TD> </TD>
<TD> </TD>
</TR>
<TR>
<TD> </TD>
<TD> </TD>
</TR>
</TABLE>
</BODY>
</HTML>
function Dbclick(){
var oTbl = $('otbl');
for(var i=0;i<oTbl.rows.length;i++){
for(var j=0;j<oTbl.rows(i).cells.length;j++){
arrDb.push(oTbl.rows(i).cells(1).innerText);
arrDb1.push(oTbl.rows(i).cells(2).innerText);
}
}
document.getElementById('hid').value = arrDb;//request.getParameter('hid')即可
document.getElementById('hid1').value = arrDb1;//request.getParameter('hid')即可
alert(arrDb.length);
alert(arrDb.toString()) <INPUT TYPE="hidden" id="hid">
<INPUT TYPE="hidden" id="hid1">
<INPUT TYPE="button" value='提交' onclick="sub()">
<INPUT TYPE="button" value="更新到数据库" onclick='Dbclick()'>传递中:
String name1 = new String(request.getParameter("hid").getBytes("ISO-8859-1")).trim();
String name2 = new String(request.getParameter("hid1").getBytes("ISO-8859-1")).trim();
String sql="insert into cesi (id1,id2)";
sql+="values('"+name1+"','"+name2+"')";
db.update(sql); 改成了这样 但单击“更新到数据库”
没有一点反应 这是怎么回事啊?
是不是我修改错了???
<INPUT TYPE="text" id='oname' value='小王'>
<INPUT TYPE="text" id='oage' value = '22'>
<INPUT TYPE="hidden" id="hid">
<INPUT TYPE="hidden" id="hid1">
<INPUT TYPE="button" value='提交' onclick="sub()">
<INPUT TYPE="button" value="更新到数据库" onclick='Dbclick()'>sell_check.jsp里:
String name1 = new String(request.getParameter("hid").getBytes("ISO-8859-1")).trim();
String name2 = new String(request.getParameter("hid1").getBytes("ISO-8859-1")).trim();
String sql="insert into cesi (id1,id2)";
sql+="values('"+name1+"','"+name2+"')";
db.update(sql); 改成这样:var arrDb = new Array();
function Dbclick(){
var oTbl = $('otbl');
for(var i=0;i<oTbl.rows.length;i++){
arrDb.push(oTbl.rows(i).cells(1).innerText);
arrDb1.push(oTbl.rows(i).cells(2).innerText);
}
document.getElementById('hid').value = arrDb;//request.getParameter('hid')即可
document.getElementById('hid1').value = arrDb1;//request.getParameter('hid')即可
alert(arrDb.length);
alert(arrDb.toString())也是没有反应???
for(int i=0;i<name1.length;i++)
{
String sql="insert into cesi (id1)";
sql+="values('"+name1[i]+"')";
db.update(sql);
}改成这样还是没有反应啊?
??