30 lines
975 B
Plaintext
30 lines
975 B
Plaintext
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
|
|
<%@include file="/include/db/db_connect.jsp"%>
|
|
<%@include file="/include/function/function.jsp"%>
|
|
<%request.setCharacterEncoding("utf-8");%>
|
|
<%
|
|
String c_no = r_call(request.getParameter("c_no"));
|
|
String c_order = r_call(request.getParameter("c_order"));
|
|
String o_no = r_call(request.getParameter("o_no"));
|
|
String o_order = r_call(request.getParameter("o_order"));
|
|
String c_field = r_call(request.getParameter("c_field"));
|
|
if(c_no.equals("")){
|
|
%>
|
|
<script>
|
|
alert("Wrong connection.");
|
|
location.href="list.jsp"
|
|
</script>
|
|
<%
|
|
}else{
|
|
String sql_ok = "update tbl_project set c_order = "+ o_order +" where c_no = "+ c_no;
|
|
stmt.execute(sql_ok);
|
|
sql_ok = "update tbl_project set c_order = "+ c_order +" where c_no = "+ o_no;
|
|
stmt.execute(sql_ok);
|
|
%>
|
|
<script>
|
|
location.href="list.jsp?c_field=<%=c_field%>"
|
|
</script>
|
|
<%
|
|
}
|
|
%>
|
|
<%@include file="/include/db/db_close.jsp"%> |