📄 siteconfig_update.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@include file ="../DT_inc/ChkPwd.jsp"%>
<%@include file="../ConnDB.jsp"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta name="robots" content="noindex,nofollow" />
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>网站配置修改</title>
<link href="Style.css" rel="stylesheet" type="text/css" />
<script language="javascript">
function form1_onsubmit()
{
if (document.form1.SiteName.value=="")
{
window.alert("请输入站点名称");
return false;
}
}
// 修改编辑栏高度
function Textarea_Size(num,objname)
{
var obj=document.getElementById(objname)
if (parseInt(obj.rows)+num>=3) {
obj.rows = parseInt(obj.rows) + num;
}
if (num>0)
{
obj.width="90%";
}
}
</script>
</head>
<body>
<br />
<a href="SiteConfig_Info.jsp">站点信息</a> | <a href="SiteConfig_Update.jsp">信息修改</a>
<hr color="#0099FF" size="1" />
<%
if (request.getParameter("SiteName") != null)
{
String SiteName=new String(request.getParameter("SiteName").getBytes("iso-8859-1"));
String SiteUrl=new String(request.getParameter("SiteUrl").getBytes("iso-8859-1"));
String LogoUrl=new String(request.getParameter("LogoUrl").getBytes("iso-8859-1"));
String SiteTitle=new String(request.getParameter("SiteTitle").getBytes("iso-8859-1"));
String Copyright=new String(request.getParameter("Copyright").getBytes("iso-8859-1"));
String WebmasterName=new String(request.getParameter("WebmasterName").getBytes("iso-8859-1"));
String WebmasterEmail=new String(request.getParameter("WebmasterEmail").getBytes("iso-8859-1"));
String IsAddSiteProblem=new String(request.getParameter("IsAddSiteProblem").getBytes("iso-8859-1"));
String MetaKeywords=new String(request.getParameter("MetaKeywords").getBytes("iso-8859-1"));
String MetaDescription=new String(request.getParameter("MetaDescription").getBytes("iso-8859-1"));
Statement stmt_ConfigUpdate=conn.createStatement();
String Sql_U="update tSiteConfig set fSiteName='"+SiteName+"',fSiteUrl='"+SiteUrl+"',fLogoUrl='"+LogoUrl+"',fSiteTitle='"+SiteTitle+"',fCopyright='"+Copyright+"',fWebmasterName='"+WebmasterName+"',fWebmasterEmail='"+WebmasterEmail+"',fIsAddSiteProblem="+IsAddSiteProblem+",fMetaKeywords='"+MetaKeywords+"',fMetaDescription='"+MetaDescription+"'";
int gai=stmt_ConfigUpdate.executeUpdate(Sql_U);
stmt_ConfigUpdate.close();
if (gai>0)
{
out.print("<p align='center'>["+ SiteName +"]网站配置修改成功</p>");
}
}
Statement stmt_SiteConfig=conn.createStatement();
String Sql="Select * from tSiteConfig";
ResultSet RsSiteConfig=stmt_SiteConfig.executeQuery(Sql);
RsSiteConfig.next();
%>
<form id="form1" name="form1" method="post" action="" onsubmit="return form1_onsubmit()">
<table width="700" border="0" align="center">
<tr>
<td width="200">网站名称：</td>
<td><input name="SiteName" type="text" value="<%=RsSiteConfig.getString("fSiteName")%>" size="50"/></td>
</tr>
<tr>
<td>网站网址：</td>
<td><input name="SiteUrl" type="text" value="<%=RsSiteConfig.getString("fSiteUrl")%>" size="50"/>
* 输入 http:// </td>
</tr>
<tr>
<td>Logo地址：</td>
<td><input name="LogoUrl" type="text" value="<%=RsSiteConfig.getString("fLogoUrl")%>" size="50" /></td>
</tr>
<tr>
<td>网站标题：</td>
<td><textarea name="SiteTitle" cols="60" rows="6"><%=RsSiteConfig.getString("fSiteTitle")%></textarea></td>
</tr>
<tr>
<td>版权信息：</td>
<td>
<textarea name="Copyright" cols="60" rows="6" id="Copyright"><%=RsSiteConfig.getString("fCopyright")%></textarea>
<a href="javascript:Textarea_Size(-5,'Copyright')" title="减小编辑区">
<font face="Wingdings" size="3" color="#0000FF">ñ</font></a>
<a href="javascript:Textarea_Size(5,'Copyright')" title="增高编辑区">
<font face="Wingdings" size="3" color="#0000FF">ò</font></a>
</td>
</tr>
<tr>
<td>站长姓名：</td>
<td><input name="WebmasterName" type="text" value="<%=RsSiteConfig.getString("fWebmasterName")%>" /></td>
</tr>
<tr>
<td>站长信箱：</td>
<td><input name="WebmasterEmail" type="text" value="<%=RsSiteConfig.getString("fWebmasterEmail")%>" size="50" /></td>
</tr>
<tr>
<td>站点关键字<br />
(将被搜索引擎用来搜索您网站的关键内容<br />
每个关键字用英文逗号分隔) </td>
<td><textarea name="MetaKeywords" cols="60" rows="6" id="MetaKeywords"><%=RsSiteConfig.getString("fMetaKeywords")%></textarea>
<a href="javascript:Textarea_Size(-5,'MetaKeywords')" title="减小编辑区">
<font face="Wingdings" size="3" color="#0000FF">ñ</font></a>
<a href="javascript:Textarea_Size(5,'MetaKeywords')" title="增高编辑区">
<font face="Wingdings" size="3" color="#0000FF">ò</font></a>
</td>
</tr>
<tr>
<td>站点描述<br />
(将被搜索引擎用来说明您网站的主要内容)</td>
<td>
<textarea name="MetaDescription" cols="60" rows="6" id="MetaDescription"><%=RsSiteConfig.getString("fMetaDescription")%></textarea>
<a href="javascript:Textarea_Size(-5,'MetaDescription')" title="减小编辑区">
<font face="Wingdings" size="3" color="#0000FF">ñ</font></a>
<a href="javascript:Textarea_Size(5,'MetaDescription')" title="增高编辑区">
<font face="Wingdings" size="3" color="#0000FF">ò</font></a>
</td>
</tr>
<tr>
<td>问题网站报告提交设置：</td>
<td>
<%if (RsSiteConfig.getString("fIsAddSiteProblem").equals("1")) {%>
<input name="IsAddSiteProblem" type="radio" value="true" checked="checked" /> 开启
<input name="IsAddSiteProblem" type="radio" value="false" /> 禁止
<%}else{%>
<input name="IsAddSiteProblem" type="radio" value="true" /> 开启
<input name="IsAddSiteProblem" type="radio" value="false" checked="checked"/> 禁止
<%}%> </td>
</tr>
<tr>
<td></td>
<td><input type="submit" name="Submit" value="修 改" />
<input type="reset" name="Reset" value="重 置" /></td>
</tr>
</table>
</form>
<p> </p>
</body>
</html>
<%
RsSiteConfig.close();
stmt_SiteConfig.close();
conn.close();
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -