read1.jsp
来自「JSP+ORACLE网站开发实例（下）.rar」· JSP 代码 · 共 358 行 · 第 1/2 页
JSP
358 行
<%@ include file="conn.jsp"%>
<%request.setCharacterEncoding("GB2312");
String willstr="";
String user_id1= (String) session.getValue("user_id");
//叛断Session变量是否超时
if((user_id1==null)|(user_id1=="")){
response.sendRedirect("timeout.htm");
}
String user_id=request.getParameter("user_id");
String sql="select * from scott.larchives where user_id='"+user_id+"' ";
ResultSet rs_lar=stmt.executeQuery(sql);
if(rs_lar.next()){
Statement stmt1=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
sql="select * from scott.apply where for_id='"+user_id+"' and user_id='"+user_id1+"'";
ResultSet rs_apply=stmt1.executeQuery(sql);
if(rs_apply.next()){
willstr=rs_lar.getString("netname")+"已向您发出交友请求";
}
Statement stmt2=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
sql="select * from scott.friend where (for_id='"+user_id1+"' and user_id='"+user_id+"') or (for_id='"+user_id+"' and user_id='"+user_id1+"')";
ResultSet rs_friend=stmt2.executeQuery(sql);
if(rs_friend.next()){
willstr=rs_lar.getString("netname")+"是您的好友";
}
Statement stmt3=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
sql="select * from scott.apply where for_id='"+user_id+"' and user_id='"+user_id1+"'";
rs_apply=stmt3.executeQuery(sql);
if(rs_apply.next()){
willstr="您已向“"+rs_lar.getString("netname")+"”发出交友请求，请静候佳音！";
}
//if rspic.eof and rspic.bof then
int picid=1;
// cur=1
//else
// rspic.pagesize=1
// cur=request("cur")
// if cur="" or clng(cur)<1 then cur=1
// if clng(cur)>rspic.pagecount then cur=rspic.pagecount
// rspic.absolutepage=cur
// picid=rspic("id")
//end if
// pics=rspic.recordcount
%>
<%!
String replacenull(String a){
if(a==null){
return " ";
}else{
return a;
}
}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Namo WebEditor v4.0(Trial)">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>个人档案</title>
<style>
<!--
-->
</style>
<script language="JavaScript">
<!--
function MM_findObj(n, d) { //v3.0
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); return x;
}
function MM_showHideLayers() { //v3.0
var i,p,v,obj,args=MM_showHideLayers.arguments;
for (i=0; i<(args.length-2); i+=3) if ((obj=MM_findObj(args[i]))!=null) { v=args[i+2];
if (obj.style) { obj=obj.style; v=(v=='show')?'visible':(v='hide')?'hidden':v; }
obj.visibility=v; }
}
//-->
</script>
<link rel="stylesheet" href="ysb.css">
</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>
<p>
<div id="layer2" style="width:765px; height:216px; position:absolute; left:71px; top:130px; z-index:1; visibility:hidden;">
<table border="0" width="761" height="216" cellspacing="0" cellpadding="0">
<tr bordercolor="#FFFFFF">
<td width="624" valign="top" align="left">
<div align="center">
<center>
<table border="0" width="122%" height="181" cellspacing="0" cellpadding="0">
<tr>
<td width="100%" height="151" valign="top" align="center"><a href="" onClick="return false" ><img name="big" src="display.jsp?id=<%=picid%>" onClick="MM_showHideLayers('layer2','','hide');MM_showHideLayers('layer','','show');MM_showHideLayers('layer1','','show');return false;" border="0"></a>
</td>
</tr>
<tr>
<td width="100%" height="12" valign="top" align="center"> </td>
</tr>
</table>
</center>
</div>
</td>
</tr>
</table>
</div>
<div id="layer" style="width:765px; height:531px; position:absolute; left:7px; top:122px; z-index:0; visibility:visible;">
<!------------------------------------------------------------------------------------------------------------------------------>
<!--------------------------------------------------------------------------------------------->
<table border="0" width="750" height="216" cellspacing="0" cellpadding="0" align="left">
<tr>
<td width="6" height="210" valign="middle"> </td>
<td width="28" height="210" valign="top" bgcolor="#FFCC99"> <font size="2"> </font>
</td>
<td width="712" height="216" valign="top" bgcolor="#fff4cf" style="border-right-style: solid; border-right-width: 1; border-bottom-style: solid; border-bottom-width: 1" bordercolor="#F4F4F4">
<!------------------------------------------------------------------------------------------>
<table border="0" width="730" height="15" cellspacing="0" cellpadding="2">
<tr>
<td width="21" height="8"> </td>
<td width="678" height="8" colspan="5"></td>
<td></td>
</tr>
<tr>
<td width="21" height="6"></td>
<td width="678" height="6" colspan="5"><font size="3" color="#b00000"><b><u><%=replacenull(rs_lar.getString("name"))%></u></b></font>个人档案<p></td>
<td></td>
</tr>
<tr>
<td width="21" height="223" valign="top">___</td>
<td width="39" height="212" valign="top"> <!--------------------------------------------------------------------------------------------->
<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td width="100%" valign="bottom" align="center">
</td>
</tr>
<%Statement stmt7=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
sql="select * from scott.friendimg where id='"+user_id+"' order by fid desc ";
ResultSet rs_friendimg=stmt7.executeQuery(sql);
if(rs_friendimg.next()){
//sql="select * from pic where user_id=" & user_id
//rspic.open sql,connpic,1,1%>
<tr>
<td width="100%"> <a href="display.jsp?id=<%=rs_friendimg.getString("fid")%>" target="_blank"><img name="small" border="1" src="display.jsp?id=<%=rs_friendimg.getString("fid")%>" width="100" height="135" ></a>
</td>
</tr>
<%}%>
<tr>
<td width="100%"></td>
</tr>
<tr>
<td width="100%"><font color="black"> 学历：<%=replacenull(rs_lar.getString("education"))%></font></td>
</tr>
<tr>
<td width="100%"><font color="black"> 星座：<%=replacenull(rs_lar.getString("star"))%></font></td>
</tr>
<tr>
<td width="100%"><font color="black"> 人气：<%=replacenull(rs_lar.getString("renqi"))%></font></td>
</tr>
<tr>
<td width="100%"><font color="black"> 点击：<%=replacenull(rs_lar.getString("click"))%></font></td>
</tr>
<tr>
<td width="100%" bgcolor="#fff4cf"><font color="black"> </font></td>
</tr>
<tr>
<td width="100%" >
<%if(!user_id.equals(user_id1)){
%>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?