📄 out_book.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<jsp:useBean id="ConnBean" scope="page" class="com.bean.db.conn" />
<title>无标题文档</title>
<style type="text/css">
<!--
BODY {
BACKGROUND-IMAGE: none; BACKGROUND-COLOR: #ade3ff
}
.STYLE6 {
font-family: "楷体_GB2312";
color: #FF0000;
font-weight: bold;
}
-->
</style>
</head>
<%
try{
String str=request.getParameter("act");
String cid=request.getParameter("cid");
String bid=request.getParameter("bid");
String sql="";
if (str.equals("out"))
{
sql="select * from card where c_id='"+cid+"'";
ResultSet rsc = ConnBean.executeQuery(sql);
if(rsc.next())
{
sql="select * from book where bid='"+bid+"'";
ResultSet rsb = ConnBean.executeQuery(sql);
if(rsb.next())
{
sql="insert into out_book (Cid,bID) values ('"+cid+"','"+bid+"')";
if(ConnBean.execute(sql).equals("OK")){
out.println("<script language='javascript'>alert('借阅登记完成！');</script>");
String XXX=ConnBean.execute("update book set iosl=iosl+1 where bid='"+bid+"'");
}
}else{
out.println("<script language='javascript'>alert('请输入正确的图书编号！');</script>");
}
}else{
out.println("<script language='javascript'>alert('请输入正确的借书证号码！');</script>");
}
}
}
catch(Exception e){}
%>
<body>
<form id="form1" name="form1" method="post" action="?act=out"><div align="center">
<h2 align="center"> </h2>
<h2 align="center"> </h2>
<h2 align="center"><span class="STYLE6">图书借阅登记
<label></label>
</span><span class="STYLE6">
<label></label>
</span> </h2>
<label><br />
借书证编号
<input name="cid" type="text" id="cid" />
</label>
图书编号
<label>
<input name="bid" type="text" id="bid" />
</label>
<label>
<input type="submit" name="Submit" value="确定" />
</label></div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -