📄 myquizview.jsp.svn-base
字号:
/*------------------------------------------------------------------------------------------------
* 柠令 狼 瘩臂 LIST
-------------------------------------------------------------------------------------------------*/
sql1 = "SELECT r.idx AS re_idx,r.phonenum AS re_phonenum,r.nickname AS re_name,r.text AS re_text,"
+ "r.ref_idx,r.takeFlag AS flag,r.regdate AS re_date ,q.idx ,q.phonenum "
+ " FROM GT_NsQuiz AS q WITH (READUNCOMMITTED) LEFT JOIN GT_NsQuizRe AS r WITH (READUNCOMMITTED) ON q.idx =r.ref_idx "
+ " WHERE q.idx = " + idx;
sql2 = " ORDER BY r.takeFlag DESC, r.regdate DESC";
sql3 = " ORDER BY r.regdate DESC";
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="240" 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 height="20">
<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>
<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="15">
<td><input type="hidden" name="re_idx" value="<%=re_idx%>" /></td>
<%
if ((0 + re_phonenum).equals(mphone)) {
%>
<td width="30" 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="30" 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="240" border="0" cellspacing="0" cellpadding="0" bgcolor="<%=pageBgColor %>">
<tr>
<td height="19">
<table width="240" 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="240" border="0" cellspacing="0" cellpadding="0">
<tr height="17">
<td></td>
<%if(mphone.equals(gphone)){ %>
<td width="60" bgcolor="<%=mainBgColor%>" align="center">
<a href="<%=url_path%>/news/myQuizList.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>"><font color="#ffffff">倒酒啊扁</font></a>
</td>
<%}else{ %>
<td width="60" 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="60" 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="240" border="0" cellspacing="0" cellpadding="0">
<tr height="19">
<td width="10" bgcolor="#BBC7C8"></td>
<td bgcolor="#DAE6E8">
<a href="<%=step1%>">权</a>>
<a href="<%=step2%>"><%=name%>丛狼迄乔</a>>
<a href="<%=step3%>">春胶</a>>柠令
</td>
<td width="10" 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
{
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 + -