infmodify_do.jsp

采用JSP+Java Bean开发的基于MySQL数据库的计数器。 包含有动网165501条数据库。 可以限制每个用户记录的IP数

<%
/**
* Title:Lerx计数器(JSP+MySQL)
* Description:含有动网最新IP数据库 165501条 2004年11月5日更新，我找到的最新的也最合适的就是这个了，花了些时间处理导入到MySQL里。
* Copyright: Copyright (c) 2005
* Company:www.lerx.com,www.5z.com.cn,www.huafang.com.cn
* @author:[e-mail]() QQ:27723812
* @version 1.0
* 开发平台：红旗Linux4.1,JDK 1.5.0_04-b05,Tomcat 5.5.9,MySQL 3.23.58
* 完成时间：2005.12.2
*/
%>
<%@ page contentType="text/html;charset=gb2312" %>
<jsp:useBean id="MD5" scope="page" class="forum.MD5" /> 
<%@ page import="java.util.*" %> 
<%@ page import="java.util.Date" %>
<%@ page import="java.sql.*" %> 
<%@ include file="const.jsp" %>
<%@ include file="conn.jsp" %>
<%
request.setCharacterEncoding("GB2312");
String ps_id,ps_SiteName,ps_URL,ps_password,ps_email,ps_SQLCmd,ps_type,ps_SQLTmp;
int pi_InitNum;
ps_id = request.getParameter("id").trim();
ps_SiteName = request.getParameter("T_sitename").trim();
ps_password = request.getParameter("T_password").trim();
if (ps_password == null){
ps_password="";
}
else
{
ps_password=ps_password.trim();
}
if (ps_password.equals(""))
{
ps_SQLTmp="";
}
else
{
ps_password = MD5.getMD5ofStr(ps_password);
ps_SQLTmp=",password='" + ps_password + "'";
}

ps_URL = request.getParameter("T_url").trim();
ps_email = request.getParameter("T_email").trim();
pi_InitNum = Integer.valueOf(request.getParameter("T_initnum")).intValue(); 



ps_SQLCmd="update statuser set ";
ps_SQLCmd	=	ps_SQLCmd + "SiteName='" + ps_SiteName + "'";
ps_SQLCmd	=	ps_SQLCmd + ps_SQLTmp;
ps_SQLCmd	=	ps_SQLCmd + ",url='" + ps_URL + "'";
ps_SQLCmd	=	ps_SQLCmd + ",email='" + ps_email + "'";
ps_SQLCmd	=	ps_SQLCmd + ",InitIP='"+pi_InitNum+"'";
ps_SQLCmd	=	ps_SQLCmd + " where id='" + ps_id + "'";

stmt.executeUpdate(ps_SQLCmd);
%>
<%@ include file="disconn.jsp" %>
<meta http-equiv=refresh content=2;url=./infmodify.jsp?id=<%=ps_id%>><title>计数器信息修改成功</title><p align="center"><br>修改成功！</p>