paperorder.jsp
来自「jsp动态网站开发与实例(第3版) 源码」· JSP 代码 · 共 75 行
JSP
75 行
<%@page contentType="text/html"%><%@page pageEncoding="GB2312"%><%@page import = "java.sql.*" %>
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:paper");
Statement smt =con.createStatement
(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String getpaperdata = "" ;
getpaperdata = "SELECT COUNT(*) as cc from list " ;
ResultSet paperrs =smt.executeQuery(getpaperdata) ;
paperrs.next() ;
%><html>
<head><title>订阅电子报</title></head>
<body>
<table border="0" width="100%">
<tr>
<td width="100%"><b><font size="5">订阅电子报</font></b>
<a href='paperlist.jsp'>[浏览]</a>
<hr>
</td>
</tr>
<tr>
<td width="100%">
<form method="POST" action="orderCheck.jsp">
订户名称:<input type="text" name="nameorder" size="20"><br>
电子邮件:<input type="text" name="mailorder" size="30"><br>
<br>
<input type="submit" value="订阅" name="order"></p>
</form>
</td>
</tr>
<tr>
<td width="100%"><b>已订阅数:<%=paperrs.getString("cc")%></b></td> </tr> <tr> <td width="100%"></td> </tr> <tr> <td width="100%"></td> </tr> </table> </body></html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?