基于web的医疗设备销售业务系统的设计与实现

![`#############mysql数据库创建语句###################
create table t_admin(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘超级管理员账号’,
password varchar(100) comment ‘超级管理员密码’
) comment ‘超级管理员’;
insert into t_admin(username,password) values(‘admin’,‘123456’);

create table t_address(
id int primary key auto_increment comment ‘主键’,
customerId int(11) comment ‘用户’,
province varchar(100) comment ‘省’,
city varchar(100) comment ‘市’,
area varchar(100) comment ‘区’,
phone varchar(100) comment ‘电话’,
lxr varchar(100) comment ‘联系人’,
xxdz varchar(1000) comment ‘详细地址’
) comment ‘收货地址’;

create table t_contact(
id int primary key auto_increment comment ‘主键’,
customerId int(11) comment ‘用户’,
phone varchar(100) comment ‘联系方式’,
content text comment ‘内容’,
insertDate datetime comment ‘日期’
) comment ‘建议’;

create table t_customer(<