📄 _23_005fmembers1_jsp.java.svn-base
字号:
{
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/";
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");
if (mphone == null) {
mphone = "01451697201";
}
String gphone = request.getParameter("gphone");
String szCount = null;
String szQuery = null;
int friendCount = 0;
int paperCount = 0;
int nguestBook = 0;
String[] friendName = new String[3];
int[] diaryCount = new int[3];
String[] diaryTitle = new String[5];
String[] lastVisit = new String[5];
String[] coffeeTitle = new String[5];
String[] coffeeTime = new String[5];
int[] coffeeCount = new int[5];
int[] sex = new int[5];
String[] guestName = new String[5];
String[] guestTime = new String[5];
int nlongs = 0;
int nidx = 0;
int ncafeIdx = 0;
String strcafeName = null;
int nissueIdx = 0;
String strissueTitle = null;
int nkthemaIdx = 0;
String strkthemaTitle = null;
int[] noticeKind = new int[6];
String[] strnoticeHead = new String[6];
Connection con = null;
PreparedStatement pstmt = null;
Statement stmt = null;
ResultSet rs = null;
try {
/*------------------------------------------------------------------------------------------------
* DB 커넥션
-------------------------------------------------------------------------------------------------*/
out.write('\r');
out.write('\n');
/**
* 무료게임타운 시스템점검 및 블랙유저 검출
*
* @ 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');
/*------------------------------------------------------------------------------------------------
* 친구신청 건수
-------------------------------------------------------------------------------------------------*/
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()) {
friendCount = 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()) {
paperCount = 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++){
System.out.println("i======================================"+i);
//System.out.println("rs.next()======================================"+rs.next());
friendName[i] = rs.getString("nickname");
diaryCount[i] = rs.getInt("cnt");
nlongs = i;
System.out.println("nlongs======================================"+nlongs);
}
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++){
diaryTitle[i] = rs.getString("diary_title");
lastVisit[i] = rs.getString("last_visit");
nlongs = 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++){
coffeeTitle[i] = rs.getString("coffeetitle");
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -