?? edit_file.jsp
字號:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="conn.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>
<%
if(session.getAttribute("adminname")==null)
{response.sendRedirect("sorry.jsp");}
%>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>修改文件</title>
<link rel="stylesheet" type="text/css" href="../Admin_Style.css">
<script language="javascript">
function YanZheng()
{
if (myform.Title.value=="")
{alert("標題不能為空！");myform.Title.focus();return false}
if (myform.Synopsis.value=="")
{alert("簡介不能為空");myform.Synopsis.focus();return false}
if (myform.Introduce.value=="")
{alert("詳細介紹不能為空");myform.Introduce.focus();return false}
</script>
<!--
var flag=false;
function DrawImage(ImgD){
var image=new Image();
image.src=ImgD.src;
if(image.width>0 && image.height>0){
flag=true;
if(image.width/image.height>= 200/150){
if(image.width>200){
ImgD.width=200;
ImgD.height=(image.height*200)/image.width;
}else{
ImgD.width=image.width;
ImgD.height=image.height;
}
ImgD.alt=image.width+"×"+image.height;
}
else{
if(image.height>150){
ImgD.height=150;
ImgD.width=(image.width*150)/image.height;
}else{
ImgD.width=image.width;
ImgD.height=image.height;
}
ImgD.alt=image.width+"×"+image.height;
}
}
}
//-->
</script>
</head>
<body background="img/beijing.gif">
<jsp:include page="Menu.jsp" flush="true"/>
<br>
<%
//得到id
String File_ID=request.getParameter("id");
//連接查詢
String condition="select S_fileInfor.column_id,file_id,file_title,";
condition+="file_synopsis,file_introduce,file_date,file_name,";
condition+="S_fileColumn.column_name from S_fileInfor,S_fileColumn ";
condition+="where S_fileInfor.column_id=S_fileColumn.column_id and file_id='"+File_ID+"'";
ResultSet fs=stmt.executeQuery(condition);
fs.first();
String File_Title=fs.getString("file_title");
String File_Synopsis=fs.getString("file_synopsis");
String FIle_Introduce=fs.getString("file_introduce");
String File_Date=fs.getString("file_date");
String File_Name=fs.getString("file_name");
String Column_Name=fs.getString("column_name");
String ColumnID=String.valueOf(fs.getInt("column_id"));
fs.close();
fs=null;
%>
</table>
<form name="myform" method="post" action="Operate_File.jsp?EditType=fileEdit&id=<%=File_ID%>&file=<%=File_Name%>" enctype="multipart/form-data" onSubmit="return YanZheng()">
<table width="77%" height="262" border="0" align="center" cellpadding="2" cellspacing="1">
<tr>
<td height="47" colspan="2"><div align="center"><strong>資料修改</strong></div></td>
</tr>
<tr>
<td height="25"><div align="right">欄目： </div></td>
<td height="25">
<%
String sql="select * from S_fileColumn";
rs=stmt.executeQuery(sql);
rs.beforeFirst();%>
<select name="Column_ID">
<option value="<%=ColumnID%>">請選擇欄目</option>
<%
while(rs.next())
{
String column_id = String.valueOf(rs.getInt("column_id"));//欄目id
String column_name = rs.getString("column_name");//欄目名
%>
<option value="<%=column_id%>"><%=column_name%></option>
<%}%>
</select>
原屬于 <%= Column_Name%>欄目</td>
</tr>
<tr>
<td width="114" height="33" align="right" valign="middle"><div align="right">標題：</div></td>
<td width="476"><input name="Title" type="text" value="<%= File_Title %>" size="50" maxlength="50"></td>
</tr>
<tr>
<td width="114" height="33" align="right" valign="middle"><div align="right">上傳日期：</div></td>
<td width="476"><input name="Date" type="text" value="<%= File_Date %>" size="50" maxlength="50"></td>
</tr>
<tr>
<td width="114" height="33" align="right" valign="middle"><div align="right">簡介：</div></td>
<td width="476"><input name="Synopsis" type="text" size="50" maxlength="100" value="<%= File_Synopsis %>"></td>
</tr>
<tr>
<td width="114" height="33" align="right" valign="middle"><div align="right">詳細介紹：</div></td>
<td width="476"><textarea name="Introduce" cols="48" rows="5"><%= FIle_Introduce %></textarea></td>
</tr>
<tr>
<td width="114" height="33" align="right" valign="middle"><div align="right">當前文件名為：</div></td>
<td width="476"><%=File_Name%></td>
</tr>
<tr>
<td width="114" height="33" align="right" valign="middle"><div align="right">重新上傳：</div></td>
<td width="476"><input type="file" name="File" size="40"></td>
</tr>
<tr>
<td height="24" colspan="2" align="right" valign="middle"> <div align="center">
<input type="submit" name="Submit1" value=" 確 定 ">
<input type="reset" name="Submit2" value="重置" >
<input type="button" name="Submit2" value="取消" onclick="history.back()">
</div></td>
</tr>
<tr>
<td height="25" colspan="2" align="right" valign="middle"> </td>
</tr>
<tr align="center"><td align="center" valign="middle"><a href="picture1.jsp"></a>返回個人相冊</td></tr>
</table>
</form>
</body>
<%
rs.close();
rs=null;
stmt.close();
conn.close();
%>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -