index.jsp

*JSP WAP 图铃下载系统* 铃声那里建表文件丢失

<%/******************************************************************


*****************************************************************/%>

<%@ page language="java" contentType="text/vnd.wap.wml;charset=gb2312" %>
<%@ page import="java.sql.*" errorPage=""%>
<%@ page import="java.util.Date"%>
<%@ page import="java.util.*"%>
<%@ page import="java.text.*"%>

<%@ include file="inc/conn.jsp" %>
<%
//为了得到网站名称

String sql_site = "";


sql_site = "select * from wap_site";
rs=stmt.executeQuery(sql_site);
rs.next();

    String rs_sitename = rs.getString("Site_name");





Date currTime = new Date();
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
String login_time=new String(formatter.format(currTime));


 String no1 = request.getParameter("x-up-calling-line-id"); 
//String no2 = request.getParameter("X_UP_CALLING_LINE_ID"); 




String sql="";
String err="";
sql="if(not exists (select Number from wap_no where Number='"+no1+"'))";
sql+="insert into wap_no (Number,Login_time) values ('"+no1+"','"+login_time+"')";
    try
	{
stmt.executeUpdate(sql);
    }
	catch (SQLException ex)
	{
err = ("Database.executeUpdate:" + sql + ex.getMessage());
		System.err.println(err);
    }










%>

<?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="<%=rs_sitename%>">
<%


%>
<p>
<br/>

<% 
//选取类名如遇重复的类名则只取一个
//String sql_type = "select  distinct(Type) as only from pic";

//String sql_type = "select  Type, count(*) as only from pic group by type";

String sql_type = "select type,count(*) from pic group by type";

rs=stmt.executeQuery(sql_type);
while (rs.next()) {

String rs_type  =  rs.getString("type");

//out.print(rs_type);

%>

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

<% 

}

rs.close();

	if(conn!=null)
	{
		conn.close();
	}
	if(stmt!=null)
	{
		stmt.close();
	}
%><br/>
<a href="search.jsp">查找</a><br/>
<%@ include file="noclassfoot.jsp"%>

</p>
</card>
</wml>