📄 _30q_0026a_005fi_005fshow_jsp.java
字号:
String SYSTEM_MOVATA_CACHE_PATH = null;
/*------------------------------------------------------------------------------------------------
* 군별에 따른 Path 설정
-------------------------------------------------------------------------------------------------*/
if("".equals(SYSTEM_VM_TYPE) || "null".equals(SYSTEM_VM_TYPE) || SYSTEM_VM_TYPE == null)
{
SYSTEM_VM_TYPE = "";
}
if (
SYSTEM_VM_TYPE.equals("w2") || SYSTEM_VM_TYPE.equals("w3")|| SYSTEM_VM_TYPE.equals("w5")|| SYSTEM_VM_TYPE.equals("w8") ||
SYSTEM_VM_TYPE.equals("b2") || SYSTEM_VM_TYPE.equals("b3")|| SYSTEM_VM_TYPE.equals("b5")|| SYSTEM_VM_TYPE.equals("b8")
)
{
SYSTEM_VM_PATH = "web2";
isQVGA = false;
}
else if(
SYSTEM_VM_TYPE.equals("w4") || SYSTEM_VM_TYPE.equals("w6")|| SYSTEM_VM_TYPE.equals("w7")|| SYSTEM_VM_TYPE.equals("w9") ||
SYSTEM_VM_TYPE.equals("b4") || SYSTEM_VM_TYPE.equals("b6")|| SYSTEM_VM_TYPE.equals("b7")|| SYSTEM_VM_TYPE.equals("b9")
)
{
SYSTEM_VM_PATH = "web";
isQVGA = true;
}
else
{
String szPageURL = HttpUtils.getRequestURL(request).toString();
if( szPageURL.indexOf("web2") > -1 )
{
SYSTEM_VM_PATH = "web2";
isQVGA = false;
}
else
{
SYSTEM_VM_PATH = "web";
isQVGA = true;
}
szPageURL = null;
}
/*------------------------------------------------------------------------------------------------
* 변수설정
-------------------------------------------------------------------------------------------------*/
img_path = "/mugeta/client/mugeta_ODC/"+SYSTEM_VM_PATH+"/";
//ava_path = "http://localhost/client/mugeta_ODC_movata/web/user/itemcoordi/";
ava_path = "/mugeta/client/mugeta_ODC_movata/web/user/itemcoordi/";
url_path = "/mugeta/client/mugeta_ODC/"+SYSTEM_VM_PATH+"/user";
db_name = "mugeta";
ContentserverIP = "http://localhost";
SYSTEM_URL_PATH = "/client/mugeta_ODC/web/user";
SYSTEM_MOVATA_CACHE_PATH = "/mugeta/client/mugeta_ODC_movata/"+SYSTEM_VM_PATH+"/user";
SYSTEM_MOVATA_SERVER = new String[1];
SYSTEM_MOVATA_SERVER[0] = "localhost";
/*------------------------------------------------------------------------------------------------
* Movata Object Name
-------------------------------------------------------------------------------------------------*/
String SYSTEM_OBJECT_NAME = "mugeta";
out.write('\r');
out.write('\n');
out.write('\r');
out.write('\n');
out.write('\r');
out.write('\n');
out.write("<!-------------------------------------------------------------\r\n");
out.write("* @ name: appConstants.jsp\r\n");
out.write("* @ func: db(int) -- jsp(String)\r\n");
out.write("* @ Author : ranxu \r\n");
out.write("* @ date :2008-06-27\r\n");
out.write("-------------------------------------------------------------->\r\n");
out.write("\r\n");
out.write('\r');
out.write('\n');
out.write('\r');
out.write('\n');
out.write("<!-------------------------------------------------------------\r\n");
out.write("* @ name: formatUtil.jsp\r\n");
out.write("* @ Author : ranxu \r\n");
out.write("* @ date :2008-06-25\r\n");
out.write("-------------------------------------------------------------->\r\n");
out.write("\r\n");
out.write('\r');
out.write('\n');
out.write('\r');
out.write('\n');
out.write('\r');
out.write('\n');
out.write("\r\n");
out.write("<style type=\"text/css\"> \r\n");
out.write("A:hover {\r\n");
out.write(" COLOR: #000000; TEXT-DECORATION: underline\r\n");
out.write("}\r\n");
out.write("A:link {\r\n");
out.write(" COLOR: #000000; TEXT-DECORATION: underline\r\n");
out.write("}\r\n");
out.write("A:visited {\r\n");
out.write(" COLOR: #000000; TEXT-DECORATION: underline\r\n");
out.write("}\r\n");
out.write("</style> \r\n");
out.write('\r');
out.write('\n');
out.write(' ');
/*------------------------------------------------------------------------------------------------------
+ 기본 파라미터
-------------------------------------------------------------------------------------------------------*/
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));
/*------------------------------------------------------------------------------------------------------
+ 전역 변수
-------------------------------------------------------------------------------------------------------*/
int idx = 0;
int idx_previous = 0;
int idx_next = 0;
String date_previous = "";
String date_next = "";
int phonenum = 0;
String nickname = "";
int reCnt = 0;
String regdate = "";
int type = 0;
String questions[] = new String[30];
String answers[] = new String[30];
idx = Integer.parseInt(request.getParameter("idx"));
/*------------------------------------------------------------------------------------------------------
+ DB 관련 변수
-------------------------------------------------------------------------------------------------------*/
PreparedStatement pstmt = null;
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
String query1 = null;
String sql = null;
/*------------------------------------------------------------------------------------------------------
+ 날짜 관련
-------------------------------------------------------------------------------------------------------*/
Timestamp di_date = null;
Date today = new Date();
SimpleDateFormat timeform;
timeform = new SimpleDateFormat("MM/dd HH:mm");
try
{
/*------------------------------------------------------------------------------------------------
* DB 커넥션
-------------------------------------------------------------------------------------------------*/
out.write('\r');
out.write('\n');
out.write(' ');
String SYSTEM_PARAMETER_SET = "?mphone="+request.getParameter("mphone")+"&gphone="+request.getParameter("mphone");
String SYSTEM_PHONE_NUMBER = request.getParameter("mphone");
//
//
if(IS_SYSTEM_CHECK)
{
if( ! IS_TESTER_MODE )
{
response.sendRedirect(url_path+"/system_notice.jsp"+SYSTEM_PARAMETER_SET);
return;
}
}
//
//
con = com.entaz.lib.db.DBConnector.getConnection("mugeta");
if( con == null )
{
response.sendRedirect(url_path+"/system_notice2.jsp"+SYSTEM_PARAMETER_SET);
return;
}
//
//
if( IS_TESTER_MODE )
{
boolean isTester = com.entaz.lib.db.DBConnector.chkTester( con, SYSTEM_PHONE_NUMBER );
if( ! isTester )
{
response.sendRedirect(url_path+"/system_notice.jsp"+SYSTEM_PARAMETER_SET);
return;
}
}
//
//
boolean isBlackUser = com.entaz.lib.db.DBConnector.chkBlackList( con, SYSTEM_PHONE_NUMBER );
if( isBlackUser )
{
response.sendRedirect(url_path+"/bad_member.jsp"+SYSTEM_PARAMETER_SET);
return;
}
out.write('\r');
out.write('\n');
out.write(' ');
out.write("<!-------------------------------------------------------------\r\n");
out.write("* @ name: bgColor.jsp\r\n");
out.write("* @ func: Change the background color by level\r\n");
out.write("\t\t give prize to user who get the right level \r\n");
out.write("* @ Author : ranxu \r\n");
out.write("* @ date :2008-06-27\r\n");
out.write("-------------------------------------------------------------->\r\n");
String bgSql = "";
String prizeSql = "";
long cumulatedExpNow = 0;
long cumulatedExp = 0;
int point_take = 0;
int point_hit = 0;
int level = 0;
int neededExp = 0;
String mainBgColor = "#ffb9b3"; //zhu ye mian bei jing yan se
String mainBgColorName = "";
String mainFontColor = "";
String contentBgColor = "";
String titleColor = ""; //biao ti lan
String titleFontColorY = ""; //wei xuan zhong
String pageBgColor = "";
String pageFNFontColor = "";
String pageFontColorY = "";
String pageFontColorN = "";
String partitionColor = "";
String btnFontColor = "";
int prize = 0;
int re = -1;
/*------------------------------------------------------------------------------------------------
* SELECT point_take and point_hit in order to get now cumulated Experence
-------------------------------------------------------------------------------------------------*/
bgSql = " SELECT point_take,point_hit FROM gt_nslevelset WHERE phonenum=?";
pstmt = con.prepareStatement(bgSql);
pstmt.setLong(1,getLong(gphone));
rs = pstmt.executeQuery();
while(rs.next()){
point_take = rs.getInt("point_take");
point_hit = rs.getInt("point_hit");
}
rs.close();
pstmt.close();
//get now cumulated Experence
cumulatedExpNow = point_take*2+point_hit*1;
/*------------------------------------------------------------------------------------------------
* get the user's level , bgcolor and so on
-------------------------------------------------------------------------------------------------*/
bgSql=" SELECT TOP 1 * FROM gt_nslevel WHERE cumulatedExp<=? ORDER BY cumulatedExp DESC";
//bgSql="SELECT top 1 * FROM gt_nslevel WHERE cumulatedExp>=? ";
pstmt = con.prepareStatement(bgSql);
pstmt.setLong(1,cumulatedExpNow);
rs = pstmt.executeQuery();
while(rs.next()){
level = rs.getInt("level");
neededExp = rs.getInt("neededExp");
cumulatedExp = rs.getInt("cumulatedExp");
mainBgColor=rs.getString("mainBgColor");
mainBgColorName=rs.getString("mainBgColorName");
mainFontColor=rs.getString("mainFontColor");
contentBgColor=rs.getString("contentBgColor");
titleColor=rs.getString("titleColor");
titleFontColorY=rs.getString("titleFontColorY");
pageBgColor=rs.getString("pageBgColor");
pageFNFontColor=rs.getString("pageFNFontColor");
pageFontColorY=rs.getString("pageFontColorY");
pageFontColorN=rs.getString("pageFontColorN");
partitionColor=rs.getString("partitionColor");
btnFontColor=rs.getString("btnFontColor");
prize = rs.getInt("prize");
}
rs.close();
pstmt.close();
/*------------------------------------------------------------------------------------------------
* give prize to user when he got the right level
-------------------------------------------------------------------------------------------------*/
if(prize!=0){
prizeSql="SELECT * FROM gt_moneybook WHERE phonenum=? AND moneybook_flag=? AND moneybook_clover=?";
pstmt=con.prepareStatement(prizeSql);
pstmt.setLong(1,getLong(gphone));
pstmt.setInt(2,1);
pstmt.setLong(3,prize);
rs = pstmt.executeQuery();
if(rs.next()){
}else{
prizeSql="EXEC gt_money_input ?,?,?";
pstmt = con.prepareStatement(prizeSql);
pstmt.setLong(1,getLong(gphone));
pstmt.setString(2,"");
pstmt.setLong(3,prize);
re = pstmt.executeUpdate();
if(re == -1){
return;
}
pstmt.close();
}
rs.close();
pstmt.close();
}
out.write('\r');
out.write('\n');
out.write(' ');
/*------------------------------------------------------------------------------------------------
* getnickname
-------------------------------------------------------------------------------------------------*/
sql = " SELECT nickname FROM GT_User_Info WITH (READUNCOMMITTED) WHERE phonenum='"+gphone+"'" ;
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if( rs.next() )
{
nickname = rs.getString("nickname");
}else{
nickname = "없음";
}
rs.close();
pstmt.close();
/**************************************
search previous idx by idx!
***************************************/
stmt = con.createStatement();
query1 = " SELECT TOP 1 idx,regdate FROM GT_Ns30question WITH (READUNCOMMITTED) WHERE idx<'"+idx+"' AND phonenum='"+gphone+"' ORDER BY regdate DESC";
rs = stmt.executeQuery(query1);
if(rs.next()){
idx_previous = rs.getInt("idx");
date_previous = formatDate((Date)rs.getTimestamp("regdate"),"MM/dd");
}
if(rs != null) rs.close();
/**************************************
search next idx by idx!
***************************************/
stmt = con.createStatement();
query1 = " SELECT TOP 1 idx,regdate FROM GT_Ns30question WITH (READUNCOMMITTED) WHERE idx>'"+idx+"' AND phonenum='"+gphone+"' ORDER BY regdate ASC";
rs=stmt.executeQuery(query1);
if(rs.next()){
idx_next = rs.getInt("idx");
date_next = formatDate((Date)rs.getTimestamp("regdate"),"MM/dd");
}
if(rs != null) rs.close();
/**************************************
스타와 맞춰보는 러브운세!
***************************************/
stmt = con.createStatement();
query1=" SELECT * FROM GT_Ns30question WITH (READUNCOMMITTED) WHERE idx = '"+idx+"'";
rs=stmt.executeQuery(query1);
if(rs.next()){
idx = rs.getInt("idx");
phonenum = rs.getInt("phonenum");
reCnt = rs.getInt("reCnt");
type = rs.getInt("type");
questions[0] = rs.getString("question1");
questions[1] = rs.getString("question2");
questions[2] = rs.getString("question3");
questions[3] = rs.getString("question4");
questions[4] = rs.getString("question5");
questions[5] = rs.getString("question6");
questions[6] = rs.getString("question7");
questions[7] = rs.getString("question8");
questions[8] = rs.getString("question9");
questions[9] = rs.getString("question10");
questions[10] = rs.getString("question11");
questions[11] = rs.getString("question12");
questions[12] = rs.getString("question13");
questions[13] = rs.getString("question14");
questions[14] = rs.getString("question15");
questions[15] = rs.getString("question16");
questions[16] = rs.getString("question17");
questions[17] = rs.getString("question18");
questions[18] = rs.getString("question19");
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -