Edit_file.jsp
资源名称:zyp.rar [点击查看]
上传用户:zdly666
上传日期:2022-08-09
资源大小:6511k
文件大小:5k
源码类别:
WEB源码(ASP,PHP,...)
开发平台:
JavaScript
- <%@ 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>