📄 researchresult.jsp
字号:
}else {
sql = sql +" , 0";
}
if (provisionNum == 5){
sql = sql +" , 1";
}else{
sql = sql +" , 0";
}
sql = sql +" , 0 ,0, getdate())";
pstmt = con.prepareStatement(sql);
pstmt.setLong(1,Long.parseLong(mphone));
pstmt.setString(2,strGuestNickName);
pstmt.setString(3,strTitle);
pstmt.executeUpdate();
pstmt.close();
/*--------------------------------------------------------------------------------------------------------------------------------------
* maxTitleIdx
---------------------------------------------------------------------------------------------------------------------------------------*/
sql = " SELECT max(idx) maxIdx FROM gt_NsResearch WITH (READUNCOMMITTED) WHERE phonenum="+Long.parseLong(gphone);
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if( rs.next() )
{
maxTitleIdx = rs.getInt("maxIdx");
titleIdx = maxTitleIdx;
}
rs.close();
pstmt.close();
if (provisionNum == 0){
response.sendRedirect("ResearchStart.jsp?mphone="+mphone+"&gphone="+gphone+"&titleIdx="+titleIdx);
}else {
/*--------------------------------------------------------------------------------------------------------------------------------------
* insert Host GT_NsResearchRe Info
---------------------------------------------------------------------------------------------------------------------------------------*/
sql = "INSERT INTO GT_NsResearchRe(phonenum, nickname, text, ref_idx,anser , takeFlag , regdate)"+
"VALUES(?,?,?,?,?,0,getdate())";
pstmt = con.prepareStatement(sql);
pstmt.setLong(1,Long.parseLong(mphone));
pstmt.setString(2,strGuestNickName);
pstmt.setString(3,researchText);
pstmt.setInt(4,maxTitleIdx);
pstmt.setInt(5,provisionNum);
pstmt.executeUpdate();
pstmt.close();
}
}
if (actionName.equals("placeTop")){
if(request.getParameter("re_titleIdx")!=null) re_titleIdx=Integer.parseInt(request.getParameter("re_titleIdx")); else re_titleIdx=0;
/*------------------------------------------------------------------------------------------------
* 盲琶篮 累磊狼 name 苞 phonenum 啊廉柯促
-------------------------------------------------------------------------------------------------*/
if(request.getParameter("re_phonenum")!=null) re_phonenum=request.getParameter("re_phonenum"); else re_phonenum="";
if(request.getParameter("re_name")!=null) re_name=java.net.URLDecoder.decode(makeKOR(request.getParameter("re_name"))); else re_name="";
/*------------------------------------------------------------------------------------------------
* 盲琶篮 NsResearch 惑怕甫 函版
-------------------------------------------------------------------------------------------------*/
sql = "UPDATE gt_NsResearch SET takeIdx = "+re_titleIdx+" WHERE idx="+titleIdx ;
pstmt = con.prepareStatement(sql);
pstmt.executeUpdate();
pstmt.close();
sql = "UPDATE gt_NsResearchRe SET takeFlag = 1 WHERE idx="+re_titleIdx ;
pstmt = con.prepareStatement(sql);
pstmt.executeUpdate();
pstmt.close();
/*------------------------------------------------------------------------------------------------
* GT_NsLevelSet 抛捞阂 俊辑 盲琶篮 累磊甫 粮犁 咯何
-------------------------------------------------------------------------------------------------*/
sql="SELECT idx FROM GT_NsLevelset WITH (READUNCOMMITTED) WHERE phonenum="+Long.parseLong(re_phonenum);
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if(rs.next())
{
id_check=rs.getInt(1);
}else{
id_check = 0;
}
if(id_check==0){
sql ="INSERT INTO GT_NsLevelSet(phonenum, nickname, point_take, point_hit , regdate)"+
"VALUES("+Long.parseLong(re_phonenum)+" , '"+re_name+"',0,0,getdate())";
pstmt = con.prepareStatement(sql);
pstmt.executeUpdate();
pstmt.close();
/*--------------------------------------------------------------------------------------------------------------------------------------
* upFlag Check
---------------------------------------------------------------------------------------------------------------------------------------*/
sql = " SELECT takeIdx FROM gt_NsResearch WITH (READUNCOMMITTED) WHERE idx="+titleIdx;
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if( rs.next() )
{
upFlag = rs.getInt("takeIdx");
}else{
upFlag = 0;
}
rs.close();
pstmt.close();
}
/*------------------------------------------------------------------------------------------------
* 盲琶篮 措函俊 累磊狼 盲琶痢荐 1肺 刘啊
-------------------------------------------------------------------------------------------------*/
sql = "UPDATE GT_NsLevelset SET point_take = point_take+2 WHERE phonenum ="+Long.parseLong(re_phonenum);
pstmt = con.prepareStatement(sql);
pstmt.executeUpdate();
pstmt.close();
response.sendRedirect("ResearchResult.jsp?mphone="+mphone+"&gphone="+gphone+"&titleIdx="+titleIdx+"&upFlag="+re_titleIdx);
}
if (actionName.equals("deleteResearchTitle")){
/*-------------------------------------------------------------------------------------------------
* gt_NsResearch && gt_NsResearchRe DELETE
--------------------------------------------------------------------------------------------------*/
sql = "DELETE FROM gt_NsResearchRe WHERE ref_idx ="+titleIdx ;
pstmt = con.prepareStatement(sql);
pstmt.executeUpdate();
pstmt.close();
sql = "DELETE FROM gt_NsResearch WHERE idx ="+titleIdx ;
pstmt = con.prepareStatement(sql);
pstmt.executeUpdate();
pstmt.close();
response.sendRedirect("ResearchList.jsp?mphone="+mphone+"&gphone="+gphone);
}
/*------------------------------------------------------------------------------------------------
* 炼雀荐 刘啊 1 /炼雀 痢荐 刘啊1
-------------------------------------------------------------------------------------------------*/
if(!mphone.equals(gphone)){
sql = "UPDATE gt_NsResearch SET seCnt = seCnt+1 WHERE idx= "+titleIdx ;
pstmt = con.prepareStatement(sql);
pstmt.executeUpdate();
pstmt.close();
sql="SELECT idx FROM GT_NsLevelset WITH (READUNCOMMITTED) WHERE phonenum="+Long.parseLong(gphone);
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if(rs.next()){
id_check = rs.getInt(1);
}else {
id_check = 0;
}
if(id_check == 0){
sql ="INSERT INTO GT_NsLevelSet(phonenum, nickname, point_take, point_hit , regdate)"+
"VALUES("+Long.parseLong(gphone)+" ,'"+strNickname+"',0,0,getdate())";
pstmt = con.prepareStatement(sql);
pstmt.executeUpdate();
pstmt.close();
}
sql = "UPDATE GT_NsLevelset SET point_hit = point_hit+1 WHERE phonenum ="+Long.parseLong(gphone);
pstmt = con.prepareStatement(sql);
pstmt.executeUpdate();
pstmt.close();
}
/*--------------------------------------------------------------------------------------------------------------------------------------
* provision info
---------------------------------------------------------------------------------------------------------------------------------------*/
sql = " SELECT TOP 1 NRe.anser,NRe.text, NRe.regdate FROM gt_NsResearch Nr WITH (READUNCOMMITTED), gt_NsResearchRe NRe WITH (READUNCOMMITTED) " ;
sql = sql + "WHERE Nr.idx=NRe.ref_idx AND NRe.phonenum="+Long.parseLong(mphone);
if ( !mphone.equals(gphone)){
sql = sql +" AND NRe.phonenum="+Long.parseLong(mphone) ;
}
sql = sql +" AND NRe.ref_idx="+titleIdx+" ORDER BY NRe.regdate desc ";
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if( rs.next() )
{
provisionNum = rs.getInt("anser");
researchText = rs.getString("text");
}
rs.close();
pstmt.close();
/*--------------------------------------------------------------------------------------------------------------------------------------
* Provision List
---------------------------------------------------------------------------------------------------------------------------------------*/
sql = "SELECT title,Provision1,Provision2,Provision3,Provision4,Provision5 ,(Provision1Cnt+Provision2Cnt+Provision3Cnt+Provision4Cnt+Provision5Cnt) reCount ,";
sql = sql + " Provision1Cnt,Provision2Cnt,Provision3Cnt,Provision4Cnt,Provision5Cnt ,maxProvisionCnt=(SELECT max(Provision1Cnt) FROM ( ";
sql = sql + "SELECT Provision1Cnt ";
sql = sql + "union all ";
sql = sql + "SELECT Provision2Cnt ";
sql = sql + "union all ";
sql = sql + "SELECT Provision3Cnt ";
sql = sql + "union all ";
sql = sql + "SELECT Provision4Cnt ";
sql = sql + "union all ";
sql = sql + "SELECT Provision5Cnt ";
sql = sql + ") tmp)FROM gt_NsResearch WITH (READUNCOMMITTED) WHERE idx="+titleIdx+" AND phonenum="+Long.parseLong(gphone);
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if( rs.next() )
{
strTitle = rs.getString("title");
reCount = rs.getInt("reCount");
maxProvisionCnt = rs.getInt("maxProvisionCnt");
if(null != strProvision1 || !"".equals(strProvision1)) strProvision1 = rs.getString("Provision1"); else strProvision1 = "";
if(null != strProvision2 || !"".equals(strProvision2)) strProvision2 = rs.getString("Provision2"); else strProvision2 = "";
if(null != strProvision3 || !"".equals(strProvision3)) strProvision3 = rs.getString("Provision3"); else strProvision3 = "";
if(null != strProvision4 || !"".equals(strProvision4)) strProvision4 = rs.getString("Provision4"); else strProvision4 = "";
if(null != strProvision5 || !"".equals(strProvision5)) strProvision5 = rs.getString("Provision5"); else strProvision5 = "";
provision1Cnt = rs.getInt("Provision1Cnt");
provision2Cnt = rs.getInt("Provision2Cnt");
provision3Cnt = rs.getInt("Provision3Cnt");
provision4Cnt = rs.getInt("Provision4Cnt");
provision5Cnt = rs.getInt("Provision5Cnt");
}
rs.close();
pstmt.close();
/*--------------------------------------------------------------------------------------------------------------------------------------
* Board Color Check
---------------------------------------------------------------------------------------------------------------------------------------*/
levelImgPath1 = img_path+"images/news/013.png";
levelImgPath2 = img_path+"images/news/013.png";
levelImgPath3 = img_path+"images/news/013.png";
levelImgPath4 = img_path+"images/news/013.png";
levelImgPath5 = img_path+"images/news/013.png";
linkBoardColor1 = titleFontColorY;
linkBoardColor2 = titleFontColorY;
linkBoardColor3 = titleFontColorY;
linkBoardColor4 = titleFontColorY;
linkBoardColor5 = titleFontColorY;
if ( provisionNum ==1){
strProvision = strProvision1;
linkBoardColor1 = "ffffff";
levelBoardColor1 = btnFontColor;
levelImgPath1 = img_path+"images/news/014.png";
}else if (provisionNum ==2){
strProvision = strProvision2;
linkBoardColor2 = "ffffff";
levelBoardColor2 = btnFontColor;
levelImgPath2 = img_path+"images/news/014.png";
}else if (provisionNum ==3){
strProvision = strProvision3;
linkBoardColor3 = "ffffff";
levelBoardColor3 = btnFontColor;
levelImgPath3 = img_path+"images/news/014.png";
}else if (provisionNum ==4){
strProvision = strProvision4;
linkBoardColor4 = "ffffff";
levelBoardColor4 = btnFontColor;
levelImgPath4 = img_path+"images/news/014.png";
}else if (provisionNum ==5){
strProvision = strProvision5;
linkBoardColor5 = "ffffff";
levelBoardColor5 = btnFontColor;
levelImgPath5 = img_path+"images/news/014.png";
}else if (provisionNum ==0){
strProvision = "";
linkBoardColor1 = titleFontColorY;
linkBoardColor2 = titleFontColorY;
linkBoardColor3 = titleFontColorY;
linkBoardColor4 = titleFontColorY;
linkBoardColor5 = titleFontColorY;
levelImgPath5 = img_path+"images/news/014.png";
}
/*--------------------------------------------------------------------------------------------------------------------------------------
* maxProvisionCntName && levelImgPath && maxProvisionCntNum Check
---------------------------------------------------------------------------------------------------------------------------------------*/
if(maxProvisionCnt == provision1Cnt){
maxProvisionCntName = strProvision1;
maxProvisionCntNum = 1 ;
}else if(maxProvisionCnt == provision2Cnt){
maxProvisionCntName = strProvision2;
maxProvisionCntNum = 2 ;
}else if(maxProvisionCnt == provision3Cnt){
maxProvisionCntName = strProvision3;
maxProvisionCntNum = 3 ;
}else if(maxProvisionCnt == provision4Cnt){
maxProvisionCntName = strProvision4;
maxProvisionCntNum = 4 ;
}else if(maxProvisionCnt == provision5Cnt){
maxProvisionCntName = strProvision5;
maxProvisionCntNum = 5 ;
}
if (returnBack ==1){
levelImgPath1 = img_path+"images/news/013.png";
levelImgPath2 = img_path+"images/news/013.png";
levelImgPath3 = img_path+"images/news/013.png";
levelImgPath4 = img_path+"images/news/013.png";
levelImgPath5 = img_path+"images/news/013.png";
linkBoardColor1 = titleFontColorY;
linkBoardColor2 = titleFontColorY;
linkBoardColor3 = titleFontColorY;
linkBoardColor4 = titleFontColorY;
linkBoardColor5 = titleFontColorY;
if ( maxProvisionCntNum ==1){
strProvision = strProvision1;
linkBoardColor1 = "ffffff";
levelBoardColor1 = btnFontColor;
levelImgPath1 = img_path+"images/news/014.png";
}else if (maxProvisionCntNum ==2){
strProvision = strProvision2;
linkBoardColor2 = "ffffff";
levelBoardColor2 = btnFontColor;
levelImgPath2 = img_path+"images/news/014.png";
}else if (maxProvisionCntNum ==3){
strProvision = strProvision3;
linkBoardColor3 = "ffffff";
levelBoardColor3 = btnFontColor;
levelImgPath3 = img_path+"images/news/014.png";
}else if (maxProvisionCntNum ==4){
strProvision = strProvision4;
linkBoardColor4 = "ffffff";
levelBoardColor4 = btnFontColor;
levelImgPath4 = img_path+"images/news/014.png";
}else if (maxProvisionCntNum ==5){
strProvision = strProvision5;
linkBoardColor5 = "ffffff";
levelBoardColor5 = btnFontColor;
levelImgPath5 = img_path+"images/news/014.png";
}else if (maxProvisionCntNum ==0){
strProvision = "";
linkBoardColor1 = titleFontColorY;
linkBoardColor2 = titleFontColorY;
linkBoardColor3 = titleFontColorY;
linkBoardColor4 = titleFontColorY;
linkBoardColor5 = titleFontColorY;
levelImgPath5 = img_path+"images/news/014.png";
}
}
%>
<html>
<head>
<title></title>
<link href="http://entaz.mugeta.com/client/mugeta_v2_test/web/user/mobile.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<!-- 鸥捞撇 矫累 -->
<tr>
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -