50 lines
1.6 KiB
Plaintext
50 lines
1.6 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_project_no = "";
|
|
c_project_no = "" + session.getAttribute("member_project_no");
|
|
String c_member_no = "";
|
|
c_member_no = "" + session.getAttribute("member_no");
|
|
String c_member_type = "";
|
|
c_member_type = "" + session.getAttribute("member_type");
|
|
|
|
String c_pt_no = r_call(request.getParameter("c_pt_no"));
|
|
String c_team_no = r_call(request.getParameter("c_team_no"));
|
|
String c_type = r_call(request.getParameter("c_type"));
|
|
String c_relation = r_call(request.getParameter("c_relation"));
|
|
String c_point = r_call(request.getParameter("c_point"));
|
|
String c_content = r_call(request.getParameter("c_content"));
|
|
|
|
if(c_pt_no.equals("")){
|
|
c_pt_no = "0";
|
|
}
|
|
if(c_team_no.equals("")){
|
|
c_team_no = "0";
|
|
}
|
|
if(c_type.equals("")){
|
|
c_type = "0";
|
|
}
|
|
if(c_relation.equals("")){
|
|
c_relation = "0";
|
|
}
|
|
if(c_point.equals("")){
|
|
c_point = "0";
|
|
}
|
|
|
|
String sql_ok = "insert tbl_comment (c_project_no, c_pt_no, c_team_no, c_type, c_relation, c_member_no, c_member_type, c_point, c_content, c_use,c_date) values ( ";
|
|
sql_ok = sql_ok + c_project_no +","+ c_pt_no +","+ c_team_no +","+ c_type +","+ c_relation +","+ c_member_no +","+ c_member_type +","+ c_point +",'"+ c_content +"',0,now())";
|
|
stmt2.execute(sql_ok);
|
|
|
|
%>
|
|
<script>
|
|
alert("Insert OK.")
|
|
parent.my_reload();
|
|
</script>
|
|
<%
|
|
|
|
%>
|
|
<%@include file="/include/db/db_close.jsp"%>
|