<%@ 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_project_no = r_call(request.getParameter("c_project_no")); String c_field = r_call(request.getParameter("c_field")); int c_order = 1; String sql1=" SELECT max(c_order) as max_order from tbl_project_operation where c_manager_no = " + session.getAttribute("manager_no") + " and c_use = 0 "; ResultSet rst = stmt.executeQuery(sql1); if(rst.next()) { c_order = c_order + rst.getInt("max_order"); } rst.close(); String sql_ok = ""; sql_ok = "insert into tbl_project_operation (c_project_no,c_manager_no,c_order,c_use,c_date) values("; sql_ok = sql_ok + " " + c_project_no + "," + session.getAttribute("manager_no") + "," + c_order + ",0,now())"; stmt2.execute(sql_ok); %> <% %> <%@include file="/include/db/db_close.jsp"%>