📄 watch.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*,java.io.*"%>
<%@ include file="include.inc"%>
<html>
<body>
<%
Class.forName(CLASSFORNAME);
Connection con=DriverManager.getConnection(SERVER,USER,PWD);
Statement stmt=con.createStatement();
ResultSet rs1=stmt.executeQuery("select * from tb_book where id=1");
if(rs1.next())
{
%>
<center><h2>明日科技 图书市场调研卡</h2>
<table width="567" height="176">
<tr><td><h3>调查结果:</h3></tr></td>
<tr><td><h4>1、您经常购买的编程类图书属于哪一类？</h4></td></tr>
<tr><td>
开发手册类得票:<%=rs1.getString("kaifa")%>票<br>
百例类得票:<%=rs1.getString("baili")%>票<br>
技巧类:<%=rs1.getString("jiqiao")%>票<br>
实例集锦类:<%=rs1.getString("shili")%>票<br>
教程类：<%=rs1.getString("jiaocheng")%>票
</td></tr>
<%
}
ResultSet rs2=stmt.executeQuery("select * from tb_language where id=1");
if(rs2.next())
{
%>
<tr><td><h4>2、您使用下面哪种编程语言或工具？</h4></td></tr>
<tr><td>
VB得票:<%=rs2.getString("VB")%>票<br>
VC++得票:<%=rs2.getString("VC")%>票<br>
JAVA得票:<%=rs2.getString("JAVA")%>票<br>
DELPHI得票:<%=rs2.getString("DELPHI")%>票<br>
ASP得票：<%=rs2.getString("ASP")%>票<br>
ASP.NET得票：<%=rs2.getString("ASPNET")%>票<br>
JSP得票：<%=rs2.getString("JSP")%>票<br>
其他得票：<%=rs2.getString("OTHER")%>票
</td></tr>
<%
}
ResultSet rs3=stmt.executeQuery("select * from tb_borrowbook where id=1");
if(rs3.next())
{
%>
<tr><td><h4>3、您最愿意购买或借阅哪类图书?</h4></td></tr>
<tr><td>
入门类图书得票:<%=rs3.getString("rumen")%>票<br>
讲解+实例类得票:<%=rs3.getString("jiangjie")%>票<br>
完全实例类得票:<%=rs3.getString("wanquan")%>票<br>
百例型类得票:<%=rs3.getString("baili")%>票<br>
技巧类得票:<%=rs3.getString("jiqiao")%>票<br>
</td></tr>
<%}
%>
</table>
</body>
</hmtl>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -