new189.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%--
建立数据库,各表
create table sp_customer(
id bigint not null auto_increment primary key,
memberName varchar(20) not null comment '会员姓名',
loginName varchar(30) not null comment '登录名',
sex varchar(2) not null comment '性别',
password varchar(20) not null comment '密码',
tel varchar(20) comment '电话',
mail varchar(30) comment '邮箱',
postCode varchar(8) comment '邮编',
createDate datetime not null comment '创建日期',
lastLoginDate datetime not null comment '最后登录日期',
level bigint not null comment '会员级别',
state int not null comment '状态,0冻结,1生效'
) comment '会员表'
create table sp_customerType(
id bigint auto_increment not null primary key,
levelName varchar(20) not null comment '级别名称',
sate int not null comment '状态,0删除,1可用'
) comment '会员级别表'
create table sp_goods(
id bigint auto_increment not null primary key,
shopName varchar(20) not null comment '商品名称',
freight double not null comment '运费,0为免费',
amount int comment '商品数量',
address varchar(20) comment '所在地',
browseAmount int comment '浏览量',
saleAmout int comment '累计售出数量',
goodsType bigint not null comment '商品分类',
price double comment '商品价格'
) comment '商品信息表'
create table sp_order(
id bigint auto_increment not null primary key,
goodsId bigint not null comment '商品编号',
memberId bigint not null comment '会员编号'
) comment '订单信息表'
create table sp_shoppingCart(
id bigint auto_increment not null primary key,
goodsId bigint not null comment '商品编号',
amount int not null comment '数量',
money double comment '金额'
) comment '购物车记录表'
create table sp_goodsType(
id bigint auto_increment not null primary key,
typeName varchar(50) not null comment '分类名称',
parentId bigint not null comment '父分类id'
) comment '商品类别表'
create table sp_leaveWord(
id bigint auto_increment not null primary key,
memberId bigint not null comment '会员编号',
userId bigint not null comment '管理员编号',
title varchar(50) comment '留言标题',
content varchar(255) comment '留言内容',
createDate datetime comment '留言日期',
replyContent varchar(255) comment '回复内容',
replyDate datetime comment '回复日期'
) comment '留言反馈表'
create table sp_sysUser(
id bigint auto_increment not null primary key,
loginName varchar(50) not null comment '登录名',
userName varchar(50) not null comment '姓名',
age int comment '年龄',
password varchar(50) comment '密码',
tel varchar(20) comment '电话'
) comment '系统用户表'
new190.jsp header.jsp
new191.jsp 连接数据库
new192.jsp 展示商品分类
new193.jsp 添加商品
new194.jsp 添加商品
new195.html login
new196.jsp login
new197.html success
new198.html error
new199.jsp login02
new200.html login02
---------------------------------------
new201.jsp login03
new202.jsp welcome
new203.java FirstServlet
new204.jsp FristServlet
new205.java simpleBean.java
new206.jsp simplebean
new207.java loginbean.java
new208.java DBDao.java
new209.html login
new210.jsp loginbean.jsp
new211.java MemberLeave.java
new212.java MemberLeaveManager.java
new213.jsp buyLeave.jsp
new214.java MemberLeaveServlet.java
new215.html register.html
new216.java user
new217.java userBiz.java
new218.java register.java
new219.jsp login.jsp
new220.java login.java
new221.java userBiz.java
new222.jsp login验证码
new223.jsp verifyCode.jsp
new224.jsp verify.jsp
new225.java DESTool.java
new226.jsp encrypt
new227.jsp 登录密码加密
--%>
</body>
</html>