addsortnew.jsp

来自「JSP+ORACLE网站开发实例（下）.rar」· JSP 代码 · 共 56 行

<%@ include file="admintop.jsp"%>
<%@ include file="isadmin.jsp"%>
<form name="myform" method="post" action="savesortnew.jsp">
  <table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#000000">
    <tr> 
      <td height="30" colspan="2" bgcolor="#B1E1F3"> 
        <div align="center"><strong>添加栏目新闻</strong></div>
      </td>
    </tr>
    <tr> 
      <td>选择栏目分类:</td>
      <td> 
        <select name="sort">
          <option value="" selected>请选择分类</option>
          <% String sql; 
      sql="select * from scott.allsort order by id";
      ResultSet rst=stmt.executeQuery(sql); 
	  while(rst.next()) { 
		%>
          <option value="<%=rst.getString("id")%>"><%=rst.getString("sort")%></option>
          <% } %>
        </select>
      </td>
    </tr>
    <tr> 
      <td>栏目新闻标题:</td>
      <td>
        <input name="title" type="text" id="title">
      </td>
    </tr>
    <tr bgcolor="#B1E1F3"> 
      <td height="25" colspan="2"> 
        <div align="center"><strong>栏目新闻内容</strong></div>
      </td>
    </tr>
    <tr> 
      <td colspan="2">
        <div align="center"> 
          <textarea name="body" cols="70" rows="15" id="body"></textarea>
        </div>
      </td>
    </tr>
    <tr> 
      <td colspan="2"> 
        <div align="center"> 
          <input type="submit" name="ccc" value="提交">
          &nbsp;&nbsp;&nbsp;&nbsp;
          <input type="reset" name="Submit2" value="取消">
        </div>
      </td>
    </tr>
  </table>
</form>
</body>
</html>