team_guess_chipin1.jsp

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

<?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 matchid=request.getParameter("matchid");
		String mvc=request.getParameter("mvc");
		
		String sql="select sum(b.Integral) from wap_Single_Team a,wap_User b where a.UserId=b.Id and a.TeamId=(select a.Id from wap_Team a,wap_User b where a.Creator=b.Id and b.Mobile='"+MISC_MSISDN+"')";
		ResultSet rs;
		rs=connSql.executeQuery(sql);
		rs.next();
		%>  
   <p align="center">PK鐜板満</p>
   <p align="center">~~~~~~~~~~~~~~</p>
  
   <p>
   鐜板湪鐨勭Н鍒嗕负锛