📄 member_005flist_jsp.java
字号:
{
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/";
url_path = "/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 = "/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');
/**
* 공통 상수 정의
*
* @ version : 1.0.0
* @ author : realbeast ( realbeast@entaz.com )
* @ last modified : 2008-03-18
*/
/*------------------------------------------------------------------------------------------------
* 기본 컨텐츠 URL
-------------------------------------------------------------------------------------------------*/
String SYSTEM_USER_NUMBER = request.getParameter("mphone");
String SYSTEM_URL_HOME = url_path + "/main.jsp?mphone=" + SYSTEM_USER_NUMBER + "&gphone=" + SYSTEM_USER_NUMBER;
String SYSTEM_URL_ITEM_SHOP = url_path + "/itemShop/main.jsp?mphone=" + SYSTEM_USER_NUMBER + "&gphone=" + SYSTEM_USER_NUMBER;
String SYSTEM_URL_RECOMMEND = url_path + "/friendrecommend/friendrecommend1.jsp?mphone=" + SYSTEM_USER_NUMBER + "&gphone=" + SYSTEM_USER_NUMBER;
String SYSTEM_URL_AD = url_path + "/isuser_check.jsp?mphone=" + SYSTEM_USER_NUMBER + "&gphone=" + SYSTEM_USER_NUMBER;
String SYSTEM_URL_PHONEPY = url_path + "/mypage/my_confirm.jsp?mphone=" + SYSTEM_USER_NUMBER;
/*------------------------------------------------------------------------------------------------
* 관리자 ( 지기 ) 폰 번호
-------------------------------------------------------------------------------------------------*/
HashMap SYSTEM_ADMIN_PHONE = new HashMap();
SYSTEM_ADMIN_PHONE.put("Town", "01051737201"); // 타운지기
SYSTEM_ADMIN_PHONE.put("Cafe", "01051797201"); // 카페지기
SYSTEM_ADMIN_PHONE.put("Gong", "01051797201"); // 공감지기
SYSTEM_ADMIN_PHONE.put("Knowledge", "01051787201"); // 지식지기
SYSTEM_ADMIN_PHONE.put("Police", "01051767201"); // 신고지기
out.write('\r');
out.write('\n');
out.write('\r');
out.write('\n');
out.write('\r');
out.write('\n');
out.write("\r\n");
out.write("\r\n");
out.write("\r\n");
out.write("\r\n");
String URL_ITEMSHOP_VM = SYSTEM_URL_PATH + "/itemShop/DoItemShopVM.jsp?mphone=" + SYSTEM_USER_NUMBER + "&gphone=" + SYSTEM_USER_NUMBER;
String URL_ITEMSHOP_VM_CHECK = SYSTEM_URL_PATH + "/itemShop/DispItemCheck.jsp?mphone=" + SYSTEM_USER_NUMBER + "&gphone=" + SYSTEM_USER_NUMBER;
String URL_ITEMSHOP_CONTEST = SYSTEM_URL_PATH + "/itemShop/MovataContest_list.jsp?mphone=" + SYSTEM_USER_NUMBER + "&gphone=" + SYSTEM_USER_NUMBER;
String URL_ITEMSHOP_CONTEST_VIEW = SYSTEM_URL_PATH + "/itemShop/MovataContest_proc.jsp?type=hitUpdate&mphone=" + SYSTEM_USER_NUMBER + "&gphone=" + SYSTEM_USER_NUMBER;
String URL_ITEMSHOP_CONTEST_VIEW2 = SYSTEM_URL_PATH + "/itemShop/MovataContest_view.jsp?mphone=" + SYSTEM_USER_NUMBER + "&gphone=" + SYSTEM_USER_NUMBER;
String URL_ITEMSHOP_CONTEST_PROC = SYSTEM_URL_PATH + "/itemShop/MovataContest_proc.jsp";
String URL_ITEMSHOP_CONTEST_WRITE = SYSTEM_URL_PATH + "/itemShop/MovataContest_write.jsp?mphone=" + SYSTEM_USER_NUMBER + "&gphone=" + SYSTEM_USER_NUMBER;
String URL_ITEMSHOP_CONTEST_RE_WRITE = SYSTEM_URL_PATH + "/itemShop/MovataContest_replyWrite.jsp?mphone=" + SYSTEM_USER_NUMBER + "&gphone=" + SYSTEM_USER_NUMBER;
String URL_ITEMSHOP_CONTEST_DELETE = SYSTEM_URL_PATH + "/itemShop/MovataContest_confirm.jsp?mphone=" + SYSTEM_USER_NUMBER + "&gphone=" + SYSTEM_USER_NUMBER;
String URL_ITEMSHOP_CONTEST_ALERT_MESSAGE = SYSTEM_URL_PATH + "/itemShop/MovataContest_alert.jsp?mphone=" + SYSTEM_USER_NUMBER + "&gphone=" + SYSTEM_USER_NUMBER;
String URL_ITEMSHOP_COORDINATION = SYSTEM_URL_PATH + "/itemShop/MovataCoordination_list.jsp?mphone=" + SYSTEM_USER_NUMBER + "&gphone=" + SYSTEM_USER_NUMBER;
String URL_ITEMSHOP_COORDINATION_VIEW = SYSTEM_URL_PATH + "/itemShop/MovataCoordination_proc.jsp?type=hitUpdate&mphone=" + SYSTEM_USER_NUMBER + "&gphone=" + SYSTEM_USER_NUMBER;
String URL_ITEMSHOP_COORDINATION_VIEW2 = SYSTEM_URL_PATH + "/itemShop/MovataCoordination_view.jsp?mphone=" + SYSTEM_USER_NUMBER + "&gphone=" + SYSTEM_USER_NUMBER;
String URL_ITEMSHOP_COORDINATION_PROC = SYSTEM_URL_PATH + "/itemShop/MovataCoordination_proc.jsp";
String URL_ITEMSHOP_COORDINATION_WRITE = SYSTEM_URL_PATH + "/itemShop/MovataCoordination_write.jsp?mphone=" + SYSTEM_USER_NUMBER + "&gphone=" + SYSTEM_USER_NUMBER;
String URL_ITEMSHOP_COORDINATION_RE_WRITE = SYSTEM_URL_PATH + "/itemShop/MovataCoordination_replyWrite.jsp?mphone=" + SYSTEM_USER_NUMBER + "&gphone=" + SYSTEM_USER_NUMBER;
String URL_ITEMSHOP_COORDINATION_DELETE = SYSTEM_URL_PATH + "/itemShop/MovataCoordination_confirm.jsp?mphone=" + SYSTEM_USER_NUMBER + "&gphone=" + SYSTEM_USER_NUMBER;
String URL_ITEMSHOP_COORDINATION_ALERT_MESSAGE = SYSTEM_URL_PATH + "/itemShop/MovataCoordination_alert.jsp?mphone=" + SYSTEM_USER_NUMBER + "&gphone=" + SYSTEM_USER_NUMBER;
String URL_ITEMSHOP_HOT_ITEM = SYSTEM_URL_PATH + "/itemShop/DispItem.jsp?mphone=" + SYSTEM_USER_NUMBER + "&gphone=" + SYSTEM_USER_NUMBER;
String URL_ITEMSHOP_CLOVER_RANKING = SYSTEM_URL_PATH + "/itemShop/CloverRanking_list.jsp?mphone=" + SYSTEM_USER_NUMBER + "&gphone=" + SYSTEM_USER_NUMBER;
String URL_ITEMSHOP_CLOVER_RANKING_MESSAGE = SYSTEM_URL_PATH + "/itemShop/CloverRanking_Manage.jsp?mphone=" + SYSTEM_USER_NUMBER + "&gphone=" + SYSTEM_USER_NUMBER;
String URL_ITEMSHOP_MY = SYSTEM_URL_PATH + "/itemShop/MyItemShop.jsp?mphone=" + SYSTEM_USER_NUMBER + "&gphone=" + SYSTEM_USER_NUMBER;
String URL_ITEMSHOP_BUY_CONFIRM = SYSTEM_URL_PATH + "/itemShop/ItemBuy.jsp?mphone=" + SYSTEM_USER_NUMBER + "&gphone=" + SYSTEM_USER_NUMBER;
out.write('\r');
out.write('\n');
response.setHeader("cache-control", "no-cache");
response.setHeader("expires", "0");
response.setHeader("pragma", "no-cache");
out.write('\r');
out.write('\n');
/**
*
*
* @ version : 1.0.0
* @ author : chengwang ( chengwang@isoftstone.com )
* @ last modified : 2008-04-29
*/
/*------------------------------------------------------------------------------------------------------
+ ���蹂�����곗�������占� -------------------------------------------------------------------------------------------------------*/
String mphone = request.getParameter("mphone");
String gphone = request.getParameter("gphone");
String szCount = null;
String szQuery = null;
int nFriendCount = 0;
int nPaperCount = 0;
int nGuestBook = 0;
String[] rgstrFriendName = new String[3];
int[] rgiDiaryCount = new int[3];
String[] rgstrDiaryTitle = new String[5];
String[] rgstrLastVisit = new String[5];
String[] rgstrCoffeeTitle = new String[5];
String[] rgstrCoffeeTime = new String[5];
int[] rgiCoffeeCount = new int[5];
int[] rgiSex = new int[5];
String[] rgstrGuestName = new String[5];
String[] rgstrGuestTime = new String[5];
int nLongs = 0;
int nFriendLongs = 0;
int nDiaryLongs = 0;
int nVisitLongs = 0;
int nNewsLongs = 0;
int nIdx = 0;
int nCafeIdx = 0;
String strCafeName = null;
int nIssueIdx = 0;
String strIssueTitle = null;
int nNoticeIdx = 0;
String strNoticeTitle = null;
int[] rgiNewsKind = new int[6];
String[] rgstrNewsTitle = new String[6];
Connection con = null;
PreparedStatement pstmt = null;
Statement stmt = null;
ResultSet rs = null;
try {
/*------------------------------------------------------------------------------------------------
* DB 而ㅵ������ -------------------------------------------------------------------------------------------------*/
out.write('\r');
out.write('\n');
out.write(' ');
/**
* 무료게임타운 시스템점검 및 블랙유저 검출
*
* @ date ?8-01-21
* @ version 1.2.0
*/
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+"/17_members_view.jsp"+SYSTEM_PARAMETER_SET);
return;
}
}
// DB 연결이 되지 않을 때, 안내창으로 이동
//
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(' ');
/*------------------------------------------------------------------------------------------------
* 移����������껌 ����쎌�
-------------------------------------------------------------------------------------------------*/
szCount = " SELECT COUNT(friend_idx) AS fCount from GT_friend WHERE friend_flag=2 AND phonenum="
+ mphone;
pstmt = con.prepareStatement(szCount);
rs = pstmt.executeQuery();
if (rs.next()) {
nFriendCount = rs.getInt("fCount");
}
rs.close();
pstmt.close();
/*------------------------------------------------------------------------------------------------
* �������������� ����쎌�
-------------------------------------------------------------------------------------------------*/
szCount = " SELECT COUNT(paper_idx) AS pCount from GT_paper_recv WHERE "+
"paper_flag=1 AND paper_check_flag=2 and phonenum_my ="+ mphone;
pstmt = con.prepareStatement(szCount);
rs = pstmt.executeQuery();
if (rs.next()) {
nPaperCount = rs.getInt("pCount");
}
rs.close();
pstmt.close();
/*------------------------------------------------------------------------------------------------
* ��������� ������占썲����������占� -------------------------------------------------------------------------------------------------*/
szCount = " SELECT ranker_guestbook AS guBook FROM GT_ranker WHERE phonenum ="+ mphone;
pstmt = con.prepareStatement(szCount);
rs = pstmt.executeQuery();
if( rs.next() )
{
nGuestBook = rs.getInt("guBook");
}
rs.close();
pstmt.close();
/*------------------------------------------------------------------------------------------------
* 移�������������� ���源�� ���源��
-------------------------------------------------------------------------------------------------*/
szCount = " SELECT TOP 3 Max(r.news_idx),count(r.phonenum) as cnt,r.nickname as nickname,r.phonenum "+
" FROM GT_recentry AS r inner join GT_friend AS f on r.phonenum = CAST(f.guest_phone as bigint)"+
" WHERE r.news_flag=0 AND f.diary_flag = 1 and f.phonenum ="+ mphone+
" AND f.friend_flag=1 GROUP BY r.nickname,r.phonenum ORDER BY Max(r.news_idx) DESC ";
pstmt = con.prepareStatement(szCount);
rs = pstmt.executeQuery();
for(int i = 0 ; rs.next() ; i++){
rgstrFriendName[i] = rs.getString("nickname");
rgiDiaryCount[i] = rs.getInt("cnt");
nFriendLongs = i;
}
rs.close();
pstmt.close();
/*------------------------------------------------------------------------------------------------
* �������밴������렐�몄������ -------------------------------------------------------------------------------------------------*/
szCount = " SELECT TOP 4 diary_idx,phonenum_my,diary_title ,phonenum,last_visit from GT_diary "+
"WHERE diary_readflag=0 AND phonenum_my= "+ mphone;
pstmt = con.prepareStatement(szCount);
rs = pstmt.executeQuery();
for(int i = 0 ; rs.next() ; i++){
rgstrDiaryTitle[i] = rs.getString("diary_title");
rgstrLastVisit[i] = rs.getString("last_visit");
nDiaryLongs = i;
}
rs.close();
pstmt.close();
/*------------------------------------------------------------------------------------------------
* ��������������移닷������������源�� �����
-------------------------------------------------------------------------------------------------*/
szCount = " SELECT TOP 4 Max(r.news_idx),count(r.phonenum) AS cnt,r.nickname AS coffeetitle,Max(r.phonenum),"+
"Max(r.news_date)AS coffeetime,Max(r.content_idx),Max(r.cafebook_idx)AS coffeecount "+
" FROM GT_recentry_cafe AS r inner join GT_mycafe AS m on r.content_idx = m.cafe_idx "+
" WHERE m.phonenum2 = "+ mphone+ " AND m.mypageNew_flag = 1 AND r.news_flag=1 "+
" GROUP BY r.nickname ORDER BY Max(r.news_idx) DESC ";
pstmt = con.prepareStatement(szCount);
rs = pstmt.executeQuery();
for(int i = 0 ; rs.next() ; i++){
rgstrCoffeeTitle[i] = rs.getString("coffeetitle");
rgstrCoffeeTime[i] = rs.getString("coffeetime");
rgiCoffeeCount[i] = rs.getInt("coffeecount");
nLongs = i;
}
rs.close();
pstmt.close();
/*------------------------------------------------------------------------------------------------
* ���洹쇰�����������몄�������������占� -------------------------------------------------------------------------------------------------*/
szCount = "SELECT top 5 guest.guest_phone,uinfo.nickname AS name,guest.guest_date AS time,uinfo.face,"+
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -