|
|
 |
 |
|
|
String req_actor = StringUtil.encodeQuot(StringUtil.nvlnull(request.getParameter("searchValue")));
request.setParameter("actorid", req_actor);
String sql = " SELECT IMAGE_ID, TITLE, IMAGE_EXP, FILE_NAME_S " +
" FROM TB_IMAGE " +
" WHERE CATEGORY = '04' " +
" AND SECTION = '02' " +
" AND VOD_ID = 'V0000280088' ";
String sql_total = " SELECT COUNT(IMAGE_ID) TOTAL " +
" FROM TB_IMAGE " +
" WHERE CATEGORY = '04' " +
" AND SECTION = '02' " +
" AND VOD_ID = 'V0000280088' ";
if (req_actor.equals(""))
{
sql += " AND TITLE LIKE '%정다빈%' ";
sql_total += " AND TITLE LIKE '%정다빈%' ";
}
else if (req_actor.equals("yoon"))
{
sql += " AND TITLE LIKE '%윤계상%' ";
sql_total += " AND TITLE LIKE '%윤계상%' ";
}
else if (req_actor.equals("jaewon"))
{
sql += " AND TITLE LIKE '%김재원%' ";
sql_total += " AND TITLE LIKE '%김재원%' ";
}
else if (req_actor.equals("minhee"))
{
sql += " AND TITLE LIKE '%김민희%' ";
sql_total += " AND TITLE LIKE '%김민희%' ";
}
else if (req_actor.equals("etc"))
{
sql = " SELECT IMAGE_ID, TITLE, IMAGE_EXP, FILE_NAME_S, REG_DATE, REG_HH " +
" FROM ( SELECT IMAGE_ID, TITLE, IMAGE_EXP, FILE_NAME_S, REG_DATE, REG_HH " +
" FROM TB_IMAGE " +
" WHERE CATEGORY = '04' " +
" AND SECTION = '02' " +
" AND VOD_ID = 'V0000280088' " +
" MINUS " +
" SELECT IMAGE_ID, TITLE, IMAGE_EXP, FILE_NAME_S, REG_DATE, REG_HH " +
" FROM TB_IMAGE " +
" WHERE CATEGORY = '04' " +
" AND SECTION = '02' " +
" AND VOD_ID = 'V0000280088' " +
" AND (TITLE LIKE '%정다빈%' OR TITLE LIKE '%윤계상%' OR TITLE LIKE '%김재원%' OR TITLE LIKE '%김민희%')) AA ";
sql_total = " SELECT COUNT(IMAGE_ID) TOTAL " +
" FROM ( SELECT IMAGE_ID, TITLE, IMAGE_EXP, FILE_NAME_S, REG_DATE, REG_HH " +
" FROM TB_IMAGE " +
" WHERE CATEGORY = '04' " +
" AND SECTION = '02' " +
" AND VOD_ID = 'V0000280088' " +
" MINUS " +
" SELECT IMAGE_ID, TITLE, IMAGE_EXP, FILE_NAME_S, REG_DATE, REG_HH " +
" FROM TB_IMAGE " +
" WHERE CATEGORY = '04' " +
" AND SECTION = '02' " +
" AND VOD_ID = 'V0000280088' " +
" AND (TITLE LIKE '%정다빈%' OR TITLE LIKE '%윤계상%' OR TITLE LIKE '%김재원%' OR TITLE LIKE '%김민희%')) AA ";
}
sql += " ORDER BY REG_DATE DESC, REG_HH DESC " ;
request.setParameter("SQL", sql);
request.setParameter("SQL_TOTAL", sql_total);
/*--목록의 갯수 구하기--*/
if (request.getParameter("totalCount") == null || request.getParameter("totalCount").equals(""))
{
}
else
{
}
if(request.getParameter("actorid").equals("etc"))
{
','','scrollbars=yes,resizable=yes,width=700,height=600')">
}
else
{
&actorid=<%=request.getParameter("actorid")%>','','scrollbars=yes,resizable=yes,width=700,height=600')">
}
|
int count = Integer.parseInt(request.getParameter("count"));
if(count%7 == 0)
{
}
|
|
