?? softedit.jsp
字號:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="check.jsp" %>
<script language=javascript src="mouse.js"></script>
<%
boolean admin = false;
if (String.valueOf(session.getAttribute("Urule")).compareTo("a")!=0){
admin = true;
//response.sendRedirect ("error.jsp?id=admin");
}
String op = "9";
if(request.getParameter("op")!=null){
op = request.getParameter("op");
}
String sql;
String id = "0";
if(request.getParameter("id")!=null){
id = request.getParameter("id");
}
if(op.compareTo("5")==0 && admin){
sql="select * from soft where ID="+request.getParameter("id");
sqlbean.executeQuery(sql);
if(sqlbean.next()){
%>
<html><head><title>修改軟件</title>
<LINK href="oa.css" rel=stylesheet>
</head>
<BODY >
<Script Language="javaScript">
function validate()
{
if (document.myform.softname.value=="")
{
alert("軟件名稱不能為空");
document.myform.softname.focus();
return false ;
}
if (document.myform.size.value=="")
{
alert("軟件大小不能為空");
document.myform.size.focus();
return false ;
}
if (document.myform.content.value=="")
{
alert("說明不能為空");
document.myform.content.focus();
return false ;
}
if (document.myform.url.value=="")
{
alert("文件連接不能為空");
document.myform.url.focus();
return false ;
}
}
</Script>
<form method="POST" action="softedit.jsp" name=myform onSubmit='return validate()'>
<INPUT TYPE="hidden" name="id" value="<%=id %>">
<INPUT TYPE="hidden" name="op" value="5">
<div align="center">
<TABLE border=1 bordercolorlight='000000' bordercolordark=#ffffff cellspacing=0 cellpadding=0
width="400" align=center>
<TR>
<TD height=20 width=60 bgColor=#efefef> 軟件名稱</TD>
<TD height=20>
<INPUT name="softname" size=20 class="txt" value="<%=sqlbean.getString("Name")%>">
</TD>
</TR>
<TR>
<TD height=20 width=60 bgColor=#efefef> 軟件大小</TD>
<TD height=20>
<INPUT name="size"
size=20 class="txt" value="<%=sqlbean.getString("size")%>">
</TD>
</TR>
<tr>
<TD height=20 width=60 bgColor=#efefef> 下載路徑</TD>
<td height="16"><input name="url" size="42" class="txt" value="<%=sqlbean.getString("url")%>"></td>
</tr>
<TR>
<TD height=20 width=60 bgColor=#efefef>
<div align="center">軟 件<BR><BR>簡 介</div>
</TD>
<TD height=20>
<TEXTAREA cols=41 name="content" rows=6 class="txt" style="overflow:auto">
<%=sqlbean.getString("Content")%>
</TEXTAREA>
</TD>
</TR>
<TR>
<TD height=20 width=60 bgColor=#efefef>
<div align="center"> 是否推薦</div>
</TD>
<TD height=20>
是<INPUT TYPE="radio" NAME="best" value="1"
<%if (sqlbean.getString("best").compareTo("1")==0) out.println (" checked");%>>
否<INPUT TYPE="radio" name="best" value="0"
<%if (sqlbean.getString("best").compareTo("0")==0) out.println (" checked");%>>
</TD>
</TR>
<tr>
<TD height=20 width=60 bgColor=#efefef> 提交表單</TD>
<td height="16"><input type="submit" value=" 提 交 " class="txt" name="edit"> <INPUT TYPE="reset" value=" 重 置 " class="txt"></td>
</tr>
<TD height=20 bgColor=#efefef colspan=2 align=center>
<a href="javascript:window.close()"><img src="images/close1_on.gif" border=0></a>
</TD>
</TR>
</table>
</div></form></body></html>
<% }
sqlbean.close();
}else if(op.compareTo("3")==0 && admin){ //del
sql ="delete from soft where ID="+request.getParameter("id");
sqlbean.executeUpdate(sql);
//out.println(sql);
sqlbean.close();
response.sendRedirect("soft.jsp");
out.println(sqlbean.showMsg("javascript:window.close();","文件已經成功刪除，即將關閉窗口……","系統提示"));
}else if(op.compareTo("2")==0 && admin){ //update
sql = "update soft set"
+" name='"+ sqlbean.to_8859_1(request.getParameter("softname"))
+"',content='"+sqlbean.to_8859_1(request.getParameter("content"))
+"',url='"+sqlbean.to_8859_1(request.getParameter("url"))
+"',size='"+sqlbean.to_8859_1(request.getParameter("size"))
+"',best='"+sqlbean.to_8859_1(request.getParameter("best"))
+"' where ID="+request.getParameter("id");
//out.println(sql);
sqlbean.executeUpdate(sql);
sqlbean.close();
out.println(sqlbean.showMsg("javascript:window.close();","文件已經成功修改，即將關閉窗口……","系統提示"));
}else if(op.compareTo("1")==0){ %>
<html><head><title>添加文件</title>
<link rel="stylesheet" href="oa.css">
<script language="javascript" src="ShowProcessBar.js"></script>
</head>
<BODY >
<script Language="javaScript">
function validate()
{
if (document.myform.softname.value=="")
{
alert("軟件名稱不能為空");
document.myform.softname.focus();
return false ;
}
if (document.myform.content.value=="")
{
alert("說明不能為空");
document.myform.content.focus();
return false ;
}
if (document.myform.url.value=="")
{
alert("文件連接不能為空");
document.myform.url.focus();
return false ;
}
}
</script>
<form method="post" action="softaddsave.jsp" enctype="multipart/form-data" name=myform onSubmit='return validate()'>
<div align="center">
<TABLE border=1 bordercolorlight='000000' bordercolordark=#ffffff cellspacing=0 cellpadding=0 align=center>
<TR>
<TD height=20 width=60 bgColor=#efefef> 軟件名稱</TD>
<TD height=20 bgColor=#efefef> <INPUT name="softname"
size=30 class="txt">
</TD>
</TR>
<TR>
<TD height=20 width=60 bgColor=#efefef>
<div align="center">軟 件<BR><BR>簡 介</div>
</TD>
<TD height=20 bgColor=#efefef>
<TEXTAREA cols=40 name="content" rows=6 class="txt" style="overflow:auto"></TEXTAREA>
</TD>
</TR>
<TR>
<TD height=20 width=60 bgColor=#efefef>
<div align="center"> 是否推薦</div>
</TD>
<TD height=20 bgColor=#efefef> 是<INPUT TYPE="radio" NAME="best" value="true"> 否<INPUT TYPE="radio" name="best" value="0" checked>
</TD>
</TR>
<tr>
<TD height=20 width=60 bgColor=#efefef> 軟件</TD>
<td height="16" bgColor=#efefef><input type="file" name="url" size="20" class="txt">
<input type="submit" value="開始上傳" name="B1" class="txt " IsShowProcessBar="True"></td>
</tr>
<TR>
<TD height=20 bgColor=#efefef colspan=2 align=center>
<a href="javascript:window.close()"><img src="images/close1_on.gif" border=0></a>
</TD>
</TR>
</table>
</div></form>
</body></html>
<% }else if(op.compareTo("4")==0){ //update
sql="select * from soft where ID="+request.getParameter("id");
sqlbean.executeQuery(sql);
if(sqlbean.next()){
%>
<html><head><title>查看軟件</title>
<LINK href="oa.css" rel=stylesheet>
</head>
<BODY >
<div align="center">
<TABLE border=1 bordercolorlight='000000' bordercolordark=#ffffff cellspacing=0 cellpadding=0
width="100%" align=center>
<TR>
<TD height=20 width=60 bgColor=#efefef> 軟件名稱</TD>
<TD height=20 ><%=sqlbean.getString("Name")%>
</TD>
</TR>
<TR>
<TD height=20 width=60 bgColor=#efefef> 軟件大小</TD>
<TD height=20><%=sqlbean.getString("size")%></TD>
</TR>
<tr>
<TD height=20 width=60 bgColor=#efefef> 下載路徑</TD>
<td height="16"><a href="<%=sqlbean.getString("url")%>" target=_blank>下載</a>
</tr>
<TR>
<TD height=20 width=60 bgColor=#efefef>
<div align="center">軟 件<BR><BR>簡 介</div>
</TD>
<TD height=20 ><%=sqlbean.getString("Content")%>
</TD>
</TR>
<TR>
<TD height=20 width=60 bgColor=#efefef>
<div align="center"> 是否推薦</div>
</TD>
<TD height=20>
是<INPUT TYPE="radio" NAME="best" value="1"
<%if (sqlbean.getString("best").compareTo("1")==0) out.println (" checked");%>>
否<INPUT TYPE="radio" name="best" value="0"
<%if (sqlbean.getString("best").compareTo("0")==0) out.println (" checked");%>>
</TD>
</TR>
<TR>
<TD height=20 width=60 bgColor=#efefef colspan=2 align=center>
<a href="javascript:window.close()"><img src="images/close1_on.gif" border=0></a>
</TD>
</TR>
</table></div>
</body></html>
<% } sqlbean.close();
}
if(!admin && op.compareTo("1")!=0 && op.compareTo("4")!=0){
out.println(sqlbean.showMsg("javascript:window.close()","可能您沒有權限如此操作！","系統提示"));
}
%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -