jsp实现网上书店的后台部分.docx
- 文档编号:8430107
- 上传时间:2023-01-31
- 格式:DOCX
- 页数:19
- 大小:17.49KB
jsp实现网上书店的后台部分.docx
《jsp实现网上书店的后台部分.docx》由会员分享,可在线阅读,更多相关《jsp实现网上书店的后台部分.docx(19页珍藏版)》请在冰豆网上搜索。
jsp实现网上书店的后台部分
Bookadd.jsp
<%@pagecontentType="text/html;charset=gb2312"language="java"import="java.sql.*"errorPage=""%>
<%@pageimport="java.util.*"%>
useBeanid="db"class="JavaBean.myDb"/> <% Stringpath=request.getContextPath(); StringbasePath=request.getScheme()+": //"+request.getServerName()+": "+request.getServerPort()+path+"/"; %> DOCTYPEHTMLPUBLIC"-//W3C//DTDHTML4.01Transitional//EN">
--
-->
--
body{
background-image:
url(image/18.jpg);
}
-->
<%
StringbookId=request.getParameter("bookid");
Stringbookname=request.getParameter("bookname");
Stringauthor=request.getParameter("author");
Stringpublisher=request.getParameter("publisher");
Stringcategory=request.getParameter("category");
Stringprice=request.getParameter("price");
Stringstock=request.getParameter("stock");
if(bookId!
=null&&bookname!
=null&&publisher!
=null&&category!
=null&&price!
=null&&stock!
=null){
Stringrssql="insertintobookvalues('"+bookId+"','"+bookname+"','"+author+"','"+publisher+"','"+category+"','"+price+"','"+stock+"')";
db.connection();
intrsn=db.update(rssql);
out.print(rssql);
//if(rsn>0){
//response.sendRedirect("Admin/bookadd.jsp");
//}
}
%>
Bookdelete.jsp
<%@pagecontentType="text/html;charset=gb2312"language="java"import="java.sql.*"errorPage=""%>
<%@pageimport="java.util.*"%>
useBeanid="db"class="JavaBean.myDb"/> <% Stringpath=request.getContextPath(); StringbasePath=request.getScheme()+": //"+request.getServerName()+": "+request.getServerPort()+path+"/"; %> DOCTYPEHTMLPUBLIC"-//W3C//DTDHTML4.01Transitional//EN">
--
-->
--
body{
background-image:
url(image/18.jpg);
}
-->
<%
ResultSetrs=null;
db.connection();
Stringquery="select*frombook";
rs=db.query(query);
while(rs.next())
{Strings1=rs.getString
(1);
Strings2=rs.getString
(2);
Strings3=rs.getString(3);
Strings4=rs.getString(4);
Strings5=rs.getString(5);
Strings6=rs.getString(6);
Strings7=rs.getString(7);
%>
id=<%=s1%>"onClick="confirm('真的要删除吗?
');">删除
<%
}
%>
<%
Stringid=request.getParameter("id");
if(id!
=null)
{
Stringsql="deletefrombookwhereid="+id;
db.connection();
booleancol=db.equals(sql);
}
%>
Bookedit.jsp
<%@pagecontentType="text/html;charset=gb2312"language="java"import="java.sql.*"errorPage=""%>
<%@pageimport="java.util.*"%>
useBeanid="db"class="JavaBean.myDb"/> <% Stringpath=request.getContextPath(); StringbasePath=request.getScheme()+": //"+request.getServerName()+": "+request.getServerPort()+path+"/"; %> DOCTYPEHTMLPUBLIC"-//W3C//DTDHTML4.01Transitional//EN">
--
-->
--
body{
background-image:
url(image/18.jpg);
}
-->
<%
ResultSetrs=null;
db.connection();
Stringquery="select*frombook";
rs=db.query(query);
while(rs.next())
{Strings1=rs.getString
(1);
Strings2=rs.getString
(2);
Strings3=rs.getString(3);
Strings4=rs.getString(4);
Strings5=rs.getString(5);
Strings6=rs.getString(6);
Strings7=rs.getString(7);
%>
id=<%=s1%>">修改
<%
}
%>
Bookedit1.jsp
<%@pagecontentType="text/html;charset=gb2312"language="java"import="java.sql.*"errorPage=""%>
<%@pageimport="java.util.*"%>
useBeanid="db"class="JavaBean.myDb"/> <% Stringpath=request.getContextPath(); StringbasePath=request.getScheme()+": //"+request.getServerName()+": "+request.getServerPort()+path+"/"; %> DOCTYPEHTMLPUBLIC"-//W3C//DTDHTML4.01Transitional//EN">
--
-->
--
body{
background-image:
url(image/18.jpg);
}
-->
<%
Stringid=request.getParameter("id");
ResultSetrs=null;
if(id!
=null)
{
Stringsql="select*frombookwhereid='"+id+"'";
db.connection();
rs=db.query(sql);
while(rs.next())
{
Strings1=rs.getString
(1);
Strings2=rs.getString
(2);
Strings3=rs.getString(3);
Strings4=rs.getString(4);
Strings5=rs.getString(5);
Strings6=rs.getString(6);
Strings7=rs.getString(7);
Strings8=rs.getString(8);
%>
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。 copyright@ 2008-2022 冰点文档网站版权所有 经营许可证编号:鄂ICP备2022015515号-1