📄 my_news_view_top_lhl.jsp
字号:
<%@ page language="java" pageEncoding="EUC-KR"%>
<%@ page import="java.io.*,java.text.*,java.util.Date,java.util.Vector, java.sql.*, com.entaz.lib.db.*, com.entaz.relay.net.* "%>
<%@ include file="../imgpath.jsp"%>
<%@ include file="appConstants.jsp"%>
<%@ include file="formatUtil.jsp"%>
<%@ include file="../common_func.jsp"%>
<%
int idxNsNews = Integer.parseInt(request.getParameter("idxNsNews"));
int idxNsNewsRE = Integer.parseInt(request.getParameter("idxNsNewsRE"));
String gphone = request.getParameter("gphone");
String mphone = request.getParameter("mphone");
Connection con = null;
PreparedStatement pstmt = null;
Statement stmt = null;
ResultSet rs = null;
ResultSet pageset = null;
// 其捞瘤 备泅 眠啊 函荐
int pagesize = 4; // 茄其捞瘤寸 10俺 免仿拱
// 傈开 函荐肺 急攫.. 其捞瘤 备泅 何盒俊 犁荤侩
int pageNUM=1; // 其捞瘤 锅龋
int pagecount=1 ; // 其捞瘤 肮荐 瘤沥 函荐
int absolutepage=1; // 例措 困摹 其捞瘤 锅龋
int dbcount=0 ; // DB 救俊 臂 肮荐 历厘 函荐
int isNoPage = 0; //茄俺档 绝蠢衬.. 绝栏搁0, 乐栏搁1
String pageurl = null;
String usernickname = "No name";
String bgColor = "";
String btnFColor = "";
try {
%>
<%@ include file="../getConnection.jsp"%>
<%@ include file="bgColor.jsp"%>
<%
btnFColor = btnFontColor;
String queryNsNewsREString = "SELECT * FROM GT_NsNewsRE WITH (READUNCOMMITTED) WHERE ref_idx=" + idxNsNews + " ORDER BY takeFlag DESC,regdate DESC";
String szCount = "SELECT count(phonenum) countNum from(SELECT * FROM GT_NsNewsRE WITH (READUNCOMMITTED) WHERE ref_idx=" + idxNsNews +") countNum";
stmt = con.createStatement();
pageset = stmt.executeQuery(szCount);
if(pageset.next()){
dbcount = pageset.getInt("countNum"); // 臂 醚 肮荐
pageset.close();
}
if(dbcount%pagesize == 0)
pagecount = dbcount/(pagesize); // 醚 其捞瘤荐 备窍扁
else
pagecount = dbcount/(pagesize)+1; // 醚 其捞瘤荐 备窍扁
if(request.getParameter("pageNUM")!=null)
{
pageNUM=Integer.parseInt(request.getParameter("pageNUM"));//瘤沥等 其捞瘤 焊咯林扁
absolutepage=(pageNUM-1)*pagesize+1;
}
String updateNsNewsString = "update gt_nsnews set takeId= ? where idx= ?";
pstmt = con.prepareStatement(updateNsNewsString);
pstmt.setInt(1, idxNsNewsRE);
pstmt.setInt(2, idxNsNews);
pstmt.executeUpdate();
String updateNsNewsREString = "update gt_nsnewsre set takeFlag= ? where idx= ?";
pstmt = con.prepareStatement(updateNsNewsREString);
pstmt.setInt(1, 1);
pstmt.setInt(2, idxNsNewsRE);
pstmt.executeUpdate();
String queryNsLevelSetString = "select * from gt_nslevelset WITH (READUNCOMMITTED) where phonenum=(select phonenum from gt_nsnewsre WITH (READUNCOMMITTED) where idx= ?)";
/////////////////////////
int nsLevelSetpoint_take = 0;
int idxNsLevelSet = 0;
////////////////////////
pstmt = con.prepareStatement(queryNsLevelSetString);
pstmt.setInt(1, idxNsNewsRE);
rs = pstmt.executeQuery();
while(rs.next())
{
idxNsLevelSet = rs.getInt("idx");
nsLevelSetpoint_take = rs.getInt("point_take");
}
if(idxNsLevelSet == 0)
{
String queryNsNewsREString1 = "select * from gt_nsnewsre WITH (READUNCOMMITTED) where idx= ?";
//////////////////////
long nsNewsREphonenum = 0;
String nsNewsREnickname = "";
//////////////////////
pstmt = con.prepareStatement(queryNsNewsREString1);
pstmt.setInt(1, idxNsNewsRE);
rs = pstmt.executeQuery();
while(rs.next())
{
nsNewsREphonenum = rs.getLong("phonenum");
nsNewsREnickname = rs.getString("nickname");
}
String insertNsLevelSetString = "insert into gt_nslevelset (phonenum,nickname,point_take,point_hit) values(?,?,?,?)";
pstmt = con.prepareStatement(insertNsLevelSetString);
pstmt.setLong(1, nsNewsREphonenum);
pstmt.setString(2, nsNewsREnickname);
pstmt.setInt(3, 1);
pstmt.setInt(4, 0);
pstmt.executeUpdate();
}
else
{
String updateNsLevelSetString = "update gt_nslevelset set point_take=? where phonenum=(select phonenum from gt_nsnewsre WITH (READUNCOMMITTED) where idx= ?)";
pstmt = con.prepareStatement(updateNsLevelSetString);
pstmt.setInt(1, nsLevelSetpoint_take+1);
pstmt.setInt(2, idxNsNewsRE);
pstmt.executeUpdate();
}
int kind = 0;
String title = "";
String text = "";
int reCnt = 0;
int hit = 0;
String regdate = "";
String queryNsNewsString = "select * from gt_nsnews WITH (READUNCOMMITTED) where idx= ?";
pstmt = con.prepareStatement(queryNsNewsString);
pstmt.setInt(1, idxNsNews);
rs = pstmt.executeQuery();
while(rs.next())
{
kind = rs.getInt("kind");
usernickname = rs.getString("nickname");
title = rs.getString("title");
text = rs.getString("text");
reCnt = rs.getInt("reCnt");
hit = rs.getInt("seCnt");
regdate = rs.getString("regdate");
}
%>
<html>
<head>
<title>My News View Top</title>
<link rel="stylesheet" href="../mobile.css" type="text/css"></link>
</head>
<body>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<!-- 鸥捞撇 矫累 -->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr height="19">
<td width="8" bgcolor="<%=mainBgColor%>"></td>
<td bgcolor="<%=mainBgColor%>"><font color="#ffffff">春胶</font></td>
</tr>
</table>
</td>
</tr>
<!-- 鸥捞撇 场 -->
<!-- 咯归 矫累 -->
<tr height="4">
<td></td>
</tr>
<!-- 咯归 场 -->
<!-- 冠胶 矫累 -->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0" bgcolor="<%=contentBgColor%>">
<tr height="6">
<td colspan="3"></td>
</tr>
<tr>
<td width="3"></td>
<td>
<font color="<%=btnFontColor%>">[<%= getType(kind) %>] </font>
<%= title %><font color="<%=btnFontColor%>"><b> [<%= reCnt %>]</b></font>
</td>
<td width="3"></td>
</tr>
<tr height="2">
<td colspan="3"></td>
</tr>
<tr>
<td width="3"></td>
<td align="right"><font color="#928279" size="3"> - <%= getTime(regdate) %> </font></td>
<td width="3"></td>
</tr>
<tr height="4">
<td colspan="3"></td>
</tr>
<tr>
<td width="3"></td>
<td bgcolor="#ffffff">
<table border="0" cellspacing="0" cellpadding="0">
<tr height="4">
<td colspan="3"></td>
</tr>
<tr>
<td width="4"></td>
<td>
<%= text %>
</td>
<td width="4"></td>
</tr>
<tr>
<td width="4"></td>
<td align="right"><font color="#7c8889" size="3">炼雀荐 <%= hit %></font></td>
<td width="4"></td>
</tr>
<tr height="4">
<td colspan="3"></td>
</tr>
</table>
</td>
<td width="3"></td>
</tr>
<tr height="3">
<td colspan="3"></td>
</tr>
<!-- 滚瓢 矫累 -->
<tr>
<td width="3"></td>
<td>
<table border="0" cellspacing="0" cellpadding="0">
<tr height="14">
<td></td>
<td width="55" bgcolor="#ffffff" align="center">
<a href="my_news_modify_lhl.jsp?idxNsNews=<%=idxNsNews%>&gphone=<%=gphone%>&mphone=<%=mphone%>"><font color="#ff4d72">荐沥/昏力</font></a>
</td>
<td width="2"></td>
<td width="55" bgcolor="#ffffff" align="center">
<a href="my_news_answer_lhl.jsp?idxNsNews=<%=idxNsNews%>&gphone=<%=gphone%>&mphone=<%=mphone%>"><font color="#ff4d72">瘩臂累己</font></a>
</td>
<td></td>
</tr>
</table>
</td>
<td width="3"></td>
</tr>
<!-- 滚瓢 场 -->
<tr height="3">
<td colspan="3"></td>
</tr>
</table>
</td>
</tr>
<!-- 冠胶 场 -->
<!--咯归 矫累-->
<tr>
<td height="10"></td>
</tr>
<!--咯归 场-->
<!--捞傈/促澜 傅农 冠胶 矫累-->
<%
pageurl = url_path+"/news/my_news_view_top_lhl.jsp?idxNsNews="+idxNsNews+"&idxNsNewsRE="+idxNsNewsRE+"&mphone="+mphone+"&gphone="+gphone;
String [] szSplit = pagePathTop(pageurl, dbcount, pageNUM, pagecount);
%>
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0" bgcolor="<%=pageBgColor %>">
<tr>
<td width="10"></td>
<td width="60" height="16" align="left">
<font color="#676767" size="3">⒏ </font>
<font color="<%=pageFNFontColor %>" size="3">(7)</font>
<%=szSplit[0]%>
<font color="<%=pageFNFontColor %>" size="3"><b>捞傈</b></font>
<%=szSplit[1]%>
</td>
<td></td>
<td width="60" align="right">
<%=szSplit[2]%>
<font color="<%=pageFNFontColor%>" size="3"><b>促澜</b></font>
<%=szSplit[3]%>
<font color="<%=pageFNFontColor%>" size="3">(9)</font>
<font color="#676767" size="3"> ⒑</font>
</td>
<td width="10"></td>
</tr>
</table>
</td>
</tr>
<!--捞傈/促澜 傅农 冠胶 场-->
<!--咯归 矫累-->
<tr>
<td height="3"></td>
</tr>
<!--咯归 场-->
<!-- 瘩臂焊扁 矫累 -->
<%
if(reCnt != 0)
{
%>
<tr height="19">
<td bgcolor="<%=btnFColor%>"><font color="#ffffff"> ″ 瘩臂焊扁</font></td>
</tr>
<%
}
%>
<%
stmt = con.createStatement();
rs = stmt.executeQuery(queryNsNewsREString);
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 nsNewsREidx = 0;
long nsNewsREphonenum = 0;
String nsNewsREnickname = "";
String nsNewsREtext = "";
String nsNewsREregdate = "";
int cnt = reCnt;
if(pageNUM == 1) {
cnt = reCnt;
} else {
cnt=reCnt-(pageNUM-1)*pagesize;
}
while(count<pagesize)
{
nsNewsREidx = rs.getInt("idx");
nsNewsREphonenum = rs.getLong("phonenum");
nsNewsREnickname = rs.getString("nickname");
nsNewsREtext = rs.getString("text");
nsNewsREregdate = rs.getString("regdate");
if(cnt == reCnt)
{
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -