⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 demand_index.jsp

📁 《JSP数据库系统开发完全手册》配套关盘
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<% request.setCharacterEncoding("gb2312"); %>
<%@ page import="com.zh.util.demand"%>
<%@ page import="com.zh.conpool.Condata"%>
<%@ page import="java.util.Vector"%>
<%@ page import="java.util.Iterator"%>
<%@ page import="com.zh.util.demandset"%>
<%
	String sess=(String)session.getAttribute("username");
	if(sess==null||sess.equals("")){
		response.sendRedirect("../main.jsp");
	}else{
		swing.Rous rou=new swing.Rous();
		boolean maybe=rou.toInt(sess,"row124");
		if(!maybe){
			response.sendRedirect("../notrous.jsp");
		}
	}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<link href="../css/style1.css" rel="stylesheet">
</head>
<jsp:useBean id="demand" class="com.zh.util.demandsql"></jsp:useBean>
<body>
<%
String id=request.getParameter("id");
%>
<table width="100%" height="25" border="0" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bordercolorlight="#FFFFFF" bordercolordark="#EEF2F9">
  <tr>
    <td> &nbsp;&nbsp;<img src="../images/Manual14.gif" width="16" height="16">客户管理&nbsp;&gt;&gt;&nbsp;&nbsp;<img src="../images/Manual11.gif" width="16" height="16"><a href="Demand_Index_Add.jsp?id=<%=id%>" target="mainName">添加客户需求</a>
        <hr color="#006699" size="1">
&nbsp;&nbsp;<img src="../images/icon_group.gif" width="15" height="15"><a href="Client_Index_Sql.jsp?id=<%=id%>&&tag=1">客户信弦杂胿ector类型本身也可以实现;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <img src="../images/Manual54.gif" width="16" height="16"><a href="Stock_Index.jsp?id=<%=id%>">采购记录</a> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <img src="../images/Manual65.gif" width="16" height="16"><a href="Follow_Index.jsp?id=<%=id%>">跟进记录</a> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <img src="../images/Manual1.gif" width="16" height="16"><a href="Call_Index.jsp?id=<%=id%>">回访记录</a> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <img src="../images/Manual11.gif" width="16" height="16"><a href="Demand_Index.jsp?id=<%=id%>">需求表</a> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <img src="../images/icon_go_left.gif" width="15" height="15"><a href="Client_Index.jsp">返回</a>
    <hr color="#003366" size="1"></td>
  </tr>
</table>
<table width="100%"  border="1" cellspacing="0" cellpadding="0" bordercolor="#FFFFFF" bordercolordark="#EFF3FF" bordercolorlight="#FFFFFF">
  <tr align="center"> 
    <td width="24%">需求项目</td>
    <td width="14%">大约金额</td>
    <td width="37%">简要说明</td>
    <td width="14%">操作</td>
  </tr>
  <%
  	String topage;
	int showpage=0;
	int pagesize=5;
	topage=request.getParameter("topage");
	if(topage==null){
		showpage=1;
	}else{
	try{
		showpage=Integer.parseInt(topage);
		}catch(NumberFormatException e){
			e.getMessage();
		}
	}
	Vector vec=demand.getSql(id,5,showpage);//如果不用迭代器方法也可以用vector类型本身也可以实现
	/***
	for(int i=0;i<vec.size();i++){
		dem dm=vec.elementAt(i);}实现的方法同下一样可以实现数据取出
	***/
	Iterator it=vec.iterator();
	int num=0;
	for(int i=0;i<vec.size();i++){
		demandset dm=(demandset)vec.elementAt(i);
		//num++;
		//demandset dm=(demandset)it.next();
  		String demid=dm.getClientId();
		
  %>
  <tr>
    <td height="25" align="center"><%=dm.getDemand()%></td>
    <td height="25" align="center"><%=dm.getMoney()%></td>
    <td height="25" align="center"><%=dm.getExplain()%></td>
    <td height="25" align="center"><a href="Demand_Index_Update.jsp?demid=<%=demid%>&&id=<%=id%>&&modify=modify"><img src="../images/ico/a_delete.gif" width="52" height="16" border="0"></a>&nbsp;</td>
    <td height="25" align="center">&nbsp;</td>
  </tr>
  <%
  }
  %>
  <tr align="center" bgcolor="#EFF3FF">
    <td height="25" colspan="5"><a href="Demand_Index.jsp?id=<%=id%>&&topage=<%=showpage-1%>"><img src="../images/1-prev.gif" width="36" height="11" border="0"></a>&nbsp;&nbsp;&nbsp;&nbsp;<a href="Demand_Index.jsp?id=<%=id%>&&topage=<%=showpage+1%>"><img src="../images/1-next.gif" width="36" height="11" border="0"></a></td>
  </tr>
</table>

</body>
</html>

⌨️ 快捷键说明

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