【JSP开源代码栏目提醒】:网学会员鉴于大家对JSP开源代码十分关注,论文会员在此为大家搜集整理了“booksend.jsp”一文,供大家参考学习
<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*,java.io.*"%>
<%@ include file="include.inc"%>
<%session.setAttribute("username",session.getAttribute("username"));%>
<html>
<style type="text/css">
<!--
.style1 {font-size: 18px}
-->
</style>
<body>
<%
Class.forName(CLASSFORNAME);
Connection con=DriverManager.getConnection(SERVER,USER,PWD);
Statement stmt=con.createStatement();
String type[]=request.getParameterValues("type");
String type2[]=request.getParameterValues("type2");
String type3[]=request.getParameterValues("type3");
%>
<%
if(type!=null)
{
for(int i=0;i<type.length;i++)
{
String aa=type[i];
try
{
stmt.executeQuery("update tb_book set "+aa+"= "+aa+" + 1 where id=1");
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
if(type2!=null)
{
for(int i=0;i<type2.length;i++)
{
String aa=type2[i];
try
{
stmt.executeQuery("update tb_language set "+aa+"= "+aa+" + 1 where id=1");
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
if(type3!=null)
{
for(int i=0;i<type3.length;i++)
{
String aa=type3[i];
try
{
stmt.executeQuery("update tb_borrowbook set "+aa+"= "+aa+" + 1 where id=1");
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
%>
<%
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>
<p align="center" class="style1"><a href="tuichu.jsp">退出</a></p>
</body>
</html>
上一篇:
Books2.jsp
下一篇:
论电子商务与现代物流的协同发展