📄 index.jsp
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="com.sun.jndi.cosnaming.CNCtxFactory"%>
<%@ include file="in.jsp"%>
<jsp:useBean id="cn" class="cn.com.yyj.util.ConDb" scope="page" />
<html>
<head>
<TITLE>我的同学录</TITLE>
<style type="text/css">
<!--
<!--
.kuan { font-size: 9pt; border: 1px solid; }
-->
.tb{ border: 1px solid; border-color: #000000}
.tr{ border: 1px solid; border-color: #000000}
.style2 {color: #000000}
.style3 {color: #000000}
.del {color: ##00FFFF}
body {
background-color: #333333;
}
a:link {
font-family: "宋体";
font-size: 12px;
color: #00FFFF;
}
.style5 {color: #FFFFFF}
.style6 {font-size: 12px}
-->
</style>
</head>
<body>
<%
String login=(String)session.getAttribute("loginOK");
if(login!=null&&login.equals("OK")){%>
<%
request.setCharacterEncoding("gb2312");
ResultSet rs;
String sqlstr;
String action = request.getParameter("act");
if (action != null) {
String sname, tj,value;
sname = request.getParameter("name").trim();
tj = request.getParameter("tj");
value = request.getParameter("searchvalue");
if (tj.equals("="))
sqlstr = "select * from class where " + sname + "='"
+ value + "'";
else if (tj.equals(">"))
sqlstr = "select * from class where " + sname + " > "
+ value;
else if (tj.equals("<"))
sqlstr = "select * from class where " + sname + " < "
+ value;
else
sqlstr = "select * from class where " + sname + " like '%"
+ value + "'%";
rs = cn.execute(sqlstr);
} else {
rs = cn.execute("select * from class");
}
rs.last();
int rowCount = rs.getRow();
if (rowCount == 0) {
%>
<table width="350" border="1" align="center" cellspacing="0">
<tr>
<td bgcolor="#0099FF">
<div align="center">
提示
</div>
</td>
</tr>
<tr>
<td>
<div align="center">
<FONT color=#FFFFFF>通讯录中没有任何记录信息!</FONT>
</div>
</td>
</tr>
<tr>
<td align=center>
<a href="add_new.jsp">点此添加记录信息</a> <a href="index.jsp">返回</a>
</td>
</tr>
</table>
<%return;
}
String strCurPage = request.getParameter("page");
int curPage;
if (strCurPage == null)
curPage = 1;
else
curPage = Integer.parseInt(strCurPage);
int countPerPage = 5;
int pageCount = (rowCount + countPerPage - 1) / countPerPage;
rs.absolute((curPage - 1) * countPerPage + 1);
int i = 0;
%>
<table width="648" height="158" border="0" align="center" cellspacing="0">
<tr>
<td width="72" height="27">
</td>
<td width="465">
<A href="search.jsp">查询</A>
</td>
<td width="105">
</td>
</tr>
<tr>
<td height="15">
</td>
<td>
<div align="center">
<span class="style5"> 共有 <%=rowCount%> 条记录</span>
</div>
</td>
<td>
</td>
</tr>
<tr>
<td>
</td>
<td valign="top">
<p>
</p>
<%while (i < countPerPage && !rs.isAfterLast()) {
%>
<a href="add_new.jsp">添加新记录</a> <a href="del.jsp?id=<%=rs.getString(1)%>">删除</a> <a href="modify.jsp?id=<%=rs.getString(1)%>">修改记录</a>
<table width="432" height="293" border="1" cellspacing="0" class="tb">
<tr>
<td height="23" colspan="3">
<img src="images/bar1.gif" width="472" height="25">
</tr>
<tr bgcolor="#CCFF99">
<td width="172">
姓名:
<%=rs.getString("name")%>
</td>
<td width="296">
性别<span class="style3">:</span>
<%=rs.getString("sex")%>
</td>
</tr>
<tr bgcolor="#CCFF99">
<td colspan="2">
生日:<span style="FONT-SIZE: 9pt"><span class="style2"></span></span>
<%=rs.getDate("birth")%>
</td>
</tr>
<tr bgcolor="#CCFF99">
<td>
QQ:
<%=rs.getString("qq")%>
</td>
<td>
E-mail:
<%=rs.getString("email")%>
</td>
</tr>
<tr bgcolor="#CCFF99">
<td>
联系电话:
<%=rs.getString("phone")%>
</td>
<td>
邮编:
<%=rs.getString("postcode")%>
</td>
</tr>
<tr bgcolor="#CCFF99">
<td colspan="2">
工作单位 :
<%=rs.getString("work")%>
</td>
</tr>
<tr bgcolor="#CCFF99">
<td colspan="2">
通信地址 :
<%=rs.getString("addr")%>
</td>
</tr>
<tr bgcolor="#CCFF99">
<td height="143" colspan="2" valign="top">
<p>
备注:
<textarea name="other" cols="60" rows="8" class=kuan><%=rs.getString("other")%> </textarea>
</p>
</td>
</tr>
</table>
<p>
<%i++;
rs.next();
}
%>
<p></p>
<p>
<FONT color="#FFFFFF">当前页 <%=curPage%></FONT> <FONT color="#FFFFFF">共 <%=pageCount%> 页</FONT>  
<%if (curPage == 1) {%>
<FONT color="#FFFFFF">第一页</FONT> <FONT color="#FFFFFF">上一页</FONT>
<%} else {
%>
<a href="index.jsp?page=<%=1%>"><FONT color="#FFFFFF">第一页</FONT></a> <a href="index.jsp?page=<%=curPage-1%>"><FONT color="#FFFFFF">上一页</FONT></a>
<%}
if (curPage == pageCount) {
%>
<FONT color="#FFFFFF">下一页 <FONT color="#FFFFFF">最后页 <%} else {
%>
<a href="index.jsp?page=<%=curPage+1%>"><FONT color="#FFFFFF">下一页</FONT></a> <a href="index.jsp?page=<%=pageCount%>"><FONT color="#FFFFFF">最后页</FONT></a> <%}%>
</p>
</td>
<td>
</td>
</tr>
</table>
<%
}else{
out.println("请先<a href=login.jsp>登录</a>");
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -