c-innovacion2/resoft/field_manager/process/survey/project/edit_ok.jsp

27 lines
1.0 KiB
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_home = r_call(request.getParameter("c_home"));
String c_project_no = r_call(request.getParameter("c_project_no"));
String c_no = r_call(request.getParameter("c_no"));
String c_name = r_call(request.getParameter("c_name"));
String c_survey_no = r_call(request.getParameter("c_survey_no"));
String c_content = r_call2(request.getParameter("c_content"));
String sql_ok = "";
sql_ok = "update tbl_survey_project set c_name='"+ c_name +"',c_survey_no="+ c_survey_no +",c_content='"+ c_content +"' ";
sql_ok = sql_ok + " where c_now = 0 and c_use = 0 and c_no = " + c_no;
stmt2.execute(sql_ok);
%>
<script>
alert("Edit OK");
parent.location.href="list.jsp?c_home=<%=c_home%>&c_project_no=<%=c_project_no%>"
</script>
<%
%>
<%@include file="/include/db/db_close.jsp"%>