📄 paperorder.jsp
字号:
<%@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 + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -