📄 main_jsp.java
字号:
/*------------------------------------------------------------------------------------------------
* 인기 아이템 가져오기
-------------------------------------------------------------------------------------------------*/
szQuery = "SELECT TOP "+nItemMax+" item_idx, item_price, item_name, item_sex FROM GT_item_step2 WHERE item_class != 5 AND item_flag = 1 ORDER BY item_hit,item_idx DESC";
pstmt = con.prepareStatement(szQuery);
rs = pstmt.executeQuery();
while( rs.next() )
{
aszItemName[nItemCount] = rs.getString("item_name");
anItemIdx[nItemCount] = rs.getInt("item_idx");
anItemPrice[nItemCount] = rs.getInt("item_price");
anItemSex[nItemCount] = rs.getInt("item_sex");
nItemCount++;
}
rs.close();
pstmt.close();
/*------------------------------------------------------------------------------------------------
* 인기짱 모바타
-------------------------------------------------------------------------------------------------*/
aszTitle[nBoardCount] = "인기짱 모바타";
aszURL[nBoardCount] = URL_ITEMSHOP_CONTEST + "&orderBy=hit";
szQuery = "SELECT TOP 1 B. *,((Year(getdate())+1)- age) as Ages FROM GT_MovataContest_TOP A INNER JOIN GT_MovataContest B ON A.refIdx = B.idx ORDER BY newid()";
pstmt = con.prepareStatement(szQuery);
rs = pstmt.executeQuery();
if( rs.next() )
{
anIdx[nBoardCount] = rs.getInt("idx");
aszNickName[nBoardCount] = rs.getString("nickname");
anAge[nBoardCount] = rs.getInt("Ages");
aszSubject [nBoardCount] = rs.getString("title");
aszPhoneNum[nBoardCount] = rs.getString("phonenum");
anPoint[nBoardCount] = rs.getInt("point");
anPurchase[nBoardCount] = rs.getInt("purchase");
anReplyCount[nBoardCount] = rs.getInt("replycnt");
anHit[nBoardCount] = rs.getInt("hit");
aRegDate[nBoardCount] = rs.getString("regdate");
aRegDate[nBoardCount] = replaceDateFormat( aRegDate[nBoardCount] , "MM/dd HH:mm" );
// 태그 및 개행 처리
//
aszSubject[nBoardCount] = replaceCRLFtoBR( aszSubject[nBoardCount] );
aszSubject[nBoardCount] = StrConvert( aszSubject[nBoardCount] );
// 폰번호 재조합
//
aszPhoneNum[nBoardCount] = makeFullUserNumber( aszPhoneNum[nBoardCount] );
}
rs.close();
pstmt.close();
nBoardCount++;
/*------------------------------------------------------------------------------------------------
* NEW 모바타
-------------------------------------------------------------------------------------------------*/
aszTitle[nBoardCount] = "NEW 모바타";
aszURL[nBoardCount] = URL_ITEMSHOP_CONTEST + "&orderBy=idx";
szQuery = "SELECT TOP 1 *,((Year(getdate())+1)- age) as Ages FROM GT_MovataContest ORDER BY idx DESC";
pstmt = con.prepareStatement(szQuery);
rs = pstmt.executeQuery();
if( rs.next() )
{
anIdx[nBoardCount] = rs.getInt("idx");
aszNickName[nBoardCount] = rs.getString("nickname");
anAge[nBoardCount] = rs.getInt("Ages");
aszSubject [nBoardCount] = rs.getString("title");
aszPhoneNum[nBoardCount] = rs.getString("phonenum");
anPoint[nBoardCount] = rs.getInt("point");
anPurchase[nBoardCount] = rs.getInt("purchase");
anReplyCount[nBoardCount] = rs.getInt("replycnt");
anHit[nBoardCount] = rs.getInt("hit");
aRegDate[nBoardCount] = rs.getString("regdate");
aRegDate[nBoardCount] = replaceDateFormat( aRegDate[nBoardCount] , "MM/dd HH:mm" );
// 태그 및 개행 처리
//
aszSubject[nBoardCount] = replaceCRLFtoBR( aszSubject[nBoardCount] );
aszSubject[nBoardCount] = StrConvert( aszSubject[nBoardCount] );
// 폰번호 재조합
//
aszPhoneNum[nBoardCount] = makeFullUserNumber( aszPhoneNum[nBoardCount] );
}
rs.close();
pstmt.close();
nBoardCount++;
/*------------------------------------------------------------------------------------------------
* 인기짱 코디네이터
-------------------------------------------------------------------------------------------------*/
aszTitle[nBoardCount] = "인기짱 코디네이터";
aszURL[nBoardCount] = URL_ITEMSHOP_COORDINATION + "&orderBy=hit";
szQuery = "SELECT TOP 1 B. *,((Year(getdate())+1)- age) as Ages FROM GT_MovataCoordination_TOP A INNER JOIN GT_MovataCoordination B ON A.refIdx = B.idx ORDER BY newid()";
pstmt = con.prepareStatement(szQuery);
rs = pstmt.executeQuery();
if( rs.next() )
{
anIdx[nBoardCount] = rs.getInt("idx");
aszNickName[nBoardCount] = rs.getString("nickname");
anAge[nBoardCount] = rs.getInt("Ages");
aszSubject [nBoardCount] = rs.getString("title");
aszPhoneNum[nBoardCount] = rs.getString("phonenum");
anPoint[nBoardCount] = rs.getInt("point");
anPurchase[nBoardCount] = rs.getInt("purchase");
anReplyCount[nBoardCount] = rs.getInt("replycnt");
anHit[nBoardCount] = rs.getInt("hit");
aRegDate[nBoardCount] = rs.getString("regdate");
aRegDate[nBoardCount] = replaceDateFormat( aRegDate[nBoardCount] , "MM/dd HH:mm" );
// 태그 및 개행 처리
//
aszSubject[nBoardCount] = replaceCRLFtoBR( aszSubject[nBoardCount] );
aszSubject[nBoardCount] = StrConvert( aszSubject[nBoardCount] );
// 폰번호 재조합
//
aszPhoneNum[nBoardCount] = makeFullUserNumber( aszPhoneNum[nBoardCount] );
}
rs.close();
pstmt.close();
nBoardCount++;
/*------------------------------------------------------------------------------------------------
* NEW 코디네이터
-------------------------------------------------------------------------------------------------*/
aszTitle[nBoardCount] = "신입 코디네이터";
aszURL[nBoardCount] = URL_ITEMSHOP_COORDINATION + "orderBy=idx";
szQuery = "SELECT TOP 1 *,((Year(getdate())+1)- age) as Ages FROM GT_MovataCoordination ORDER BY idx DESC";
pstmt = con.prepareStatement(szQuery);
rs = pstmt.executeQuery();
if( rs.next() )
{
anIdx[nBoardCount] = rs.getInt("idx");
aszNickName[nBoardCount] = rs.getString("nickname");
anAge[nBoardCount] = rs.getInt("Ages");
aszSubject [nBoardCount] = rs.getString("title");
aszPhoneNum[nBoardCount] = rs.getString("phonenum");
anPoint[nBoardCount] = rs.getInt("point");
anPurchase[nBoardCount] = rs.getInt("purchase");
anReplyCount[nBoardCount] = rs.getInt("replycnt");
anHit[nBoardCount] = rs.getInt("hit");
aRegDate[nBoardCount] = rs.getString("regdate");
aRegDate[nBoardCount] = replaceDateFormat( aRegDate[nBoardCount] , "MM/dd HH:mm" );
// 태그 및 개행 처리
//
aszSubject[nBoardCount] = replaceCRLFtoBR( aszSubject[nBoardCount] );
aszSubject[nBoardCount] = StrConvert( aszSubject[nBoardCount] );
// 폰번호 재조합
//
aszPhoneNum[nBoardCount] = makeFullUserNumber( aszPhoneNum[nBoardCount] );
}
rs.close();
pstmt.close();
con.close();
}
catch(Exception e)
{
throw e;
}
finally
{
if ( rs != null ) { try { rs.close(); } catch ( Exception e ) { } }
if ( stmt != null ) { try { stmt.close(); } catch ( Exception e ) { } }
if ( con != null ) { try { con.close(); } catch ( Exception e ) { } }
}
// QVGA HTML
//
if( isQVGA )
{
out.write("\r\n");
out.write("\r\n");
out.write("\r\n");
out.write("<html>\r\n");
out.write("<head>\r\n");
out.write("<link href=\"../mobile.css\" rel=\"stylesheet\" type=\"text/css\">\r\n");
out.write("</head>\r\n");
out.write("<body>\r\n");
out.write("\r\n");
out.write("<table width=\"240\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n");
out.write("<!--타이틀 이미지 시작-->\r\n");
out.write("\t<tr>\r\n");
out.write("\t\t<td align=\"center\">\r\n");
out.write("\t\t\t<img src=\"");
out.print(img_path);
out.write("images/itemshop/tit_1.png\" width=\"160\" height=\"30\">\r\n");
out.write("\t\t</td>\r\n");
out.write("\t</tr>\r\n");
out.write("<!--타이틀 이미지 끝-->\r\n");
out.write("\r\n");
out.write("<!--여백 시작-->\r\n");
out.write(" <tr>\r\n");
out.write(" <td height=\"5\"></td>\r\n");
out.write(" </tr>\r\n");
out.write("<!--여백 끝-->\r\n");
out.write("\r\n");
out.write(" <!--상단 리스트 시작-->\r\n");
out.write("\t<tr>\r\n");
out.write("\t\t<td align=\"center\" valign=\"middle\">\r\n");
out.write("\t\t\t<table width=\"150\" border=\"0\" align=\"center\">\r\n");
out.write("\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t\t<td width=\"30\"><img pictosrc=\"31\" src=\"");
out.print(img_path);
out.write("images/itemshop/icon_gametype_1.png\"></td>\r\n");
out.write("\t\t\t\t\t<td><a href=\"");
out.print(URL_ITEMSHOP_CONTEST_WRITE);
out.write("\"><font color=\"#5f6a6b\">제1회 모바타 콘테스트</font></a></td>\r\n");
out.write("\t\t\t\t</tr>\r\n");
out.write("\t\t\t</table>\r\n");
out.write("\t\t</td>\r\n");
out.write("\t</tr>\r\n");
out.write("\t\r\n");
out.write("\t<!--\r\n");
out.write("\t<tr>\r\n");
out.write("\t\t<td align=\"center\" valign=\"middle\">\r\n");
out.write("\t\t\t<table width=\"130\" border=\"0\" align=\"center\">\r\n");
out.write("\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t\t<td width=\"30\"><img pictosrc=\"31\" src=\"");
out.print(img_path);
out.write("images/itemshop/icon_gametype_1.png\"></td>\r\n");
out.write("\t\t\t\t\t<td><a href=\"#\"><font color=\"#5f6a6b\">이벤트 / 업데이트</font></a></td>\r\n");
out.write("\t\t\t\t</tr>\r\n");
out.write("\t\t\t</table>\r\n");
out.write("\t\t</td>\r\n");
out.write("\t</tr>\r\n");
out.write("\t-->\r\n");
out.write("\r\n");
out.write("\t<tr>\r\n");
out.write("\t\t<td align=\"center\"><font color=\"#ff9100\">★</font> <a href=\"");
out.print(URL_ITEMSHOP_MY);
out.write("\"><font color=\"#5f6a6b\">MY 모바타</font></a> <font color=\"#ff9100\">★</font></td>\r\n");
out.write("\t</tr>\r\n");
out.write("\r\n");
out.write("\t<tr>\r\n");
out.write("\t\t<td align=\"center\"><font color=\"#ff9100\">★</font> <a href=\"");
out.print(URL_ITEMSHOP_VM);
out.write("&type=1\"><font color=\"#5f6a6b\">아이템 구매</font></a> <font color=\"#ff9100\">★</font></td>\r\n");
out.write("\t</tr>\r\n");
out.write(" <!--상단 리스트 끝-->\r\n");
out.write("\r\n");
out.write(" <!--여백 시작-->\r\n");
out.write(" <tr>\r\n");
out.write(" <td height=\"8\"></td>\r\n");
out.write(" </tr>\r\n");
out.write("<!--여백 끝-->\r\n");
out.write("\r\n");
out.write("<!-- 0 - 인기 아이템 시작-->\r\n");
out.write(" <tr>\r\n");
out.write(" <td>\r\n");
out.write(" <table width=\"240\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n");
out.write("\t\t\t<tr height=\"17\">\r\n");
out.write("\t\t\t\t<td bgcolor=\"#ff9100\"> <b><font color=\"#ffe500\">:::</font> <font color=\"#ffffff\"> 인기아이템</font></b></td>\r\n");
out.write("\t\t\t</tr>\r\n");
out.write("\r\n");
out.write("\t\t\t<tr height=\"4\">\r\n");
out.write("\t\t\t\t<td bgcolor=\"#ffffff\"></td>\r\n");
out.write("\t\t\t</tr>\r\n");
out.write("\r\n");
out.write("\t\t\t<tr>\r\n");
out.write("\t\t\t\t<td align=\"center\">\r\n");
out.write("\t\t\t\t<table width=\"240\">\r\n");
out.write("\t\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t\t\t<td width=\"6\"></td>\r\n");
out.write("\t\t\t\t\t\t<td width=\"72\" align=\"center\"><font color=\"#ff4b5c\"><b>1위</b></font></td>\r\n");
out.write("\t\t\t\t\t\t<td width=\"6\"></td>\r\n");
out.write("\t\t\t\t\t\t<td width=\"72\" align=\"center\"><font color=\"#ff4b5c\"><b>2위</b></font></td>\r\n");
out.write("\t\t\t\t\t\t<td width=\"6\"></td>\r\n");
out.write("\t\t\t\t\t\t<td width=\"72\" align=\"center\"c><font color=\"#ff4b5c\"><b>3위</b></font></td>\r\n");
out.write("\t\t\t\t\t\t<td width=\"6\"></td>\r\n");
out.write("\t\t\t\t\t</tr>\r\n");
out.write("\r\n");
out.write("\t\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t\t\t<td colspan=\"7\" height=\"3\"></td>\r\n");
out.write("\t\t\t\t\t</tr>\r\n");
out.write("\r\n");
out.write("\t\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t\t\t<td height=\"72\" width=\"6\"></td>\r\n");
out.write("\t\t\t\t\t\t");
for ( int i = 0 ; i < nItemCount ; i++ )
{
out.write("\r\n");
out.write("\t\t\t\t\t\t<td width=\"72\">\r\n");
out.write("\t\t\t\t\t\t\t<table bgcolor=\"#bbc7c8\" cellspacing=\"0\" cellpadding=\"0\">\r\n");
out.write("\t\t\t\t\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t\t\t\t\t\t<td colspan=\"3\" height=\"2\"></td>\r\n");
out.write("\t\t\t\t\t\t\t\t</tr>\r\n");
out.write("\t\t\t\t\t\t\t\t\r\n");
out.write("\t\t\t\t\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t\t\t\t\t\t<td width=\"2\"></td>\r\n");
out.write("\t\t\t\t\t\t\t\t\t<td width=\"70\" height=\"70\">\r\n");
out.write("\t\t\t\t\t\t\t\t\t<a href=\"");
out.print(URL_ITEMSHOP_VM_CHECK);
out.write("&sex=");
out.print(anItemSex[i]);
out.write("&pageNUM=1&selectedIndex=");
out.print((i+1));
out.write("&selectedSex=0\">\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t<img src=\"");
out.print(ava_path);
out.write("display_item.jsp?item_idx=");
out.print(anItemIdx[i]);
out.write("\" border=\"0\">\r\n");
out.write("\t\t\t\t\t\t\t\t\t</a>\r\n");
out.write("\t\t\t\t\t\t\t\t\t</td>\r\n");
out.write("\t\t\t\t\t\t\t\t\t<td width=\"2\"></td>\r\n");
out.write("\t\t\t\t\t\t\t\t</tr>\r\n");
out.write("\r\n");
out.write("\t\t\t\t\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t\t\t\t\t\t<td colspan=\"3\" height=\"2\"></td>\r\n");
out.write("\t\t\t\t\t\t\t\t</tr>\r\n");
out.write("\t\t\t\t\t\t\t</table>\r\n");
out.write("\t\t\t\t\t\t</td>\r\n");
out.write("\t\t\t\t\t\t<td width=\"6\"></td>\r\n");
out.write("\t\t\t\t\t\t");
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -