?? reg2.jsp
字號(hào):
<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="feng" scope="page" class="feng.jdbc" />
<%
/*
季風(fēng)流量統(tǒng)計(jì)系統(tǒng)1.0版(JSP)
程序作者:季風(fēng)
QQ:9183838
E-Mail:feng0904@163.com
網(wǎng)站:http://www.hxwa.net
*/
Connection con = feng.getConn();
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String id=request.getParameter("id") ;
String url=request.getParameter("url");
String txtemail=request.getParameter("txtemail");
String sql="select admin from InfoList where admin='"+id+"' or url='"+url+"'";
ResultSet rs = stmt.executeQuery(sql) ;
rs.last();
if (rs.getRow()>0) {
out.println("<script language=jscript>alert('該用戶名已存在或該網(wǎng)址已登記');history.back();</script>");
}
else {
String webname=request.getParameter("webname");
String pws=request.getParameter("pws");
String intro=request.getParameter("intro");
String keys=request.getParameter("keys");
String clas=request.getParameter("class");
id=feng.ex_chinese(id);
url=feng.ex_chinese(url);
txtemail=feng.ex_chinese(txtemail);
webname=feng.ex_chinese(webname);
pws=feng.ex_chinese(pws);
intro=feng.ex_chinese(intro);
keys=feng.ex_chinese(keys);
clas=feng.ex_chinese(clas);
sql="insert into InfoList(admin,email,password,name,url,typename,note2,keys) values('"+id+"','"+txtemail+"','"+pws+"','"+webname+"','"+url+"','"+clas+"','"+intro+"','"+keys+"')";//"','"+feng.gettime()+
stmt.executeUpdate(sql) ;
sql="insert into admin(username,password) values('"+id+"','"+pws+"')";
stmt.executeUpdate(sql) ;
// out.println("<font size=2 color=blue>謝謝您的注冊(cè),正在處理您的用戶信息,請(qǐng)稍后...</font><meta http-equiv='refresh' content='2;url=reg3.jsp'>");
%>
<form action=reg3.jsp method=post name=reg>
<input type=hidden name=id value="<%=id%>">
<input type=hidden name=oldid value="<%=id%>">
<input type=hidden name=keys value="<%=keys%>">
<input type=hidden name=cla value="<%=clas%>">
<input type=hidden name=oldintro value="<%=intro%>">
<input type=hidden name=webname value="<%=webname%>">
<input type=hidden name=url value="<%=url%>">
<input type=hidden name=mail value="<%=txtemail%>">
</form>
<script language=jscript>document.reg.submit()</script>
<%
}
try {
rs.close();
stmt.close();
con.close();
}
catch (Exception ex) {
}
%>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -