大虾们,帮帮我这个新手吧!复选框问题 把你要使用checkbox的部分贴出来。还有你需要连什么数据库,access,oracle,还是mysql等等! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 <td bgcolor="#99CCFF"> <input type="checkbox" name="checkbox" value="<%= khbh %>"></td>再加上script:document.form1.checkbox.value=khbh就行了。只要checkbox现在的值和它原先配置好的值一样,它就是选中状态。<input type="checkbox" name="checkbox" value="<%= khbh %>">中的value="<%= khbh %>">就是原先配置好的值。代码一个字:乱。 不过建议使用radio一般修改的单条修改比较好,批量修改会比较麻烦!先给你个radio的例子!<HTML><HEAD><META http-equiv='Content-Type' content='text/html;charset=gb2312'><Meta name='Gemeratpr' content='网络程序员伴侣(Lshdic)2004'><TITLE>网页标题</TITLE><STYLE>*{font-size:12px;color:;}a{text-decoration:none;}a:hover{color:red;}</STYLE></HEAD><BODY topmargin='2' leftmargin='2'><BASE target='_top'><input type='radio' name='r1' value='1'>1111<input type='radio' name='r1' value='2'>2222<input type='radio' name='r1' value='3'>3333<input type='button' name='b1' value='haha' onclick=fun1()><SCRIPT language='Jscript'>function fun1(){for(var i=0;i<3;i++)if(r1[i].checked){ alert(r1[i].value); break;}}</SCRIPT></BODY></HTML> to ningIII(小宁) :我做的就是批量修改的,修改客户的类别,批量修改,而且客户有其种类别to Liangstar(小小编程猫) 我mm:帮帮我吧,我把内容修改了一下,源代码如下,希望尽快帮帮我 <%@ page import="java.sql.*,java.io.*,java.util.Date,java.util.Calendar,java.util.GregorianCalendar" contentType="text/html;charset=gb2312" %><%@ include file="../include/conn.jsp"%><%@ include file="../include/function.jsp"%><% String ZYBH=(String)session.getValue("bh"); if (ZYBH==null) response.sendRedirect("../"); else { String ZYQX=""; ZYQX=(String)session.getValue("qx"); //String sql; //String Name; //sql="select * from ZYXXB where ZYBH='"+ZYBH+"'"; //ResultSet rs=stmt.executeQuery(sql);%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><title>修改客户类别</title></head><body><form name="form1" method="post" action="edit_kehu_action.jsp"> <p align="center"><font color="#FF9900" size="5">修改客户类别</font></p> <table width="100%" border="0" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bgcolor="#FFCCCC"> <tr> <td><table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#CCFFFF"> <tr> <td colspan="2"><div align="center">意向型客户</div></td> </tr> <tr bgcolor="#FFFFCC"> <td colspan="2"> <div align="center">客户名称</div></td> </tr> <% String lb="意向型客户"; String lb_en=new String (lb.getBytes("gb2312"),"iso8859-1"); String Sql; Sql="select * from KHXXB,ZYXXB where KHXXB.ZYBH=ZYXXB.ZYBH and KHXXB.ZYBH='"+ZYBH+"' and KHXXB.KHLB like '%"+lb_en+"%' "; ResultSet rst=stmt.executeQuery(Sql); while(rst.next()) { String khmc = rst.getString("KHMC"); //String khlb = rst.getString("KHLB"); %> <tr bgcolor="#FFFFCC"> <td width="24%"> <input type="checkbox" name="name" value="checkbox"></td> <td width="76%"><%= khmc %> </td> </tr> <% }; %> <tr> <td colspan="2"><select name="f_khlb"id="select"> <option selected>意向型客户</option> <option>预计三个月签单客户</option> <option>预计一个月签单客户</option> <option>投标客户</option> <option>新签单客户</option> <option>老客户</option> <option>丢单客户</option> </select></td> </tr> </table></td> <td><table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#CCFFFF"> <tr> <td colspan="2"><div align="center">预计三个月签单客户</div></td> </tr> <tr bgcolor="#FFFFCC"> <td colspan="2"> <div align="center">客户名称</div></td> </tr> <% String lb1="预计三个月签单客户"; String lb1_en=new String (lb1.getBytes("gb2312"),"iso8859-1"); String Sql1; Sql1="select * from KHXXB,ZYXXB where KHXXB.ZYBH=ZYXXB.ZYBH and KHXXB.ZYBH='"+ZYBH+"' and KHXXB.KHLB like '%"+lb1_en+"%' "; ResultSet rst1=stmt.executeQuery(Sql1); while(rst1.next()) { String khmc1 = rst1.getString("KHMC"); String khlb1 = rst1.getString("KHLB"); %> <tr bgcolor="#FFFFCC"> <td width="18%"> <input type="checkbox" name="name" value="checkbox"></td> <td width="82%"><%= khmc1 %> </td> </tr> <% }; %> <tr> <td colspan="2"><select name="f_khlb1"id="select1"> <option>意向型客户</option> <option selected>预计三个月签单客户</option> <option>预计一个月签单客户</option> <option>投标客户</option> <option>新签单客户</option> <option>老客户</option> <option>丢单客户</option> </select></td> </tr> </table></td> <td><table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#CCFFFF"> <tr> <td colspan="2"><div align="center">预计一个月签单客户</div></td> </tr> <tr bgcolor="#FFFFCC"> <td colspan="2"> <div align="center">客户名称</div></td> </tr> <% String lb2="预计一个月签单客户"; String lb2_en=new String (lb2.getBytes("gb2312"),"iso8859-1"); String Sql2; Sql2="select * from KHXXB,ZYXXB where KHXXB.ZYBH=ZYXXB.ZYBH and KHXXB.ZYBH='"+ZYBH+"' and KHXXB.KHLB like '%"+lb2_en+"%' "; ResultSet rst2=stmt.executeQuery(Sql2); while(rst2.next()) { String khmc2 = rst2.getString("KHMC"); String khlb2 = rst2.getString("KHLB"); %> <tr bgcolor="#FFFFCC"> <td width="18%"> <input type="checkbox" name="name" value="checkbox"></td> <td width="82%"><%= khmc2 %></td> </tr> <% }; %> <tr> <td colspan="2"><select name="f_khlb2"id="select2"> <option>意向型客户</option> <option>预计三个月签单客户</option> <option selected>预计一个月签单客户</option> <option>投标客户</option> <option>新签单客户</option> <option>老客户</option> <option>丢单客户</option> </select></td> </tr> </table></td> <td><table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#CCFFFF"> <tr> <td colspan="2"><div align="center">投标客户</div></td> </tr> <tr bgcolor="#FFFFCC"> <td colspan="2"> <div align="center">客户名称</div></td> </tr> <% String lb3="投标客户"; String lb3_en=new String (lb3.getBytes("gb2312"),"iso8859-1"); String Sql3; Sql3="select * from KHXXB,ZYXXB where KHXXB.ZYBH=ZYXXB.ZYBH and KHXXB.ZYBH='"+ZYBH+"' and KHXXB.KHLB like '%"+lb3_en+"%' "; ResultSet rst3=stmt.executeQuery(Sql3); while(rst3.next()) { String khmc3 = rst3.getString("KHMC"); String khlb3= rst3.getString("KHLB"); %> <tr bgcolor="#FFFFCC"> <td width="19%"> <input type="checkbox" name="name" value="checkbox"></td> <td width="81%"><%= khmc3 %></td> </tr> <% }; %> <tr> <td colspan="2"><select name="f_khlb3"id="select3"> <option>意向型客户</option> <option>预计三个月签单客户</option> <option>预计一个月签单客户</option> <option selected>投标客户</option> <option>新签单客户</option> <option>老客户</option> <option>丢单客户</option> </select></td> </tr> </table></td> <td><table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#CCFFFF"> <tr> <td colspan="2"><div align="center">新签单客户</div></td> </tr> <tr bgcolor="#FFFFCC"> <td colspan="2"> <div align="center">客户名称</div></td> </tr> <% String lb4="新签单客户"; String lb4_en=new String (lb4.getBytes("gb2312"),"iso8859-1"); String Sql4; Sql4="select * from KHXXB,ZYXXB where KHXXB.ZYBH=ZYXXB.ZYBH and KHXXB.ZYBH='"+ZYBH+"' and KHXXB.KHLB like '%"+lb4_en+"%' "; ResultSet rst4=stmt.executeQuery(Sql4); while(rst4.next()) { String khmc4 = rst.getString("KHMC"); String khlb4 = rst.getString("KHLB"); %> <tr bgcolor="#FFFFCC"> <td width="19%"> <input type="checkbox" name="name" value="checkbox"></td> <td width="81%"><%= khmc4 %></td> </tr> <% }; %> <tr> <td colspan="2"><select name="f_khlb4"id="select4"> <option>意向型客户</option> <option>预计三个月签单客户</option> <option>预计一个月签单客户</option> <option>投标客户</option> <option selected>新签单客户</option> <option>老客户</option> <option>丢单客户</option> </select></td> </tr> </table></td> <td><table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#CCFFFF"> <tr> <td colspan="2"><div align="center">老客户</div></td> </tr> <tr bgcolor="#FFFFCC"> <td colspan="2"> <div align="center">客户名称</div></td> </tr> <% String lb5="老客户"; String lb5_en=new String (lb5.getBytes("gb2312"),"iso8859-1"); String Sql5; Sql5="select * from KHXXB,ZYXXB where KHXXB.ZYBH=ZYXXB.ZYBH and KHXXB.ZYBH='"+ZYBH+"' and KHXXB.KHLB like '%"+lb5_en+"%' "; ResultSet rst5=stmt.executeQuery(Sql5); while(rst5.next()) { String khmc5 = rst5.getString("KHMC"); String khlb5 = rst5.getString("KHLB"); %> <tr bgcolor="#FFFFCC"> <td width="19%"> <input type="checkbox" name="name" value="checkbox"></td> <td width="81%"><%= khmc5 %></td> </tr> <% }; %> <tr> <td colspan="2"><select name="f_khlb5"id="select5"> <option>意向型客户</option> <option>预计三个月签单客户</option> <option>预计一个月签单客户</option> <option>投标客户</option> <option>新签单客户</option> <option selected>老客户</option> <option>丢单客户</option> </select></td> </tr> </table></td> <td><table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#CCFFFF"> <tr> <td colspan="2"><div align="center">丢单客户</div></td> </tr> <tr bgcolor="#FFFFCC"> <td colspan="2"> <div align="center">客户名称</div></td> </tr> <% String lb6="丢单客户"; String lb6_en=new String (lb6.getBytes("gb2312"),"iso8859-1"); String Sql6; Sql6="select * from KHXXB,ZYXXB where KHXXB.ZYBH=ZYXXB.ZYBH and KHXXB.ZYBH='"+ZYBH+"' and KHXXB.KHLB like '%"+lb6_en+"%' "; ResultSet rst6=stmt.executeQuery(Sql6); while(rst6.next()) { String khmc6 = rst6.getString("KHMC"); String khlb6= rst6.getString("KHLB"); %> <tr bgcolor="#FFFFCC"> <td width="17%"> <input type="checkbox" name="name" value="checkbox"></td> <td width="83%"><%= khmc6 %></td> </tr> <% }; %> <tr> <td colspan="2"><select name="f_khlb6"id="select6"> <option>意向型客户</option> <option>预计三个月签单客户</option> <option>预计一个月签单客户</option> <option>投标客户</option> <option>新签单客户</option> <option>老客户</option> <option selected>丢单客户</option> </select></td> </tr> </table></td> </tr> </table> <div align="center"> <p> <input type="submit" name="Submit" value="修改客户类别"> <input type="reset" name="Submit2" value="重置"> </p> </div></form></body></html><% stmt.close(); conn.close(); }; %>不知这样做是不是太麻烦了 头晕了~楼主这样的代码还是改改 逻辑性不好这样没有人愿意仔细看的:) just an advice 自己统计一下<input type=checkbox>1<input type=checkbox>1<input type=checkbox>1<input type=checkbox>1<br><input type="button" value="全选" onclick="doCheckBox(1)"><input type="button" value="全不选" onclick="doCheckBox(2)"><input type="button" value="反选" onclick="doCheckBox(3)"><script>function doCheckBox(iType){ //1:全选;2:全不选;3:反选; for(iIndex=0;iIndex<document.all.length;iIndex++) { if(document.all(iIndex).type=="checkbox") { switch(iType) { case 1:document.all(iIndex).checked=true;break; case 2:document.all(iIndex).checked=false;break; case 3:{if(document.all(iIndex).checked==true){document.all(iIndex).checked=false;}else{document.all(iIndex).checked=true;}}break; } } }}</script> 还有你所有的checkBox都是<input type="checkbox" name="name" value="checkbox">,name都一样,那你知道到底是哪个checkBox提交吗?,建议把名字命名成有意义的,如果是在循环里面命名成数组形式的。可以参考http://community.csdn.net/Expert/topic/2634/2634502.xml?temp=.8228266http://community.csdn.net/Expert/topic/2637/2637586.xml?temp=.9193231晴mm:俺也是高手帮俺解决的,现在俺就借花献佛了。。关注 哈哈,妹妹阿,hoho信箱给我,晚上给你程序! 我的信箱是 [email protected]我用的是mysql数据库 to ningIII(小宁): 怎么?信箱都给你了,快帮帮我啊 有谁做过web 设置服务器参数 急 在线等 有个问题想请教一下 httpClient 流 乱码问题 求解 写个程序可以加载任意,一种加载数据库文件 tomcat自动关闭了。。 Struts中关于LookupDispatchAction的问题 如何防止远程提交表单? ArtifactTransferException 常见问题:jsp 访问 mysql 问题! 请教几个方法! 命命行编译问题 标签错误,请教各位。谢谢。在线等待! 我的数据库里有很多记录,我想一次读出200条,然后分页,每页40条!如果用户读到第5页,我在从数据库里读出200条。用jsp应该怎么实现啊?
<HEAD>
<META http-equiv='Content-Type' content='text/html;charset=gb2312'>
<Meta name='Gemeratpr' content='网络程序员伴侣(Lshdic)2004'>
<TITLE>网页标题</TITLE>
<STYLE>
*{font-size:12px;color:;}
a{text-decoration:none;}
a:hover{color:red;}
</STYLE>
</HEAD>
<BODY topmargin='2' leftmargin='2'>
<BASE target='_top'>
<input type='radio' name='r1' value='1'>1111
<input type='radio' name='r1' value='2'>2222
<input type='radio' name='r1' value='3'>3333
<input type='button' name='b1' value='haha' onclick=fun1()>
<SCRIPT language='Jscript'>
function fun1(){
for(var i=0;i<3;i++)
if(r1[i].checked)
{
alert(r1[i].value);
break;
}
}
</SCRIPT></BODY>
</HTML>
to Liangstar(小小编程猫) 我mm:帮帮我吧,我把内容修改了一下,源代码如下,希望尽快帮帮我
<%@ include file="../include/conn.jsp"%>
<%@ include file="../include/function.jsp"%>
<%
String ZYBH=(String)session.getValue("bh");
if (ZYBH==null)
response.sendRedirect("../");
else
{
String ZYQX="";
ZYQX=(String)session.getValue("qx");
//String sql;
//String Name;
//sql="select * from ZYXXB where ZYBH='"+ZYBH+"'";
//ResultSet rs=stmt.executeQuery(sql);
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>修改客户类别</title>
</head><body>
<form name="form1" method="post" action="edit_kehu_action.jsp"> <p align="center"><font color="#FF9900" size="5">修改客户类别</font></p>
<table width="100%" border="0" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bgcolor="#FFCCCC">
<tr>
<td><table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#CCFFFF">
<tr>
<td colspan="2"><div align="center">意向型客户</div></td>
</tr>
<tr bgcolor="#FFFFCC">
<td colspan="2"> <div align="center">客户名称</div></td>
</tr>
<%
String lb="意向型客户";
String lb_en=new String (lb.getBytes("gb2312"),"iso8859-1");
String Sql;
Sql="select * from KHXXB,ZYXXB where KHXXB.ZYBH=ZYXXB.ZYBH and KHXXB.ZYBH='"+ZYBH+"' and KHXXB.KHLB like '%"+lb_en+"%' ";
ResultSet rst=stmt.executeQuery(Sql);
while(rst.next())
{
String khmc = rst.getString("KHMC");
//String khlb = rst.getString("KHLB");
%>
<tr bgcolor="#FFFFCC">
<td width="24%"> <input type="checkbox" name="name" value="checkbox"></td>
<td width="76%"><%= khmc %>
</td>
</tr>
<% }; %>
<tr>
<td colspan="2"><select name="f_khlb"id="select">
<option selected>意向型客户</option>
<option>预计三个月签单客户</option>
<option>预计一个月签单客户</option>
<option>投标客户</option>
<option>新签单客户</option>
<option>老客户</option>
<option>丢单客户</option>
</select></td>
</tr>
</table></td>
<td><table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#CCFFFF">
<tr>
<td colspan="2"><div align="center">预计三个月签单客户</div></td>
</tr>
<tr bgcolor="#FFFFCC">
<td colspan="2"> <div align="center">客户名称</div></td>
</tr>
<%
String lb1="预计三个月签单客户";
String lb1_en=new String (lb1.getBytes("gb2312"),"iso8859-1");
String Sql1;
Sql1="select * from KHXXB,ZYXXB where KHXXB.ZYBH=ZYXXB.ZYBH and KHXXB.ZYBH='"+ZYBH+"' and KHXXB.KHLB like '%"+lb1_en+"%' ";
ResultSet rst1=stmt.executeQuery(Sql1);
while(rst1.next())
{
String khmc1 = rst1.getString("KHMC");
String khlb1 = rst1.getString("KHLB");
%>
<tr bgcolor="#FFFFCC">
<td width="18%"> <input type="checkbox" name="name" value="checkbox"></td>
<td width="82%"><%= khmc1 %> </td>
</tr>
<% }; %>
<tr>
<td colspan="2"><select name="f_khlb1"id="select1">
<option>意向型客户</option>
<option selected>预计三个月签单客户</option>
<option>预计一个月签单客户</option>
<option>投标客户</option>
<option>新签单客户</option>
<option>老客户</option>
<option>丢单客户</option>
</select></td>
</tr>
</table></td>
<td><table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#CCFFFF">
<tr>
<td colspan="2"><div align="center">预计一个月签单客户</div></td>
</tr>
<tr bgcolor="#FFFFCC">
<td colspan="2"> <div align="center">客户名称</div></td>
</tr>
<%
String lb2="预计一个月签单客户";
String lb2_en=new String (lb2.getBytes("gb2312"),"iso8859-1");
String Sql2;
Sql2="select * from KHXXB,ZYXXB where KHXXB.ZYBH=ZYXXB.ZYBH and KHXXB.ZYBH='"+ZYBH+"' and KHXXB.KHLB like '%"+lb2_en+"%' ";
ResultSet rst2=stmt.executeQuery(Sql2);
while(rst2.next())
{
String khmc2 = rst2.getString("KHMC");
String khlb2 = rst2.getString("KHLB");
%>
<tr bgcolor="#FFFFCC">
<td width="18%"> <input type="checkbox" name="name" value="checkbox"></td>
<td width="82%"><%= khmc2 %></td>
</tr>
<% }; %>
<tr>
<td colspan="2"><select name="f_khlb2"id="select2">
<option>意向型客户</option>
<option>预计三个月签单客户</option>
<option selected>预计一个月签单客户</option>
<option>投标客户</option>
<option>新签单客户</option>
<option>老客户</option>
<option>丢单客户</option>
</select></td>
</tr>
</table></td>
<td><table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#CCFFFF">
<tr>
<td colspan="2"><div align="center">投标客户</div></td>
</tr>
<tr bgcolor="#FFFFCC">
<td colspan="2"> <div align="center">客户名称</div></td>
</tr>
<%
String lb3="投标客户";
String lb3_en=new String (lb3.getBytes("gb2312"),"iso8859-1");
String Sql3;
Sql3="select * from KHXXB,ZYXXB where KHXXB.ZYBH=ZYXXB.ZYBH and KHXXB.ZYBH='"+ZYBH+"' and KHXXB.KHLB like '%"+lb3_en+"%' ";
ResultSet rst3=stmt.executeQuery(Sql3);
while(rst3.next())
{
String khmc3 = rst3.getString("KHMC");
String khlb3= rst3.getString("KHLB");
%>
<tr bgcolor="#FFFFCC">
<td width="19%"> <input type="checkbox" name="name" value="checkbox"></td>
<td width="81%"><%= khmc3 %></td>
</tr>
<% }; %>
<tr>
<td colspan="2"><select name="f_khlb3"id="select3">
<option>意向型客户</option>
<option>预计三个月签单客户</option>
<option>预计一个月签单客户</option>
<option selected>投标客户</option>
<option>新签单客户</option>
<option>老客户</option>
<option>丢单客户</option>
</select></td>
</tr>
</table></td>
<td><table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#CCFFFF">
<tr>
<td colspan="2"><div align="center">新签单客户</div></td>
</tr>
<tr bgcolor="#FFFFCC">
<td colspan="2"> <div align="center">客户名称</div></td>
</tr>
<%
String lb4="新签单客户";
String lb4_en=new String (lb4.getBytes("gb2312"),"iso8859-1");
String Sql4;
Sql4="select * from KHXXB,ZYXXB where KHXXB.ZYBH=ZYXXB.ZYBH and KHXXB.ZYBH='"+ZYBH+"' and KHXXB.KHLB like '%"+lb4_en+"%' ";
ResultSet rst4=stmt.executeQuery(Sql4);
while(rst4.next())
{
String khmc4 = rst.getString("KHMC");
String khlb4 = rst.getString("KHLB");
%>
<tr bgcolor="#FFFFCC">
<td width="19%"> <input type="checkbox" name="name" value="checkbox"></td>
<td width="81%"><%= khmc4 %></td>
</tr>
<% }; %>
<tr>
<td colspan="2"><select name="f_khlb4"id="select4">
<option>意向型客户</option>
<option>预计三个月签单客户</option>
<option>预计一个月签单客户</option>
<option>投标客户</option>
<option selected>新签单客户</option>
<option>老客户</option>
<option>丢单客户</option>
</select></td>
</tr>
</table></td>
<td><table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#CCFFFF">
<tr>
<td colspan="2"><div align="center">老客户</div></td>
</tr>
<tr bgcolor="#FFFFCC">
<td colspan="2"> <div align="center">客户名称</div></td>
</tr>
<%
String lb5="老客户";
String lb5_en=new String (lb5.getBytes("gb2312"),"iso8859-1");
String Sql5;
Sql5="select * from KHXXB,ZYXXB where KHXXB.ZYBH=ZYXXB.ZYBH and KHXXB.ZYBH='"+ZYBH+"' and KHXXB.KHLB like '%"+lb5_en+"%' ";
ResultSet rst5=stmt.executeQuery(Sql5);
while(rst5.next())
{
String khmc5 = rst5.getString("KHMC");
String khlb5 = rst5.getString("KHLB");
%>
<tr bgcolor="#FFFFCC">
<td width="19%"> <input type="checkbox" name="name" value="checkbox"></td>
<td width="81%"><%= khmc5 %></td>
</tr>
<% }; %>
<tr>
<td colspan="2"><select name="f_khlb5"id="select5">
<option>意向型客户</option>
<option>预计三个月签单客户</option>
<option>预计一个月签单客户</option>
<option>投标客户</option>
<option>新签单客户</option>
<option selected>老客户</option>
<option>丢单客户</option>
</select></td>
</tr>
</table></td>
<td><table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#CCFFFF">
<tr>
<td colspan="2"><div align="center">丢单客户</div></td>
</tr>
<tr bgcolor="#FFFFCC">
<td colspan="2"> <div align="center">客户名称</div></td>
</tr>
<%
String lb6="丢单客户";
String lb6_en=new String (lb6.getBytes("gb2312"),"iso8859-1");
String Sql6;
Sql6="select * from KHXXB,ZYXXB where KHXXB.ZYBH=ZYXXB.ZYBH and KHXXB.ZYBH='"+ZYBH+"' and KHXXB.KHLB like '%"+lb6_en+"%' ";
ResultSet rst6=stmt.executeQuery(Sql6);
while(rst6.next())
{
String khmc6 = rst6.getString("KHMC");
String khlb6= rst6.getString("KHLB");
%>
<tr bgcolor="#FFFFCC">
<td width="17%"> <input type="checkbox" name="name" value="checkbox"></td>
<td width="83%"><%= khmc6 %></td>
</tr>
<% }; %>
<tr>
<td colspan="2"><select name="f_khlb6"id="select6">
<option>意向型客户</option>
<option>预计三个月签单客户</option>
<option>预计一个月签单客户</option>
<option>投标客户</option>
<option>新签单客户</option>
<option>老客户</option>
<option selected>丢单客户</option>
</select></td>
</tr>
</table></td>
</tr>
</table>
<div align="center">
<p>
<input type="submit" name="Submit" value="修改客户类别">
<input type="reset" name="Submit2" value="重置">
</p>
</div>
</form>
</body>
</html>
<%
stmt.close();
conn.close();
};
%>
不知这样做是不是太麻烦了
<input type=checkbox>1
<input type=checkbox>1
<input type=checkbox>1
<input type=checkbox>1
<br>
<input type="button" value="全选" onclick="doCheckBox(1)">
<input type="button" value="全不选" onclick="doCheckBox(2)">
<input type="button" value="反选" onclick="doCheckBox(3)">
<script>
function doCheckBox(iType)
{
//1:全选;2:全不选;3:反选;
for(iIndex=0;iIndex<document.all.length;iIndex++)
{
if(document.all(iIndex).type=="checkbox")
{
switch(iType)
{
case 1:document.all(iIndex).checked=true;break;
case 2:document.all(iIndex).checked=false;break;
case 3:{if(document.all(iIndex).checked==true){document.all(iIndex).checked=false;}else{document.all(iIndex).checked=true;}}break;
}
}
}
}
</script>
可以参考http://community.csdn.net/Expert/topic/2634/2634502.xml?temp=.8228266
http://community.csdn.net/Expert/topic/2637/2637586.xml?temp=.9193231
晴mm:俺也是高手帮俺解决的,现在俺就借花献佛了。。
关注
我用的是
mysql数据库