📄 myquizview.jsp.svn-base
字号:
if(upFlag.equals("0")){sql=sql1+sql3;}else{sql=sql1+sql2;}
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if(!rs.next()) // 蔼捞 绝阑锭
{
isNoPage = 1;
pagesize=0;
}
else // 蔼捞 乐阑锭 //rs.absolute(absolutepage);
{
for(int s=0; s<absolutepage-1; s++)
rs.next();
}
int count = 0 ;
int cnt = reCnt;
if(pageNUM == 1){
cnt = reCnt;
}else{
cnt=reCnt-(pageNUM-1)*pagesize;
}
while(count<pagesize){
count++;
re_idx = rs.getInt(1);
re_phonenum = rs.getString(2);
re_name = rs.getString(3);
re_text = rs.getString(4);
ref_idx = rs.getInt(5);
flag = rs.getInt(6);
re_date = rs.getString(7);
phonenum = rs.getString(9);
takeFlag = rs.getInt("flag");
if (takeFlag == 1){
placeTopColor = "#fefad2";
}else{
placeTopColor = "#e1eef1";
}
%>
<!-- 馆汗 1 矫累 -->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0" bgcolor=<%=placeTopColor%>>
<tr>
<!--酒官鸥 矫累-->
<td width="54" align="top">
<table width="54" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="3" height="3"></td>
</tr>
<tr>
<td width="3"></td>
<td align="top">
<img src="<%=ava_path%>display_thumb.jsp?mphone=<%=mphone%>&gphone=0<%=re_phonenum%>" width="48" height="54">
</td>
<td width="3"></td>
</tr>
<tr>
<td colspan="3" height="3"></td>
</tr>
</table>
</td>
<!--酒官鸥 场-->
<!-- 闰祸 咯归 矫累 -->
<td bgcolor="#ffffff" width="3"></td>
<!-- 闰祸 咯归 场 -->
<!-- 郴侩 矫累 -->
<td valign="top">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2" height="3"></td>
</tr>
<tr>
<td width="4"></td>
<td>
<font color="#7c8889"><a href="<%=url_path%>/mypage/my_confirm.jsp?mphone=<%=mphone%>&gphone=0<%=re_phonenum%>"><%=re_name%></a></font>
<br>
<font color="#a2a2a2" size="3">(- <%=getTime(re_date)%>)</font>
</td>
</tr>
<tr>
<td width="4"></td>
<td>
<%=re_text%>
</td>
</tr>
</table>
</td>
<!-- 郴侩 场 -->
<td width="8"></td>
</tr>
<tr height="3">
<td width="54" bgcolor="#ffffff"></td>
<td width="3" bgcolor="#ffffff"></td>
<td></td>
<td width="8"></td>
</tr>
<tr height="2">
<td colspan="4"></td>
</tr>
<tr>
<!-- 滚瓢 父甸扁 矫累 -->
<td width="54" align="center">
<font color="#a2a2a2"><%=cnt%>
</font>
</td>
<td width="3"></td>
<td>
<table border="0" cellspacing="0" cellpadding="0">
<tr height="14">
<td><input type="hidden" name="re_idx" value="<%=re_idx%>" /></td>
<%if ((0+re_phonenum).equals(mphone)){%>
<td width="31" align="center" bgcolor="#ffffff">
<font color="#7c8889"><a href="<%=url_path%>/news/myQuizAnswerModify.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&idx=<%=idx%>&name=<%=name%>&re_idx=<%=re_idx%>&upFlag=<%=upFlag%>&click=0">荐沥</a>
</font>
</td>
<%}else if(!(0+re_phonenum).equals(phonenum)&& mphone.equals(gphone)&& upFlag.equals("0")){%>
<td width="31" align="center" bgcolor="#ffffff">
<font color="#7c8889"> <a href="<%=url_path%>/news/myQuizAnswerTakeUping.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&idx=<%=idx%>&name=<%=name%>&re_idx=<%=re_idx%>">盲琶
</a>
</font>
</td>
<%} %>
</tr>
</table>
</td>
<td width="8"></td>
<!-- 滚瓢 父甸扁 场 -->
</tr>
<tr height="2">
<td colspan="4"></td>
</tr>
</table>
</td>
</tr>
<!--咯归 矫累-->
<tr>
<td height="3"></td>
</tr>
<!--咯归 场-->
<!-- 馆汗 1 场 -->
<%
cnt --;
if(rs.isLast())
{ //盖 付瘤阜 饭内靛 老版快
break;
}
else
{
rs.next();
}
}
%>
<!-- 瘩臂焊扁 场 -->
<!--其捞瘤 傅农 矫累-->
<%
String[] szSplit2 = pagePathBottom(pageurl, dbcount, pageNUM, pagecount);
%>
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0" bgcolor="<%=pageBgColor %>">
<tr>
<td height="16">
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td></td>
<td width="21" align="center">
<%=szSplit2[0]%>
<font color="#676767" size="3"><%=szSplit2[1]%>
</font>
<%=szSplit2[2]%>
</td>
<%
String pageColor = "";
for(int i=1;i<6;i++)
{
if(pageNUM%10 == Integer.parseInt(szSplit2[i*3+1]))
pageColor = pageFontColorY;
else
pageColor = pageFontColorN;
%>
<td width="1" align="center">
<font color="<%=pageColor %>" size="3">|</font>
</td>
<td width="21" align="center">
<%=szSplit2[i*3]%>
<font color="<%=pageColor%>" size="3"><b><%=szSplit2[i*3+1]%>
</b>
</font>
<%=szSplit2[i*3+2]%>
</td>
<%
}
%>
<td width="21" align="center">
<%=szSplit2[18]%>
<font color="#676767" size="3"><%=szSplit2[19]%>
</font>
<%=szSplit2[20]%>
</td>
<td></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<!--其捞瘤 傅农 场-->
<%
}
%>
<!--咯归 矫累-->
<tr>
<td height="8"></td>
</tr>
<!--咯归 场-->
<!-- 滚瓢 矫累 -->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr height="16">
<td></td>
<%if(mphone.equals(gphone)){ %>
<td width="55" bgcolor="<%=mainBgColor%>" align="center">
<a href="<%=url_path%>/news/myQuizList.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>"><font color="#ffffff">倒酒啊扁</font></a>
</td>
<%}else{ %>
<td width="55" bgcolor="<%=mainBgColor%>" align="center">
<a href="<%=url_path%>/news/myQuizList.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>"><font color="#ffffff">柠令格废</font></a>
</td>
<%} %>
<td width="2"></td>
<td width="55" bgcolor="<%=mainBgColor%>" align="center">
<a href="<%=url_path%>/news/NewsMain.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>"><font color="#ffffff">迄乔春胶肺</font></a>
</td>
<td></td>
</tr>
</table>
</td>
</tr>
<!-- 滚瓢 场 -->
<!-- 咯归 矫累 -->
<tr height="11">
<td></td>
</tr>
<!-- 咯归 场 -->
<!--版肺钎矫 矫累-->
<%
String step1=url_path+"/main.jsp?mphone="+mphone+"&gphone="+gphone;//权
String step2=url_path+"/mypage/my_confirm.jsp?mphone="+mphone+"&gphone="+gphone;
String step3=url_path+"/news/NewsMain.jsp?mphone="+mphone+"&gphone="+gphone;
%>
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr height="15">
<td width="8" bgcolor="#BBC7C8"></td>
<td bgcolor="#DAE6E8">
<a href="<%=step1%>">权</a>>
<a href="<%=step2%>"><%=name%>狼迄乔</a>>
<a href="<%=step3%>">春胶</a>>柠令殿废
</td>
<td width="8" bgcolor="#BBC7C8"></td>
</tr>
</table>
</td>
</tr>
<!--版肺钎矫 场-->
</table>
<%@ include file="../newbottom.jsp"%>
</body>
</html>
<%
}
catch (Exception e)
{
System.out.println(e);
}
finally
{
if(rs != null) try{rs.close();}catch(Exception se){}
if(pageset != null) try{pageset.close();}catch(Exception se){}
if(pstmt != null) try{pstmt.close();}catch(Exception es){}
if(stmt != null) try{stmt.close();}catch(Exception es){}
if(con != null) try{con.close();}catch(Exception es){}
}
%>
<%!
public String getType(int input)
{
if(input == 1)
return new String("郴秒氢");
if(input == 2)
return new String("郴厚剐");
if(input == 3)
return new String("郴己氢");
else
return new String("扁鸥");
}
public String getTitle(String input,int type)
{
String strType = getType(type);
int typeLen = strType.length();
StringBuffer sb = new StringBuffer();
int length = input.length();
if(length > 20 && length <= 40)
return input.substring(0,19-typeLen) + "<br>" + input.substring(20-typeLen,length);
if(length > 40 && length <= 60)
return input.substring(0,19-typeLen) + "<br>" + input.substring(20-typeLen,39-typeLen) + "<br>" + input.substring(39-typeLen+1,length);
return input;
}
public String getText(String input)
{
String strPrintText = "";
for (int i = 1; i<=input.length();i++){
if (i % 20 == 0)
{
strPrintText = strPrintText + input.substring(i-1, i) + "<br>";
}
else
{
strPrintText = strPrintText + input.substring(i-1, i);
}
}
return strPrintText;
}
public static String splitLongWord(String String1, int int2)
{
if( String1 == null )
return null;
else
{
/* StringBuffer StringBuffer4 = new StringBuffer();
char charray[] = String1.toCharArray();
if(charray[0]<=0||charray[0]>=128)
{
for( int i = 1;i<=charray.length; i++ )
{
StringBuffer4.append( charray[i-1] );
if(i%int2==0)
{
StringBuffer4.append( "<br>" );
}
}*/
int int3 = String1.length();
StringBuffer StringBuffer4 = new StringBuffer();
int int5 = 0;
int int6;
for( int6 = 0; int6 < int3; ++int6 )
{
char char7 = String1.charAt( int6 );
StringBuffer4.append( char7 );
if( char7 == 32 )
int5 = 0;
else if( ++int5 > int2 )
{
StringBuffer4.append( "<br>" );
int5 = 0;
}
}
return StringBuffer4.toString();
}
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -