📄 list.jsp

📁 JSP+ORACLE网站开发实例（下）.rar
💻 JSP
字号:
<%@ include file="conn.jsp"%>
<%! 
String replacenull(String a){ 
	if(a==null){
return "&nbsp;"; 
	}else{
return a; 
	}
} 
%> 
<%request.setCharacterEncoding("GB2312");
 String user_id= (String) session.getValue("user_id"); 
//叛断Session变量是否超时
if((user_id==null)|(user_id=="")){
response.sendRedirect("timeout.htm"); 
}
String px =request.getParameter("px");
if(px==null){
	 px="j_date";
}
String search_txt =request.getParameter("search_txt");
String sql="select user_id,netname,sex,netcall,britherday,ip,renqi,home,date1,photo from scott.larchives"; 


if(search_txt!=null){
sql=sql + " where netname like '%" + search_txt + "%'";
	sql=sql + " or sex like '%" + search_txt + "%'";
	sql=sql + " or netcall like '%" + search_txt + "%'";
	sql=sql + " or britherday like '%" + search_txt + "%'";
	sql=sql + " or ip like '%" + search_txt + "%'";
	sql=sql + " or renqi like '" + search_txt + "'";
	sql=sql + " or date1 like '%" + search_txt + "%' ";

}
sql=sql + " order by lar_id desc";
ResultSet rs_lar=stmt.executeQuery(sql); 

%>
<html>
<head>
<style>
<!--
.x:link      { color: white; text-decoration: none }
.x:visited   { color: white; text-decoration: none }
.x:active    { color: red; text-decoration: none }
.x:hover     { color: red;text-decoration:nome}
tr           { font-size: 10pt }
body         { font-size: 10pt }
a:link       { color: blue; text-decoration: none }
a:visited    { color: blue; text-decoration: none }
a:active     { color: red; text-decoration: none }
a:hover      { color: red; text-decoration: none }
-->
</style>
<title>网友列表</title>
<meta name="generator" content="Namo WebEditor v4.0(Trial)">
<style type="text/css">A:visited {
 COLOR: #000000; TEXT-DECORATION: none
}
A:link {
 COLOR: #000000; TEXT-DECORATION: none
}
A:hover {
 COLOR: #0080c0; TEXT-DECORATION: none
}
TD {
 FONT-SIZE: 9pt; COLOR: #000000; FONT-FAMILY: "宋体"
}
.f1 {
 LINE-HEIGHT: 18px
}
.en {
 FONT-WEIGHT: bold; FONT-FAMILY: "Arial","Verdana"
}
.new {
 FONT-WEIGHT: bold; COLOR: #ff3300; FONT-FAMILY: "Arial"
}
.line {
 LINE-HEIGHT: 19px
}
</style>
<SCRIPT language=JavaScript>
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
  if (theURL != "fuckyou")
 {   window.open(theURL,winName,features);}
}
//-->
</SCRIPT></head>
<body leftmargin="5" topmargin="0">
<table width="772" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><img src="images/top.gif" width="772" height="112" usemap="#Map" border="0"></td>
  </tr>
</table>
<table border="0" width="776" cellpadding="2" cellspacing="0">
  <tr> 
    <td width="537" align="center" style="border-bottom-style: solid; border-bottom-width: 1" height="18"> 
      <p align="left"> <font size="2">
	  <%if(search_txt!=null){ %>
	  以下是包含关键字<font color="#ff0000"><%=search_txt%></font>的所有网友
	  <%}else{%>
	  以下是所有网友的列表<%}%></font> 
      </p>
    </td>
    <td width="231" align="center" style="border-bottom-style: solid; border-bottom-width: 1" height="18">&nbsp; 
    </td>
  </tr>
  <tr> 
    <td height="18" colspan="2">
    </td>
  </tr>
  <tr align="right"> 
    <td height="18" colspan="2">&nbsp; </td>
     </tr>
</table>
  <!------------------------------------------------------------------------------------------------------------------------->
    
<table border="1" width="776" cellspacing="0" bordercolorlight="#333300" bordercolordark="#FFFFFF" cellpadding="2">
  <tr bgcolor="#336600"> 
    <td width="85" align="center" style="border-left-style: solid; border-left-width: 1; border-bottom-style: solid; border-bottom-width: 1" height="20"><font color="#FFFFFF">网名</font></td>
    <td width="59" align="center" style="border-left-style: solid; border-left-width: 1; border-bottom-style: solid; border-bottom-width: 1" height="20"><font color="#FFFFFF">性别</font></td>
    <td width="106" align="center" style="border-left-style: solid; border-left-width: 1; border-bottom-style: solid; border-bottom-width: 1" height="20"><font color="#FFFFFF">来自</font></td>
    <td width="82" align="center" style="border-left-style: solid; border-left-width: 1; border-bottom-style: solid; border-bottom-width: 1" height="20"><font color="#FFFFFF">生日</font></td>
    <td width="98" align="center" style="border-left-style: solid; border-left-width: 1; border-bottom-style: solid; border-bottom-width: 1" height="20"><font color="#FFFFFF">网络寻呼机</font></td>
    <td width="98" align="center" style="border-left-style: solid; border-left-width: 1; border-bottom-style: solid; border-bottom-width: 1" height="20"><font color="#FFFFFF">登记IP</font></td>
    <td width="86" align="center" style="border-left-style: solid; border-left-width: 1; border-bottom-style: solid; border-bottom-width: 1" height="20"><font color="#FFFFFF">登记时间</font></td>
    <td width="74" align="center" style="border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; border-bottom-style: solid; border-bottom-width: 1" height="20"><font color="#FFFFFF">照片数</font></td>
    <td width="68" align="center" style="border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; border-bottom-style: solid; border-bottom-width: 1" height="20"><font color="#FFFFFF">人气</font></td>
  </tr>
  <%while(rs_lar.next()){%> 
  <tr bgcolor="#DDF9FF"> 
    <td width="85" align="center" style="border-left-style: solid; border-left-width: 1; border-bottom-style: solid; border-bottom-width: 1" height="20"><a href="read.jsp?user_id=<%=rs_lar.getString("user_id")%>" title="查看网友<%=replacenull(rs_lar.getString("netname"))%>的祥细资料"><%=rs_lar.getString("netname")%></a></td>
    <td width="59" align="center" style="border-left-style: solid; border-left-width: 1; border-bottom-style: solid; border-bottom-width: 1" height="20"><%=replacenull(rs_lar.getString("sex"))%></td>
    <td width="106" style="border-left-style: solid; border-left-width: 1; border-bottom-style: solid; border-bottom-width: 1" height="20"><%=replacenull(rs_lar.getString("home"))%></td>
    <td width="82" align="center" style="border-left-style: solid; border-left-width: 1; border-bottom-style: solid; border-bottom-width: 1" height="20"><%=replacenull(rs_lar.getString("britherday"))%></td>
    <td width="98" align="center" style="border-left-style: solid; border-left-width: 1; border-bottom-style: solid; border-bottom-width: 1" height="20"><%=replacenull(rs_lar.getString("netcall"))%></td>
    <td width="98" align="center" style="border-left-style: solid; border-left-width: 1; border-bottom-style: solid; border-bottom-width: 1" height="20"><%=replacenull(rs_lar.getString("ip"))%></td>
    <td width="86" align="center" style="border-left-style: solid; border-left-width: 1; border-bottom-style: solid; border-bottom-width: 1" height="20"><%=replacenull(rs_lar.getString("date1"))%></td>
    <td width="74" align="center" style="border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; border-bottom-style: solid; border-bottom-width: 1" height="20"><%=replacenull(rs_lar.getString("photo"))%></td>
    <td width="68" align="center" style="border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; border-bottom-style: solid; border-bottom-width: 1" height="20"><%=replacenull(rs_lar.getString("renqi"))%></td>
  </tr>
  <%}%> 
</table>
  
<table width="776" bgcolor="white" cellpadding="2" cellspacing="0" border="0">
  <tr align="center"> 
    <td bgcolor="white">&nbsp; </td>
    </tr>
  </table>
  <!-------------------------------------------------------------------------------------------------------------------------><!------------------------------------------------------------------------------------------------------------------------->
<form>
  
<table border="0" width="776" cellspacing="0" height="27">
  <tr>
      <td width="100%" height="13">
      <p align="center"> 搜索关键字
        <input type="text" name="search_txt" size="8" value="<%=replacenull(search_txt)%>">
        <input type="submit" value="搜索" name="B1">
      </p>
      </td>
   </tr>
    <tr>
      
    <td width="100%" height="25"> 
      <p align="center">关键字为空列出所有网友 
    </td>
    </tr>
  </table>
        
<map name="Map">
  <area shape="rect" coords="228,95,273,110" href="default.jsp">
  <area shape="rect" coords="293,94,358,109" href="your.jsp">
  <area shape="rect" coords="384,95,444,111" href="list.jsp">
  <area shape="rect" coords="470,95,527,112" href="register.jsp">
  <area shape="rect" coords="556,92,617,111" href="sendphoto.jsp">
  <area shape="rect" coords="643,93,699,111" href="pics.jsp">
</map>
⌨️ 快捷键说明

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