code325.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>bookshop</title>
</head>
<body>
<%--
create table shop_book(
id int(4) not null auto_increment primary key comment '图书编号',
bookName varchar(40) not null comment '图书名称' ,
bookClass int(4) not null comment '图书分类',
author varchar(25) comment '作者',
publish varchar(150) comment '出版社',
bookNo varchar(30) comment '书号',
content text(300) comment '内容',
price float(8) comment '价格',
amount int(4) comment '总数量',
leavNumber int(4) comment '剩余数量',
regtime datetime comment '注册时间',
picture varchar(60) comment '封面'
)
create table shop_bookadmin(
id int not null auto_increment primary key comment '',
adminuser varchar(20) not null comment '管理员',
adminpwd varchar(20) not null comment '密码'
)
create table shop_user(
id int(2) not null auto_increment primary key comment '用户编号',
userName varchar(50) not null comment '用户名',
pwd varchar(50) not null comment '密码',
names varchar(50) not null comment '真名',
sex varchar(50) comment '性别',
address varchar(50) comment '地址',
phone varchar(50) comment '电话',
post varchar(50) comment '邮编',
email varchar(50) comment '电子邮件',
regtime datetime comment '注册时间',
regipaddress varchar(50) comment ''
)
create table shop_allorders(
id int(4) not null auto_increment primary key comment '编号',
orderid int(4) not null comment '总订单id',
bookid int(4) not null comment '书号',
amount int(4) comment '数量'
)
create table shop_order(
id int(4) not null auto_increment primary key comment '订单id',
orderid varchar(50) not null comment '总订单id',
userid int(2) not null comment '用户id',
submittime datetime comment '提交时间',
consignmenttime datetime comment '购买时间',
totalprice float comment '总价格' ,
content text comment '描述',
ipaddress varchar(50) comment 'ip地址',
ispayoff varchar(50) comment '是否付款',
isaddress varchar(20) comment '是否发货'
)
create table shop_bookclass(
id int(4) not null auto_increment primary key comment '分类编号',
classname varchar(30) not null comment '分类名'
)
DataBase code326
dataFormat code327
User code328
book code329
bookclass code330
order code331
allorders code332
shopcart code333
ManageLogin code334
manageBook code335
--%>
</body>
</html>
