<%@ 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_ok = r_call(request.getParameter("c_ok")); String c_team_no = r_call(request.getParameter("c_team_no")); String c_content = r_call(request.getParameter("c_content")); String c_point_project_no = r_call(request.getParameter("c_point_project_no")); String p1[] = request.getParameterValues("p1"); String c_value = ""; int c_point = 0; for(int i=0; i< p1.length; i++){ if(i>0){ c_value = c_value + "|"; } c_value = c_value + p1[i]; c_point = c_point + Integer.parseInt(p1[i]); } String sql_re = "select * from tbl_point_result where c_point_project_no = "+ c_point_project_no +" and c_team_no = "+ c_team_no +" and c_pointer_no = "+ session.getAttribute("pointer_no") +" "; ResultSet rs_re = stmt.executeQuery(sql_re); if (rs_re.next()) { String sql_ok = "update tbl_point_result set c_value = '"+ c_value +"', c_point = "+ c_point +", c_ok = "+ c_ok +", c_content = '"+ c_content +"', c_update = now() where c_point_project_no = "+ c_point_project_no +" and c_team_no = "+ c_team_no +" and c_pointer_no = "+ session.getAttribute("pointer_no") +" "; stmt2.execute(sql_ok); }else{ String sql_ok = "insert into tbl_point_result (c_point_project_no,c_team_no,c_pointer_no,c_value,c_point,c_content,c_ok,c_date) values ("; sql_ok = sql_ok + c_point_project_no + "," + c_team_no + "," + session.getAttribute("pointer_no") + ",'" + c_value + "'," + c_point + ",'" + c_content + "'," + c_ok + ",now())"; stmt2.execute(sql_ok); } rs_re.close(); %> <%@include file="/include/db/db_close.jsp"%>