📄 _24_005fnotmembers_jsp.java
字号:
String gphone = request.getParameter("gphone");
/**TEST */
if(mphone==null)
{
mphone = "1";
}
int idx = 0;
int cafeIdx =0;
String cafeName = null;
int issueIdx =0;
String issueTitle = null;
int kthemaIdx =0;
String kthemaTitle = null;
String szCount = null;
String szQuery = null;
Connection con = null;
PreparedStatement pstmt = null;
Statement stmt = null;
ResultSet rs = null;
try
{
/*------------------------------------------------------------------------------------------------
* DB 커넥션
-------------------------------------------------------------------------------------------------*/
/**
* 무료게임타운 시스템점검 및 블랙유저 검출
*
* @ 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;
}
/*------------------------------------------------------------------------------------------------
* 타운 카페
-------------------------------------------------------------------------------------------------*/
szCount = " SELECT top 1 idx from GT_t_1 where flag = 5 ORDER BY newid()";
pstmt = con.prepareStatement(szCount);
rs = pstmt.executeQuery();
if( rs.next() )
{
idx = rs.getInt("idx");
szQuery ="SELECT cafe_idx,cafe_name FROM GT_cafe WHERE cafe_idx = "+idx;
}
else
{
szQuery ="SELECT top 1 cafe_idx,cafe_name FROM GT_cafe ORDER BY cafe_idx DESC";
}
pstmt = con.prepareStatement(szQuery);
rs = pstmt.executeQuery();
if( rs.next() )
{
cafeIdx = rs.getInt("cafe_idx");
cafeName = rs.getString("cafe_name");
}
rs.close();
pstmt.close();
/*------------------------------------------------------------------------------------------------
* 타운 공감
-------------------------------------------------------------------------------------------------*/
szCount = "SELECT top 1 idx from GT_t_1 where flag = 4 ORDER BY newid()";
pstmt = con.prepareStatement(szCount);
rs = pstmt.executeQuery();
if( rs.next() )
{
idx = rs.getInt("idx");
szQuery ="SELECT issue_title,issue_idx FROM GT_issue WHERE issue_idx = "+idx;
}
else
{
szQuery ="SELECT top 1 issue_title,issue_idx FROM GT_issue order BY issue_idx DESC";
}
pstmt = con.prepareStatement(szQuery);
rs = pstmt.executeQuery();
if( rs.next() )
{
issueIdx = rs.getInt("issue_idx");
issueTitle = rs.getString("issue_title");
}
rs.close();
pstmt.close();
/*------------------------------------------------------------------------------------------------
* 타운 광장
-------------------------------------------------------------------------------------------------*/
szCount = "SELECT top 1 idx FROM GT_t_1 WHERE flag = 1 OR flag = 2 ORDER BY newid()";
pstmt = con.prepareStatement(szCount);
rs = pstmt.executeQuery();
if( rs.next() )
{
idx = rs.getInt("idx");
szQuery ="SELECT kthema_idx,kthema_title,phonenum FROM GT_kthema WHERE kthema_idx="+idx;
}
else
{
szQuery ="SELECT top 1 kthema_idx,kthema_title,phonenum FROM GT_kthema ORDER BY kthema_idx DESC";
}
pstmt = con.prepareStatement(szQuery);
rs = pstmt.executeQuery();
if( rs.next() )
{
kthemaIdx = rs.getInt("kthema_idx");
kthemaTitle = rs.getString("kthema_title");
}
rs.close();
pstmt.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 ) { } }
}
out.write("\r\n");
out.write("\r\n");
out.write("\r\n");
out.write("<html>\r\n");
out.write("<body bgcolor=\"#FFFFFF\">\r\n");
out.write("\r\n");
out.write("<!--��낯臾�-->\r\n");
out.write("<table width=\"228\" height=\"65\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\">\r\n");
out.write("\t<tr valign=\"top\" >\r\n");
out.write("\t\t<td>\r\n");
out.write("\t\t\t\r\n");
out.write("\t\t\t<table width=\"228\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n");
out.write("\t\t\t\t<tr height=\"2\">\r\n");
out.write("\t\t\t\t\t<td></td>\r\n");
out.write("\t\t\t\t</tr>\r\n");
out.write("\r\n");
out.write("\t\t\t\t<!--����댁뭅����� -->\r\n");
out.write("\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t\t<td><img src=\"http://entaz.mugeta.com/client/FTP_Working_Folder/web/images/main/bu_06.png\" pictosrc=\"8\"> <a href=\"#\"><font color=\"#FC3F4E\"><b>[���移댄�]</b></font></a> ");
out.print(cafeName );
out.write("</td>\r\n");
out.write("\t\t\t\t</tr>\r\n");
out.write("\t\t\t\t<!--����댁뭅����->\r\n");
out.write("\r\n");
out.write("\t\t\t\t<tr height=\"4\">\r\n");
out.write("\t\t\t\t\t<td></td>\r\n");
out.write("\t\t\t\t</tr>\r\n");
out.write("\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t\t<td width=\"228\" height=\"1\" background=\"http://entaz.mugeta.com/client/FTP_Working_Folder/web/images/main/dot_01.png\"></td>\r\n");
out.write("\t\t\t\t</tr>\r\n");
out.write("\t\t\t\t<tr height=\"4\">\r\n");
out.write("\t\t\t\t\t<td></td>\r\n");
out.write("\t\t\t\t</tr>\r\n");
out.write("\r\n");
out.write("\t\t\t\t<!--����닿났媛���� -->\r\n");
out.write("\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t\t<td><img src=\"http://entaz.mugeta.com/client/FTP_Working_Folder/web/images/main/bu_03.png\" pictosrc=\"5\"> <a href=\"#\"><font color=\"#B160FA\"><b>[���怨듦�]</b></font></a> ");
out.print(issueTitle );
out.write("</td>\r\n");
out.write("\t\t\t\t</tr>\r\n");
out.write("\t\t\t\t<!--����닿났媛���->\r\n");
out.write("\r\n");
out.write("\t\t\t\t<tr height=\"4\">\r\n");
out.write("\t\t\t\t\t<td></td>\r\n");
out.write("\t\t\t\t</tr>\r\n");
out.write("\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t\t<td width=\"228\" height=\"1\" background=\"http://entaz.mugeta.com/client/FTP_Working_Folder/web/images/main/dot_01.png\"></td>\r\n");
out.write("\t\t\t\t</tr>\r\n");
out.write("\t\t\t\t<tr height=\"4\">\r\n");
out.write("\t\t\t\t\t<td></td>\r\n");
out.write("\t\t\t\t</tr>\r\n");
out.write("\r\n");
out.write("\t\t\t\t<!--����������� -->\r\n");
out.write("\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t\t<td><img src=\"http://entaz.mugeta.com/client/FTP_Working_Folder/web/images/main/bu_02.png\" pictosrc=\"4\"> <a href=\"#\"><font color=\"#FC3F4E\"><b>[吏��愿��]</b></font></a> ");
out.print(kthemaTitle );
out.write("</td>\r\n");
out.write("\t\t\t\t</tr>\r\n");
out.write("\t\t\t\t<!--����������->\r\n");
out.write("\t\t\t</table>\t\t\t\r\n");
out.write("\r\n");
out.write("\t\t</td>\r\n");
out.write("\t</tr>\r\n");
out.write("</table>\r\n");
out.write("<!--��낯臾�-->\r\n");
out.write("\r\n");
out.write("\r\n");
out.write("\r\n");
out.write("</body>\r\n");
out.write("</html>\r\n");
out.write("\r\n");
out.write(" \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("<!--��� NEW ���-->\r\n");
out.write(" <tr>\r\n");
out.write(" <td align=\"center\">\r\n");
out.write(" <table width=\"226\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n");
out.write(" <tr> \r\n");
out.write(" \t\t\t\t<td width=\"226\" height=\"17\" bgcolor=\"#FCF768\" align=\"center\"><font color=\"#FF8919\"><b>��� NEW !</b></font></td>\r\n");
out.write(" \t\t\t\t\r\n");
out.write(" \t </tr>\r\n");
out.write("\t\t <tr height=\"3\">\r\n");
out.write("\t\t\t\t<td></td>\r\n");
out.write("\t\t\t</tr>\r\n");
out.write("\t\t\t<tr>\r\n");
out.write("\t\t\t\t<td><a href=\"#\"><font color=\"#FB9B00\">[���移댄�]</font></a> �밸━��諛고�</td>\r\n");
out.write("\t\t\t</tr>\r\n");
out.write("\t\t\t<tr height=\"3\">\r\n");
out.write("\t\t\t\t<td></td>\r\n");
out.write("\t\t\t</tr>\r\n");
out.write("\t\t\t<tr>\r\n");
out.write("\t\t\t\t<td width=\"226\" height=\"1\" background=\"http://entaz.mugeta.com/client/FTP_Working_Folder/web/images/main/dot_01.png\"></td>\r\n");
out.write("\t\t\t</tr>\r\n");
out.write("\t\t\t<tr height=\"3\">\r\n");
out.write("\t\t\t\t<td></td>\r\n");
out.write("\t\t\t</tr>\r\n");
out.write("\t\t\t<tr>\r\n");
out.write("\t\t\t\t<td><a href=\"#\"><font color=\"#FB9B00\">[���怨듦�]</font></a> �곌뎬�곌뎬硫��</td>\r\n");
out.write("\t\t\t</tr>\r\n");
out.write("\t\t\t<tr height=\"3\">\r\n");
out.write("\t\t\t\t<td></td>\r\n");
out.write("\t\t\t</tr>\r\n");
out.write("\t\t\t<tr>\r\n");
out.write("\t\t\t\t<td width=\"226\" height=\"1\" background=\"http://entaz.mugeta.com/client/FTP_Working_Folder/web/images/main/dot_01.png\"></td>\r\n");
out.write("\t\t\t</tr>\r\n");
out.write("\t\t\t<tr height=\"3\">\r\n");
out.write("\t\t\t\t<td></td>\r\n");
out.write("\t\t\t</tr>\r\n");
out.write("\t\t\t<tr>\r\n");
out.write("\t\t\t\t<td><a href=\"#\"><font color=\"#FB9B00\">[吏��愿��]</font></a> ���遺�━吏��?</td>\r\n");
out.write("\t\t\t</tr>\r\n");
out.write(" </table>\r\n");
out.write(" </td>\r\n");
out.write(" </tr>\r\n");
out.write(" <!--��� NEW ��->\r\n");
out.write("\r\n");
out.write(" <!--�щ갚 ���-->\r\n");
out.write(" <tr>\r\n");
out.write(" <td height=\"20\"></td>\r\n");
out.write(" </tr>\r\n");
out.write("<!--�щ갚 ��->\r\n");
out.write("\r\n");
out.write("</table>\r\n");
out.write("\r\n");
out.write("</body>\r\n");
out.write("</html>\r\n");
} catch (Throwable t) {
if (!(t instanceof SkipPageException)){
out = _jspx_out;
if (out != null && out.getBufferSize() != 0)
out.clearBuffer();
if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
}
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -