join_team_ok.jsp

来自「wap站点源码」· JSP 代码 · 共 34 行

<?xml version='1.0' encoding="utf-8"?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN" "http://www.wapforum.org/DTD/ wml_1.1.html">
<%@page language="java" contentType="text/vnd.wap.wml; charset=utf-8" %>
<%@page import="sql_db.ConnSql"%>
<%@page import="java.sql.*"%>
<wml> 
  <template> 
   <do type="options" label="back"> 
    <prev/>
   </do> 
  </template> 
  <card id="card1"> 

    <%ConnSql connSql = new ConnSql();
		connSql.setConnectDatabase(); 
		String MISC_MSISDN=request.getParameter("MISC_MSISDN");
		String teamid=request.getParameter("teamid");		
		
		String sql="select Id,Name from wap_Team where Code='"+teamid+"'";
		ResultSet rs;
		rs=connSql.executeQuery(sql);
		rs.next();
		String sId=rs.getString(1);
		String sName=rs.getString(2);
		
		String insSql="insert into wap_Single_Team(TeamId,UserId) select "+sId+",Id from wap_User where Mobile='"+MISC_MSISDN+"' and Id not in (select UserId from wap_Single_Team)";
		connSql.executeInsert(insSql);
		connSql.commit();
		%>  
   <p align="center">鍏ュ洟鎴愬姛</p>	
   <p align="center">~~~~~~~~~~~~~~</p>
  
   <p>
   娆㈣繋鎮ㄥ姞鍏