getua.jsp

无线应用协议的应用,功能为图铃下载,为手机用户提供更新平台

<%@ page contentType="text/vnd.wap.wml;charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@page import="java.util.Date"%>
<%@page import="java.util.*"%>
<%@page import="java.text.*"%>
<%@ include file="inc/conn.jsp" %>
<?xml version="1.0" encoding="gb2312" ?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN" "http://www.wapforum.org/DTD/wml_1.1.xml">
<wml>
<card id="card01" title="unimg">


<%
String mid = request.getParameter("MISC_MID");
String ua  = request.getHeader("USER-AGENT"); 

/*
String ssex,scode;
ssex="1";//默认为男
scode="123";//密码默认为123
*/

/*************  调试后停止注释
Date currTime = new Date();
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
String login_time=new String(formatter.format(currTime).getBytes("iso-8859-1"));
//if(mid.equals("")||ua.equals(""))
String sql="";
String err="";
sql="if(not exists (select Mid from wap_ua where Mid='"+mid+"'))";
sql+="insert into yltb_ua (Mid,Ua,Login_time) values ('"+mid+"','"+ua+"','"+login_time+"')";
    try
	{
stmt.executeUpdate(sql);
    }
	catch (SQLException ex)
	{
err = ("Database.executeUpdate:" + sql + ex.getMessage());
		System.err.println(err);
    }
**********/
//提取图片类
//String getpictype="select type from pic";
String getpictype="SELECT DISTINCT type FROM pic";


rs=stmt.executeQuery(getpictype);
rs.next();
int intPageSize; 
int intRowCount; 
int intPageCount; 
int intPage; 
String strPage;
int i;
intPageSize = 20;
strPage = request.getParameter("page");
if(strPage==null){
intPage = 1;
}
else
{
intPage = Integer.parseInt(strPage);
if(intPage<1){ intPage = 1;}
}
rs.last(); 
intRowCount = rs.getRow(); 
intPageCount =(intRowCount+intPageSize-1) / intPageSize;
if(intPage>intPageCount) intPage = intPageCount;
if(intPageCount>0){
rs.absolute((intPage-1) * intPageSize+1); 
i = 0; 
while(i< intPageSize && !rs.isAfterLast())

{

String rs_type = rs.getString("type");
%>
<p>

<a href="pic_list.jsp?TYPE=<%=rs_type%>"><%=rs_type%></a><br/>


</p>


  <% 
rs.next(); 
   i++; 
  } 
  }
rs.close();
stmt.close(); 
conn.close();
%>
<p>
 <a href="about.jsp" >业务说明</a><br/>
 <a href="http://wap.gd.monternet.com" >广东风采</a><br/>
<br/>
</p>
</card>
</wml>