41 lines
2.0 KiB
Plaintext
41 lines
2.0 KiB
Plaintext
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
|
|
<%@ include file="/field_manager/include/manager_head.jsp"%>
|
|
<%
|
|
String c_home = r_call(request.getParameter("c_home"));
|
|
String c_maker = r_call(request.getParameter("c_maker"));
|
|
String y = r_call(request.getParameter("y"));
|
|
String c_no = r_call(request.getParameter("c_no"));
|
|
String c_up_no = r_call(request.getParameter("c_up_no"));
|
|
String now_order = r_call(request.getParameter("now_order"));
|
|
String change_order = r_call(request.getParameter("change_order"));
|
|
|
|
|
|
String sql_ok = "update tbl_menu set c_order = 10000 where c_up_no = "+ c_up_no +" and c_order = "+ change_order + " and c_home = " + c_home + " and c_maker = " + c_maker;
|
|
stmt.execute(sql_ok);
|
|
sql_ok = "update tbl_menu set c_order = " + change_order + " where c_up_no = "+ c_up_no +" and c_order = "+ now_order + " and c_home = " + c_home + " and c_maker = " + c_maker ;
|
|
stmt.execute(sql_ok);
|
|
sql_ok = "update tbl_menu set c_order = " + now_order + " where c_up_no = "+ c_up_no +" and c_order = 10000" + " and c_home = " + c_home + " and c_maker = " + c_maker ;
|
|
stmt.execute(sql_ok);
|
|
if(!c_no.equals("")){
|
|
sql_ok = "update tbl_menu set c_content = '" + c_no + "' where c_no = "+ c_up_no +" " + " and c_home = " + c_home + " and c_maker = " + c_maker ;
|
|
stmt.execute(sql_ok);
|
|
if(y.equals("1")){
|
|
sql_ok = "select c_up_no from tbl_menu where c_no = "+ c_up_no +" " + " and c_home = " + c_home + " and c_maker = " + c_maker;
|
|
ResultSet rst3 = stmt.executeQuery(sql_ok);
|
|
if(rst3.next()){
|
|
if(rst3.getInt("c_up_no")>0){
|
|
sql_ok = "update tbl_menu set c_content = '" + c_no + "' where c_no = "+ rst3.getInt("c_up_no") +" " + " and c_home = " + c_home + " and c_maker = " + c_maker;
|
|
stmt.execute(sql_ok);
|
|
}
|
|
}
|
|
rst3.close();
|
|
}
|
|
}
|
|
%>
|
|
<script>
|
|
alert("순서를 수정했습니다.");
|
|
location.href="list.jsp?c_home=<%=c_home%>&c_maker=<%=c_maker%>"
|
|
</script>
|
|
|
|
<%@ include file="/field_manager/include/manager_bottom.jsp"%>
|