📄 showbook.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" %>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<jsp:useBean id="classlist" scope="page" class="leecong.javabean.BookClassList"/>
<jsp:useBean id="booklist" scope="page" class="leecong.javabean.BookList"/>
<%!
Enumeration listname=null;
Hashtable list=null;
ResultSet rs=null;
String bookno="";
int bookid=0;
%>
<%
if(!booklist.DBConn())
{
out.print("<script language='javascript'>alert('数据库连接错误!');</script>");
}
%>
<%
if(request.getParameter("bookid")!=null)
{
bookid=Integer.parseInt(request.getParameter("bookid"));
rs=booklist.getBook(bookid);
}
else
{
bookno=request.getParameter("bookno");
rs=booklist.getBook(bookno);
}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title></title>
<link rel="stylesheet" href="books.css" type="text/css">
<style type="text/css">
<!--
.style1 {
color: #FF9999;
font-weight: bold;
}
.style2 {
color: #3399FF;
font-weight: bold;
}
.style4 {color: #FF0000}
-->
</style>
<script language="javascript">
function checkform() {
if (document.form1.bookname.value==""){
alert("图书名不能为空");
document.form1.bookname.focus();
return false;
}
if (document.form1.author.value==""){
alert("图书作者不能为空");
document.form1.author.focus();
return false;
}
if (document.form1.publish.value==""){
alert("出版社不能为空");
document.form1.publish.focus();
return false;
}
if (document.form1.bookno.value==""){
alert("图书编号不能为空");
document.form1.bookno.focus();
return false;
}
if (document.form1.price.value==""){
alert("图书价格不能为空");
document.form1.price.focus();
return false;
}
if (document.form1.amount.value==""){
alert("图书数量不能为空");
document.form1.amount.focus();
return false;
}
return true;
}
</script>
</head>
<body>
<table width="300" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td bgcolor="#FFFFFF">
<div align="center" class="style1">图 书 商 品 信 息 修 改</div></td>
</tr>
</table>
<br>
<%
try
{
if(rs.next())
{
%>
<form name="form1" action="modifybook" method="post" onSubmit="return checkform();">
<table width="80%" border="1" cellspacing="1" cellpadding="1" bordercolor="#CC9966" align="center">
<tr>
<td width="22%"><div align="center">图书名称：</div></td>
<td width="78%">
<input type="hidden" name="bookid" value="<%=rs.getInt(1)%>">
<input type="text" name="bookname" maxlength="40" size="30" value="<%=rs.getString(2)%>">
<span class="style4">*</span></td>
</tr>
<tr>
<td><div align="center">图书作者：</div></td>
<td>
<input type="text" name="author" maxlength="25" size="20" value="<%=rs.getString(4)%>">
<span class="style4">*</span></td>
</tr>
<tr>
<td><div align="center">出版社 ：</div></td>
<td>
<input type="text" name="publish" size="40" maxlength="150" value="<%=rs.getString(5)%>">
<span class="style4">*</span></td>
</tr>
<tr>
<td><div align="center">图书类别：</div></td>
<td>
<%
if(!classlist.DBConn())
{
out.print("<script language='javascript'>alert('数据库连接错误!');</script>");
}
%>
<select name="bookclass">
<%
if(classlist.classList()){
list=classlist.getClassList();
listname=list.keys();
while(listname.hasMoreElements()){
int ClassId=((Integer)listname.nextElement()).intValue();
String ClassName=(String)(list.get(new Integer(ClassId)));
%>
<option value="<%=ClassId%>" <%if(rs.getInt(3)==ClassId) out.print("selected");%>><%=ClassName%></option>
<%
}
}
%>
</select>
<span class="style4">*</span></td>
</tr>
<tr>
<td><div align="center">图书编号：</div></td>
<td>
<input type="text" name="bookno" size="20" maxlength="30" value="<%=rs.getString(6)%>">
<span class="style4">*</span><span class="style2"><span class="style3">英文字符或数字的组合</span></span></td>
</tr>
<tr>
<td><div align="center">图书价格：</div></td>
<td>
<input type="text" name="price" size="8" maxlength="8" value="<%=rs.getFloat(8)%>">
<span class="style4">*</span><span class="style2">单位（元）<span class="style3">数字</span></span></td>
</tr>
<tr>
<td><div align="center">图书数量：</div></td>
<td>
<input type="text" name="amount" size="8" maxlength="4" value="<%=rs.getInt(9)%>">
<span class="style4">*</span><span class="style2">单位（本/套）<span class="style3">数字</span></span></td>
</tr>
<tr>
<td><div align="center">图书简介：</div></td>
<td>
<textarea name="content" cols="40" rows="6" wrap="hard"><%=rs.getString(7)%></textarea></td>
</tr>
<tr>
<td colspan="2" bordercolor="#FFFFFF"><div align="center">
<input type="image" src="../images/edit.gif" width="83" height="35">
<br>
提示：<span class="style2">"<span class="style4">*</span>" 为必填项</span></div></td>
</tr>
</table>
<br>
</form>
<%
}
else
{
out.print("<center><font color='red' size='3'>没有找到该图书!</font><center>");
}
}catch(Exception ex){ex.printStackTrace();}
%>
<div align="center"><br>
<a href="javascript:window.close()" style="font-size:14px;">关闭窗口</a><br>
</div><br>
<table width="70%" border="0" cellspacing="2" cellpadding="2" align="center">
<tr>
<td align="center">开发:LeeCong<br>
CopyRight@2006 <br>
Email:<a href="mailto:leecong@eyou.com">leecong@eyou.com</a></td>
</tr>
</table>
<%
classlist.close();
booklist.close();
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -