用JavaScript来生成一个SQL查询表单-表单状态栏

来源:　作者:　更新时间:2011-12-09　点击: 次
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<head>
<title>用<a href='http://js.zz5u.net'><u>JavaScript</u></a>来生成一个SQL查询表单_网页代码站(www.6a8a.com)</title>
<style>
*{
    font-size:12px;
    padding:0;
    margin:0;
}
body{
    padding:40px;
}
#MainBox{
    border:#666 1px solid;
    background-color:#eee;
    width:700px;
}
#MainBox td{
    padding:4px;
}
#ConditionBox{
    height:150px;
    width:100%;
    overflow-y:auto;
    border:#bbb 1px solid;
    padding:2px;
    background-color:#fff;
}
.tmFrame{
    border:#eee 1px solid;
    padding:2px;
    width:100%;
}
.tmFrame_highlight{
    border:#666 1px solid;
    padding:2px;
    width:100%;
    background-color:#f7f7f7;
}
.fname{
    float:left;
    width:200px;
}
.conn{
    float:left;
    width:100px;
}
.fvalue{
    float:left;
    width:100px;
}
.handlebox{
    float:right;
    width:180px;
    display:none;
}
.handlebox_view{
    float:right;
    width:180px;
    display:block;
}
.rbox{
    float:right;
    margin:1px;
    background-color:#999;
    color:#fff;
    padding:1px;
    width:15px;
    cursor:hand;
}
legend{
    border:#bbb 1px solid;
    padding:4px;
}
fieldset{
    border:#bbb 1px solid;
    padding:4px;
}
.sqlwords{
    margin:2px;
    border:#bbb 1px solid;
    width:100%;
}
</style>
<script>
////构造函数
function ce(e){return document.createElement(e)}
/* Example:
*   var a = cex("DIV", {onmouseover:foo, name:'div1', id:'main'});
*/
function cex(e, x){
    var a = ce(e);
    for (prop in x){
      a[prop] = x[prop];
    }
    return a;
}
/*
* function ge
* Shorthand function for document.getElementById(i)
*/
function ge(i){return document.getElementById(i)}
/*
* function ac
* Example: ac( house, ac(roof, shingles), ac(floor, ac(tiles, grout)))
*/
function ac(){
    if (ac.arguments.length > 1){
        var a = ac.arguments[0];
        for (i=1; i<ac.arguments.length; i++){
            if (arguments[i])
               a.appendChild(ac.arguments[i]);
        }
        return a;
    } else {
        return null;
    }
}
/////ID增量
function guid(){
   if (!window.__id) window.__id = 0;
   return ++window.__id;
}
//======建立条件类
function term(tname,fname,conn,fvalue,ttype){
    this.tname=tname;
    this.fname=fname;
    this.conn=conn;
    this.fvalue=fvalue;
    this.id= guid();
    this.ttype=ttype;
}
term.prototype.getHTML = function(){
   var termFrame = cex("DIV", {
      id:this.id,
      className:'tmframe',
      onmouseover:this.fc_term_onmouseover(),
      onmouseout:this.fc_term_onmouseout()
      });
   //var module = cex("DIV", {
      //id:'module'+this.id,
      //className:'module'
      /<BR>
<p><strong>标签(Tag):</strong> </p></DIV>
<div class="art_list"><ul></ul></div>
<div class="vtitle">继续阅读表单状态栏</div>
<div class="arc_sx">
<li> 上一篇：<a href='http://js.zz5u.net/daohang/2011/1209/13599.html'>JS实现飞过去的EMAIL地址添加功能</a> </li><li> 下一篇：没有了 </li>
<div class="cl"></div>
</div>
<div class="mood">
<iframe id="mood_frame" width="500" height="200" src="http://www.zz5u.net/plus/mood/mood.php?aid=13600" marginWidth=0 marginHeight=0 frameborder="0" scrolling="no"></iframe>
</div>
<div class="mood_ad">
<SCRIPT language=javascript type=text/javascript src="http://www.zz5u.net/ad/a2.js"></SCRIPT>
</div>
<div class="arc_bottom"><ul class="handle">
<li class="pinglun">
<a href="http://temp.zz5u.net" title="网站模板">网站模板</a></li>
<li class="scrap">
<a href="http://skin.zz5u.net">CMS模板</a></li>
<li class="pinglun">
<a href="http://www.zz5u.net/dig.php" title="tag标签">Tag标签</a></li>
<li class="mail">
<a href="http://www.zz5u.net/plus/recommend.php?aid=13600" target="_blank">推荐</a></li>
<li class="scrap">
<a href="javascript:openwinx('http://www.zz5u.net/plus/diy.php?action=post&diyid=2&title='+document.title+'&error_link='+window.location.href+'','error','755','550')" target="_self">报错</a></li>
</ul>
<ul class="keep">
<li class="gotop"><a href="JavaScript;" onclick="backToTop();return false;" title="回到顶部">顶部</a></li>
<li class="putin"><a href="http://www.zz5u.net/" title="返回首页">返回首页</a></li>
</ul></div>
<DIV class=vtitle>相关表单状态栏：</DIV>
<DIV class=arc_xgnr>
<li><a href='http://js.zz5u.net/daohang/2011/1209/13595.html'>JavaScript自动复制文本框的内容到另一个文</a></li>
<li><a href='http://js.zz5u.net/daohang/2011/1209/13591.html'>用CSS美化的一个清新表单布局</a></li>
<li><a href='http://js.zz5u.net/daohang/2011/1209/13589.html'>告诉你一个超级实用的select标签（Optgroup</a></li>
<li><a href='http://js.zz5u.net/daohang/2011/1209/13588.html'>一个不常用，但非常实用的标签(fieldset)</a></li>
<li><a href='http://js.zz5u.net/daohang/2011/1209/13585.html'>一个基于JS的5级联动Select下拉选择框</a></li>
<li><a href='http://js.zz5u.net/daohang/2011/1209/13573.html'>一个比较实用的JS列表框功能(增删,上下移动</a></li>
<li><a href='http://js.zz5u.net/daohang/2011/1209/13563.html'>JavaScript用正则验证IP地址格式是否正确</a></li>
<li><a href='http://js.zz5u.net/daohang/2011/1209/13556.html'>JavaScript动态切换文本框焦点(IP为例)</a></li>
<li><a href='http://js.zz5u.net/daohang/2011/0405/12542.html'>用Javascript正则表达式验证Email地址</a></li>
<li><a href='http://js.zz5u.net/daohang/2009/0707/2845.html'>文字中状态栏中一个一个的冒出来</a></li>

</DIV><DIV class=cl></DIV>
<div class="box_xgimg">
<div class="title_xg"><div style="float:left;padding-left:-10px;text-align:left;"><b>最新图文资讯</b></div>
    <span style="float:right;padding-right:10px;font-size:12px;font-weight:normal;">
	<a href="javascript://" class="currON" id="picA1" onclick="selectSwitch(1)" onmouseover="pauseSwitch()" onmouseout="goonSwitch()">1</a>
	<a href="javascript://"  id="picA2"  onclick="selectSwitch(2)"  onmouseover="pauseSwitch()" onmouseout="goonSwitch()">2</a>
	<a href="javascript://"  id="picA3"  onclick="selectSwitch(3)"  onmouseover="pauseSwitch()" onmouseout="goonSwitch()">3</a>
	<a href="javascript://"  id="picA4"  onclick="selectSwitch(4)"  onmouseover="pauseSwitch()" onmouseout="goonSwitch()">4</a>
	<a href="javascript://"  id="picA5"  onclick="selectSwitch(5)"  onmouseover="pauseSwitch()" onmouseout="goonSwitch()">5</a>
	<a href="javascript://"  id="picA6"  onclick="selectSwitch(6)"  onmouseover="pauseSwitch()" onmouseout="goonSwitch()">6</a>
   </span></div>
<div class="roll" id="roll" style="margin-left:0px;padding-left:0px;">
<ul id="picUL1" onmouseover="pauseSwitch()" onmouseout="goonSwitch()">
<LI>
<a href="http://web.zz5u.net/IT/2011/0707/13361.html" target="_blank" blockid="1148"><img src="http://www.zz5u.net/uploads/allimg/110707/1_0FG531133928.jpg" alt="腾讯投资金山网络2千万美元 获1个董事会席位" /><span>腾讯投资金山网络2千万美元 获1个董事会席位</span></a>
  </LI>
<LI>
<a href="http://web.zz5u.net/host/2011/0630/13341.html" target="_blank" blockid="1148"><img src="http://www.zz5u.net/uploads/allimg/c110630/130944635c60-15001_lit.jpg" alt="让FTP服务器共享更安全" /><span>让FTP服务器共享更安全</span></a>
  </LI>
<LI>
<a href="http://web.zz5u.net/host/2011/0630/13342.html" target="_blank" blockid="1148"><img src="http://www.zz5u.net/uploads/allimg/c110630/1309446364130-19624_lit.jpg" alt="网管经验谈:FTP服务器防“雷”记" /><span>网管经验谈:FTP服务器防“雷”记</span></a>
  </LI>
<LI>
<a href="http://web.zz5u.net/host/2011/0630/13345.html" target="_blank" blockid="1148"><img src="http://www.zz5u.net/uploads/allimg/c110630/13094463GJ0-1113b_lit.jpg" alt="Windows下FTP服务器安全管理" /><span>Windows下FTP服务器安全管理</span></a>
  </LI>

</ul>
<ul style="display:none;" id="picUL2" onmouseover="pauseSwitch()" onmouseout="goonSwitch()">
<LI>
<a href="http://js.zz5u.net/ad/jdt/2011/0529/12900.html" target="_blank" blockid="1148"><img src="http://www.zz5u.net/uploads/allimg/110529/1-110529134U30-L.gif" alt="网易旅游频道幻灯片" /><span>网易旅游频道幻灯片</span></a>
  </LI>
<LI>
<a href="http://js.zz5u.net/ad/jdt/2010/1011/12259.html" target="_blank" blockid="1148"><img src="http://www.zz5u.net/uploads/allimg/20101011/1-101011222A00-L.jpg" alt="迅雷网div+css+js图片展示代码" /><span>迅雷网div+css+js图片展示代码</span></a>
  </LI>
<LI>
<a href="http://js.zz5u.net/ad/jdt/2010/0808/12115.html" target="_blank" blockid="1148"><img src="http://www.zz5u.net/uploads/allimg/20100808/1-100PQJF50-L.jpg" alt="JavaScript 滑动条效果" /><span>JavaScript 滑动条效果</span></a>
  </LI>
<LI>
<a href="http://js.zz5u.net/ad/jdt/2010/0808/12114.html" target="_blank" blockid="1148"><img src="http://www.zz5u.net/uploads/allimg/20100808/1-100PQJ2200-L.jpg" alt="Flash+xml网站顶部banner焦点图" /><span>Flash+xml网站顶部banner焦点图</span></a>
  </LI>

</ul>
<ul style="display:none;" id="picUL3" onmouseover="pauseSwitch()" onmouseout="goonSwitch()">
<LI>
<a href="http://js.zz5u.net/ad/dlad/2010/0807/12107.html" target="_blank" blockid="1148"><img src="http://www.zz5u.net/uploads/allimg/20100807/1-100PG54P90-L.gif" alt="兼容标准的页面任意漂浮广告代码" /><span>兼容标准的页面任意漂浮广告代码</span></a>
  </LI>
<LI>
<a href="http://js.zz5u.net/ad/dlad/2009/0920/3585.html" target="_blank" blockid="1148"><img src="http://www.zz5u.net/uploads/litimg/090920/11130415150.gif" alt="单独关闭的两边对联广告代码" /><span>单独关闭的两边对联广告代码</span></a>
  </LI>
<LI>
<a href="http://js.zz5u.net/ad/dlad/2009/0920/3532.html" target="_blank" blockid="1148"><img src="http://www.zz5u.net/uploads/litimg/090920/02001515550.jpg" alt="div+css显示对联带关闭代码" /><span>div+css显示对联带关闭代码</span></a>
  </LI>
<LI>
<a href="http://js.zz5u.net/ad/dlad/2009/0920/3521.html" target="_blank" blockid="1148"><img src="http://www.zz5u.net/uploads/litimg/090919/2029221cO.jpg" alt="页面随意漂浮广告代码演示" /><span>页面随意漂浮广告代码演示</span></a>
  </LI>

</ul>
<ul id="picUL4" onmouseover="pauseSwitch()" onmouseout="goonSwitch()" style="display:none;">
<LI>
<a href="http://js.zz5u.net/ad/tc/2010/1011/12260.html" target="_blank" blockid="1148"><img src="http://www.zz5u.net/uploads/allimg/20101011/1-1010112242310-L.jpg" alt="阿里妈妈网站顶部banner代码" /><span>阿里妈妈网站顶部banner代码</span></a>
  </LI>
<LI>
<a href="http://js.zz5u.net/ad/tc/2009/0920/3553.html" target="_blank" blockid="1148"><img src="http://www.zz5u.net/uploads/090920/1_11222R27.gif" alt="MSN左上角flash伸缩广告" /><span>MSN左上角flash伸缩广告</span></a>
  </LI>
<LI>
<a href="http://js.zz5u.net/ad/tc/2009/0920/3546.html" target="_blank" blockid="1148"><img src="http://www.zz5u.net/uploads/litimg/090920/10004211950.gif" alt="仿QQ消息弹出广告效果(带音乐)" /><span>仿QQ消息弹出广告效果(带音乐)</span></a>
  </LI>
<LI>
<a href="http://js.zz5u.net/ad/tc/2009/0920/3524.html" target="_blank" blockid="1148"><img src="http://www.zz5u.net/uploads/litimg/090919/203T11G29.jpg" alt="经典的右下角提示消息广告代码" /><span>经典的右下角提示消息广告代码</span></a>
  </LI>

</ul>
<ul  id="picUL5" onmouseover="pauseSwitch()" onmouseout="goonSwitch()" style="display:none;">
<LI>
<a href="http://css.zz5u.net/CSSTem/2009/0921/3588.html" target="_blank" blockid="1148"><img src="http://www.zz5u.net/uploads/litimg/090921/01213515436.gif" alt="CSS+JS打造求职搜索表单" /><span>CSS+JS打造求职搜索表单</span></a>
  </LI>
<LI>
<a href="http://css.zz5u.net/CSSTem/2009/0920/3586.html" target="_blank" blockid="1148"><img src="http://www.zz5u.net/uploads/litimg/090920/1143121RW.jpg" alt="CSS模板：变化灵活的CSS网页框架" /><span>CSS模板：变化灵活的CSS网页框架</span></a>
  </LI>
<LI>
<a href="http://css.zz5u.net/CSSTem/2009/0920/3545.html" target="_blank" blockid="1148"><img src="http://www.zz5u.net/uploads/litimg/090920/09503011137.gif" alt="Div+CSS模板下载-City Lights" /><span>Div+CSS模板下载-City Lights</span></a>
  </LI>
<LI>
<a href="http://css.zz5u.net/CSSTem/2009/0920/3544.html" target="_blank" blockid="1148"><img src="http://www.zz5u.net/uploads/litimg/090920/0940531C23.gif" alt="CSS模板：Mint Chocolate Chip" /><span>CSS模板：Mint Chocolate Chip</span></a>
  </LI>

</ul>
<ul id="picUL6" onmouseover="pauseSwitch()" onmouseout="goonSwitch()" style="display:none;">
<LI>
<a href="http://www.zz5u.net/html/computer/cz/2010_5717.html" target="_blank" blockid="1148"><img src="http://www.zz5u.net/uploads/allimg/20100423/1_0423134615V94.jpg" alt="<font color='#CC0000'>周末超值采购：八款最受网友关注的笔记本</font>" /><span><font color='#CC0000'>周末超值采购：八款最受网友关注的笔记本</font></span></a>
  </LI>
<LI>
<a href="http://www.zz5u.net/html/computer/cs/2010_5757.html" target="_blank" blockid="1148"><img src="http://www.zz5u.net/uploads/allimg/20100425/1_0425211G3Q13.jpg" alt="图解：在windows下用磁盘管理工具给新硬盘分区" /><span>图解：在windows下用磁盘管理工具给新硬盘分区</span></a>
  </LI>
<LI>
<a href="http://www.zz5u.net/html/computer/cs/2010_5754.html" target="_blank" blockid="1148"><img src="http://www.zz5u.net/uploads/allimg/20100425/1_042521063AF0.jpg" alt="<font color='#FF0000'>用 PQ 8.05 中文版分区的图解</font>" /><span><font color='#FF0000'>用 PQ 8.05 中文版分区的图解</font></span></a>
  </LI>
<LI>
<a href="http://www.zz5u.net/html/computer/cs/2010_5753.html" target="_blank" blockid="1148"><img src="http://www.zz5u.net/uploads/allimg/20100425/1_04252104106012.jpg" alt="<font color='#CC0000'>图解：硬盘分区在DOS下用FDISK工具分区</font>" /><span><font color='#CC0000'>图解：硬盘分区在DOS下用FDISK工具分区</font></span></a>
  </LI>

</ul>
<script>
reSwitchPic();
</script>
</div>
</div>
<DIV class=cl></DIV>
</DIV>
<DIV id=sidecontent>
<DIV class=ad6>
<SCRIPT language=javascript type=text/javascript src="http://www.zz5u.net/ad/list4.js"></SCRIPT>
</DIV>
<DIV class="search bo">
<form id=searchform method=get action="http://www.zz5u.net/plus/search.php">
<DIV class=cl>
<INPUT value=98 type=hidden name=typeid></DIV><INPUT id=keyword onfocus=inputAutoClear(this) 
value=搜索表单状态栏... name=keyword><INPUT value=2 type=hidden name=kwtype><INPUT 
value=titlekeyword type=hidden name=searchtype><INPUT id=searchsubmit type=submit> 
</form></DIV>
<DIV class=templetbox>
<H4 class=stitline>最新表单状态栏</H4>
<UL class=style01>
<LI><a href='http://js.zz5u.net/daohang/2011/1209/13597.html'>JS实现的圆角弹出框，可以代替ALERT来使用</a></LI>
<LI><a href='http://js.zz5u.net/daohang/2011/1209/13598.html'>又一款中英文按拼音排序的列表框</a></LI>
<LI><a href='http://js.zz5u.net/daohang/2011/1209/13599.html'>JS实现飞过去的EMAIL地址添加功能</a></LI>
<LI><a href='http://js.zz5u.net/daohang/2011/1209/13600.html'>用JavaScript来生成一个SQL查询表单</a></LI>
<LI><a href='http://js.zz5u.net/daohang/2011/1209/13578.html'>JS打造拖动滚动条评分的特效</a></LI>
<LI><a href='http://js.zz5u.net/daohang/2011/1209/13579.html'>JS实现用图片代替表单的单选、复选按钮</a></LI>
<LI><a href='http://js.zz5u.net/daohang/2011/1209/13580.html'>用CSS的htc来美化SELECT下拉表单</a></LI>
<LI><a href='http://js.zz5u.net/daohang/2011/1209/13581.html'>JS仿HAO123多搜索引擎跳转代码</a></LI>

</UL></DIV><DIV class=ad23>
<SCRIPT language=javascript type=text/javascript src="http://www.zz5u.net/ad/list5.js"></SCRIPT>
</DIV>
<DIV class=templetbox>
<H4 class=stitline>推荐表单状态栏</H4>
<UL class=style01>
<LI><a href='http://js.zz5u.net/daohang/2011/1209/13600.html'>用JavaScript来生成一个SQL查询表单</a></LI>
<LI><a href='http://js.zz5u.net/daohang/2011/1209/13569.html'>JS控制2个下拉列表框交换数据</a></LI>
<LI><a href='http://js.zz5u.net/daohang/2009/0707/2846.html'>状态栏多条提示字符出现</a></LI>
<LI><a href='http://js.zz5u.net/daohang/2009/0707/2844.html'>怎么在状态栏中显示当前的日期和时间</a></LI>
<LI><a href='http://js.zz5u.net/daohang/2009/0707/2843.html'>状态栏的文字象弹簧一样不停缩放</a></LI>
<LI><a href='http://js.zz5u.net/daohang/2009/0707/2841.html'>一段文字在状态栏上不停跳动显示，可以作为提示信息</a></LI>
<LI><a href='http://js.zz5u.net/daohang/2009/0630/2824.html'>网站标题栏特效：打字效果</a></LI>

</UL></DIV>
<DIV class=ad7>
<SCRIPT language=javascript type=text/javascript src="http://www.zz5u.net/ad/list6.js"></SCRIPT>
</DIV></DIV>
<DIV class=cl></DIV></DIV>
<SCRIPT type=text/javascript>mb5uv4.init()</SCRIPT>
<div id="footer_list">
<div class="list_footer_l"><span id="tongji"></span>用JavaScript来生成一个SQL查询表单</div>
<div class="list_footer_r"><SCRIPT language=javascript type=text/javascript src="http://www.zz5u.net/ad/foot.js"></SCRIPT></div>
</div>
</div>
</BODY></HTML>