介绍：
spring+springmvc+mybatis+mysql+eclipse。
截图：
数据库表：
CREATE TABLE adminuser (
uid int(11) NOT NULL AUTO_INCREMENT,
username varchar(255) DEFAULT NULL COMMENT ‘管理员姓名’,
password varchar(255) DEFAULT NULL COMMENT ‘密码’,
PRIMARY KEY (uid)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
– Records of adminuser
INSERT INTO adminuser VALUES (‘2’, ‘admin’, ‘admin’);
– Table structure for cart
DROP TABLE IF EXISTS cart;
CREATE TABLE cart (
pid int(11) DEFAULT NULL COMMENT ‘商品id’,
uid int(11) DEFAULT NULL COMMENT ‘客户id’,
count int(11) DEFAULT NULL COMMENT ‘数量’,
KEY cart_user (uid),
KEY cart_product (pid),
CONSTRAINT cart_product FOREIGN KEY (pid) REFERENCES product (pid),
CONSTRAINT cart_user FOREIGN KEY (uid) REFERENCES user (uid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of cart
INSERT INTO cart VALUES (‘21’, ‘8’, ‘1’);
INSERT INTO cart VALUES (‘35’, ‘8’, ‘2’);
INSERT INTO cart VALUES (‘79’, ‘8’, ‘3’);
INSERT INTO cart VALUES (‘21’, ‘7’, ‘1’);
– Table structure for category
DROP TABLE IF EXISTS category;
CREATE TABLE category (
cid int(11) NOT NULL AUTO_INCREMENT COMMENT ‘id’,
cname varchar(255) DEFAULT NULL COMMENT ‘类型名称’,
PRIMARY KEY (cid)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
– Records of category
INSERT INTO category VALUES (‘1’, ‘当地汽车’);
INSERT INTO category VALUES (‘2’, ‘车友信息’);
INSERT INTO category VALUES (‘3’, ‘车友圈’);
INSERT INTO category VALUES (‘4’, ‘汽车交易’);
INSERT INTO category VALUES (‘5’, ‘汽车新闻’);
INSERT INTO category VALUES (‘6’, ‘汽车新闻’);
INSERT INTO category VALUES (‘10’, ‘汽车课堂’);
– Table structure for categorysecond
DROP TABLE IF EXISTS categorysecond;
CREATE TABLE categorysecond (
csid int(11) NOT NULL AUTO_INCREMENT COMMENT ‘第二类型id’,
csname varchar(255) DEFAULT NULL COMMENT ‘第二类型名称’,
cid int(11) DEFAULT NULL COMMENT ‘第一类型id’,
PRIMARY KEY (csid),
KEY FK936FCAF21DB1FD15 (cid),
CONSTRAINT FK936FCAF21DB1FD15 FOREIGN KEY (cid) REFERENCES category (cid)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8;