?? 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 + -