📄 vouch.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="../error/error.jsp" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html >
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>图书评比</title>
<jsp:useBean id="books" class="BookShop.MyDb" scope="page"/><link rel="stylesheet" type="text/css" href="../css/bs.css"/>
<script language="javascript" src="../css/bs.js"></script>
<%!
String idbook,bookname,sqlu,tidbook,host,select;
int vote,temp;
%>
</head>
<body topmargin="0">
<p> </p>
<table width="556" border="1" align="center" cellpadding="-1" cellspacing="0" bordercolor="#FFFFFF" bordercolorlight="#0066ff" bordercolordark="#FFFFFF" >
<caption>
<div class="two">读者推荐</div>
<p></p>
</caption>
<tr>
<td width="383" height="27" align="center">图书列表</td>
<td width="167" height="27" align="center">推荐人数</td>
</tr>
<%
//没有当前图书增加新图书
select=(String)request.getParameter("select");
bookname=(String)request.getParameter("bookname");
select=books.inStr(select);
bookname=books.inStr(bookname);
boolean flag=false;
if(bookname!=null&&bookname!=""){
flag=true;
}
if(flag){
String sqls1="SELECT bookname,vote FROM vouch WHERE bookname='"+bookname+"'";
String sqli="INSERT INTO vouch(bookname) VALUES('"+bookname+"')";
Statement stmt=books.getstmtread();
ResultSet rs=stmt.executeQuery(sqls1);
if(!rs.next()){
//没有当前图书增加书名
books.close();
Statement stmt1=books.getstmt();
temp=stmt1.executeUpdate(sqli);
if(temp<=0){
session.setAttribute("error","系统有误请您重新输入");
response.sendRedirect("../error/errorpage.jsp");
}
books.close();
}else{
//有当前图书增加票数
rs.beforeFirst();
if(rs.next()){
vote=rs.getInt(2);
vote++;
books.close();
String sqlu="UPDATE vouch SET vote="+vote+" WHERE bookname='"+bookname+"'";
Statement stmt2=books.getstmt();
temp=0;
temp=stmt2.executeUpdate(sqlu);
if(temp<=0){
response.sendRedirect("../error/errorpage.jsp");
session.setAttribute("error","系统有误请您重新输入");
}
books.close();
}
}//if rs.next
}//if flag
//查看推荐图书
String sqls="SELECT bookname,vote FROM vouch ";
Statement stmt2=books.getstmtread();
ResultSet rs2=stmt2.executeQuery(sqls);
if(!rs2.next()){
%>
<tr>
<td height="40" colspan="2" align="center" class="red12">暂无读者推荐图书</td>
</tr>
<%
books.close();
}else{
rs2.beforeFirst();
%>
<form action="" method="post" name="form1" >
<tr>
<td height="27" align="center" valign="middle">
<select name="select" onChange="Jscript:submit()">
<%
while(rs2.next()){
bookname=rs2.getString(1);
%>
<option value="<%=bookname%>"
<%
if(bookname.equals(select)) out.print("selected");
%>
><%=bookname%></option>
<%
}
rs2.beforeFirst();
if(rs2.next()){
bookname=rs2.getString(1);
}
books.close();
if(select==""){
select=bookname;
}
%>
</select>
</td>
<td height="27" align="center">
<%
String sqls2="SELECT vote FROM vouch WHERE bookname='"+select+"'";
stmt2=books.getstmtread();
rs2=stmt2.executeQuery(sqls2);
if(rs2.next()){
vote=rs2.getInt(1);
out.print(vote);
}
books.close();
%> </td>
</tr>
</form>
<%
}
// pageContext.removeAttribute("books");
%>
<form action="" method="post" name="form2" onSubmit="return vouch()">
<tr>
<td height="30" colspan="2" align="center"> <input name="bookname" type="text" size="30" maxlength="40" value=""></td>
</tr>
<tr valign="middle">
<td height="58" align="center" colspan="2"> <input type="submit" name="Submit" value="推荐" > </td>
</tr>
</form>
<tr align="center" valign="middle">
<td height="59" class="red12" colspan="2">以上是广大读者自己向大家推荐的图书，你也可以在这里添加您认为最喜爱的书！！！</td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -