homebk.jsp

wap站点源码

<?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.*"%>
<%@page import="java.lang.Math.*"%>
<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 isExist="select Code from wap_User where Mobile='"+MISC_MSISDN+"'";
		ResultSet rs;
		rs=connSql.executeQuery(isExist);
		if (!rs.next()){
			boolean isHave=true;
			String aZero="000000";
			String strn="";
			String aId="";
			ResultSet rs1;
			while (isHave){
				strn=Integer.toString((int)(1000000*Math.random()));
				aId=aZero.substring(0,(6-strn.length()))+strn;
				
				isExist="select Code from wap_User where Code='"+aId+"'";
				rs1=connSql.executeQuery(isExist);
				if (rs1.next()){
					isHave=true;
					}
				else{
					isHave=false;
					}
			}
			String sql="insert into wap_User(Mobile,Code,Integral) values('"+MISC_MSISDN+"','"+aId+"',1000)";
			connSql.executeInsert(sql);
			
		}
		
		String sql2="insert into wap_Log(User_Id,Node_Id) select Id,10 from wap_User where Mobile='"+MISC_MSISDN+"'";
		connSql.executeInsert(sql2);
		connSql.commit();
		%>  
   <p align="center">姊﹀够涓栫晫鏉