<%@ 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_pnm_no = r_call(request.getParameter("c_pnm_no")); String sql2 = "select a.*, b.c_field as c_field_no, c.c_eng_name as c_field_eng_name,b.c_up_no as c_cate_no from tbl_pnm_for_bcb a "; sql2 = sql2 + " inner join tbl_project b on b.c_no = a.c_project_no "; sql2 = sql2 + " inner join tbl_field c on c.c_no = b.c_field "; sql2 = sql2 + " where a.c_use = 0 and a.c_member_no = " + session.getAttribute("member_no") + " and a.c_no = " + c_pnm_no; ResultSet rs2=stmt.executeQuery(sql2); if(rs2.next()){ session.setAttribute("member_field_no",rs2.getString("c_field_no")); session.setAttribute("member_field_eng_name",rs2.getString("c_field_eng_name")); session.setAttribute("member_cate_no",rs2.getString("c_cate_no")); session.setAttribute("member_project_no",rs2.getString("c_project_no")); session.setAttribute("member_team_no",rs2.getString("c_team_no")); session.setAttribute("member_pnm_no",rs2.getString("c_no")); session.setAttribute("member_type",rs2.getString("c_type")); } rs2.close(); %> <%@include file="/include/db/db_close.jsp"%>