manage.jsp

来自「java + sqlserver2000编写的一个网上购书系统,实现了一些基本的」· JSP 代码 · 共 80 行

JSP
80 行
字号 
<%@ page contentType="text/html; charset=gb2312" language="java"%>
<jsp:useBean id="databean" scope="session" class="ConnBean.conn" />
<%@ page import="java.sql.*"%>
<%@ page import="java.util.Date"%>
<%@ page import="java.util.Vector"%>
<%@ page import="cart.buyList"%>
<html>
	<head>
		<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
		<title>生成订单</title>
	</head>
	<body>
		<%
			Date date = new Date();
			String dat = date.toLocaleString();
			String subid = request.getParameter("subid");
			String username = request.getParameter("username");
			String rname = request.getParameter("rname");
			String userid = request.getParameter("userid");
			String totalprice = request.getParameter("totalprice");
			String demo = request.getParameter("demo");
			String address = request.getParameter("address");
			String post = request.getParameter("post");
			String pay = request.getParameter("pay");
			String sendway = request.getParameter("sendway");
			String stime = request.getParameter("stime");
			String tel = request.getParameter("teleph");
			String sql = "insert into userorderlist(OrderlistNo,UserName,RealName,UserID,SubmitTime,TotalPrice,IsPayoff,IsSendout,Allinfo,UserAddress,Tel,Post,OrderlistState,Way,SendWay) values('"
					+ subid
					+ "','"
					+ username
					+ "','"
					+ rname
					+ "','"
					+ userid
					+ "','"
					+ stime
					+ "','"
					+ totalprice
					+ "',  '否' , '否' ,'"
					+ demo
					+ "','"
					+ address + "','" + tel + "','" + post + "', '未处理','" + pay + "','" + sendway + "')";
			int temp = databean.executeUpdate(sql);
			Vector shop = (Vector) session.getAttribute("shop");
			int number = 0;
			double price = 0;
			int num = 0;
			if (totalprice == null || totalprice.equals("")) {
				out
						.println("<script language='javascript'>alert('金额有误，订单无效');window.location.href='index_order.jsp';</script>");
			} else {
				for (int i = 0; i < shop.size(); i++) {
					buyList mylist = (buyList) shop.elementAt(i);
					String bookno = mylist.bookno;
					String bookname = mylist.bookname;
					price = mylist.price;
					number = mylist.number;
					String str = "insert into orderlist(OrderlistNo,BookName,BookNo,Number,Price)values('"
							+ subid
							+ "','"
							+ bookname
							+ "','"
							+ bookno
							+ "','"
							+ number + "','" + number * price + "')";
					int te = databean.executeUpdate(str);
					if (temp > 0) {
						out
								.println("<script language='javascript'>alert('订单生成');window.location.href='../logindindex.jsp';</script>");
					} else {
						out
								.println("<script language='javascript'>alert('订单无效');history.back();</script>");
					}
				}
			}
		%>
	</body>
</html>

manage.jsp - 源码说明

本页面展示了「java + sqlserver2000编写的一个网上购书系统,实现了一些基本的功能,但对于初学者来说这个系统已经足以起到帮助作用」中的 manage.jsp 源码文件，采用 JSP 编程语言编写，共 80 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与sqlserver相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?