<%@ include file="/blog_main/include/left_login.jsp"%>
<%@ include file="/blog_main/include/left_notice.jsp"%>
<%@ include file="/blog_main/include/left_menu.jsp"%>
<%
PreparedStatement pstmt2 = null;
ResultSet rs2 = null;
func_lib now_date = new func_lib();
fields = " T_ID, question1,question2,question3,question4,question5,question6,question7,question8,question9,question10 ";
fields += " ,answer1,answer2,answer3,answer4,answer5,answer6,answer7,answer8,answer9,answer10 ";
fields += " ,post1,post2,post3,post4,post5,site_url,site_intro ";
query = "select * from ";
query += "(select rownum as rnum, " + fields + " from (select " + fields + " from TODAY_MEMBER where OPEN_DATE <= '"+ now_date.getTime("") + "' and OPEN_FLAG = 'S' order by OPEN_DATE Desc)) ";
query += "where rnum > 0 and rnum <= 1 ";
pstmt = conn.prepareStatement(query);
rs = pstmt.executeQuery();
String T_ID = "";
String answer = "";
String[] post = new String[5];
String site_url = null;
i = 0;
//String question1 = "";
if(rs.next())
{
answer = rs.getString("ANSWER1");
if (answer.length() > 100) {
answer = answer.substring(0,100) + "...";
}
for (i=0;i<5;i++) {
post[i] = rs.getString("POST"+(i+1));
}
T_ID = rs.getString("T_ID");
site_url = rs.getString("SITE_URL");
}
// 좌측 content query
String query2 = "select W_FILEIMG, M_NAME from BL_WEBLOG, MEMBER where W_ID = M_ID and W_ID = '" + T_ID +"' ";
//out.println (query2);
pstmt2 = conn.prepareStatement(query2);
rs2 = pstmt2.executeQuery();
String W_FILEIMG = "";
String M_NAME = "";
rs2 = pstmt2.executeQuery();
if(rs2.next())
{
W_FILEIMG = rs2.getString("W_FILEIMG");
M_NAME = rs2.getString("M_NAME");
}
//////////////////////////////////////////////////////////////////////////
%>
<%=M_NAME%>
<%=answer%>
<%=site_url%>
<%
for (i=0;i<5;i++) {
if (post[i] != null) {
String comment1 = post[i].substring(7);
StringTokenizer st = new StringTokenizer(comment1);
String url_str = st.nextToken("/");
if (url_str.equals("blog.culturecities.go.kr")) {
String p_id = st.nextToken("/");
String p_num = st.nextToken("/");
//query = "select P_ID, I_FILENAME from BL_POST, BL_IMGFILE where P_NUM = I_PNUM and P_NUM = '" + arr_str[3] + "' ";
query = "select I_FILENAME from BL_IMGFILE where I_PNUM = '" + p_num + "' ";
//out.println(query);
pstmt = conn.prepareStatement(query);
rs = pstmt.executeQuery();
String I_FILENAME = "";
if(rs.next())
{
I_FILENAME = rs.getString("I_FILENAME");
}
%>
<%
}
else {
%>
<%
}
}
else {
%>
<%
}
}
%>
<%
// 문화 매거진
//query = "select * from MAIN_MAGAZINE_MAIN, BL_CATE_DIR1 where cate_dir = d1_idx ";
query = "select * from MAIN_MAGAZINE_MAIN ";
String idx = "";
String subject = "";
String file_name = "";
String real_name = "";
String contents = "";
String blog_id = "";
String p_num = "";
String p_cnum = "";
String cate_dir = "";
String d1_name = "";
pstmt = conn.prepareStatement(query);
rs = pstmt.executeQuery();
if(rs.next())
{
idx = rs.getString("IDX");
subject = rs.getString("subject");
file_name = rs.getString("file_name");
real_name = rs.getString("real_name");
contents = rs.getString("contents");
if (contents.length() > 200) {
contents = contents.substring(0,200) + "...";
}
p_num = rs.getString("p_num");
cate_dir = rs.getString("cate_dir");
if (cate_dir.equals("2")) d1_name = "공연 알림터";
else if (cate_dir.equals("3")) d1_name = "도두보기";
else if (cate_dir.equals("1")) d1_name = "이미지 아시아";
else if (cate_dir.equals("4")) d1_name = "토론방";
}
query = "select P_ID, P_CNUM from BL_POST where P_NUM = '" + p_num + "' ";
//out.println(query);
pstmt = conn.prepareStatement(query);
rs = pstmt.executeQuery();
if(rs.next())
{
blog_id = rs.getString("P_ID");
p_cnum = rs.getString("P_CNUM");
}
%>
<%
/*
query = "select REGDATE, HIT_ID, HIT_COUNT, SCRAP_ID, SCRAP_COUNT from MAIN_BEST_HISTORY order by REGDATE Desc ";
//out.println(query);
pstmt = conn.prepareStatement(query);
rs = pstmt.executeQuery();
String REGDATE = "";
String HIT_ID = "";
int HIT_COUNT = 0;
String SCRAP_ID = "";
int SCRAP_COUNT = 0;
if(rs.next())
{
REGDATE = rs.getString("REGDATE");
HIT_ID = rs.getString("HIT_ID");
HIT_COUNT = rs.getInt("HIT_COUNT");
SCRAP_ID = rs.getString("SCRAP_ID");
SCRAP_COUNT = rs.getInt("SCRAP_COUNT");
}
*/
//query = "select W_TITLE, W_INTRO, W_STYLE, W_FILEIMG, M_NAME from BL_WEBLOG, MEMBER where W_ID = M_ID and W_ID = '" + HIT_ID +"' ";
//out.println (query2);
fields = " W_ID, W_TITLE, W_FILEIMG, W_STYLE, W_INTRO, W_HIT_TODAY, M_NAME ";
query = "select * from ";
query += "(select rownum as rnum, " + fields + " from (select " + fields + " from BL_WEBLOG, MEMBER where W_ID = M_ID and W_ID <> 'master' and W_ID <> 'help' order by W_HIT_TODAY Desc)) ";
query += "where rnum > 0 and rnum <= 1 ";
//out.println(query);
//out.close();
pstmt = conn.prepareStatement(query);
rs = pstmt.executeQuery();
String W_ID = "";
String W_TITLE = "";
String W_INTRO = "";
int W_STYLE = 0;
//String W_FILEIMG = "";
String W_STYLE_STR = "";
//String M_NAME = "";
rs = pstmt.executeQuery();
if(rs.next())
{
W_ID = rs.getString("W_ID");
W_TITLE = rs.getString("W_TITLE");
if (W_TITLE == null) W_TITLE = "..";
if (W_TITLE.length() > 10) {
W_TITLE = W_TITLE.substring(0,10) + "...";
}
W_INTRO = rs.getString("W_INTRO");
if (W_INTRO == null) W_INTRO = "..";
if (W_INTRO.length() > 15) {
W_INTRO = W_INTRO.substring(0,15) + "...";
}
W_STYLE = rs.getInt("W_STYLE");
W_FILEIMG = rs.getString("W_FILEIMG");
M_NAME = rs.getString("M_NAME");
switch (W_STYLE) {
case 1 :
W_STYLE_STR = "바른생활 꿀벌";
break;
case 2 :
W_STYLE_STR = "친절한 당나귀";
break;
case 3 :
W_STYLE_STR = "야심찬 독수리";
break;
case 4 :
W_STYLE_STR = "낭만적인 공작";
break;
case 5 :
//W_STYLE_STR = "탐구하는 올빼미";
W_STYLE_STR = "탐구하는 올..";
break;
case 6 :
W_STYLE_STR = "신중한 사슴";
break;
case 7 :
//W_STYLE_STR = "낙천적인 원숭이";
W_STYLE_STR = "낙천적인 원..";
break;
case 8 :
//W_STYLE_STR = "리더쉽의 호랑이";
W_STYLE_STR = "리더쉽의 호..";
break;
case 9 :
//W_STYLE_STR = "조화로운 코끼리";
W_STYLE_STR = "조화로운 코..";
break;
}
}
%>
<%
//query = "select W_TITLE, W_INTRO, W_STYLE, W_FILEIMG, M_NAME from BL_WEBLOG, MEMBER where W_ID = M_ID and W_ID = '" + SCRAP_ID +"' ";
//out.println (query2);
fields = "";
query = "";
fields = " W_ID, W_TITLE, W_STYLE, W_FILEIMG, W_INTRO, W_SCRAP_TODAY, M_NAME ";
query = "select * from ";
query += "(select rownum as rnum, " + fields + " from (select " + fields + " from BL_WEBLOG, MEMBER where W_ID = M_ID and W_ID <> 'master' and W_ID <> 'help' order by W_SCRAP_TODAY Desc, W_SCRAP_COUNT Desc)) ";
query += "where rnum > 0 and rnum <= 1 ";
//out.println(query);
//out.close();
pstmt = conn.prepareStatement(query);
rs = pstmt.executeQuery();
if(rs.next())
{
W_ID = rs.getString("W_ID");
W_TITLE = rs.getString("W_TITLE");
if (W_TITLE == null) W_TITLE = "..";
if (W_TITLE.length() > 10) {
W_TITLE = W_TITLE.substring(0,10) + "...";
}
W_INTRO = rs.getString("W_INTRO");
if (W_INTRO == null) W_INTRO = "";
if (W_INTRO.length() > 15) {
W_INTRO = W_INTRO.substring(0,15) + "...";
}
W_STYLE = rs.getInt("W_STYLE");
W_FILEIMG = rs.getString("W_FILEIMG");
M_NAME = rs.getString("M_NAME");
switch (W_STYLE) {
case 1 :
W_STYLE_STR = "바른생활 꿀벌";
break;
case 2 :
W_STYLE_STR = "친절한 당나귀";
break;
case 3 :
W_STYLE_STR = "야심찬 독수리";
break;
case 4 :
W_STYLE_STR = "낭만적인 공작";
break;
case 5 :
//W_STYLE_STR = "탐구하는 올빼미";
W_STYLE_STR = "탐구하는 올..";
break;
case 6 :
W_STYLE_STR = "신중한 사슴";
break;
case 7 :
//W_STYLE_STR = "낙천적인 원숭이";
W_STYLE_STR = "낙천적인 원..";
break;
case 8 :
//W_STYLE_STR = "리더쉽의 호랑이";
W_STYLE_STR = "리더쉽의 호..";
break;
case 9 :
//W_STYLE_STR = "조화로운 코끼리";
W_STYLE_STR = "조화로운 코..";
break;
}
}
%>
<%
fields = " W_TITLE, W_ID ";
query = "select * from ";
query += "(select rownum as rnum, " + fields + " from BL_WEBLOG order by W_IDX Desc) ";
query += "where rnum > 0 and rnum <= 5 ";
pstmt = conn.prepareStatement(query);
rs = pstmt.executeQuery();
while(rs.next()){
W_TITLE = rs.getString("W_TITLE");
if (W_TITLE == null) W_TITLE = "..";
if (W_TITLE.length() > 20) {
W_TITLE = W_TITLE.substring(0,20) + "...";
}
W_ID = rs.getString("W_ID");
%>
<%=W_TITLE%>
<%
}
%>
<%
fields = " P_TITLE, P_ID, P_NUM, P_CNUM ";
query = "select * from ";
query += "(select rownum as rnum, " + fields + " from BL_POST order by P_NUM Desc) ";
query += "where rnum > 0 and rnum <= 5 ";
pstmt = conn.prepareStatement(query);
rs = pstmt.executeQuery();
P_ID = "";
P_TITLE = "";
P_NUM = "";
P_CNUM = "";
while(rs.next()){
P_TITLE = rs.getString("P_TITLE");
if (P_TITLE == null) P_TITLE = "..";
if (P_TITLE.length() > 16) {
P_TITLE = P_TITLE.substring(0,16) + "...";
}
P_ID = rs.getString("P_ID");
P_NUM = rs.getString("P_NUM");
P_CNUM = rs.getString("P_CNUM");
%>
<%=P_TITLE%>
<%
}
%>
<%
fields = " o_idx, question, example1, example2, example3, example4, example5, example6, example7, example8, example9, example10 ";
query = "select * from ";
query += "(select rownum as rnum, " + fields + " from MAIN_POLL_QUESTION order by O_IDX Desc) ";
query += "where rnum > 0 and rnum <= 1 ";
pstmt = conn.prepareStatement(query);
rs = pstmt.executeQuery();
String o_idx = "";
String question = "";
String[] example = new String[10];
if (rs.next()){
o_idx = rs.getString("o_idx");
question = rs.getString("question");
for (i=0;i<10;i++) {
example[i] = rs.getString("example"+(i+1));
}
%>
