📄 test.jsp

📁 《JSP数据库系统开发完全手册》配套关盘
💻 JSP
字号:
<script language=javascript>
 <!--
 var startTime,endTime;
 var d=new Date();
 startTime=d.getTime();
 //-->
 </script>
<html>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="sqlbean" scope="page" class="com.zh.conpool.Condata"/>
<jsp:useBean id="pagi" scope="page" class="com.zh.util.page" />
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>企业内部管理信息平台-管理</title>
<link rel="stylesheet" href="m_style.css" type="text/css">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}
//-->
</script>
</head>
<body>
<table width="500">
	<% 
	 String nowPage="";
	 String str_where="";//设置查询条件,默认值为空
	 String footer="";
	 String id="";
	 String cuclass="";
	 String parentclass="";
	 String author="";
	 String title="";
	 String d="";
	 nowPage=request.getParameter("pages");  //获取地址栏传过来的pages参数
	 if (nowPage==null||nowPage.equals("null"))
	nowPage="0";    //将当前页的具体页号置为0
	pagi.setPages(5);   //设置分页的每页条数
	ResultSet rs = pagi.setQuerysql("tb_contract",str_where,"test.jsp",nowPage);
	footer = pagi.PageFooter(); //读分页栏
	try{
		if (pagi.intPageCount>0)
		{int i=0;
		while (rs.next())
		{i++;
		if (i>((pagi.intPage-1)*pagi.intPageSize) &&(i<=pagi.intPage*pagi.intPageSize))//定位下一页翻转页的总记录数
		   {
			id=rs.getString(2);
			parentclass=rs.getString(3);
			cuclass=rs.getString(4);
			d=rs.getString(5);
			title=rs.getString(6);
			author=rs.getString(7);
			%>
			<tr><td height="30" class="forumrow"><%=id%></td>
			<td height="30" class="forumrow"><%=parentclass%> <%=cuclass%></td>
			<td height="30" class="forumrow"><a href=../show.jsp?id=<%=id%> target="_blank"><%=title%></a></td>
			<td height="30" class="forumrow"><%=d%></td>
			<td height="30" class="forumrow"><%=author%></td>
			<td><a href="test.jsp?delete=del&id=<%=id%>"
		onclick="{if(confirm('此操作将删除当前记录！\n \n 删除后将不能恢复，您确定执行的操作吗?')){this.document.myform.submit();return true;}return false;}">删除</a>|<a href="test.jsp?id=<%=id%>">修改</a></td></tr>
			<%}//end if
		} //end while
		} //end if
	
		rs.close();
		} catch(Exception e){
		out.println(e.getMessage());
		}
		finally
			 {}
	out.print("</table>");
	out.println("<table border=0 width='70%' cellspacing='0' cellpadding='0' align='center' bordercolorlight='#000000'    bordercolordark='#FFFFFF'><tr><td colspan=4 align=center>"+footer+"</td></tr>");
	%>
</table>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -