📄 buy.jsp

📁 一个自己完成的网上书店
💻 JSP
字号:
<%@ page language="java" import="java.util.*,java.sql.*,java.io.*"
	pageEncoding="gbk"%>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://"
			+ request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
	<head>
		<base href="<%=basePath%>">

		<title>My JSP 'buy.jsp' starting page</title>

		<meta http-equiv="pragma" content="no-cache">
		<meta http-equiv="cache-control" content="no-cache">
		<meta http-equiv="expires" content="0">
		<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
		<meta http-equiv="description" content="This is my page">
		<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->

		<style type="text/css">
<!--
.style1 {
	color: #FF0000;
	font-family: "华文隶书";
	font-size: 36px;
}
body {
	background-image: url(new/bg-0.jpg);
}
-->
        </style>
		<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
	</head>

	<body>
		<p>
			&nbsp;
		</p>
		<p>
			&nbsp;
		</p>
		<p>
			<%
				String driverName = "com.mysql.jdbc.Driver";
				String userName = "root";
				String userPasswd = "ptnest";
				String url = "jdbc:mysql://127.0.0.1/bookstore?useUnicode=true&characterEncoding=gb2312";
				try {
					Class.forName(driverName);

				} catch (ClassNotFoundException e) {
					System.out.print("数据库类没有找到" + e.getMessage());
				}

				Connection conn = DriverManager.getConnection(url, userName,
						userPasswd);
				Statement stmt = conn.createStatement();
			%>
			<%
				int year, month, day;
				GregorianCalendar calendar = new GregorianCalendar();
				month = calendar.get(Calendar.MONTH) + 1;
				day = calendar.get(Calendar.DAY_OF_MONTH);
				year = calendar.get(Calendar.YEAR);
				String nowtime = year + "年" + month + "月" + day + "日";
				int bkID, bknum, bksum = 0;
				String mysql = "select *from orderlist ,book where book.name=orderlist.goodsname and user='"
						+ session.getAttribute("username") + "'";
				ResultSet rs = stmt.executeQuery(mysql);
				while (rs.next()) {
					bkID = rs.getInt("book.price");
					bknum = rs.getInt("goodsnumber");
					bksum = bksum + bkID * bknum;
				}
			%>
			<%
						String sql1 = "select level from user where name='"
						+ session.getAttribute("username") + "'";
				int level = 0;
				try {
					ResultSet rs1 = stmt.executeQuery(sql1);

					rs.next();

					level = rs1.getInt("level");

				} catch (Exception ex) {
					ex.toString();
				}
			%>

		</p>
		<center class="style1">
			您一共需要付款
			<%=bksum%>
			元
		</center>
		<p class="style1">
		<center>
			您是
			<%=level%>
			级，享受
			<%
				if (level == 0)
				out.println(9);
			if (level == 1)
				out.println(87);
			if (level == 2)
				out.println(83);
			if(level==3)
				out.println(79);
		%>
			折
			</center>
		</p>
		<center>
			<p class="style1">
				感谢您的光临！
			</p>
			<p class="style1">
				祝您幸福愉快！
			</p>
		</center>
	</body>
</html>
⌨️ 快捷键说明

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