29 lines
828 B
Plaintext
29 lines
828 B
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 sql= "select * from tbl_apply_team_member where c_member_no = 0 and c_use = 0 ";
|
|
ResultSet rs=stmt.executeQuery(sql);
|
|
while(rs.next()){
|
|
String sql2= "select * from tbl_member where c_id = '"+ rs.getString("c_email") +"' and c_use = 0 ";
|
|
ResultSet rs2=stmt.executeQuery(sql2);
|
|
if(rs2.next()){
|
|
|
|
String sql_ok = "update tbl_apply_team_member set c_member_no = "+ rs2.getInt("c_no") +" where c_no = " + rs.getInt("c_no") ;
|
|
stmt2.execute(sql_ok);
|
|
|
|
}
|
|
rs2.close();
|
|
|
|
}
|
|
rs.close();
|
|
|
|
|
|
%>
|
|
|
|
<%@include file="/include/db/db_close.jsp"%>
|