📄 editsoft.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="../conn.jsp" %>
<%if ((session.getAttribute("admin")==null)){
response.sendRedirect("admin.jsp");
}else{
String sql="select * from class order by classid";
ResultSet rs=stmt.executeQuery(sql);
Statement stmt2=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql2="select * from Nclass order by Nclassid";
ResultSet rs2=stmt2.executeQuery(sql2);
Statement stmt3=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql3="select * from download where id='"+request.getParameter("softid").trim()+"'";
ResultSet rs3=stmt3.executeQuery(sql3);
rs3.next();
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>编 辑 软 件</title>
<style type="text/css">
<!--
body {
background-color: #D4DEF9;
}
-->
</style>
<style type=text/css>
<!--
BODY{
margin:0px;
FONT-SIZE: 12px;
FONT-FAMILY: "宋体", "Verdana", "Arial", "Helvetica", "sans-serif";
scrollbar-face-color: #DEE3E7;
scrollbar-highlight-color: #FFFFFF;
scrollbar-shadow-color: #DEE3E7;
scrollbar-3dlight-color: #D1D7DC;
scrollbar-arrow-color: #006699;
scrollbar-track-color: #EFEFEF;
scrollbar-darkshadow-color: #98AAB1;
background-color: #D4DEF9;
}
table { border:0px; }
td { font:normal 12px 宋体; }
img { vertical-align:bottom; border:0px; }
a { font:normal 12px 宋体; color:#000000; text-decoration:none; }
a:hover { color:#428EFF;text-decoration:underline; }
.sec_menu { border-left:1px solid white; border-right:1px solid white; border-bottom:1px solid white; overflow:hidden; background:#D6DFF7; }
.menu_title { }
.menu_title span { position:relative; top:2px; left:8px; color:#215DC6; font-weight:bold; }
.menu_title2 { }
.menu_title2 span { position:relative; top:2px; left:8px; color:#428EFF; font-weight:bold; }
input,select,Textarea{
font-family:宋体,Verdana, Arial, Helvetica, sans-serif; font-size: 12px;}
}
.style1 {
color: #3D6DD3;
font-weight: bold;
}
-->
</style>
</head>
<body >
<p></p>
<table width="100%" height="169" border="0" cellpadding="0" cellspacing="0" bgcolor="#3D6DD3">
<tr>
<td valign="top"><form name="form1" method="post" action="save.jsp?softid=<%=request.getParameter("softid").trim()%>&action=edit"><table width="100%" height="100%" border="0" cellpadding="0" cellspacing="1">
<tr>
<td height="25" colspan="4" bgcolor="#D4DEF9"><div align="center">
<input type="submit" name="Submit" value="添加">
<input type="reset" name="Submit2" value="清除">
</div></td>
</tr>
<tr bgcolor="#D4DEF9">
<td width="12%" height="30" align="right"><strong>软件类型:</strong></td>
<td width="33%" height="30"> <select name="Classid" id="Classid">
<option value="==请选类型=="selected>==请选类型==</option>
<%while(rs.next()){
if ((rs.getString("classid")).equals(rs3.getString("classid"))){
out.print("<option value='"+rs.getString("classid")+"' selected>"+rs.getString("class")+"</option>");
}else{
out.print("<option value='"+rs.getString("classid")+"' >"+rs.getString("class")+"</option>");
}
}
rs.close();
%>
</select></td>
<td width="20%" height="30" align="right"><strong>选择分类:</strong></td>
<td width="35%" height="30"> <select name="Nclassid" id="Nclassid">
<option value="==请选分类=="selected>==请选分类==</option>
<%while(rs2.next()){
if ((rs2.getString("Nclassid")).equals(rs3.getString("Nclassid"))){
out.print("<option value='"+rs2.getString("Nclassid")+"' selected>"+rs2.getString("Nclass")+"</option>");
}else{
out.print("<option value='"+rs2.getString("Nclassid")+"' >"+rs2.getString("Nclass")+"</option>");
}
}
rs2.close();
%>
</select></td>
</tr>
<tr bgcolor="#D4DEF9">
<td height="30" align="right"><strong>软件名称:</strong></td>
<td height="30"> <input name="softname" type="text" id="softname" value="<%=rs3.getString("softname")%>"></td>
<td height="30" align="right"><strong>运行环境:</strong></td>
<td height="30"> <SELECT name="yxhj" size="1">
<OPTION value="ASP+ACCESS" name="yxhj"<%if ((rs3.getString("yxhj").trim()).equals("ASP+ACCESS")) {out.print("selected");}%> >ASP+ACCESS</OPTION>
<OPTION value="ASP+SQLServer" name="yxhj" <%if ((rs3.getString("yxhj").trim()).equals("ASP+SQLServer")) {out.print("selected");}%>>ASP+SQLServer</OPTION>
<OPTION value="PHP+文本" name="yxhj" <%if ((rs3.getString("yxhj").trim()).equals("PHP+文本")) {out.print("selected");}%>>PHP+文本</OPTION>
<OPTION value="PHP+MYSQL" name="yxhj" <%if ((rs3.getString("yxhj").trim()).equals("PHP+MYSQL")) {out.print("selected");}%>>PHP+MYSQL</OPTION>
<OPTION value="JSP环境" name="yxhj" <%if ((rs3.getString("yxhj").trim()).equals("JSP环境")) {out.print("selected");}%>>JSP环境</OPTION>
<OPTION value="CGI环境" name="yxhj" <%if ((rs3.getString("yxhj").trim()).equals("CGI环境")) {out.print("selected");}%>>CGI环境</OPTION>
<OPTION value=".NET环境" name="yxhj" <%if ((rs3.getString("yxhj").trim()).equals(".NET环境")) {out.print("selected");}%>>.NET环境</OPTION>
<OPTION value="Win9x/WinNT/Win2000/WinXP/Win2003" name="yxhj" <%if ((rs3.getString("yxhj").trim()).equals("Win9x/WinNT/Win2000/WinXP/Win2003")) {out.print("selected");}%>>Win9x/WinNT/Win2000/WinXP/Win2003</OPTION>
<OPTION value="WinNT/Win2000/WinXP/Win2003" name="yxhj" <%if ((rs3.getString("yxhj").trim()).equals("WinNT/Win2000/WinXP/Win2003")) {out.print("selected");}%>>WinNT/Win2000/WinXP/Win2003</OPTION>
<OPTION value="Win9x" name="yxhj" <%if ((rs3.getString("yxhj").trim()).equals("Win9x")) {out.print("selected");}%>>Win9x</OPTION>
<OPTION value="Linux" name="yxhj" <%if ((rs3.getString("yxhj").trim()).equals("Linux")) {out.print("selected");}%>>Linux</OPTION>
</SELECT></td>
</tr>
<tr bgcolor="#D4DEF9">
<td height="30" align="right"><strong>格式:</strong></td>
<td height="30"> [软件
<input name="radiobutton" type="radio" value="radiobutton" checked>
]</td>
<td height="30" align="right"><strong>推荐度:</strong></td>
<td height="30"> <select name="Grade" class="input" id="Grade">
<option value="5" <%if ((rs3.getString("grade").trim()).equals("5")) {out.print("selected");}%>>★★★★★</option>
<option value="4" <%if ((rs3.getString("grade").trim()).equals("4")) {out.print("selected");}%>>★★★★</option>
<option value="3" <%if ((rs3.getString("grade").trim()).equals("3")) {out.print("selected");}%>>★★★</option>
<option value="2" <%if ((rs3.getString("grade").trim()).equals("2")) {out.print("selected");}%>>★★</option>
<option value="1" <%if ((rs3.getString("grade").trim()).equals("1")) {out.print("selected");}%>>★</option>
<option value="0" <%if ((rs3.getString("grade").trim()).equals("0")) {out.print("selected");}%>>不评级</option>
</select></td>
</tr>
<tr bgcolor="#D4DEF9">
<td height="30" align="right"><strong>下载地址:</strong></td>
<td height="30"> <input name="downurl" type="text" id="downurl" value="<%=rs3.getString("downurl")%>" ></td>
<td height="30" align="right"><strong>地址说明:</strong></td>
<td height="30"> <input name="urlsay" type="text" id="urlsay" value="<%=rs3.getString("urlsay")%>"></td>
</tr>
<tr bgcolor="#D4DEF9">
<td height="30" align="right"><strong>软件大小:</strong></td>
<td height="30"> <input name="softsize" type="text" id="softsize" value="<%=rs3.getString("softsize")%>" ></td>
<td height="30" align="right"><strong>程序演示:</strong></td>
<td height="30"> <input name="codeshow" type="text" id="codeshow" value="<%=rs3.getString("codeshow")%>"></td>
</tr>
<tr bgcolor="#D4DEF9">
<td height="30" align="right"><strong>相关链接:</strong></td>
<td height="30"> <input name="abouturl" type="text" id="abouturl" value="<%=rs3.getString("abouturl")%>"></td>
<td height="30" align="right"><strong>软件图片:</strong></td>
<td height="30"> <input name="images" type="text" id="images" value="<%=rs3.getString("images")%>"></td>
</tr>
<tr bgcolor="#D4DEF9">
<td height="30" align="right"><strong>授权形式:</strong></td>
<td height="30" colspan="3">
<select name="sq" id="sq">
<option value="免费软件" <%if ((rs3.getString("sq").trim()).equals("免费软件")) {out.print("selected");}%>>免费软件</option>
<option value="共享软件" <%if ((rs3.getString("sq").trim()).equals("共享软件")) {out.print("selected");}%>>共享软件</option>
<option value="破解软件" <%if ((rs3.getString("sq").trim()).equals("破解软件")) {out.print("selected");}%>>破解软件</option>
</select>
语言
<select name="lang" id="lang">
<option value="简体中文" <%if ((rs3.getString("jb").trim()).equals("简体中文")) {out.print("selected");}%>>简体中文</option>
<option value="繁体中文" <%if ((rs3.getString("jb").trim()).equals("繁体中文")) {out.print("selected");}%>>繁体中文</option>
<option value="英文" <%if ((rs3.getString("jb").trim()).equals("英文")) {out.print("selected");}%>>英文</option>
<option value="其它" <%if ((rs3.getString("jb").trim()).equals("其它")) {out.print("selected");}%>>其它</option>
</select>
推荐
<input name="tj" type="checkbox" id="tj" value="推荐"<%if ((rs3.getString("tj").trim()).equals("推荐")) {out.print("checked");}%>>
精品
<input name="jp" type="checkbox" id="jp" value="精品" <%if ((rs3.getString("tj").trim()).equals("精品")) {out.print("checked");}%>>
级别
<select name="jb" id="jb" >
<option value="免费软件" <%if ((rs3.getString("jb").trim()).equals("免费软件")) {out.print("selected");}%> >免费软件</option>
<option value="收费软件" <%if ((rs3.getString("jb").trim()).equals("收费软件")) {out.print("selected");}%>>收费软件</option>
<option value="会员软件" <%if ((rs3.getString("jb").trim()).equals("会员软件")) {out.print("selected");}%>>会员软件</option>
</select></td>
</tr>
<tr>
<td height="132" align="right" valign="top" bgcolor="#D4DEF9"><strong>软件简介:</strong></td>
<td colspan="3" bgcolor="#D4DEF9"> <textarea name="txtnote" cols="60" rows="8" id="txtnote"><%=rs3.getString("note")%>
</textarea></td>
</tr>
<tr>
<td colspan="4" bgcolor="#D4DEF9"> </td>
</tr>
<tr>
<td colspan="4" bgcolor="#D4DEF9"> </td>
</tr>
<tr>
<td colspan="4" bgcolor="#D4DEF9"><div align="center">
<input type="submit" name="Submit3" value="编辑">
<input type="reset" name="Submit22" value="清除">
</div></td>
</tr>
</table>
</form></td>
</tr>
</table>
</body>
</html>
<%
}
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -