da_addbook.jsp
来自「JSP课件以及一个网上书店系统程序,带数据库」· JSP 代码 · 共 176 行
JSP
176 行
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html >
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>添加图书信息</title>
<style type="text/css">
<!--
.stybook {color: #ff6600;
font-size:12px; }
-->
</style>
</head>
<%@ include file="../inc/conn.jsp"%>
<%@ include file="../inc/format.jsp"%>
<link href="../style1.css" rel="stylesheet" type="text/css" />
<body>
<%//添加操作
//先判断用户是否单击了“完成”按钮
if(request.getParameter("Submit")!=null){
//初始化表单中的各参数 获取新书各项信息
String bkname=Bytes(request.getParameter("bkname"));
String bkfl=request.getParameter("bkfl");
String cmd=request.getParameter("cmd");
String bkpub=Bytes(request.getParameter("bkpub"));
String bkxm=Bytes(request.getParameter("bkxm"));
String bkzz=Bytes(request.getParameter("bkzz"));
String bkdate=Bytes(request.getParameter("bkdate"));
String bkisbn=request.getParameter("bkisbn");
String bkyz=request.getParameter("bkyz");
String bkys=request.getParameter("bkys");
String bkdj=request.getParameter("bkdj");
String bkhj=request.getParameter("bkhj");
String bkkb=request.getParameter("bkkb");
String bksl=request.getParameter("bksl");
String bkjj=Bytes(request.getParameter("bkjj"));
String bkml=Bytes(request.getParameter("bkml"));
String bkfm=request.getParameter("bkfm");
if(Cint(cmd)!=1){cmd="0";}
//组织SQL插入语句
sql="insert into tushumingxi(shu_name,lieID,banshe,dingjia,huiyuanjia,jinhuoliang,fengmian,zhuozhe,commend,ISBN,kaiben,yeshu,shu_mu,shu_jian,shu_xm) values('";
sql+=bkname+"',"+bkfl+",'" +bkpub +"',"+bkdj+","+bkhj+","+bksl+",'";
sql+=bkfm+"','"+bkzz+"','"+cmd+"','"+bkisbn+"','"+bkkb+"',"+bkys+",'"+bkml+"','"+bkjj+"','"+bkxm+"')";
//out.print(sql);
//执行插入操作
stmt.executeUpdate(sql);
out.print("<script>alert('添加图书成功!');window.location='sys.jsp';</script>");
}
%>
<form name="form_search" method="post" ID="Form1"><table width="95%" border="1" align="center" cellpadding="5" cellspacing="5" bordercolor="#CCCCCC"
bgcolor="#FFFFFF" ID="Table15">
<tr>
<td width="50%" bordercolor="#f8f8f8" bgcolor="#f8f8f8">
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" ID="Table3">
<tr class="stybook">
<td width="50%"> ·图书名称
<input size="30" style="border:1 solid #AEAEB1; font-size:9pt; background-color:#f9fcff"
name="bkname" value="最新图书" onMouseOver='js:this.focus()' onFocus="js:this.select()"
onClick="js:this.value=''" id="Text1"> </td>
<td width="30%">·分 类：
<select name="bkfl" size="1" id="bkfl">
<%sql="select * from category where highLevelID=0";
rs=dbBean.exeSQL(sql);
while(rs.next()){
%>
<option value="<%=rs.getString("categoryID")%>"><%=rs.getString("categoryName")%></option>
<%}%>
</select> </td>
<td width="20%">
<input name="cmd" type="checkbox" id="cmd" value="1" checked>
推荐</td>
</tr>
</table>
<table width="100%" border="0" align="center" cellpadding="4" cellspacing="0" ID="Table28">
<tr>
<td width="60%"><table width="100%" border="0" cellpadding="3" cellspacing="0" bordercolor="#000000" bgcolor="#FFFFFF" id="Table29">
<tr class="stybook">
<td width="50%" height="20">出版社：
<input size="30" style="border:1 solid #AEAEB1; font-size:9pt; background-color:#f9fcff"
name="bkpub" value="清华大学出版社" onMouseOver='js:this.focus()' onFocus="js:this.select()"
onClick="js:this.value=''" id="key2"></td>
<td>条形码：ISBN
<input size="25" style="border:1 solid #AEAEB1; font-size:9pt; background-color:#f9fcff"
name="bkisbn" value="9787302134657" onMouseOver='js:this.focus()' onFocus="js:this.select()"
onClick="js:this.value=''" id="key24"></td>
</tr>
<tr bgcolor="#F1F1F1" class="stybook">
<td height="20">系列名：
<input size="30" style="border:1 solid #AEAEB1; font-size:9pt; background-color:#f9fcff"
name="bkxm" value="清华电脑学堂" onMouseOver='js:this.focus()' onFocus="js:this.select()"
onClick="js:this.value=''" id="key"> </td>
<td height="20">印 数：
<input size="10" style="border:1 solid #AEAEB1; font-size:9pt; background-color:#f9fcff"
name="bkyz" value="1-5000" onMouseOver='js:this.focus()' onFocus="js:this.select()"
onClick="js:this.value=''" id="key25">
页 数：
<input size="10" style="border:1 solid #AEAEB1; font-size:9pt; background-color:#f9fcff"
name="bkys" value="400" onMouseOver='js:this.focus()' onFocus="js:this.select()"
onClick="js:this.value=''" id="key252"></td>
</tr>
<tr class="stybook">
<td height="20">作 者：
<input size="25" style="border:1 solid #AEAEB1; font-size:9pt; background-color:#f9fcff"
name="bkzz" value="清华电脑学堂" onMouseOver='js:this.focus()' onFocus="js:this.select()"
onClick="js:this.value=''" id="key22">
等 </td>
<td width="567">定 价：
<input size="10" style="border:1 solid #AEAEB1; font-size:9pt; background-color:#f9fcff"
name="bkdj" value="40" onMouseOver='js:this.focus()' onFocus="js:this.select()"
onClick="js:this.value=''" id="key2523">
会员价：
<input size="10" style="border:1 solid #AEAEB1; font-size:9pt; background-color:#f9fcff"
name="bkhj" value="40" onMouseOver='js:this.focus()' onFocus="js:this.select()"
onClick="js:this.value=''" id="key2524"></td>
</tr>
<tr bgcolor="#F1F1F1" class="stybook">
<td height="20">出版日期：
<input size="30" style="border:1 solid #AEAEB1; font-size:9pt; background-color:#f9fcff"
name="bkdate" onMouseOver='js:this.focus()' onFocus="js:this.select()"
onClick="js:this.value=''" id="key23" value="<%=new java.util.Date()%>"></td>
<td height="20">开 本：
<input size="10" style="border:1 solid #AEAEB1; font-size:9pt; background-color:#f9fcff"
name="bkkb" value="180*260" onMouseOver='js:this.focus()' onFocus="js:this.select()"
onClick="js:this.value=''" id="key2522">
数 量：
<input size="10" style="border:1 solid #AEAEB1; font-size:9pt; background-color:#f9fcff"
name="bksl" value="40" onMouseOver='js:this.focus()' onFocus="js:this.select()"
onClick="js:this.value=''" id="key2525"></td>
</tr>
</table></td>
</tr>
</table>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" ID="Table40">
<tr>
<td><img src="../pic/indexnew_12.gif" height="13" width="68"></td>
</tr> <tr>
<td height="1" bgcolor="#E7DFD6"> </td>
</tr>
<tr><td>
<textarea name="bkjj" cols="75" rows="5" wrap="physical" ID="Textarea1">
</textarea>
</td></tr>
</table>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" background="../pic/body_line1.jpg"
ID="Table54">
<tr>
<td height="37" align="left" valign="middle"> 图书目录 </td>
</tr>
<tr>
<td valign="middle">
<table width="100%" border="0" cellpadding="0" cellspacing="1" bordercolor="#CCCCCC" bgcolor="#FFFFFF"
ID="Table55">
<tr>
<td>
<textarea name="bkml" cols="75" rows="5" wrap="physical" ID="Textarea1">
</textarea> </td>
</tr>
</table> </td>
</tr>
</table> </td>
</tr>
<tr class="stybook">
<td bordercolor="#f8f8f8" bgcolor="#f8f8f8">图书封面图片路径：
<input size="30" style="border:1 solid #AEAEB1; font-size:9pt; background-color:#f9fcff"
name="bkfm" value="images/default.gif" onMouseOver='js:this.focus()' onFocus="js:this.select()"
onClick="js:this.value=''" id="bkfm">
<input name="Submit" type="submit" class="submit" value="完成"></td>
</tr>
</table>
</form>
</body>
</html>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?