?? editsoft.jsp
字號:
<%@ include file="../conn.jsp"%>
<%!
String replacenull(String a){
if(a==null){
return " ";
}else{
return a;
}
}
%>
<%!
String selected(String a,String b){
if(a.equals(b)){
return "selected";
}else{
return "";
}
}
%>
<%request.setCharacterEncoding("GB2312");
String classid=request.getParameter("classid");
String Nclassid=request.getParameter("Nclassid");
String did=request.getParameter("id");
if ((session.getValue("admin")==null)){
response.sendRedirect("login.jsp");
}else{
String aaa= (String) session.getValue("flag");
int ddd=Integer.parseInt(aaa);
if(ddd>2){
out.print("<br><p align=center>您沒有操作的權限</p>");
}else{
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>修 改 下 載 程 序</title>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<%
String sql="select * from scott.Nclass order by Nclassid asc";
ResultSet rs=stmt.executeQuery(sql);
%>
<SCRIPT language="JavaScript">
var onecount;
onecount=0;
subcat = new Array();
<%
int count = 0;
while(rs.next()){
%>
subcat[<%=count%>] = new Array("<%=rs.getString("Nclass")%>","<%=rs.getString("classid")%>","<%=rs.getString("Nclassid")%>");
<%
count++;
}
rs.close();
%>
onecount=<%=count%>;
function changelocation(locationid)
{
document.myform.Nclassid.length = 0;
var locationid=locationid;
var i;
for (i=0;i < onecount; i++)
{
if (subcat[i][1] == locationid)
{
document.myform.Nclassid.options[document.myform.Nclassid.length] = new Option(subcat[i][0], subcat[i][2]);
}
}
}
</SCRIPT>
<body bgcolor=#FFFFFF>
<form method="POST" name="myform" action="adminsave.jsp?id=<%=request.getParameter("id")%>&action=edit">
<TABLE width="610" border="0" cellspacing="1">
<TR align="center" bgcolor="#E1F4EE">
<TD colspan="4" height="30"><b>
<input type="submit" value=" 添 加 "
name="cmdok2" class="buttonface">
<input type="reset" value=" 清 除 "
name="cmdcancel2" class="buttonface">
</b></TD>
</TR>
<tr>
<td width="72" align="right" valign="top" height="30" bgcolor="#E1F4EE"><b><font color="#FF0000">軟件類型：</font></b></td>
<td width="250" bgcolor="#E1F4EE" height="30">
<%sql="select * from scott.class ";
rs=stmt.executeQuery(sql);
%>
<SELECT name="classid" onChange="changelocation(document.myform.classid.options[document.myform.classid.selectedIndex].value)" size="1">
<%
while(rs.next()){
%>
<OPTION value="<%=rs.getString("classid")%>" <%=selected(rs.getString("classid"),classid)%> ><%=rs.getString("class")%></OPTION>
<%
}
rs.close();
%>
</SELECT>
</td>
<td width="67" bgcolor="#E1F4EE" align="right" height="30"> <B><font color="#FF0000">選擇分類：</font></B>
</td>
<td width="208" bgcolor="#E1F4EE" height="30">
<SELECT name="Nclassid" size="1">
<%sql="select * from scott.nclass ";
rs=stmt.executeQuery(sql);
while(rs.next()){
%>
<OPTION value="<%=rs.getString("nclassid")%>" <%=selected(rs.getString("nclassid"),Nclassid)%> ><%=rs.getString("nclass")%></OPTION>
<%
}
rs.close();
%>
</SELECT>
</td>
</tr>
<% sql="select * from scott.download where id='"+request.getParameter("id")+"'";
rs=stmt.executeQuery(sql);
if(rs.next()){
%>
<tr>
<td width="72" align="right" height="26" bgcolor="#E1F4EE"><b><font color="#FF0000">軟件</font></b><font color="#FF0000"><b>名稱：</b></font></td>
<td width="250" height="26" bgcolor="#E1F4EE"> <FONT color="#FF0000">
<input type="text" name="txtshowname" size="33"
class="smallinput" maxlength="100" value="<%=replacenull(rs.getString("showname"))%>">
</FONT></td>
<td width="67" height="26" bgcolor="#E1F4EE" align="right"> <b><font color="#FF0000">運行環境：</font></b></td>
<td width="208" height="26" bgcolor="#E1F4EE"> <FONT color="#FF0000">
<select name="system" size="1">
<option <%=selected(rs.getString("system"),"Win9x/WinNT/Win2000/WinXP/WinME")%> value="Win9x/WinNT/Win2000/WinXP/WinME" name="system"><font color="#FF0000">Win9x/WinNT/Win2000/WinXP/WinME</font></option>
<option <%=selected(rs.getString("system"),"Win9x/WinNT/Win2000/WinME")%> value="Win9x/WinNT/Win2000/WinME" name="system"><font color="#FF0000">Win9x/WinNT/Win2000/WinME</font></option>
<option <%=selected(rs.getString("system"),"Win9x/WinNT/Win2000")%> value="Win9x/WinNT/Win2000" name="system"><font color="#FF0000">Win9x/WinNT/Win2000</font></option>
<option <%=selected(rs.getString("system"),"Win9x/WinNT")%> value="Win9x/WinNT" name="system"><font color="#FF0000">Win9x/WinNT</font></option>
<option <%=selected(rs.getString("system"),"Win9x/WinME")%> value="Win9x/WinME" name="system"><font color="#FF0000">Win9x/WinME</font></option>
</select>
</FONT> </td>
</tr>
<tr>
<td width="72" align="right" height="30" nowrap bgcolor="#E1F4EE">格式:</td>
<td width="250" height="30" bgcolor="#E1F4EE"> [軟件
<input type="radio" value="" name="movie" checked>
] </td>
<td width="67" height="30" bgcolor="#E1F4EE"><b><font color="#FF0000">推薦度：</font></b></td>
<td width="208" height="30" bgcolor="#E1F4EE">
<select name="hot" size="1">
<option <%=selected(rs.getString("hot"),"1")%> value="1" name="hot">一星級</option>
<option <%=selected(rs.getString("hot"),"2")%> value="2" name="hot">二星級</option>
<option <%=selected(rs.getString("hot"),"3")%> value="3" name="hot">三星級</option>
<option <%=selected(rs.getString("hot"),"4")%> value="4" name="hot">四星級</option>
<option <%=selected(rs.getString("hot"),"5")%> value="5" name="hot">五星級</option>
</select>
<!--<input type="text" name="hot" size="60" class="smallinput" maxlength="100" value="3">-->
</td>
</tr>
<tr bgcolor="#E1F4EE">
<td width="72" align="right" height="30">
<div align="left"><b><font color="#FF0000">下載地址1</font>：
</b></div>
</td>
<td width="250" height="30">
<input type="text" name="txtfilename" size="35"
class="smallinput" maxlength="100" value="<%=replacenull(rs.getString("filename"))%>">
</td>
<td width="67" height="30"><b><font color="#FF0000">地址說明：</font></b></td>
<td width="208" height="30">
<input type="text" name="txtname" size="33"
class="smallinput" maxlength="100" value="<%=replacenull(rs.getString("txtname"))%>">
</td>
</tr>
<tr>
<td width="72" align="right" height="8" bgcolor="#E1F4EE"><b><font color="#FF0000">軟件大小：</font></b></td>
<td width="250" height="8" bgcolor="#E1F4EE">
<!--<input type="text" name="system" size="60" class="smallinput" maxlength="100" value="Win98/2000+PWS4&NT+IIS4/5">-->
<input type="text" name="size" size="33"
class="smallinput" maxlength="100" value="<%=replacenull(rs.getString("size1"))%>">
</td>
<td width="67" height="8" bgcolor="#E1F4EE" align="right"> <b>程序演示：</b>
</td>
<td height="8" bgcolor="#E1F4EE" width="208">
<input type="text" name="txtbb" size="33"
class="smallinput" maxlength="100" value="<%=replacenull(rs.getString("bb"))%>">
</td>
</tr>
<tr bgcolor="#E1F4EE">
<td width="72" align="right" height="30" bgcolor="#E1F4EE"><b>軟件來源：</b></td>
<td height="30" bgcolor="#E1F4EE" width="250">
<input type="text" name="fromurl" size="33"
class="smallinput" maxlength="100" value="<%=replacenull(rs.getString("fromurl"))%>">
</td>
<td height="30" bgcolor="#E1F4EE" width="67" align="right"><B>軟件圖片：</B></td>
<td height="30" bgcolor="#E1F4EE" width="208">
<INPUT type="text" name="images" size="33"
class="smallinput" maxlength="160" value="<%=replacenull(rs.getString("images"))%>">
</td>
</tr>
<tr bgcolor="#E1F4EE">
<td width="72" align="right" height="30"><b><font color="#FF0000">授權形式：</font></b></td>
<td height="30" colspan="3">
<select name="order" size="1">
<option selected value="免費軟件" name="orders">免費軟件</option>
</select>
<!--<input type="text" name="order" size="60" class="smallinput" maxlength="100" value="免費">-->
語言:
<select name="xxyf" size="1">
<option <%=selected(rs.getString("xxyf"),"簡體中文")%> value="簡體中文" name="xxyf">簡體中文</option>
<option <%=selected(rs.getString("xxyf"),"繁體中文")%> value="繁體中文" name="xxyf">繁體中文</option>
<option <%=selected(rs.getString("xxyf"),"英文")%> value="英文" name="xxyf">英文</option>
<option <%=selected(rs.getString("xxyf"),"其他")%> value="其他" name="xxyf">其他</option>
</select>
<!--<input type="text" name="xxyf" size="60" class="smallinput" maxlength="100" value="其他">-->
推薦
<input type="checkbox" name="hots" value="on" checked>
精品
<input type="checkbox" name="hide" value="on" >
會員
<select size="1" name="hy">
<option value="0" selected name="hy">免費軟件</option>
</select>
</td>
</tr>
<tr bgcolor="#E1F4EE">
<td width="72" align="right" valign="top" height="30"><b><font color="#FF0000">程序簡介</font>：</b></td>
<td colspan="3" height="30">
<textarea rows="6" name="txtnote" cols="82" class="smallarea">
<%=replacenull(rs.getString("note"))%>
</textarea>
</td>
</tr>
<input type="hidden" name="txtfilename1" size="82"
class="smallinput" maxlength="100" value="<%=replacenull(rs.getString("filename1"))%>">
<input type="hidden" name="txtname1" size="82"
class="smallinput" maxlength="100" value="<%=replacenull(rs.getString("txtname1"))%>">
<input type="hidden" name="txtfilename2" size="82"
class="smallinput" maxlength="100" value="<%=replacenull(rs.getString("filename2"))%>">
<input type="hidden" name="txtname2" size="82"
class="smallinput" maxlength="100" value="<%=replacenull(rs.getString("txtname2"))%>">
<input type="hidden" name="txtfilename3" size="82"
class="smallinput" maxlength="100" value="<%=replacenull(rs.getString("filename3"))%>">
<input type="hidden" name="txtname3" size="82"
class="smallinput" maxlength="100" value="<%=replacenull(rs.getString("txtname3"))%>">
<input type="hidden" name="txtfilename4" size="82"
class="smallinput" maxlength="100" value="<%=replacenull(rs.getString("filename4"))%>">
<input type="hidden" name="txtname4" size="82"
class="smallinput" maxlength="100" value="<%=replacenull(rs.getString("txtname4"))%>">
</table>
<div align="center"><center><p><input type="submit" value=" 添 加 "
name="cmdok" class="buttonface"> <input type="reset" value=" 清 除 "
name="cmdcancel" class="buttonface"></p>
</center></div>
<%} %>
</form>
</body>
</html>
<%
}
}
%>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -