33 lines
1.2 KiB
Plaintext
33 lines
1.2 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_pnm_no = r_call(request.getParameter("c_pnm_no"));
|
|
|
|
|
|
|
|
|
|
String sql2 = "select a.*, b.c_field as c_field_no,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 + " 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_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();
|
|
|
|
|
|
%>
|
|
<script>
|
|
location.href="/default.jsp"
|
|
</script>
|
|
<%@include file="/include/db/db_close.jsp"%>
|