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

📄 list.jsp

📁 基于jsp的网络百宝箱
💻 JSP
字号:
🔍 
<%@ page language="java" contentType="text/html; charset=GBK" pageEncoding="GB18030" import="java.sql.*,java.util.*,java.io.*"%>
<%@ include file="config.ini"%>
<%@ include file="conn.jsp"%>
<%@ include file="readlogin.jsp"%>
<jsp:useBean id="iCanDipage" class="com.iCan.DipageBean" scope="page" />
<%
    //设置分页显示的页数
	iCanDipage.setCountPageRecord(recordsPerPage);
%>
<html>

<head>
<%@ include file="head.jsp"%>
</head>

<body>
<center>
<table border="0" width="768" id="table1" cellspacing="0" cellpadding="0">
	<tr>
	<%@ include file="top.jsp"%>
	</tr>
	<tr>
		<td width="90" valign="top">
	<%@ include file="menu.jsp"%>		</td>
		<td width="588" valign="top">
		<table border="0" width="100%" id="table3" cellspacing="0" cellpadding="0">
			<tr>
				<td>
				<table border="1" width="100%" id="table4" bordercolorlight="#0A9EE4" cellspacing="0" cellpadding="5" bordercolordark="#0A9EE4"  height=300>
					<tr>
						<td valign="top">
						<table border="0" width="100%" id="table5" cellspacing="0" cellpadding="0">
							<tr>
								<td>
								<table border="0" width="100%" id="table6" cellspacing="0" cellpadding="0">
									<tr>
										<td valign="bottom" width="50%">
										<a href="list_add.jsp" target="_top">
										<img src="images/list-add.jpg" align="left" style="border-style: solid; border-width: 0" width="131" height="45"></a></td>
										<td width="50%">
										<img src="images/n-list.jpg" align="right" width="230" height="70"></td>
									</tr>
								</table>
								</td>
							</tr>
							<tr>
								<td><hr noshade color="#0A9EE4" size="1"></td>
							</tr>
							<tr>
								<td>
								<table border="0" width="100%" id="table8" cellspacing="0" cellpadding="0">
									<tr>
										<td>
										<form method="POST" target="_top" action="list.jsp" name="form1">
											<p align="right">
											<span style="font-size: 9pt">姓名：<input type="text" name="s_name" size="10" style="border: 1px solid #0A9EE4">&nbsp;&nbsp;&nbsp; 
											分类：<select size="1" name="s_sort" style="border: 1px solid #0A9EE4">
										<option value="all" selected>全部</option>
										<option value="家人、亲戚">家人、亲戚
										</option>
										<option value="同事、同学">同事、同学</option>
										<option value="朋友">朋友</option>
										<option value="网友、笔友">网友、笔友</option>
										<option value="业务人士">业务人士</option>
										<option value="其他">其他</option>
										</select>&nbsp;&nbsp;&nbsp;
											<input type="submit" value="搜索" name="B1" style="border: 1px solid #0A9EE4">&nbsp;&nbsp;&nbsp;
											</span></p>
										</form>
										</td>
									</tr>
								</table>
								</td>
							</tr>
							<tr>
								<td>
								<table border="1" width="100%" id="table7" cellspacing="0" cellpadding="0" bordercolorlight="#0A9EE4" bordercolordark="#FFFFFF">
<tr>
										<td width="14%" height="22">
										<p align="center"><font color="#0A9EE4">
										<span style="font-size: 9pt; font-weight: 700">
										姓名</span></font></td>
										<td width="16%" height="22" align="center">
										<font color="#0A9EE4">
										<span style="font-size: 9pt; font-weight: 700">
										移动电话</span></font></td>
										<td width="22%" height="22" align="center">
										<font color="#0A9EE4">
										<span style="font-size: 9pt; font-weight: 700">
										QQ</span></font></td>
										<td width="30%" height="22" align="center">
										<font color="#0A9EE4">
										<span style="font-size: 9pt; font-weight: 700">
										Email</span></font></td>
										<td width="18%" height="22" align="center" colspan="2">
										<font color="#0A9EE4">
										<span style="font-size: 9pt; font-weight: 700">
										操&nbsp; 作</span></font></td>
									</tr>
<%
//获取查询时需要的联系人姓名和类别参数
String s_name=codeToString(request.getParameter("s_name"));
String s_sort=codeToString(request.getParameter("s_sort"));
sqlstr="select id,name,mobile,qq,email from list where user='"+iCan+"'";
if(s_name!=null)
{sqlstr=sqlstr+" and name like '%"+s_name.trim()+"%'";}
if(s_sort!=null&&(!s_sort.equals("all")))
{sqlstr=sqlstr+" and sort='"+s_sort+"'";}
try
{
  //根据联系人姓名和类别进行查询
  rs=iCanDb.doSelect(sqlstr);
  if(rs.next())
  {
    rs.last();
    int count=rs.getRow();
    rs.beforeFirst();
    
    iCanDipage.setCountRecord(count);
	//根据用户提交的分页显示的参数，获得要显示的页数
    String pages=request.getParameter("dipage");
    if(iCanDipage.isFirstPage(pages))
       rs.beforeFirst();
    else
      rs.absolute(iCanDipage.getAbsoluteLocation());
    int dipagei=0;
    //循环获取要显示的记录集合中每条记录的不同字段
    while(rs.next())
     {
      String id=rs.getString("id");
      String name=rs.getString("name");
      String mobile=rs.getString("mobile");
      String qq=rs.getString("qq").trim();
      String email=rs.getString("email");
      
%>
									<tr>
										<td width="14%" height="22">
										<p align="center"><span style="font-size: 9pt"><a href=list_read.jsp?id=<%=id%> target=_top><font color="#0A9EE4"><%=name%></font></a></span></td>
										<td width="16%" height="22">
										<p align="center">
										<span style="font-size: 9pt">&nbsp;<%=mobile%></span></td>
										<td width="22%" height="22">
										<p align="center">
										<span style="font-size: 9pt">&nbsp;<%=qq%><%if(!qq.equals("")){%><a target=blank href=tencent://message/?uin=<%=qq%>&Site=<%=name%>&Menu=yes><img border="0" SRC=http://wpa.qq.com/pa?p=1:<%=qq%>:5 alt="点击这里给他发消息"></a><%}%></span></td>
										<td width="30%" height="22">
										<p align="center">
										<span style="font-size: 9pt">&nbsp;<%=email%></span></td>
										<td width="9%" height="22">
										<p align="center">
										<span style="font-size: 9pt">
										<font color="#0A9EE4">[ </font> <a href="list_edit.jsp?id=<%=id%>" target=_top>
										<font color="#0A9EE4">修改</font></a><font color="#0A9EE4"> ]</font></span></td>
										<td height="22" width="9%">
										<p align="center"><span style="font-size: 9pt">
										<font color="#0A9EE4">[ </font> <a href="list_del.jsp?action=confirm&id=<%=id%>" target=_top>
										<font color="#0A9EE4">删除</font></a><font color="#0A9EE4"> ]</font></span></td>
									</tr>

<%
        dipagei++;//显示的页数加1
        if(dipagei>=iCanDipage.getCountPageRecord()) break; //当前页显示完，则退出循环
    }
%>
	               </table><table border="0" width="100%" id="table1" cellspacing="0" cellpadding="0" style="font-size: 9pt; font-family: 宋体" height="20">
										<tr><td width="100%" valign="bottom">
<%
iCanDipage.showDipageBar("list.jsp",out);
%></td></tr></table>
<%
  }
  else
  {
%>
									<tr>
										<td height="25" colspan="6"><span style="font-size: 9pt">&nbsp;&nbsp;&nbsp; 
										暂无记录！</span></td>
									</tr></table>
<%
  }
}
catch(Exception e)
{
  out.print("<script>");
  out.print("alert('数据库错误！');");
  out.print("location.href='index.jsp';");
  out.print("</script>");
}
%>
								</td>
							</tr>
							<tr>
								<td>　</td>
							</tr>
							<tr>
								<td>
								<p align="center"><input type="button" value="返回" name="B2" style="border: 1px solid #156FC7" onclick="javascript:location.href='list.jsp';"></td>
							</tr>
							<tr>
								<td>　</td>
							</tr>
						</table>
						</td>
					</tr>
				</table>
				</td>
			</tr>
		</table>
		</td>
		<td width="90">　</td>
	</tr>
	<tr>
		<td width="90" valign="top">
	　</td>
		<td width="588" valign="top">
<%@ include file="copyright.jsp"%>
		</td>
		<td width="90">　</td>
	</tr>
</table>
<p>
</center>
</p>
</body>

</html>

⌨️ 快捷键说明

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