add.jsp

来自「新闻发布系统1.0 第一步:解开压缩包」· JSP 代码 · 共 57 行

JSP
57
字号
<html>
<%@ page contentType="text/html;charset=gb2312" %>
<head>
	<title>输入数据页面</title>
</head>
<body bgcolor="#FFFFFF" text="#800080" vlink="#0000FF">

<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="sqlbean" scope="page" class="news.sql_data"/>
<font color="navy" face="Arial">
<h2 align="center"><br>
</font><font color="#000000" face="Arial" size="4"><strong>Add New Data</strong></font><font color="navy"></h2>
</font>
<form method="post" action="insert.jsp">
  <font face="arial" size="2" color="#000080"><div align="center">
  <center>
  <p>
  <b>类目:</b>
<% String sql,classname;
sql = "select * from class";
ResultSet rs = sqlbean.executeQuery(sql);
out.print("<SELECT  name='class'>");
int i=0;
while(rs.next())
{
i++;
classname = (String)rs.getString("class");
out.print("<OPTION value='");
out.print(classname);
out.print("'>");
out.print(classname);
out.print("</OPTION>");
 }
rs.close();
out.print("</SELECT>");
%>
  <p>
  <b>标题:</b>
  <input name="title" size="37">
  <p>
  <b>文章:</b>
  <textarea rows="8" name="news" cols="36"></textarea><br>
  <input type="submit" value="submit" name="submit" size="25">
  </font>&nbsp; <font face="arial"><input type="reset" value="clear" name="clear" size="25">
  </font><br>
  <br>
  </font><font face="Arial" size="2" color="#000080">
  <b>There Are <%= i%> Data Entries</b> 
  <br>
  </font><font face="Arial" color="navy" size="2">
  <a href="main.jsp">&lt;Back To Main Page</a></p>
  </center></div>
</form>
</font>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?