<%@ page contentType="text/html; charset=gb2312" %>
<%@ page session="true" %>
<%
if (session.getAttribute("admin")==null || session.getAttribute("admin")==""){
response.sendRedirect("error.htm");
} %>
<%@ page import="org.pan.web.book.bookclass"%>
<jsp:useBean id="classlist" scope="page" class="org.pan.web.bookclasslist" />
<jsp:useBean id="book" scope="page" class="org.pan.web.booksmn" />
<%
String mesg = "";
String submit = request.getParameter("Submit");
if (submit!=null && !submit.equals("")){
if(abooks.insert(request)){
session.setAttribute("bookname",abooks.getBookName());
session.setAttribute( "bookid", Long.toString( abooks.getbookid() ) );
response.sendRedirect("booklist.jsp?action=bookok"); mesg = "新图书资料提交成功!"; } else {
mesg = "数据库操作失败";
}else {
mesg = "对不起,你提交的参数有错误";
}
}
%><html>
<head>
<title>卓越电子书店管理系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language="javascript">
function checkform() {
if (document.form1.bookname.value=="") {
document.form1.bookname.focus();
alert("图书名为空!");
return false;
}
if (document.form1.author.value=="") {
alert("作者名为空!");
document.form1.author.focus();
return false;
} return true; }
</script>
<link rel="stylesheet" href="books.css" type="text/css">
</head><body bgcolor="#008B8B" text="#000000">
<div align="center">
<table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td align="center" width="23%"><img src="../images/javabeans.gif" width="126" height="88"></td>
<td align="center" width="77%"><img src="../images/baners.gif" width="468" height="60"></td>
</tr>
<tr>
<td align="center" width="23%" valign="top">
<table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td> </td>
</tr>
<tr>
<td align="center"><a href="main.jsp">回管理首页</a></td>
</tr>
<tr>
<td align="center"><a href="booklist.jsp">商店图书查询</a></td>
</tr>
<tr>
<td align="center"><a href="addbook.jsp">添加图书资料</a></td>
</tr>
<tr>
<td align="center"><a href="orderlist.jsp">订单信息查询</a></td>
</tr>
<tr>
<td align="center"><a href="userlist.jsp">用户信息查询</a></td>
</tr>
<tr>
<td align="center"><a href="logout.jsp">退出</a></td>
</tr>
</table>
</td>
<td align="center" width="77%">
<p><br>
<font size="3"><b>添加新的图书资料</b></font></p>
<% if(!mesg.equals("")){
out.println(mesg);
}%>
<form name="form1" method="post" action="addbook.jsp">
<table width="90%" border="0" cellspacing="1" cellpadding="1">
<tr>
<td align="right" width="35%">图书名称:</td>
<td width="65%">
<input type="text" name="bookname" maxlength="40" size="30">
</td>
</tr>
<tr>
<td align="right" width="35%">作者:</td>
<td width="65%">
<input type="text" name="author" maxlength="25" size="20">
</td>
</tr>
<tr>
<td align="right" width="35%">出版社:</td>
<td width="65%">
<input type="text" name="publish" size="40" maxlength="150">
</td>
</tr>
<tr>
<td align="right" width="35%">所属类别:</td>
<td width="65%">
<select name="bookclass">
<% if (classlist.excute()){
for (int i=0;i<classlist.getClasslist().size();i++){
bookclass bc = (bookclass) classlist.getClasslist().elementAt(i); %>
<option value="<%= bc.getId()%>"><%= bc.getClassName() %></option>
<% }
}%>
</select>
</td>
</tr>
<tr>
<td align="right" width="35%">书号:</td>
<td width="65%">
<input type="text" name="bookno" size="20" maxlength="30">
</td>
</tr>
<tr>
<td align="right" width="35%">定价:</td>
<td width="65%">
<input type="text" name="price" size="8" maxlength="10">
元</td>
</tr>
<tr>
<td align="right" width="35%">总数量:</td>
<td width="65%">
<input type="text" name="amount" size="8" maxlength="10">
本</td>
</tr>
<tr>
<td align="right" width="35%" valign="top">图书简介:</td>
<td width="65%">
<textarea name="content" cols="40" rows="6"></textarea>
</td>
</tr>
<tr>
<td align="right" width="35%"> </td>
<td width="65%">
<input type="submit" name="Submit" value="提交" onclick="return(checkform());">
<input type="reset" name="reset" value="重置">
</td>
</tr>
</table>
</form>
<p> </p>
</td>
</tr>
</table>
<br>
<table width="70%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td align="center">光光工作室<br>
CopyRight©2009 <br>
Email:<a href="mailto:[email protected]">[email protected]</a></td>
</tr>
</table>
</div>
</body>
</html>
<% book.close();%>
<%@ page session="true" %>
<%
if (session.getAttribute("admin")==null || session.getAttribute("admin")==""){
response.sendRedirect("error.htm");
} %>
<%@ page import="org.pan.web.book.bookclass"%>
<jsp:useBean id="classlist" scope="page" class="org.pan.web.bookclasslist" />
<jsp:useBean id="book" scope="page" class="org.pan.web.booksmn" />
<%
String mesg = "";
String submit = request.getParameter("Submit");
if (submit!=null && !submit.equals("")){
if(abooks.insert(request)){
session.setAttribute("bookname",abooks.getBookName());
session.setAttribute( "bookid", Long.toString( abooks.getbookid() ) );
response.sendRedirect("booklist.jsp?action=bookok"); mesg = "新图书资料提交成功!"; } else {
mesg = "数据库操作失败";
}else {
mesg = "对不起,你提交的参数有错误";
}
}
%><html>
<head>
<title>卓越电子书店管理系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language="javascript">
function checkform() {
if (document.form1.bookname.value=="") {
document.form1.bookname.focus();
alert("图书名为空!");
return false;
}
if (document.form1.author.value=="") {
alert("作者名为空!");
document.form1.author.focus();
return false;
} return true; }
</script>
<link rel="stylesheet" href="books.css" type="text/css">
</head><body bgcolor="#008B8B" text="#000000">
<div align="center">
<table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td align="center" width="23%"><img src="../images/javabeans.gif" width="126" height="88"></td>
<td align="center" width="77%"><img src="../images/baners.gif" width="468" height="60"></td>
</tr>
<tr>
<td align="center" width="23%" valign="top">
<table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td> </td>
</tr>
<tr>
<td align="center"><a href="main.jsp">回管理首页</a></td>
</tr>
<tr>
<td align="center"><a href="booklist.jsp">商店图书查询</a></td>
</tr>
<tr>
<td align="center"><a href="addbook.jsp">添加图书资料</a></td>
</tr>
<tr>
<td align="center"><a href="orderlist.jsp">订单信息查询</a></td>
</tr>
<tr>
<td align="center"><a href="userlist.jsp">用户信息查询</a></td>
</tr>
<tr>
<td align="center"><a href="logout.jsp">退出</a></td>
</tr>
</table>
</td>
<td align="center" width="77%">
<p><br>
<font size="3"><b>添加新的图书资料</b></font></p>
<% if(!mesg.equals("")){
out.println(mesg);
}%>
<form name="form1" method="post" action="addbook.jsp">
<table width="90%" border="0" cellspacing="1" cellpadding="1">
<tr>
<td align="right" width="35%">图书名称:</td>
<td width="65%">
<input type="text" name="bookname" maxlength="40" size="30">
</td>
</tr>
<tr>
<td align="right" width="35%">作者:</td>
<td width="65%">
<input type="text" name="author" maxlength="25" size="20">
</td>
</tr>
<tr>
<td align="right" width="35%">出版社:</td>
<td width="65%">
<input type="text" name="publish" size="40" maxlength="150">
</td>
</tr>
<tr>
<td align="right" width="35%">所属类别:</td>
<td width="65%">
<select name="bookclass">
<% if (classlist.excute()){
for (int i=0;i<classlist.getClasslist().size();i++){
bookclass bc = (bookclass) classlist.getClasslist().elementAt(i); %>
<option value="<%= bc.getId()%>"><%= bc.getClassName() %></option>
<% }
}%>
</select>
</td>
</tr>
<tr>
<td align="right" width="35%">书号:</td>
<td width="65%">
<input type="text" name="bookno" size="20" maxlength="30">
</td>
</tr>
<tr>
<td align="right" width="35%">定价:</td>
<td width="65%">
<input type="text" name="price" size="8" maxlength="10">
元</td>
</tr>
<tr>
<td align="right" width="35%">总数量:</td>
<td width="65%">
<input type="text" name="amount" size="8" maxlength="10">
本</td>
</tr>
<tr>
<td align="right" width="35%" valign="top">图书简介:</td>
<td width="65%">
<textarea name="content" cols="40" rows="6"></textarea>
</td>
</tr>
<tr>
<td align="right" width="35%"> </td>
<td width="65%">
<input type="submit" name="Submit" value="提交" onclick="return(checkform());">
<input type="reset" name="reset" value="重置">
</td>
</tr>
</table>
</form>
<p> </p>
</td>
</tr>
</table>
<br>
<table width="70%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td align="center">光光工作室<br>
CopyRight©2009 <br>
Email:<a href="mailto:[email protected]">[email protected]</a></td>
</tr>
</table>
</div>
</body>
</html>
<% book.close();%>
1 12 42 12 12 12 12 12 12
2 0 0 0
3 0 0 0
4 0 0 0
5 0 0 0
6 0 0 0
7 0 0 0
8 0 0 0
插入后是这样的结果,根本没有数据,都是0.为什么呢?请知道问题的