📄 upbook.jsp
字号:
<%@ page language="java" pageEncoding="GB2312"%>
<%@ page import= "java.sql.*" %>
<jsp:useBean id="upbook" scope="page" class="ConnBean.conn"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>My JSP 'addbook.jsp' starting page</title>
<link rel="stylesheet" type="text/css" href="../css/admin.css">
</head>
<BODY leftMargin=0 topMargin=0 BGCOLOR="#FFCCCC">
<TABLE class=navi cellSpacing=1 align=center border=0>
<TBODY>
<TR>
<TH colSpan=2>当前位置：图书管理>>修改图书信息</TH>
</TR>
<TR>
<TD align=right>[<A href="bookinfo.jsp">所有图书</A>] [<A href="addbook.jsp">新增图书</A>] [<A href="index.jsp">回首页</A>]</TD></TR>
</TBODY>
</TABLE>
<BR>
<FORM name=myform method=post action=book_up.jsp>
<TABLE class=form cellSpacing=1 align=center border=0>
<%
String bno="";
String idname="";
String bname="";
String aut="";
String bclass="";
String pub="";
String pic="";
String con="";
String pri="";
String sal="";
try{
ResultSet rs2=null;
ResultSet rs=null;
rs2=upbook.executeQuery("select * from bookinfo ");
while(rs2.next()){
String bookno=rs2.getString("BookNo");
if(request.getParameter("check"+bookno)!=null)
{
String strsql3="select * from bookinfo where BookNo='"+bookno+"' ";
rs=upbook.executeQuery(strsql3);
rs.next();
bno=rs.getString("BookNo");
idname=rs.getString("ID");
bname=rs.getString("BookName");
aut=rs.getString("Author");
bclass=rs.getString("BookClass");
pub=rs.getString("Publish");
pic=rs.getString("Pictrue");
con=rs.getString("Content");
pri=rs.getString("Price");
sal=rs.getString("SalePrice");
}
}%>
<TBODY>
<TR>
<TH width="15%">设置名称</TH>
<TH width="55%">基本参数设置</TH>
<TH width="30%">设置说明</TH></TR>
<TR>
<TD>所属分类：</TD>
<TD>
<SELECT size=1 name=class_name>
<OPTION selected><%=bclass%></OPTION>
<OPTION value=法律类>法律类</OPTION><OPTION value=经济管理类>经济管理类</OPTION>
<OPTION value=计算机类>计算机类</OPTION><OPTION value=建筑类>建筑类</OPTION>
<OPTION value=生活类>生活类</OPTION><OPTION value=社科类>社科类</OPTION>
<OPTION value=文学类>文学类</OPTION><OPTION value=外语类>外语类</OPTION>
<OPTION value=艺术类>艺术类</OPTION>
</SELECT>
</TD>
<TD><SPAN class=red>*</SPAN><SPAN class=gray>请选择图书分类</SPAN></TD>
</TR>
<TR>
<TD>图书编号:</TD>
<TD>
<INPUT size=40 name=book_no readonly=true value=<%=bno%>></TD>
<TD><SPAN class=red>*</SPAN><SPAN class=gray>图书的编码</SPAN></TD>
</TR>
<TR>
<TD>图书名称：</TD>
<TD><INPUT maxLength=100 size=40 name=book_name value=<%=bname %>></TD>
<TD><SPAN class=red>*</SPAN><SPAN class=gray>图书名称，最多20个汉字</SPAN></TD>
</TR>
<TR>
<TD>类别号：</TD>
<TD>
<SELECT size=1 name=class_no>
<OPTION selected><%=idname %></OPTION>
<OPTION value=FL0009>FL0009</OPTION><OPTION value=JG0002>JG0002</OPTION>
<OPTION value=JSJ0004>JSJ0004</OPTION><OPTION value=JZ0008>JZ0008</OPTION>
<OPTION value=SH0007>SH0007</OPTION><OPTION value=SK0003>SK0003</OPTION>
<OPTION value=WX0001>WX0001</OPTION><OPTION value=WY0005>WY0005</OPTION>
<OPTION value=YS0006>YS0006</OPTION>
</SELECT>
</TD>
<TD><SPAN class=red>*</SPAN><SPAN class=gray>请选择图书类别号</SPAN></TD>
</TR>
<TR>
<TD>作者：</TD>
<TD><INPUT size=40 name=book_aut value=<%=aut%>></TD>
<TD><SPAN class=red>*</SPAN><SPAN class=gray>输入该书的作者名</SPAN></TD></TR>
<TR>
<TD>出版社：</TD>
<TD><INPUT size=40 name=book_pub value=<%=pub%>></TD>
<TD><SPAN class=red>*</SPAN><SPAN class=gray>该书出版社的名字</SPAN></TD></TR>
<TR>
<TD>价格：</TD>
<TD><INPUT size=40 name=book_pri value=<%=pri%>></TD>
<TD><SPAN class=red>*</SPAN><SPAN class=gray>输入该书的价格</SPAN></TD></TR>
<TR>
<TD>销售价：</TD>
<TD><INPUT size=40 name=sale_pri value=<%=sal%>></TD>
<TD><SPAN class=red>*</SPAN><SPAN class=gray>该书的实际价格</SPAN></TD></TR>
<TR>
<TD>封面图地址：</TD>
<TD><INPUT size=40 name=book_pic readonly=true value=<%=pic %>></TD>
<TD><SPAN class=red>*</SPAN><SPAN class=gray>不能修改封面图</SPAN></TD>
</TR>
<TR>
<TD>图书内容简介：</TD>
<TD><TEXTAREA name=book_con rows=10 cols=60 ><%=con %></TEXTAREA></TD>
<TD><SPAN class=red>*</SPAN><SPAN class=gray>图书内容简单介绍</SPAN></TD>
</TR>
</TBODY>
<% }catch(Exception e){
out.print("e");} %>
</TABLE>
<table class=form cellSpacing=1 align=center border=0>
<tr>
<td align=center><input type=submit name=addnewbook value=修 改></td>
</tr>
</table>
</FORM>
</BODY></HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -