📄 researchresult.jsp.svn-base
字号:
<!--------------------------------------------------------------------------------------------------------------
*@霸烙皋牢
*@Author : zhou peng(2008-06-23)
--------------------------------------------------------------------------------------------------------------->
<%@ page import='java.io.*,java.text.*,java.util.Date,java.util.Vector, java.sql.*, com.entaz.lib.db.*, com.entaz.relay.net.*' contentType='text/html;charset=euc-kr'%>
<%@ include file="../imgpath.jsp"%>
<%@ include file="../common_func.jsp"%>
<%@ include file="formatUtil.jsp"%>
<%@ include file="../makeKOR.jsp"%>
<style type="text/css">
A:hover {
COLOR: #000000; TEXT-DECORATION: underline
}
A:link {
COLOR: #000000; TEXT-DECORATION: underline
}
A:visited {
COLOR: #000000; TEXT-DECORATION: underline
}
</style>
<%!
public static String isNull(String str)
{
if (str == null)
return "";
else
return str;
}
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();
}
}
%>
<%
/**
* @ version : 1.0.0
* @ author : zhou peng ( pengzhou@isoftstone.com )
* @ last modified : 2008-06-23
*/
/*------------------------------------------------------------------------------------------------------
+ 扁夯 颇扼固磐
-------------------------------------------------------------------------------------------------------*/
String mphone= request.getParameter("mphone");
String gphone= request.getParameter("gphone");
if(mphone == null){
mphone= "09900100081";
}
if(gphone == null){
gphone = mphone;
}
mphone = getStrPhone(getLong(mphone));
gphone = getStrPhone(getLong(gphone));
/*------------------------------------------------------------------------------------------------------
+ 傈开 函荐
-------------------------------------------------------------------------------------------------------*/
String sql = null;
String strNickname = null;
String strGuestNickName = null;
String strGuestPhoneNum = null;
String strText = null;
String guestPhone = null;
String strTitle = null;
int reCount = 0;
String regdate = null;
String strProvision1 = null;
String strProvision2 = null;
String strProvision3 = null;
String strProvision4 = null;
String strProvision5 = null;
int provision1Cnt = 0;
int provision2Cnt = 0;
int provision3Cnt = 0;
int provision4Cnt = 0;
int provision5Cnt = 0;
int provisionNum = 0;
int maxProvisionCnt = 0;
String maxProvisionCntName = null;
int maxProvisionCntNum = 0;
String levelImgPath1 = null;
String levelImgPath2 = null;
String levelImgPath3 = null;
String levelImgPath4 = null;
String levelImgPath5 = null;
String levelBoardColor1 = null;
String levelBoardColor2 = null;
String levelBoardColor3 = null;
String levelBoardColor4 = null;
String levelBoardColor5 = null;
String linkBoardColor1 = null;
String linkBoardColor2 = null;
String linkBoardColor3 = null;
String linkBoardColor4 = null;
String linkBoardColor5 = null;
int re_titleIdx = 0 ;
int maxTitleIdx = 0;
int lastTitleIdx = 0;
int nextTitleIdx = 0;
int myLastTitleIdx = 0;
int myNextTitleIdx = 0;
int lastTitleCnt = 0;
int nextTitleCnt = 0;
String lastTitle = null;
String nextTitle = null;
String actionName = null;
int id_check = 0;
String re_name = null;
String re_phonenum = null;
int upFlag = 0;
String placeTopColor = null;
int takeFlag = 0;
int returnBack = 0;
if(request.getParameter("returnBack")!=null) returnBack=Integer.parseInt(request.getParameter("returnBack")); else returnBack=0;
if(request.getParameter("actionName")!=null) actionName=request.getParameter("actionName"); else actionName="";
int titleIdx = 0;
if(request.getParameter("titleIdx")!=null) titleIdx=Integer.parseInt(request.getParameter("titleIdx")); else titleIdx=0;
String strProvision = null;
String researchText = null;
if(request.getParameter("upFlag")!=null) upFlag=Integer.parseInt(request.getParameter("upFlag")); else upFlag=0;
/*------------------------------------------------------------------------------------------------------
+ Page Split
-------------------------------------------------------------------------------------------------------*/
String pageurl = null;
// 其捞瘤 备泅 眠啊 函荐
int pagesize = 4; // 茄其捞瘤寸 10俺 免仿拱
// 傈开 函荐肺 急攫.. 其捞瘤 备泅 何盒俊 犁荤侩
int pageNUM = 1; // 其捞瘤 锅龋
int pagecount = 1 ; // 其捞瘤 肮荐 瘤沥 函荐
int absolutepage = 1; // 例措 困摹 其捞瘤 锅龋
int dbcount = 0; // DB 救俊 臂 肮荐 历厘 函荐
int isNoPage = 0; //茄俺档 绝蠢衬.. 绝栏搁0, 乐栏搁1
/*--------------------------------------------------------------------------------------------------------------------------------------------
+ DB 包访 函荐
---------------------------------------------------------------------------------------------------------------------------------------------*/
Connection con = null;
PreparedStatement pstmt = null;
Statement stmt = null;
ResultSet rs = null;
ResultSet pageset = null;
ResultSet rsDate = null;
try
{
/*--------------------------------------------------------------------------------------------------------------------------------------
* DB 目池记
---------------------------------------------------------------------------------------------------------------------------------------*/
%>
<%@ include file="../getConnection.jsp"%>
<%@ include file="bgColor.jsp"%>
<%
/*--------------------------------------------------------------------------------------------------------------------------------------
* Host nickName
---------------------------------------------------------------------------------------------------------------------------------------*/
sql = " SELECT nickname FROM GT_User_Info WITH (READUNCOMMITTED) WHERE phonenum='"+gphone+"'" ;
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if( rs.next() )
{
strNickname = rs.getString("nickname");
}else{
strNickname = "绝澜";
}
rs.close();
pstmt.close();
/*--------------------------------------------------------------------------------------------------------------------------------------
* Guest nickName
---------------------------------------------------------------------------------------------------------------------------------------*/
sql = " SELECT nickname FROM GT_User_Info WITH (READUNCOMMITTED) WHERE phonenum='"+mphone+"'" ;
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if( rs.next() )
{
strGuestNickName = rs.getString("nickname");
}else{
strGuestNickName = "";
}
rs.close();
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();
/*--------------------------------------------------------------------------------------------------------------------------------------
* Action Checked and Implement
---------------------------------------------------------------------------------------------------------------------------------------*/
if (actionName.equals("insertGuest")){
if(request.getParameter("provisionNum")!=null) provisionNum=Integer.parseInt(request.getParameter("provisionNum")); else provisionNum=0;
if(request.getParameter("researchText")!=null) researchText=java.net.URLDecoder.decode(makeKOR(request.getParameter("researchText"))); else researchText="";
/*--------------------------------------------------------------------------------------------------------------------------------------
* insert Guest 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,titleIdx);
pstmt.setInt(5,provisionNum);
pstmt.executeUpdate();
pstmt.close();
/*------------------------------------------------------------------------------------------------
* NsResearch ProvisionCnt Update
-------------------------------------------------------------------------------------------------*/
sql = "UPDATE gt_NsResearch SET Provision1Cnt =";
if(provisionNum == 1){
sql = sql +"Provision1Cnt+1 , ";
}else {
sql = sql +"Provision1Cnt+0 , ";
}
sql = sql +"Provision2Cnt =";
if (provisionNum == 2){
sql = sql +"Provision2Cnt+1 , ";
}else {
sql = sql +"Provision2Cnt+0 , ";
}
sql = sql + "Provision3Cnt =";
if (provisionNum == 3){
sql = sql +"Provision3Cnt+1 , ";
}else {
sql = sql +"Provision3Cnt+0 , ";
}
sql = sql +"Provision4Cnt =";
if (provisionNum == 4){
sql = sql +"Provision4Cnt+1 , ";
}else {
sql = sql +"Provision4Cnt+0 , ";
}
sql = sql +"Provision5Cnt =";
if (provisionNum == 5){
sql = sql +"Provision5Cnt+1 ";
}else{
sql = sql +"Provision5Cnt+0 ";
}
sql = sql + " WHERE idx="+titleIdx ;
pstmt = con.prepareStatement(sql);
pstmt.executeUpdate();
pstmt.close();
}
if (actionName.equals("insertHost")){
if(request.getParameter("strTitle")!=null) strTitle=java.net.URLDecoder.decode(makeKOR(request.getParameter("strTitle"))); else strTitle="";
if(request.getParameter("strProvision1")!=null) strProvision1=java.net.URLDecoder.decode(makeKOR(request.getParameter("strProvision1"))); else strProvision1="";
if(request.getParameter("strProvision2")!=null) strProvision2=java.net.URLDecoder.decode(makeKOR(request.getParameter("strProvision2"))); else strProvision2="";
if(request.getParameter("strProvision3")!=null) strProvision3=java.net.URLDecoder.decode(makeKOR(request.getParameter("strProvision3"))); else strProvision3="";
if(request.getParameter("strProvision4")!=null) strProvision4=java.net.URLDecoder.decode(makeKOR(request.getParameter("strProvision4"))); else strProvision4="";
if(request.getParameter("strProvision5")!=null) strProvision5=java.net.URLDecoder.decode(makeKOR(request.getParameter("strProvision5"))); else strProvision5="";
if(request.getParameter("provisionNum")!=null) provisionNum=Integer.parseInt(request.getParameter("provisionNum")); else provisionNum=0;
if(request.getParameter("researchText")!=null) researchText=java.net.URLDecoder.decode(makeKOR(request.getParameter("researchText"))); else researchText="";
/*--------------------------------------------------------------------------------------------------------------------------------------
* insert Host GT_NsResearch Info
---------------------------------------------------------------------------------------------------------------------------------------*/
sql = "INSERT INTO GT_NsResearch(phonenum, nickname, title ,Provision1 ,Provision2 ,Provision3 ,Provision4 ,Provision5 ,Provision1Cnt,Provision2Cnt,Provision3Cnt,Provision4Cnt,Provision5Cnt ,takeIdx ,seCnt ,regdate";
sql = sql +" ) VALUES(?,?,?";
if(null!=strProvision1 &&!strProvision1.equals("")){
sql = sql +" , '"+strProvision1+"'";
}else {
sql = sql +" , ''";
}
if (null!=strProvision2 &&!strProvision2.equals("")){
sql = sql +" , '"+strProvision2+"'";
}else {
sql = sql +" , ''";
}
if (null!=strProvision3 &&!strProvision3.equals("")){
sql = sql +" , '"+strProvision3+"'";
}else {
sql = sql +" , ''";
}
if (null!=strProvision4 &&!strProvision4.equals("")){
sql = sql +" , '"+strProvision4+"'";
}else {
sql = sql +" , ''";
}
if (null!=strProvision5 &&!strProvision5.equals("")){
sql = sql +" , '"+strProvision5+"'";
}else{
sql = sql +" , ''";
}
if(provisionNum == 1){
sql = sql +" , 1";
}else {
sql = sql +" , 0";
}
if (provisionNum == 2){
sql = sql +" , 1";
}else {
sql = sql +" , 0";
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -