<%--
/**
*
* Filename :survey_test.jsp
* Comment : 여론조사 관리 리스트
* History : 2004/07/22, 김민자. v1.0. 처음작성
*
* @version : 1.0
* @author Copyright (c) 2004 by Intmoa Crop. All Right Reserved.
*/
--%>
<%@ page contentType="text/html; charset=euc-kr" %>
<%@ page import="java.sql.*, java.io.*, java.util.*,java.text.SimpleDateFormat, javax.naming.*, javax.sql.*, javax.servlet.*,util.*,research.*" %>
<%
response.setHeader("Pragma", "no-cache");
response.setHeader("Cache-Control", "no-cache");
ResearchData bbs = null;
ResearchItemData td = null;
Connection con = null;
StringBuffer sqlResult = null;
Statement stmt = null;
ResultSet rs = null;
Vector List = null; // 게시물 리스트 항목을 담을 Vector
String research="";
String usr_chk = "";
String Subject = "";
String header="";
String content="";
String sdate="";
String edate="";
String itemcode=""; //설문고유번호
String itemseq="";
String ex_type="";
String sel_type="";
String input_type="";
String sbj_name1="";
String sbj_name2="";
String sbj_name3="";
String date_chk=""; //날짜 체크
String[] bogi=null;
String[] sbj=null;
int[] result = null;
int[] percent = null;
String returnUrl="";
int ex_count=0;
int sel_num=0;
int list_size = 0;
int ex_num=0;
int quest_num=0;
int resultMax=0;
int resultTotal=0;
String cont1="";
String cont2="";
String cont3="";
String tableSess = "SURVEY";//테이블 세션
// boolean isAdmin = false; // 관리자 여부..
String adminKey = TUtil.objectToBaseStr(session.getAttribute(tableSess),"");
String whois = TUtil.objectToBaseStr(session.getAttribute("whois"),""); // 관리자 구분..
//if ( "ok".equals(adminKey) || "total_admin".equals(whois) )
// isAdmin = true;
//if ( !isAdmin ) { %><%// }
RegisterNoFilter reg = new RegisterNoFilter();
ResearchItemList bList = new ResearchItemList(); // 게시판 리스트 데이타를 가져오는 Class
research = TUtil.nullTobaseStr(request.getParameter("RESEARCH"),"5");
itemcode = TUtil.nullTobaseStr(request.getParameter("item_code"),"1");
Research conf = new Research();
bbs = conf.getResearchDataList(research);
String title = TUtil.nullTobaseStr(bbs.R_SUBJECT,"설문제목이 없습니다.");
content = TUtil.ViewCont(bbs.R_CONTENT);
sdate = TUtil.nullTobaseStr(bbs.R_SDATE,"");
edate = TUtil.nullTobaseStr(bbs.R_EDATE,"");
List = bList.r_list( research,"1",bbs ); // 게시물 리스트 데이타를 Vector 에 넣는다
list_size = List.size();
if (!"71".equals(research)){
%>
<%=title%>
<%=title%>
[설문기간] <%=sdate%> ~ <%=edate%>
<%
try
{
int i =0 ;
con = DBConnection.getGBConnection();
try
{
sqlResult =new StringBuffer();
sqlResult.append(" SELECT R_CONT1, R_CONT2,R_CONT3 ")
.append("FROM GB_RESEARCH_RESULT ")
.append("WHERE R_NUM='"+research+"' ")
.append("AND R_ITEMNUM='"+itemcode+"' ")
.append("AND R_CONT1 || R_CONT2 || R_CONT3 is not null ");
stmt = con.createStatement();
rs= stmt.executeQuery(sqlResult.toString());
while(rs.next())
{
if(i == 0 )
{
out.println("
");
}
i++;
cont1 = (rs.getString(1) != null && rs.getString(1).length()!=0)? rs.getString(1) :"";
cont2 = (rs.getString(2) != null && rs.getString(2).length()!=0)? rs.getString(2) :"";
cont3 = (rs.getString(3) != null && rs.getString(3).length()!=0)? rs.getString(3) :"";
cont1 = reg.searchInit(cont1);
cont2 = reg.searchInit(cont2);
cont3 = reg.searchInit(cont3);
out.println("- ");
out.println(TUtil.b_html(TUtil.StrReplace(cont1,"&","&"),'T'));
if(!cont2.equals("")){
out.println("
");
out.println("- "+TUtil.b_html(TUtil.StrReplace(cont2,"&","&"),'T') +"
");
out.println("
");
}
out.println(" ");
}
if(i > 0)
{
out.println("
");
}
}//end of try
catch(SQLException sqle)
{
System.out.println("오류="+"/open_content/participation/online_survey/survey_sbj_result.jsp");
}//end of catch(SQLException esql)
catch(Exception e)
{
System.out.println("오류="+"/open_content/participation/online_survey/survey_sbj_result.jsp");
}//end of catch(Exception e)
}//end of try
catch(Exception e)
{
System.out.println("오류="+"/open_content/participation/online_survey/survey_sbj_result.jsp");
}
finally
{
if(rs != null) try{ rs.close();} catch(Exception ex) {System.out.println("오류="+"/open_content/participation/online_survey/survey_sbj_result.jsp");}
if(stmt != null) try{ stmt.close();} catch(Exception ex) {System.out.println("오류="+"/open_content/participation/online_survey/survey_sbj_result.jsp");}
if(con != null) try{ con.close();} catch(Exception ex) {System.out.println("오류="+"/open_content/participation/online_survey/survey_sbj_result.jsp");}
}
%>
