javascript实例--循环判断查询表单,构建SQL语句
来源:互联网 发布:网络推手收费 编辑:程序博客网 时间:2024/05/22 15:06
<%...@ page language="java" contentType="text/html; charset=GB18030"
pageEncoding="GB18030"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GB18030">
<script language="javascript">...
function subm(obj)...{
var list=new Array("name","grade","peciality","course","level","form");
var j=0;
var sql="select * from cjcj ";
var keyword="where "
for(i=0;i<list.length;i++)...{
var selectObj=document.getElementById("what"+list[i]);
var selectValue=selectObj.options[selectObj.selectedIndex].value;
if(selectValue!="all"+list[i])...{
var valueInput=document.getElementById(list[i]+"KeyWord");
if(valueInput.value=="")...{
alert(selectObj.options[selectObj.selectedIndex].text);
return false;
}else...{
keyword+=" "+selectValue+"='"+valueInput.value+"' and";
}
}else...{
j++;
}
}
if(j==6)...{
alert("请输入一个关键字")
return false;
}
obj.sql.value=sql+keyword.substring(0,keyword.length-3);
return true;
}
</script>
</head>
<body>
<center><input type="button" value="录入成人教育成绩"
onclick="document.location.href='./addcjcj.jsp'"></center><br>
<form action="./body/zksearchbody.jsp" method="post" onsubmit="return subm(this)">
<table border="1" width="80%" align="center">
<tr>
<td colspan="2" align="center">成人教育成绩查询</td>
</tr>
<tr>
<td align="center" width="30%"><select style="width:80%"
id="whatname" name="whatname">
<option selected value="allname">查询所有学生成绩</option>
<option value="name">请输入姓名</option>
<option value="xh">请输入学号</option>
</select></td>
<td><input type="text" style="width:90%" name="nameKeyWord">
</td>
</tr>
<tr>
<td align="center"><select style="width:80%" id="whatgrade" name="whatgrade">
<option value="allgrade">查询所有年级成绩</option>
<option value="grade">请输入年级</option>
</select></td>
<td><input type="text" style="width:90%" name="gradeKeyWord">
</td>
</tr>
<tr>
<td align="center"><select style="width:80%" id="whatpeciality" name="whatpeciality">
<option value="allpeciality">查询所有专业成绩</option>
<option value="peciality">请输入专业名称</option>
</select></td>
<td><input type="text" style="width:90%" name="pecialityKeyWord">
</td>
</tr>
<tr>
<td align="center"><select style="width:80%" id="whatcourse" name="whatcourse">
<option value="allcourse">查询所有课程成绩</option>
<option value="courseid">请输入课程编码</option>
<option value="coursename">请输入课程名称</option>
</select></td>
<td><input type="text" style="width:90%" name="courseKeyWord">
</td>
</tr>
<tr>
<td align="center"><select style="width:80%" id="whatlevel" name="whatlevel">
<option value="alllevel">查询所有层次成绩</option>
<option value="level">请输入层次</option>
</select></td>
<td><input type="text" style="width:90%" name="levelKeyWord">
</td>
</tr>
<tr>
<td align="center"><select style="width:80%" id="whatform" name="whatform">
<option value="allform">查询所有形式成绩</option>
<option value="form">请输入形式</option>
</select></td>
<td><input type="text" style="width:90%" name="formKeyWord">
</td>
</tr>
<tr>
<td align="center" colspan="2"><input type="Submit" name="Submit"
value="提交查询"></td>
</tr>
</table>
<input type="text" name="sql" id="sql">
</form>
</body>
</html>
pageEncoding="GB18030"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GB18030">
<script language="javascript">...
function subm(obj)...{
var list=new Array("name","grade","peciality","course","level","form");
var j=0;
var sql="select * from cjcj ";
var keyword="where "
for(i=0;i<list.length;i++)...{
var selectObj=document.getElementById("what"+list[i]);
var selectValue=selectObj.options[selectObj.selectedIndex].value;
if(selectValue!="all"+list[i])...{
var valueInput=document.getElementById(list[i]+"KeyWord");
if(valueInput.value=="")...{
alert(selectObj.options[selectObj.selectedIndex].text);
return false;
}else...{
keyword+=" "+selectValue+"='"+valueInput.value+"' and";
}
}else...{
j++;
}
}
if(j==6)...{
alert("请输入一个关键字")
return false;
}
obj.sql.value=sql+keyword.substring(0,keyword.length-3);
return true;
}
</script>
</head>
<body>
<center><input type="button" value="录入成人教育成绩"
onclick="document.location.href='./addcjcj.jsp'"></center><br>
<form action="./body/zksearchbody.jsp" method="post" onsubmit="return subm(this)">
<table border="1" width="80%" align="center">
<tr>
<td colspan="2" align="center">成人教育成绩查询</td>
</tr>
<tr>
<td align="center" width="30%"><select style="width:80%"
id="whatname" name="whatname">
<option selected value="allname">查询所有学生成绩</option>
<option value="name">请输入姓名</option>
<option value="xh">请输入学号</option>
</select></td>
<td><input type="text" style="width:90%" name="nameKeyWord">
</td>
</tr>
<tr>
<td align="center"><select style="width:80%" id="whatgrade" name="whatgrade">
<option value="allgrade">查询所有年级成绩</option>
<option value="grade">请输入年级</option>
</select></td>
<td><input type="text" style="width:90%" name="gradeKeyWord">
</td>
</tr>
<tr>
<td align="center"><select style="width:80%" id="whatpeciality" name="whatpeciality">
<option value="allpeciality">查询所有专业成绩</option>
<option value="peciality">请输入专业名称</option>
</select></td>
<td><input type="text" style="width:90%" name="pecialityKeyWord">
</td>
</tr>
<tr>
<td align="center"><select style="width:80%" id="whatcourse" name="whatcourse">
<option value="allcourse">查询所有课程成绩</option>
<option value="courseid">请输入课程编码</option>
<option value="coursename">请输入课程名称</option>
</select></td>
<td><input type="text" style="width:90%" name="courseKeyWord">
</td>
</tr>
<tr>
<td align="center"><select style="width:80%" id="whatlevel" name="whatlevel">
<option value="alllevel">查询所有层次成绩</option>
<option value="level">请输入层次</option>
</select></td>
<td><input type="text" style="width:90%" name="levelKeyWord">
</td>
</tr>
<tr>
<td align="center"><select style="width:80%" id="whatform" name="whatform">
<option value="allform">查询所有形式成绩</option>
<option value="form">请输入形式</option>
</select></td>
<td><input type="text" style="width:90%" name="formKeyWord">
</td>
</tr>
<tr>
<td align="center" colspan="2"><input type="Submit" name="Submit"
value="提交查询"></td>
</tr>
</table>
<input type="text" name="sql" id="sql">
</form>
</body>
</html>
- javascript实例--循环判断查询表单,构建SQL语句
- 纯SQL语句循环查询
- SQL查询和判断语句
- SQL查询和判断语句
- SQL经典判断语句实例
- sql语句实现查询实例
- sql语句实现查询实例
- sql语句实现查询实例
- JavaScript的语句—判断,选择,循环
- 在MyEclipse中构建SQL查询语句
- 构建Sql多条件查询语句
- PL/SQL跳转/判断/循环语句块
- sql的循环,判断,跳转语句
- pl/sql oraclev_name|| 判断 循环 语句
- SQL 循环语句 while 介绍 实例 简介
- SQL 循环语句 while 介绍 实例 简介
- sql中while语句多层循环实例
- SQL 循环语句 while 介绍 实例
- 10岁学编程 拥有19项专利的女程序员
- linux tar命令
- 强!不开监控也能用NOD32保驾护航(图)
- 最近在学习Spring,准备参加工作了
- Notes:An Ontology-based Information Retrieval Model--基于本体的信息检索模型
- javascript实例--循环判断查询表单,构建SQL语句
- 发现Google地图两个严重的缺陷
- 使用VIM开发软件项目 - (6) 文件浏览和缓冲区浏览
- 突然想到学生项目的一个问题
- 有人在研究arroundme 吗,一个开源的php社会化网络程序
- Struts,MVC 的一种开放源码实现
- 我的程序路
- Qt 4.2.2 windows下如何在终端中信息;
- 软件设计模式C#Software Design Patterns in C#