select_team.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"> 
    <do type="accept" label="Start"> 
        <go href="#Welcome"/> 
    </do> 
    <%ConnSql connSql = new ConnSql();
		connSql.setConnectDatabase(); 
		String MISC_MSISDN=request.getParameter("MISC_MSISDN");
		String sql="select c.TeamId,sum(d.Integral) from wap_Single_Team c, wap_User d where c.UserId=d.Id and c.TeamId= ( select a.Id from wap_Team a,wap_User b where a.Creator=b.Id and b.Mobile='"+MISC_MSISDN+"') group by c.TeamId";
		ResultSet rs;
		rs=connSql.executeQuery(sql);
		rs.next();
		String tId=rs.getString(1);
		String integral=rs.getString(2);
		
		%>  
   <p align="center">PK鐜板満</p>
   <p align="center">~~~~~~~~~~~~~~</p>
  
   <p> 
   <img src="/soccer/images/shanshui.png" alt="shanshui.png"/>
   </p> 
   <p>
   	鏈