📄 reg_setup.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" %>
<jsp:useBean id="data" scope="page" class="shop.data.conn" />
<%
String admin=(String)session.getValue("admin");
if(admin=="" || admin==null)
{%>
<script language="javascript">
alert("请登陆后再执行管理操作");
self.location="index.jsp";
</script>
<%}else{
String sql="select * from admin where admin='"+admin+"'";
ResultSet rs=data.executeQuery(sql);
if(!rs.next())
{%>
<script language="javascript">
alert("对不起，无此管理员帐号");
history.back();
</script>
<%}}%>
<%
String sql="select regtext from shopother";
ResultSet rs=data.executeQuery(sql);
rs.next();
String regtext=rs.getString("regtext");
rs.close();
%>
<style type="text/css">
<!-- @import url(../images/css.css); -->
</style>
<%
String queryid=request.getParameter("queryid");
if(queryid!="" && queryid!=null)
{
sql="delete from pwdquery where id='"+queryid+"'";
rs=data.executeQuery(sql);
response.sendRedirect("reg_setup.jsp");
}
%>
<%
String modeid=request.getParameter("modeid");
if(modeid!="" && modeid!=null)
{
sql="delete from mode where id='"+modeid+"'";
rs=data.executeQuery(sql);
response.sendRedirect("reg_setup.jsp");
}
%>
<table width="500" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="30" bgcolor="3969A5"><div align="center"><font color="#FFFFFF">注册条约设置</font></div></td>
</tr>
</table>
<table width="500" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="20"></td>
</tr>
<tr>
<td>
<form action="" method="post">
<input type="hidden" name="upregtext" value="">
<table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#999999">
<tr>
<td><table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td height="25" bgcolor="#EEEEEE"><div align="center"><font color="#0000FF">修改注册条约</font></div></td>
</tr>
<tr>
<td><div align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="15"></td>
</tr>
</table>
<textarea name="regtext" cols="50" rows="15"><%=regtext%></textarea></div><br><div align="center">
<input type="submit" value="修改" onClick="document.all.upregtext.value='true';" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
<input type="reset" value="重写" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="15"></td>
</tr>
</table>
</div></td>
</tr>
</table></td>
</tr>
</table></form>
<table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#999999">
<tr>
<td height="25" bgcolor="#EEEEEE"> <div align="center"><font color="#0000FF">管理密码提示问题</font></div></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#FFFFFF"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="10"> </td>
</tr>
</table>
<%
sql="select * from pwdquery";
rs=data.executeQuery(sql);
int id=0;
String pwdquery="";
while(rs.next())
{
id=rs.getInt("id");
pwdquery=rs.getString("pwdquery");
%>
<form action="query_save.jsp" method="post">
<input type="hidden" name="id" value="<%=id%>">
<table width="320" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="220" height="25"><div align="center">
<input type="text" name="pwdquery" size="25" maxlength="30" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="<%=pwdquery%>">
</div></td>
<td width="50"><div align="center"><input type="submit" value="修改" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></div></td>
<td width="50"><div align="center"><input type="button" value="删除" onClick="javascript:window.location='reg_setup.jsp?queryid=<%=id%>'" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></div></td>
</tr>
</table>
</form>
<%}%>
<form action="" method="post">
<input type="hidden" name="addquery" value="">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="25"><div align="center"><input type="text" name="query" size="25" maxlength="30" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
<input type="submit" value="添加" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" onClick="document.all.addquery.value='true';"></div></td>
</tr>
</table>
</form>
</td>
<td></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table><br>
<table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#999999">
<tr>
<td height="25" bgcolor="#EEEEEE"><div align="center"><font color="#0000FF">管理交易方式</font></div></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="10"></td>
</tr>
</table>
<%
sql="select * from mode";
rs=data.executeQuery(sql);
int i=0;
String mode="";
while(rs.next())
{
i=rs.getInt("id");
mode=rs.getString("mode");
%>
<form action="mode_save.jsp" method="post">
<input type="hidden" name="modeid" value="<%=i%>">
<table width="320" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="220" height="25"><div align="center"><input type="text" name="mode" size="25" maxlength="10" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="<%=mode%>"></div></td>
<td width="50"><div align="center"><input type="submit" value="修改" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></div></td>
<td width="50"><div align="center"><input type="button" value="删除" onClick="javascript:window.location='reg_setup.jsp?modeid=<%=i%>'"style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva"></div></td>
</tr>
</table>
</form>
<%} %>
<form action="" method="post">
<input type="hidden" name="addmode" value="">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="25"><div align="center"><input type="text" name="mode" size="25" maxlength="30" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
<input type="submit" value="添加" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" onClick="document.all.addmode.value='true';"></div></td>
</tr>
</table>
</form>
</td>
</tr>
</table></td>
</tr>
<tr>
<td height="20"></td>
</tr>
</table>
<table width="500" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="30" bgcolor="3969A5"> </td>
</tr>
</table>
<%
String upregtext=request.getParameter("upregtext");
if(upregtext!=null && upregtext.equals("true"))
{
String gettext=request.getParameter("regtext");
gettext=new String(gettext.getBytes("ISO8859_1"),"GBK");
sql="update shopother set regtext='"+gettext+"'";
rs=data.executeQuery(sql);
response.sendRedirect("reg_setup.jsp");
}
%>
<%
String addquery=request.getParameter("addquery");
if(addquery!=null && addquery.equals("true"))
{
String query=request.getParameter("query");
query=new String(query.getBytes("ISO8859_1"),"GBK");
sql="insert into pwdquery(pwdquery) values(\'"+query+"\')";
rs=data.executeQuery(sql);
response.sendRedirect("reg_setup.jsp");
}
%>
<%
String addmode=request.getParameter("addmode");
if(addmode!=null && addmode.equals("true"))
{
String getmode=request.getParameter("mode");
getmode=new String(getmode.getBytes("ISO8859_1"),"GBK");
sql="insert into mode(mode) values(\'"+getmode+"\')";
rs=data.executeQuery(sql);
response.sendRedirect("reg_setup.jsp");
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -