displaytxun.jsp

“JSP数据库项目案例导航”一书从第一章到第十一章各章实例的源程序文件以及数据库文件。 注意： 1. 本书中的案例提供的数据库环境不同

        <%if(cur>1){%>
		<a onclick="firsrpg()" style="cursor:hand">第一页&nbsp&nbsp&nbsp </a><%}%>
		<%if(cur>1){ t=cur-1;%>
		<a onclick="lastpg()" style="cursor:hand">上一页&nbsp&nbsp&nbsp </a><%}%>
		<%if(cur<sum){ s=cur+1;%>
		<a onclick="nextpg()" style="cursor:hand">下一页&nbsp&nbsp&nbsp</a><%}%>&nbsp&nbsp
		<%if(cur<sum){%>
		<a onclick="finalpg()" style="cursor:hand">最后页&nbsp&nbsp&nbsp </a><%}%>
		直接<input type=image src="../images/hand.gif" name="gotof" onclick="return chkdata()">
		<input type=text size=5 name=bm class=formcolor>页</TD>
<%}%>
	</tr>
</TABLE>

<br><br>
<script>
	function firsrpg()
	{
		document.all.txt_type.value = "1";
		document.all.txt_edit.value = "";
		document.all.form1.action = "person.jsp?bm=1";
		document.all.form1.submit();
	}
	function lastpg()
	{
		document.all.txt_type.value = "1";
		document.all.txt_edit.value = "";
		document.all.form1.action = "person.jsp?bm="+<%=t%>;
		document.all.form1.submit();
	}
	function nextpg()
	{
		document.all.txt_type.value = "1";
		document.all.txt_edit.value = "";
		document.all.form1.action = "person.jsp?bm="+<%=s%>;
		document.all.form1.submit();
	}
	function finalpg()
	{
		document.all.txt_type.value = "1";
		document.all.txt_edit.value = "";
		document.all.form1.action = "person.jsp?bm="+<%=sum%>;
		document.all.form1.submit();
	}

	function onchgss(selobj)
	{
		var choice = selobj.selectedIndex;
	    document.all.txt_srch.value = selobj.options[choice].value;
		selobj.options[choice].selected;
	}
	function onpaixuxm()
	{
		document.all.txt_type.value = 1;
		if(document.all.txt_paixu.value !="0" && document.all.txt_paixu.value !="1")
			document.all.txt_paixu.value ="0";
		
		if(document.all.txt_paixu.value =="1")
		{
			document.all.txt_paixu.value ="0";
			imgname = "../images/arrowup.gif";
		}
		else if(document.all.txt_paixu.value =="0")
		{
			document.all.txt_paixu.value ="1";
			imgname = "../images/arrowdown.gif";
		}
		
		document.all.form1.action = "person.jsp?imgname0="+imgname;
		document.all.form1.submit();
	}

	function srch()
	{
		onchgss(document.all.sel_search);
		document.all.txt_edit.value = "";
		if(document.all.txt_search.value == "")
		{
			alert("请输入搜索内容！");
			return false;
		}
		if(document.all.txt_srch.value == "")
		{
			alert("请选择查询字段！");
			return false;
		}
		if(document.all.chk_search.value=="ON" && document.all.txt_search.value == "")
		{
			alert("请输入搜索内容！");
			return false;
		}
		document.all.form1.action = "person.jsp";
		document.all.form1.submit(); 
	}

	function oncheck(myname){
		if(myname.checked)
			myname.value="ON";
		else
			myname.value="";
	}
	function addPerson()
	{
		document.all.txt_type.value = "1";
		document.all.txt_edit.value = "1";
		document.all.form1.action = "person.jsp";
		document.all.form1.submit();
	}
	
	function modPerson(orderno)
	{
		document.all.txt_type.value = "1";
		document.all.txt_edit.value = "2";
		document.all.txt_lxrxh.value = orderno;
		document.all.form1.action = "person.jsp";
		document.all.form1.submit();
	}
	function delPerson(orderno)
	{
		if(!confirm("是否真的要删除？"))
		{
		}
		else
		{
			document.all.txt_type.value = "1";
			document.all.txt_edit.value = "3";
			document.all.txt_lxrxh.value = orderno;
			document.all.form1.action = "../../PerSvlt";
			document.all.form1.submit();
		}
	}
	function isDigit(str)
	{
		var bool = true;
		for(var i=0;i<str.length;i++)
		{
			if(!(str.charAt(i)>=0&&str.charAt(i)<=9))
			{
				bool = false;
				break;
			}
		}
		return bool;
	}
	function chkdata()
	{
		document.all.txt_type.value = "1";
		document.all.txt_edit.value = "";
		if(!isDigit(document.all.bm.value))
        {
			alert("输入的页码不是数字!");
			document.all.bm.value="";
			document.all.bm.focus();
			return false;
		}
		if(document.all.bm.value=="")
		{
			alert("请输入页码!");
			document.all.bm.value="";
			document.all.bm.focus();
			return false;
		}
		else
		{
			var t = document.all.bm.value;
			var cur = <%=cur%>;
			var sum = <%=sum%>;

			while(t.length>cur.length)
            {
				alert("请跳至1和"+sum+"之间!");
				document.all.bm.value="";
				document.all.bm.focus();
				return false;
			}
			if(t==cur){return false;}
            
			
			while(t.length>sum.length)
			{
				alert("请跳至1和"+sum+"之间!");
				document.all.bm.value="";
				document.all.bm.focus();
				return false;
			}
			if(t<1||t>sum)
			{
				alert("请跳至1和"+sum+"之间!");
				document.all.bm.value="";
				document.all.bm.focus();
				return false;
			}
		}
		return true;
	}
	function selectall()
	{
		var num = document.all.checkboxid.length;
		if(document.all.selall.value == "全选")
		{
			for(var i=0;i<num;i++)
			{
				document.all.checkboxid[i].checked = true;	
			}
			document.all.selall.value = "取消全选";
		}
		else
		{
			for(var i=0;i<num;i++)
			{
				document.all.checkboxid[i].checked = false;	
			}
			document.all.selall.value = "全选";
		}
	}
	function del()
	{
		var delid = "";
		var num = <%=j%>;
		if(num==1)
	    {
			if(document.all.checkboxid.checked==true)
				delid = document.all.checkboxid.value;
		}
		if(num>=2)
		{
			var numid = document.all.checkboxid.length;
			for(var i=0;i<numid;i++)
			{
				if(document.all.checkboxid[i].checked == true)
				{
					if(delid == "")
					{
						delid = document.all.checkboxid[i].value;
					}
					else
					{
						delid = delid+","+document.all.checkboxid[i].value;
					}					
				}
			}
		}
		if(delid=="")
		{
			alert("请选择要删除的联系人！");
			return false;
		}
		if(!confirm("是否真的要删除？"))
		{
			return false;
		}
		document.all.txt_type.value = "1";
		document.all.txt_edit.value = "4";
		document.all.txt_lxrxh.value = delid;
		document.all.form1.action = "../../PerSvlt";
		document.all.form1.submit();
	}
	function clearlxr(){
		if(!confirm("是否真的要删除所有的联系人？"))
		{
			return false;
		}
		document.all.txt_type.value = "1";
		document.all.txt_edit.value = "5";
		document.all.form1.action = "../../PerSvlt";
		document.all.form1.submit();
	}
</script>
<%}catch(Exception e){oa.main.Logger.log("ERROR:oa.person.displayTxun.jsp=>");e.printStackTrace(oa.main.Logger.log);}
finally{
	if(myBean!=null)myBean.closeConn();
}%>