📄 add.jsp
字号:
<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> <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"><Back To Main Page</a></p>
</center></div>
</form>
</font>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -