<%@ 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); %> <% %> <%@include file="/include/db/db_close.jsp"%>