c-innovacion2/resoft/field_manager/process/bcb/team/insert_team_ok.jsp

22 lines
828 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_team_name = r_call(request.getParameter("c_team_name"));
String c_exp = r_call(request.getParameter("c_exp"));
String c_project_no = r_call(request.getParameter("c_project_no"));
String sql_ok = "";
sql_ok = "insert into tbl_team (c_relation, c_project_no,c_team_name,c_exp,c_use,c_date) values(";
sql_ok = sql_ok + "0," + c_project_no + ",'" + c_team_name + "','" + c_exp + "',0,now())";
stmt2.execute(sql_ok);
%>
<script>
alert("Insert OK");
parent.location.href="list.jsp?c_project_no=<%=c_project_no%>"
</script>
<%
%>
<%@include file="/include/db/db_close.jsp"%>