📄 member_005flist_jsp.java
字号:
"uinfo.sex AS sex FROM GT_guest AS guest INNER JOIN GT_user_info AS uinfo ON "+
"CAST(guest.guest_phone AS bigint) = uinfo.phonenum2 AND guest.phonenum2 ="+ mphone +
" ORDER BY guest.guest_date DESC";
pstmt = con.prepareStatement(szCount);
rs = pstmt.executeQuery();
for(int i = 0 ; rs.next() ; i++)
{
rgstrGuestName[i] = rs.getString("name");
rgiSex[i] = rs.getInt("sex");
rgstrGuestTime[i] = rs.getString("time");
nVisitLongs = i;
}
rs.close();
pstmt.close();
/*------------------------------------------------------------------------------------------------
* �����������옙������ ������ -- ������ 移닷����
-------------------------------------------------------------------------------------------------*/
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() )
{
nIdx = rs.getInt("idx");
szQuery ="SELECT cafe_idx,cafe_name FROM GT_cafe WHERE cafe_idx = "+nIdx ;
}
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() )
{
nCafeIdx = rs.getInt("cafe_idx");
strCafeName = 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() )
{
nIdx = rs.getInt("idx");
szQuery ="SELECT issue_title,issue_idx FROM GT_issue WHERE issue_idx = "+nIdx ;
}
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() )
{
nIssueIdx = rs.getInt("issue_idx");
strIssueTitle = 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() )
{
nIdx = rs.getInt("idx");
szQuery ="SELECT kthema_idx,kthema_title,phonenum FROM GT_kthema WHERE kthema_idx="+nIdx ;
}
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() )
{
nNoticeIdx = rs.getInt("kthema_idx");
strNoticeTitle = rs.getString("kthema_title");
}
rs.close();
pstmt.close();
/*------------------------------------------------------------------------------------------------
* ������ NEW
-------------------------------------------------------------------------------------------------*/
szQuery = " SELECT TOP 6 notice_idx,notice_main_flag_idx,notice_date,notice_kind,notice_text,"+
"notice_head,notice_path FROM GT_notice ORDER BY notice_main_flag_idx ASC ";
pstmt = con.prepareStatement(szQuery);
rs = pstmt.executeQuery();
for(int i = 0 ; rs.next() ; i++)
{
rgstrNewsTitle[i] = rs.getString("notice_head");
rgiNewsKind[i] = rs.getInt("notice_kind");
nNewsLongs = i;
}
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) {
}
}
}
out.write('\r');
out.write('\n');
out.write("\r\n");
out.write("\r\n");
out.write("<html>\r\n");
out.write("\t<head>\r\n");
out.write("\t\t<link href=\"../mobile.css\" rel=\"stylesheet\" type=\"text/css\">\r\n");
out.write("\t</head>\r\n");
out.write("\t<body>\r\n");
out.write("\r\n");
out.write("\t\t<table width=\"240\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n");
out.write("\t\t\t<!--개인폰피박스 시작-->\r\n");
out.write("\t\t\t<tr>\r\n");
out.write("\t\t\t\t<td>\r\n");
out.write("\t\t\t\t\t<!--핑크테두리 시작-->\r\n");
out.write("\t\t\t\t\t<table width=\"240\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n");
out.write("\t\t\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t\t\t\t<td width=\"240\" height=\"3\" bgcolor=\"#FC3F4E\" colspan=\"3\"></td>\r\n");
out.write("\t\t\t\t\t\t</tr>\r\n");
out.write("\r\n");
out.write("\t\t\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t\t\t\t<td width=\"3\" height=\"3\" bgcolor=\"#fc3f4e\"></td>\r\n");
out.write("\t\t\t\t\t\t\t<!--실제 컨텐츠 틀 시작-->\r\n");
out.write("\t\t\t\t\t\t\t<td>\r\n");
out.write("\t\t\t\t\t\t\t\t<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n");
out.write("\t\t\t\t\t\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t<td width=\"231\" height=\"3\" colspan=\"3\"></td>\r\n");
out.write("\t\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\t<tr>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t<td width=\"2\" height=\"63\"></td>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t<!--아바타 사진 + 메뉴 시작-->\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t<td width=\"226\" height=\"63\">\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t<!--아바타사진-->\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t<td width=\"55\" height=\"63\" bgcolor=\"#dae6e8\">\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t<table>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td width=\"70\" height=\"1\" bgcolor=\"#dae6e8\" colspan=\"3\"></td>\r\n");
out.write("\t\t\t\t\t\t\t\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\t\t\t\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td width=\"3\" height=\"61\" bgcolor=\"#dae6e8\"></td>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tsrc=\"");
out.print(img_path);
out.write("images/itemshop/temp_1.png\">\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</td>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td width=\"3\" height=\"61\" bgcolor=\"#dae6e8\"></td>\r\n");
out.write("\t\t\t\t\t\t\t\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\t\t\t\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td width=\"70\" height=\"1\" bgcolor=\"#dae6e8\" colspan=\"3\"></td>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</tr>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t</table>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t</td>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t<!--아바타사진-->\r\n");
out.write("\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t<!--여백-->\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t<td width=\"5\"></td>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t<!--여백-->\r\n");
out.write("\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t<!--메뉴-->\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t<td width=\"120\">\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t<table>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tsrc=\"");
out.print(img_path);
out.write("images/itemshop/temp_4.png\"\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tpictosrc=\"77\">\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t친구 신청\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t");
out.print(nFriendCount);
out.write("\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t건\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</td>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</tr>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<tr height=\"5\">\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td></td>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</tr>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tsrc=\"");
out.print(img_path);
out.write("images/itemshop/temp_5.png\"\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tpictosrc=\"76\">\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t새 쪽지\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t");
out.print(nPaperCount);
out.write("\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t개\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</td>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</tr>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<tr height=\"5\">\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td></td>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</tr>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tsrc=\"");
out.print(img_path);
out.write("images/itemshop/temp_6.png\"\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tpictosrc=\"83\">\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t방명록 새글");
if(nGuestBook != 0){
out.write('도');
out.write('착');
}else{
out.write('없');
out.write('음');
out.write(' ');
}
out.write("\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</td>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</tr>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t\t</table>\r\n");
out.write("\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t</td>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t\t<!--메뉴-->\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t\t</tr>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t\t</table>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t</td>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t<!--아바타 사진 + 메뉴 끝-->\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t<td width=\"2\" height=\"63\"></td>\r\n");
out.write("\t\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\t<tr>\r\n");
out.write("\t\t\t\t\t\t\t\t\t\t<td width=\"231\" height=\"3\" colspan=\"3\"></td>\r\n");
out.write("\t\t\t\t\t\t\t\t\t</tr>\r\n");
out.write("\r\n");
out.write("\r\n");
out.write("\t\t\t\t\t\t\t\t</table>\r\n");
out.write("\t\t\t\t\t\t\t</td>\r\n");
out.write("\t\t\t\t\t\t\t<!--실제 컨텐츠 틀 끝-->\r\n");
out.write("\t\t\t\t\t\t\t<td width=\"3\" height=\"3\" bgcolor=\"#fc3f4e\"></td>\r\n");
out.write("\t\t\t\t\t\t</tr>\r\n");
out.write("\r\n");
out.write("\t\t\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t\t\t\t<td width=\"240\" height=\"3\" bgcolor=\"#FC3F4E\" colspan=\"3\"></td>\r\n");
out.write("\t\t\t\t\t\t</tr>\r\n");
out.write("\t\t\t\t\t</table>\r\n");
out.write("\t\t\t\t\t<!--핑크테두리 끝-->\r\n");
out.write("\t\t\t\t</td>\r\n");
out.write("\t\t\t</tr>\r\n");
out.write("\t\t\t<!--개인폰피박스 끝-->\r\n");
out.write("\r\n");
out.write("\r\n");
out.write("\t\t\t<!--여백 시작-->\r\n");
out.write("\t\t\t<tr>\r\n");
out.write("\t\t\t\t<td height=\"5\"></td>\r\n");
out.write("\t\t\t</tr>\r\n");
out.write("\t\t\t<!--여백 끝-->\r\n");
out.write("\r\n");
out.write("\r\n");
out.write("\t\t\t<!--따끈한 타운이슈 시작-->\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\t<table width=\"226\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n");
out.write("\t\t\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t\t\t\t<td width=\"226\" height=\"17\" bgcolor=\"#C0FFB6\" align=\"center\">\r\n");
out.write("\t\t\t\t\t\t\t\t<font color=\"#4BAEA3\"><b>따끈한 타운 이슈!</b> </font>\r\n");
out.write("\t\t\t\t\t\t\t</td>\r\n");
out.write("\r\n");
out.write("\t\t\t\t\t\t</tr>\r\n");
out.write("\t\t\t\t\t\t<tr height=\"3\">\r\n");
out.write("\t\t\t\t\t\t\t<td></td>\r\n");
out.write("\t\t\t\t\t\t</tr>\r\n");
out.write("\t\t\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t\t\t\t<td>\r\n");
out.write("\t\t\t\t\t\t\t\t<img\r\n");
out.write("\t\t\t\t\t\t\t\t\tsrc=\"");
out.print(img_path);
out.write("images/itemshop/temp_7.png\"\r\n");
out.write("\t\t\t\t\t\t\t\t\tpictosrc=\"8\">\r\n");
out.write("\t\t\t\t\t\t\t\t \r\n");
out.write("\t\t\t\t\t\t\t\t<a href=\"#\"><font color=\"#1DC72C\">[타운카페]</font>");
out.print(strCafeName );
out.write(" </a> \r\n");
out.write("\t\t\t\t\t\t\t</td>\r\n");
out.write("\t\t\t\t\t\t</tr>\r\n");
out.write("\t\t\t\t\t\t<tr height=\"3\">\r\n");
out.write("\t\t\t\t\t\t\t<td></td>\r\n");
out.write("\t\t\t\t\t\t</tr>\r\n");
out.write("\t\t\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t\t\t\t<td width=\"226\" height=\"1\"\r\n");
out.write("\t\t\t\t\t\t\t\tbackground=\"http://entaz.mugeta.com/client/FTP_Working_Folder/web/images/main/dot_01.png\"></td>\r\n");
out.write("\t\t\t\t\t\t</tr>\r\n");
out.write("\t\t\t\t\t\t<tr height=\"3\">\r\n");
out.write("\t\t\t\t\t\t\t<td></td>\r\n");
out.write("\t\t\t\t\t\t</tr>\r\n");
out.write("\t\t\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t\t\t\t<td>\r\n");
out.write("\t\t\t\t\t\t\t\t<img\r\n");
out.write("\t\t\t\t\t\t\t\t\tsrc=\"");
out.print(img_path);
out.write("images/itemshop/temp_8.png\"\r\n");
out.write("\t\t\t\t\t\t\t\t\tpictosrc=\"5\">\r\n");
out.write("\t\t\t\t\t\t\t\t \r\n");
out.write("\t\t\t\t\t\t\t\t<a href=\"#\"><font color=\"#1DC72C\">[타운공감]</font>");
out.print(strIssueTitle );
out.write(" </a>\r\n");
out.write("\t\t\t\t\t\t\t</td>\r\n");
out.write("\t\t\t\t\t\t</tr>\r\n");
out.write("\t\t\t\t\t\t<tr height=\"3\">\r\n");
out.write("\t\t\t\t\t\t\t<td></td>\r\n");
out.write("\t\t\t\t\t\t</tr>\r\n");
out.write("\t\t\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t\t\t\t<td width=\"226\" height=\"1\"\r\n");
out.write("\t\t\t\t\t\t\t\tbackground=\"http://entaz.mugeta.com/client/FTP_Working_Folder/web/images/main/dot_01.png\"></td>\r\n");
out.write("\t\t\t\t\t\t</tr>\r\n");
out.write("\t\t\t\t\t\t<tr height=\"3\">\r\n");
out.write("\t\t\t\t\t\t\t<td></td>\r\n");
out.write("\t\t\t\t\t\t</tr>\r\n");
out.write("\t\t\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t\t\t\t<td>\r\n");
out.write("\t\t\t\t\t\t\t\t<img\r\n");
out.write("\t\t\t\t\t\t\t\t\tsrc=\"");
out.print(img_path);
out.write("images/itemshop/temp_9.png\"\r\n");
out.write("\t\t\t\t\t\t\t\t\tpictosrc=\"4\">\r\n");
out.write("\t\t\t\t\t\t\t\t \r\n");
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -