?? channel_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.ChannelName.value=="")
{
window.alert("請輸入欄目名稱");
return false;
}
}
</script>
</head>
<body>
<br />
<a href="Channel_Manage.jsp">頻道欄目管理</a> | <a href="Channel_Add.jsp">頻道欄目添加</a>
<hr color="#0099FF" size="1" />
<%
String ID=request.getParameter("ID");
if ((request.getParameter("ChannelName")!=null) )
{
String ChannelName=new String(request.getParameter("ChannelName").getBytes("iso-8859-1"));
String OrderID=new String(request.getParameter("OrderID").getBytes("iso-8859-1"));
String ReadMe=new String(request.getParameter("ReadMe").getBytes("iso-8859-1"));
String Place=new String(request.getParameter("Place").getBytes("iso-8859-1"));
String ViewType=new String(request.getParameter("ViewType").getBytes("iso-8859-1"));
String LinkUrl=new String(request.getParameter("LinkUrl").getBytes("iso-8859-1"));
String ContentTittle=new String(request.getParameter("ContentTittle").getBytes("iso-8859-1"));
String Content=new String(request.getParameter("Content").getBytes("iso-8859-1"));
Statement stmtU=conn.createStatement();
String SqlU="update tChannel set fChannelName='"+ChannelName+"',fOrderID='"+OrderID+"',fReadMe ='" +ReadMe +"', fPlace='"+Place+"',fViewType='"+ViewType+"',fLinkUrl='"+LinkUrl+"',fContentTittle='"+ContentTittle+"',fContent='"+Content+"' where fChannelID="+ ID;
int gai = stmtU.executeUpdate(SqlU);
stmtU.close();
if (gai>0)
{
out.print("<p align='center'>頻道欄目更改成功</p>");
}
}
Statement stmtChannel=conn.createStatement();
String Sql="Select * from tChannel where fChannelID=" + ID ;
ResultSet RsChannel= stmtChannel.executeQuery(Sql);
RsChannel.next();
%>
<form id="form1" name="form1" method="post" action="" onsubmit="return form1_onsubmit()">
<table width="750" border="0" align="center">
<tr>
<td>頻道欄目名稱：</td>
<td><input type="text" name="ChannelName" value="<%=RsChannel.getString("fChannelName")%>" /></td>
</tr>
<tr>
<td>排序ID：</td>
<td><input name="OrderID" type="text" value="<%=RsChannel.getInt("fOrderID")%>" /></td>
</tr>
<tr>
<td>顯示位置：</td>
<td>
<%if (RsChannel.getString("fPlace").equals("0"))
{ %>
<input name="Place" type="radio" value="0" checked="checked" />
網(wǎng)頁上部
<input type="radio" name="Place" value="1" />
網(wǎng)頁下部
<% }else{ %>
<input name="Place" type="radio" value="0"/>
網(wǎng)頁上部
<input type="radio" name="Place" value="1" checked="checked" />
網(wǎng)頁下部
<% }%> </td>
</tr>
<tr>
<td>顯示方式：</td>
<td>
<%if (RsChannel.getString("fViewType").equals("0"))
{
%>
<input name="ViewType" type="radio" value="0" checked="checked" />
鏈接地址
<input type="radio" name="ViewType" value="1" />
內容頁
<% }else{ %>
<input name="ViewType" type="radio" value="0"/>
鏈接地址
<input type="radio" name="ViewType" value="1" checked="checked" />
內容頁
<% } %> </td>
</tr>
<tr>
<td>鏈接地址：</td>
<td><input name="LinkUrl" type="text" id="LinkUrl" size="50" value="<%=RsChannel.getString("fLinkUrl")%>"/></td>
</tr>
<tr>
<td>欄目簡介：</td>
<td><textarea name="ReadMe" cols="60" rows="6"><%=RsChannel.getString("fReadMe")%></textarea></td>
</tr>
<tr>
<td>欄目標題：</td>
<td><input name="ContentTittle" type="text" value="<%=RsChannel.getString("fContentTittle")%>"></td>
</tr>
<tr>
<td>欄目內容：</td>
<td><textarea name="Content" style="display:none"><%=RsChannel.getString("fContent")%></textarea>
<IFRAME ID="eWebEditor1" src="../DT_inc/Editor/eWebEditor.jsp?id=Content&style=standard" frameborder="0" scrolling="no" width="650" height="350"></IFRAME>
</td>
</tr>
<tr>
<td><input type="hidden" name="ID" value="<%=ID%>" /></td>
<td><input type="submit" name="Submit" value="提交" />
<input type="reset" name="Reset" value="重置" /></td>
</tr>
</table>
</form>
<p> </p>
</body>
</html>
<%
RsChannel.close();
stmtChannel.close();
conn.close();
%>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -