📄 addsoft.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);
%>
<!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?action=add"><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()){
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()){
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"></td>
<td height="30" align="right"><strong>运行环境:</strong></td>
<td height="30"> <SELECT name="yxhj" size="1">
<OPTION value="ASP+ACCESS" name="yxhj" selected>ASP+ACCESS</OPTION>
<OPTION value="ASP+SQLServer" name="yxhj">ASP+SQLServer</OPTION>
<OPTION value="PHP+文本" name="yxhj">PHP+文本</OPTION>
<OPTION value="PHP+MYSQL" name="yxhj">PHP+MYSQL</OPTION>
<OPTION value="JSP环境" name="yxhj">JSP环境</OPTION>
<OPTION value="CGI环境" name="yxhj">CGI环境</OPTION>
<OPTION value=".NET环境" name="yxhj">.NET环境</OPTION>
<OPTION value="Win9x/WinNT/Win2000/WinXP/Win2003" name="yxhj">Win9x/WinNT/Win2000/WinXP/Win2003</OPTION>
<OPTION value="WinNT/Win2000/WinXP/Win2003" name="yxhj">WinNT/Win2000/WinXP/Win2003</OPTION>
<OPTION value="Win9x" name="yxhj">Win9x</OPTION><OPTION value="Linux" name="yxhj">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">★★★★★</option>
<option value="4" selected>★★★★</option>
<option value="3">★★★</option>
<option value="2">★★</option>
<option value="1">★</option>
<option value="0">不评级</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="http://" ></td>
<td height="30" align="right"><strong>地址说明:</strong></td>
<td height="30"> <input name="urlsay" type="text" id="urlsay" value="点击下载"></td>
</tr>
<tr bgcolor="#D4DEF9">
<td height="30" align="right"><strong>软件大小:</strong></td>
<td height="30"> <input name="softsize" type="text" id="softsize" value="不详" onFocus="this.value='';" onBlur="this.value='不详';"></td>
<td height="30" align="right"><strong>程序演示:</strong></td>
<td height="30"> <input name="codeshow" type="text" id="codeshow" value="http://"></td>
</tr>
<tr bgcolor="#D4DEF9">
<td height="30" align="right"><strong>相关链接:</strong></td>
<td height="30"> <input name="abouturl" type="text" id="abouturl" value="http://"></td>
<td height="30" align="right"><strong>软件图片:</strong></td>
<td height="30"> <input name="images" type="text" id="images" value="images/ad261236.gif"></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="免费软件" selected>免费软件</option>
<option value="共享软件">共享软件</option>
<option value="破解软件">破解软件</option>
</select>
语言
<select name="lang" id="lang">
<option value="简体中文" selected>简体中文</option>
<option value="繁体中文">繁体中文</option>
<option value="英文">英文</option>
<option value="其它">其它</option>
</select>
推荐
<input name="tj" type="checkbox" id="tj" value="推荐">
精品
<input name="jp" type="checkbox" id="jp" value="精品">
级别
<select name="jb" id="jb">
<option value="免费软件" selected>免费软件</option>
<option value="收费软件">收费软件</option>
<option value="会员软件">会员软件</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"></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>
<%
//rs.close();
//rs2.clsoe();
stmt.close();
stmt2.close();
conn.close();
}
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -